Microsoft Implementing Data Models and Reports with Microsoft SQL Server 2012 70-466 Exam Questions

You create a materialized reference dimension between a dimension named Regions and a measure group named Orders.

You use a table named Customers as a bridge as shown in the exhibit. (Click the Exhibit button.)

You need to ensure that data is updated to reflect any changes in the relationship. The solution must NOT require that the entire cube be reprocessed.

What should you reprocess?

You are developing a SQL Server Analysis Services (SSAS) cube named Sales Planning. The cube consists of two measure groups named Sales and Planning. Each measure group is based on a data warehouse fact table and consists of a single MOLAP partition that has the same name as its measure group.

The Planning measure group consists of two measures:

* Forecast, which uses the Sum aggregate function

* Forecast Count, which uses the Count aggregate function

Users contribute planning values by using a legacy application. An extract, transform, load (ETL) process is scheduled to periodically transfer the planning values from the database of the legacy application to the data warehouse.

Financial analysts query the Sales Planning cube and report that the planning values are sometimes out of date. A new company requirement mandates that the planning values be entered directly into the cube by using Microsoft Excel 2010 PivotTable What-If Analysis.

You need to write-enable the Planning partition.

What should you do before write-enabling the partition?

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

What should you do?

You need to configure the permissions for the sales team members in the Sales Reports library.

Which permissions should you use? (Each answer presents part of the solution. Choose all that apply.)

You are developing a SQL Server Reporting Services (SSRS) sales summary report.

The report header consists of several images.

You need to ensure that the header of the report is hidden when a user exports the report to PDF format.

Which Hidden property expression should you use for the report header? {More than one answer choice may achieve the goal. Select the BEST answer.)

You are developing a SQL Server Analysis Services (SSAS) tabular project. The model has tables named Invoice Line Items and Products.

The Invoice Line Items table has the following columns:

Product Id

Unit Sales Price

The Unit Sales Price column stores the unit price of the product sold.

The Products table has the following columns:

Product Id

Maximum Sales Price

The Maximum Sales Price column is available only in the Products table.

You add a column named Is Overpriced to the Invoice Line Items table. The Is Overpriced column must store a value of TRUE if the value of the Unit Sales Price is greater than the value of the Maximum Sales Price. Otherwise, a value of FALSE must be stored.

You need to define the Data Analysis Expressions (DAX) expression for the Is Overpriced column.

Which DAX formula should you use? (Each answer represents a complete solution. Choose all that apply.)

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

The data warehouse has a table named FactStock that is used to track movements of stock. A column named MovementQuantity contains quantities of stock. A positive quantity is used for input and negative quantity is used for output. A column named Movement Date is related to the time dimension. The quantity in stock, at a given point in time, can be evaluated as the sum of all MovementQuantity values at that point in time.

You need to create a measure that calculates the quantity in stock value.

What should you do?