It is impossible to pass Microsoft 70-470 exam without any help in the short term. Come to Pass4sure soon and find the most advanced, correct and guaranteed Microsoft 70-470 practice questions. You will get a surprising result by our Down to date Recertification for MCSE: Business Intelligence practice guides.

Q91. - (Topic 7) 

You need to ensure that queries to the Sales Analysis cube default to the correct time period. 

Where should you set the default member Multidimensional Expressions (MDX) expression? 

A. In the DefaultMember property of the Month attribute of the Date dimension. 

B. In the cube's calculation script. 

C. In the DefaultMeasure property of the cube. 

D. In the Analysts role. 

Answer:


Q92. HOTSPOT - (Topic 9) 

You are designing aggregations for a SQL Server Analysis Services (SSAS) cube. 

You need to ensure that every aggregation includes the Category attribute. 

Which option should you select? To answer, select the appropriate option button in the 

answer area. 

Answer: 


Q93. - (Topic 4) 

You need to roll back the compatibility level of the Research database. 

What should you do? 

A. Restore a backup of the previous version of the database. 

B. Use an ALTER DATABASE statement to set the compatibility option. 

C. Change the CompatibilityLevel property in the XMLA script, and then execute the script. 

D. In SQL Server Management Studio (SSMS), change the compatibility level in the database properties. 

Answer:


Q94. - (Topic 4) 

You need to develop a BISM that meets the business requirements for ad-hoc and daily operational analysis. You must minimize development effort. 

Which development approach and mode should you use? 

A. Develop a tabular project and configure the model with the DirectQuery mode setting on and the project query mode set to DirectQuery. 

B. Develop a tabular project and configure the model with the DirectQuery mode setting on and the project query mode set to In-Memory with DirectQuery. 

C. Develop a multidimensional project and configure the model with the DirectQuery mode setting off. 

D. Develop a multidimensional project and configure the cube to use hybrid OLAP (HOLAP) storage mode. 

Answer:

Explanation: 

/ After the upgrade users must be able to perform the following tasks: 

/ Ad-hoc analysis of data in the SSAS databases by using the Microsoft Excel PivotTable 

client (which uses MDX). 

/ Daily operational analysis by executing a custom application that uses ADOMD.NET and 

existing Multidimensional Expressions (MDX) queries. 

/ Deploy a data model to allow the ad-hoc analysis of data. The data model must be 

cached and source data from an OData feed. 

We cannot use DirectQuery mode so C is the only answer that will provide the required 

caching. 

When a model is in DirectQuery mode, it can only be queried by using DAX. You cannot 

use MDX to create queries. This means that you cannot use the Excel Pivot Client, 

because Excel uses MDX. 


Q95. DRAG DROP - (Topic 10) 

You are developing a SQL Server Analysis Services (SSAS) cube. 

You need to reuse a measure group from a different database. 

In SQL Server Data Tools (SSDT), which three actions should you perform in sequence? 

 (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.) 

Answer: 


Q96. DRAG DROP - (Topic 9) 

You have a business intelligence (BI) infrastructure that contains three servers. The servers are configured as shown in the following table. 

You need to recommend a health monitoring solution for the BI infrastructure. 

The solution must meet the following requirements: 

Monitor the status of the Usage Data Collection feature. 

Monitor the number of end-users accessing the solution. 

Monitor the amount of cache used when the users query data. 

Which health monitoring solution should you recommend using on each server? To answer, drag the appropriate monitoring solutions to the correct servers. Each monitoring solution may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. 

... 

Answer: 


Q97. - (Topic 5) 

You need to scale out SSAS. 

What should you do? 

A. Back up the cube on ServerB and restore it on ServerC each day. 

B. Create an empty cube on ServerC and link to the objects in the cube on ServerB. 

C. Process the cube on both ServerB and ServerC each day. 

D. Synchronize the cube from ServerB to ServerC each day. 

Answer:


Q98. - (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:


Q99. DRAG DROP - (Topic 9) 

You plan to deploy a SQL Server Integration Services (SSIS) project by using the project deployment model. 

You need to monitor control flow tasks to determine whether any of them are running longer than usual. 

Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.) 

Answer: 


Q100. - (Topic 10) 

You are developing a SQL Server Reporting Services (SSRS) report that renders in HTML. The report includes a dataset with fields named Description, Price, and Color. The report layout includes a table that displays product details and also includes columns named Description, Price, and Color. 

You need to modify the report so that users can sort products by the Price column. 

What should you do? 

A. Add a custom action to the Price text box. 

B. Set the SortExpression property to =Fields!Price.Value for the Price text box. 

C. In the Expression dialog box for the Price text box, enter the =SortBy FieldslPrice.Value expression. 

D. Set the SortExpression value to =Fields!Price.Description for the Price text box. 

Answer: