Skip to content

All About Certified 70-470 exam question

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


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:

Q51. – (Topic 9) 

You are designing a strategy for an enterprise reporting solution that uses SQL Server Reporting Services (SSRS). 

Many of the SSRS reports will use common utilities and functions, including the following: 


Report utility functions and business logic in code Standardized report formatting properties such as fonts and colors for report branding 

Formatting may change and new functions may be added as the reporting solution evolves. 

You need to create a strategy for deploying the formatting and code across the entire enterprise reporting solution. You must also ensure that reports can be easily updated to reflect formatting and function changes. 

What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.) 

A. Create a report as a template. Apply standardized formatting to the template. Store code in the Code section of the template. 

B. Build a web service that retrieves formatting properties and runs code. Call the web service through a report dataset. 

C. Store the formatting properties and code in database objects. Use stored procedures to populate a default value for report parameters and map each parameter to a corresponding formatting property. 

D. Create an assembly that contains formatting properties and code. Deploy the assembly on the Reporting Server and reference the assembly from each report. 


Q52. HOTSPOT – (Topic 9) 

You have an OLAP cube named Cube1. Cube1 has two partitions named partition1 and partition2. 

You need to configure the storage mode for each cube partition. 

The solution must meet the following requirements: 

. Users must be able to retrieve aggregate data from partition1 as quickly as 


. The processing time for partition1 and partition2 must be minimized. 

. The least possible amount of storage must be used for partition2. 

What should you do? To answer, select the appropriate storage mode for each partition in the answer area. 


Q53. – (Topic 10) 

You are developing a SQL Server Analysis Services (SSAS) cube. The cube contains several dimensions, a local measure group, and a linked measure group. Both measure groups use MOLAP partitions. 

You need to write-enable one of the linked measure group partitions to support Microsoft Excel 2010 PivotTable What-If Analysis. 

What should you do before the partition can be write-enabled? 

A. Implement the cube as a local cube. 

B. Implement the linked measure group as a local measure group. 

C. Ensure that the measure group measures only use semiadditive aggregation functions. 

D. Ensure that the measure group measures only use nonadditive aggregation functions 


Q54. – (Topic 3) 

You need to select an appropriate tool for creating the Regional Sales report. 

Which tool or tools should you use? (Each correct answer presents a complete solution. Choose all that apply.) 

A. Excel 2010, using the CUBE functions 

B. Power View, using a Matrix 

C. Excel 2010, using a PivotTable 

D. Report Builder, using a Matrix 

Answer: B,C,D 


B: Working with a matrix in Power View A matrix is a type of visualization that is similar to a table in that it is made up of rows and columns. However, a matrix can be collapsed and expanded by rows and/or columns. If it contains a hierarchy, you can drill down/drill up. 

C: Using an Excel Pivot Table, connecting to the Cube, will give you the option to drill down the cube. Using conditional formatting you can highlight specific value ranges. 

D: Matrices provide functionality similar to crosstabs and pivot tables. At run time, as the report data and data regions are combined, a matrix grows horizontally and vertically on the page. Values in matrix cells display aggregate values scoped to the intersection of the row and column groups to which the cell belongs. You can format the rows and columns to highlight the data you want to emphasize. You can also include drilldown toggles that initially hide detail data; the user can then click the toggles to display more or less detail as needed. 

* From scenario: Management has requested a new report named Regional Sales. This report must be based on the Sales cube and must allow users to filter by a specific year and present a grid with every region on the columns and the Products hierarchy on the rows. The hierarchy must initially be collapsed and allow the user to drill down through the hierarchy to analyze sales. Additionally, sales values that are less than $5000 must be highlighted in red. 

Q55. DRAG DROP – (Topic 9) 

You are designing a dataset for a SQL Server Reporting Services (SSRS) report. The report includes the report items displayed in the following graphic. 

The dataset is sourced from a commonly used stored procedure in an inventory data mart hosted in a SQL Azure database. 

It returns the status for all products across all storage sites. The report must display data for the storage site that is selected by the Site report parameter. You cannot change the stored procedure code. 

You need to filter the dataset to use only data specific to the selected site. 

How should you configure the filter? 

To answer, drag the appropriate expression or expressions to the correct location or locations in the answer area. (Answer choices may be used once, more than once, or not all.) 


Q56. – (Topic 10) 

You are deploying an update to a SQL Server Analysis Services (SSAS) cube to a production environment. 

The production database has been configured with security roles. 

You need to preserve the existing security roles in the production database. Database roles and their user accounts from the development environment must not be deployed to the production server. 

Which deployment method should you use? 

A. Use the SQL Server Analysis Services Deployment Wizard. 

B. Backup and restore the database. 

C. Deploy the project from SQL Server Data Tools to the production server. 

D. Use the SQL Server Analysis Services Migration Wizard. 


Q57. – (Topic 2) 

You need to configure the partition storage settings to support the reporting requirements. Which partition storage setting should you use? 

A. Low-latency MOLAP 

B. In-Memory 

C. High-latency MOLAP 

D. Regular 

E. DirectQuery 

F. LazyAggregations 


Q58. – (Topic 6) 

You need to ensure that you can monitor the usage data. 

What should you do? 

A. In SharePoint Central Administration, enable usage data collection. 

B. In the PowerPivot Configuration Tool, repair PowerPivot for SharePoint. 

C. In the PowerPivot Configuration Tool, upgrade PowerPivot for SharePoint. 

D. In Reporting Services Configuration Manager, enable report execution logging. 


Q59. DRAG DROP – (Topic 10) 

You are developing a SQL Server Analysis Services (SSAS) multidimensional project. The project file includes two cubes named Finance and Operations. The project also includes a dimension named Date. The Date dimension includes two hierarchies named Fiscal and Calendar. The Date dimension has been added to both cubes. 

You need to disable the Fiscal hierarchy in the Operations cube without impacting other database objects. 

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.) 


Q60. HOTSPOT – (Topic 9) 

You administer a SQL Server Analysis Services (SSAS) cube. 

You plan to optimize the cube partitions by using usage-based optimization. 

You need to configure the SSAS instance. 

Which properties should you configure? To answer, select the appropriate properties in the 

dialog box in the answer area.