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

1. HOTSPOT
You are developing a SQL Server Analysis Services (SSAS) cube.
Revenue must be compared to a goal and described by a status and a trend. Revenue,
goal, status, and trend will be defined by Multidimensional Expressions (MDX) expressions.
You need to add the Revenue measure.
Which tab should you select? (To answer, select the appropriate tab in the answer area.)

2. You need to configure a hierarchy for DimProduct that meets the technical requirements.
What should you do?

A) Set ProductName as the parent of ProductSubCategory and set ProductSubcategory as the parent of ProductCategory. For ProductSubcategory, click Hide if Name Equals Parent.
B) Set ProductName as the parent of ProductSubcategory and set ProductSubCategory as the parent of ProductCategory. For ProductCategory, click Hide if Name Equals Parent
C) Set ProductCategory as the parent of ProductSubCategory and set ProductSubcategory as the parent of ProductName. For ProductSubcategory, click Hide if Name Equals Parent.
D) Set ProductCategory as the parent of ProductSubcategory and set ProductSubCategory as the parent of ProductName. For ProductCategory, click Hide if Name Equals Parent

3. DRAG DROP
You are developing a SQL Server Analysis Services (SSAS) cube.
You need to add a calculated member to the Customer dimension to evaluate the sum of values for the United Kingdom and the United States.
Which expression should you use? (To answer, drag the appropriate expression to the answer area.)

4. You are designing a customer dimension for a multidimensional OLAP (MOLAP) database. The dimension table will contain millions of rows of data.
Customer dimension attributes will come from the following two sources:
- An enterprise resource planning (ERP) system that contains millions of rows of data. Attributes from this source will be updated daily.
- A marketing database that contains thousands of rows of data representing customers' geographic information. Attributes from this source will be updated monthly.
Most report queries against the cube use attributes from both sources. Customers in the
cube dimension will frequently be filtered by the geographic attributes.
You need to design the dimension table and cube dimension to ensure that report queries perform well, and minimize the time required to reprocess cube attributes.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

A) Create a dimension table for each source, and a cube dimension for each source.
B) Create one dimension table that combines data from both sources. Create a cube dimension for each source.
C) Create a dimension table for each source. Create one cube dimension that joins the two dimension tables together.
D) Create one dimension table that combines data from both sources. Create one cube dimension that references the dimension table.

5. You need to ensure that all reports meet the reporting requirements.
What is the best way to achieve the goal? More than one answer choice may achieve the goal. Select the BEST answer.

A) Create a report. Copy the report to the PrivateAssemblies\ProjectItems\ReportProject folder in the Visual Studio directory. Create each new report by using the locally stored report
B) Create a report. Copy the report to source code control. Create each new report by using the report template in source code control.
C) Create a report part. Publish the report part to a SharePoint site. Add the report part to each new report that is created.
D) Create a report part. Publish the report part to a server that has SSRS installed. Add the report part to each new report that is created.

Solutions: