Feb 2018 updated: Testking Microsoft 70-470 test engine 161-170

Proper study guides for Update Microsoft Recertification for MCSE: Business Intelligence certified begins with Microsoft 70-470 preparation products which designed to deliver the Breathing 70-470 questions by making you pass the 70-470 test at your first time. Try the free 70-470 demo right now.

2018 NEW RECOMMEND

Free VCE & PDF File for Microsoft 70-470 Real Exam
(Full Version!)

Pass on Your First TRY 100% Money Back Guarantee Realistic Practice Exam Questions

Free Instant Download NEW 70-470 Exam Dumps (PDF & VCE):
Available on:
https://www.certleader.com/70-470-dumps.html

Q161. HOTSPOT – (Topic 9) 

You are developing a SQL Server Analysis Services (SSAS) cube. A dimension named Customer is based on the DimCustomer table. A subset of the data source view is shown in the following graphic. 

You need to relate the Customer dimension to the AccountBalance measure group. 

Which relationship type should you choose? To answer, select the appropriate option from the drop-down list in the dialog box. 

Answer: 

Q162. – (Topic 1) 

You need to identify the reports that produce the errors that Marc is receiving. 

What should you do? 

A. Write a query by using the Subscriptions table in the report server database. 

B. Use the Windows Event Viewer to search the Application log for errors. 

C. Write a query by using the ExecutionLog3 view in the report server database. 

D. Search the ReportServerService_<timestamp>.log file for errors. 

Answer:

Q163. – (Topic 10) 

You are developing a BI Semantic Model (BISM) based on a simple and small dataset sourced from SQL Server. The data size and complexity of the data relationships will not change. The model will be used to produce reports in Power View. The reports will show the relationship between product sales and rainfall over time. 

You need to use an appropriate project type. 

Which project types should you use? (Each answer presents a complete solution. Choose all that apply.) 

A. a tabular project that uses the DirectQuery query mode 

B. a tabular project that uses the In-Memory query mode 

C. a multidimensional project that uses the ROLAP storage mode and columnstore indexes 

D. a multidimensional project that uses the MOLAP storage mode and proactive cache 

E. a PowerPivot workbook that is deployed to Microsoft SharePoint Server 2010 

Answer: A,B,E 

Explanation: Power View is a thin web client that launches right in the browser from a data model in SharePoint Server 2010. The model can be a PowerPivot model workbook or a tabular model running on a SQL Server 2012 Analysis Services (SSAS) server. 

Q164. – (Topic 10) 

You install SQL Server Reporting Services (SSRS). You need to restore a copy of the symmetric key. Which command should you run? 

A. rskeymgmt –d 

B. rskeymgmt –a –f %temp%\\rs.key –p Password1 

C. rskeymgmt –e –f %temp%\\rs. key –p Password1 

D. rskeymgmt –i 

Answer:

Q165. – (Topic 10) 

You are working with a SQL Server Reporting Services (SSRS) instance in native mode. An item role named Reports Writer is present on the server. 

The Reports Writer role cannot view and modify report caching parameters. 

You need to ensure that the Reports Writer role can view and modify report caching parameters. 

What should you do? 

A. Add the Manage individual subscriptions task to the Reports Writer role. 

B. Add the Manage report history task to the Reports Writer role. 

C. Add the View data sources task to the Reports Writer role. 

D. Add the Manage all subscriptions task to the Reports Writer role. 

Answer:

Q166. – (Topic 2) 

You need to configure per-user security authentication for reporting against the Sales cube. 

What should you do? (Each correct answer presents part of the complete solution. Choose all that apply.) 

A. Create Service Principal Names (SPNs). 

B. Configure account delegation. 

C. Enable forms-based authentication. 

D. Enable mixed-mode authentication. 

Answer: A,D 

Explanation: * From scenario: 

/ Administrative staff from around the world will produce sales reports with Microsoft Excel 

2010 based on the Sales cube. 

/ Security requirements 

When possible, the system must use Windows authentication for all database connections. 

The system must prevent users from querying data from outside of their region. 

The system must allow certain users to query data from multiple regions. 

A: To use Kerberos authentication with SQL Server requires both the following conditions to be true: The client and server computers must be part of the same Windows domain, or in trusted domains. A Service Principal Name (SPN) must be registered with Active Directory, which assumes the role of the Key Distribution Center in a Windows domain. The SPN, after it is registered, maps to the Windows account that started the SQL Server instance service. If the SPN registration has not been performed or fails, the Windows security layer cannot determine the account associated with the SPN, and Kerberos authentication will not be used. 

D: For windows authentication we need to enable mixed-mode authentication 

Q167. – (Topic 10) 

You are developing a SQL Server PowerPivot workbook that sources data from a SQL Azure database. The PowerPivot model includes a single table named FactSales that consists of four columns named Year, Country, Product, and Revenue. The model includes the following two measures. 

. Sales:=SUM(FactSales[Revenue;) 

. Sales %:=;Sales] / CALCULATE([Sales], ALL(FactSales)) 

In Microsoft Excel 2010 you create the following PivotTable report. 

Users report that the Sales % measure computes an incorrect ratio. The measure should meet a requirement to compute a ratio over all visible sales values defined by the query filters. The Grand Total value for the Sales % measure should equal 100%. 

You need to fix the Sales % measure to meet the requirement. 

Which Data Analysis Expressions (DAX) expression should you use? 

A. = [Sales] / CALCULATE([Sales]) 

B. = [sales] / [Sales](ALLSELECTED(FactSales)) 

C. = [sales] / CALCULATE([Sales], VALUES(FactSales[Year]), VALUES(FactSales[Country])) 

D. = [sales] / [Sales](ALLEXCEPT(FactSales, FactSales[Year])) 

Answer:

Q168. – (Topic 10) 

You are troubleshooting query performance for a SQL Server Analysis Services (SSAS) cube. 

A user reports that a Multidimensional Expressions (MDX) query is very slow. 

You need to identify the MDX query statement in a trace by using SQL Server Profiler. 

Which event class should you use? 

A. Progress Report Begin 

B. Query Begin 

C. Execute MDX Script Begin 

D. Calculate Non Empty Begin 

E. Get Data From Aggregation 

F. Query Subcube 

Answer:

Q169. – (Topic 10) 

You are developing a BI Semantic Model (BISM) that will be used to analyze complex budgeting and forecast data sourced from a financial database. The model will be deployed to a server with 32 GB of RAM. 

The source data, located in a SQL Server data warehouse, is currently using 10 terabytes of disk space and is doubling in size every three months. The model will be queried by staff in the accounting department by using Microsoft Excel 2010. 

You need to ensure the highest query performance and scalability for the accounting department queries. 

Which project type should you choose? 

A. PowerPivot workbook 

B. tabular project that uses the In-Memory query mode 

C. multidimensional project 

D. tabular project that uses the DirectQuery query mode 

Answer:

Q170. – (Topic 7) 

You need to ensure that the Sales Per Capita calculated measure produces correct results. 

What should you do? 

A. Set the DataType property of the Population column of the FactPopulation data source view table to System.Int64. 

B. Set the Source DataType property of the Population measure to Biglnt. 

C. Set the data type of the Population column of the FactPopulation data warehouse table to BIGINT. 

D. Set the DataType property of the Population measure to Biglnt. 

Answer: