Microsoft Transition Your MCITP: Business Intelligence Developer 2008 to MCSE: Business Intelligence Sample Questions:

1. You need to configure Library1 to support the planned self-service reports.
What is the best configuration you should add to Library1? More than one answer choice may achieve the goal. Select the BEST answer.

A) the Report Builder report content type
B) the PowerPivot Gallery Document content type
C) the Report content type
D) the Report Builder Model content type

2. 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?

A) Convert the Planning measure group to a linked measure group.
B) Set the StorageMode property of the Planning partition to Rolap
C) Set the ProcessingMode property of the Planning partition to LazyAggregations.
D) Set the ProcessingMode property of the Planning measure group to LazyAggregations.
E) Remove the Forecast Count measure.
F) Set the Type property of the Planning measure group to Budget.

3. You are developing a SQL Server Analysis Services (SSAS) tabular project.
A model contains tables and columns that must not be visible to the user. The columns and tables cannot be removed because they are used in calculations.
You need to hide the tables and columns.
What should you do?

A) Right-click the applicable tables and columns and select the Hide option.
B) Right-click the applicable tables and columns and select the Hide from Client Tools option.
C) In the Properties window for the applicable tables and columns, set the Visible property to True
D) In the Properties window for the applicable tables and columns, set the Enabled property to False

4. You need to define the trend calculation for the sales performance KPI. Which KPI trend MDX expression should you use?

A) Option C
B) Option B
C) Option D
D) Option A

5. 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?

A) The Sales partition
B) The Customers dimension
C) The Orders partition
D) The Regions dimension

Solutions: