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

1. DRAG DROP
You have a cube named Cube1 that contains the sales data for your company.
You plan to build a report based on the cube.
You need to write an MDX expression that returns the total sales from the first month of the 2009 fiscal year and the total sales from the same period of the 2008 fiscal year.
Which code segments should you insert at line 03 and line 05? To answer, drag the appropriate code segments to the correct lines. Each code segments 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.

2. HOTSPOT
A SQL Server Analysis Services (SSAS) cube has roles to define dimension data security. A role named USA allows users to browse data pertaining to the United States. A role named Canada allows users to browse data pertaining to Canada.
A user can browse sales data pertaining to the United States but cannot browse sales data pertaining to Canada. You validate that the user belongs to the USA and Canada roles.
You need to reproduce the issue in SQL Server Management Studio (SSMS).
Which option should you select? To answer, select the appropriate action in the answer area.

3. After you deploy the RegionalSales report, you attempt to configure the subscriptions.
You discover that the subscription creation screen does not display the option to deliver the
report by email.
You need to ensure that subscriptions can be delivered by using email.
What should you do?

A) Modify the Rsmgrpolicy.config file.
B) From Central Administration, modify the properties of the Reporting Service Application.
C) From Central Administration, modify the SMTP settings of the SharePoint Server server farm.
D) Modify the Rssrvrpolicy.config file.

4. A production SQL Server Analysis Services (SSAS) cube is processed daily. The users query facts by using a hierarchy named Geography from a dimension named Geography.
The DimGeography table in the data source view is used as the source of the Geography dimension. The table has the following structure.

The Geography dimension has three attribute hierarchies:
---
City
State-Province
Country
The attributes have the following relationships defined: City > State-Province > Country. Each attribute has a key and a name sourced from the related key and name columns in the DimGeography table.
During processing, you receive the following error message: "Errors in the OLAP storage engine: A duplicate attribute key has been found when processing: Table: 'dbo_DimGeography, Column: StateProvinceKey', Value: '23'. The attribute is 'State-Province'."
You verify that the data is accurate.
You need to ensure that the dimension processes successfully.
What should you do?

A) Remove the State-Province attribute.
B) Delete the Geography hierarchy.
C) Relate the State-Province and Country attributes directly to the City attribute.
D) Remove the duplicate data from the DimGeography table.

5. Note: This question is part of a series of questions that use the same set of answer choices. An answer choice may be correct for more than one question in the series.
You are creating a SQL Server Analysis Services (SSAS) cube.
You need to create a time dimension. It must be linked to a measure group named Sales at the day granularity level. It must also be linked to a measure group named Salary at the month granularity level.
What should you do?

A) Create a dimension. Then add a cube dimension and link it several times to the measure group.
B) Create a dimension. Create regular relationships between the cube dimension and the measure group. Configure the relationships to use different dimension attributes.
C) Create several dimensions. Add each dimension to the cube.
D) Add a hidden measure that uses the Sum aggregate function. Add a calculated measure aggregating the measure along the time dimension.
E) Create a dimension with one attribute hierarchy. Set the IsAggregatable property to False and then set the DefaultMember property. Use a many-to-many relationship to link the dimension to the measure group.
F) Create a dimension with one attribute hierarchy. Set the ValueColumn property, set the IsAggregatable property to False, and then set the DefaultMember property. Configure the cube dimension so that it does not have a relationship with the measure group. Add a calculated measure that uses the MemberValue attribute property.
G) Add a calculated measure based on an expression that counts members filtered by the Exists and NonEmpty functions.
H) Use the Business Intelligence Wizard to define dimension intelligence.
I) Add a measure that uses the Count aggregate function to an existing measure group.
J) Add a measure group that has one measure that uses the DistinctCount aggregate function.
K) Use role playing dimensions.
L) Create a dimension with one attribute hierarchy. Set the IsAggrcgatable property to False and then set the DefaultMember property. Use a regular relationship between the dimension and measure group.
M) Create a new named calculation in the data source view to calculate a rolling sum. Add a measure that uses the Max aggregate function based on the named calculation.
N) Create a dimension with one attribute hierarchy. Set the IsAggregatable property to False and then set the DefaultMember property. Use a many-to-many relationship to link the dimension to the measure group.
O) Add a measure that uses the DistinctCount aggregate function to an existing measure group.

Solutions: