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

1. You are developing a SQL Server Analysis Services (SSAS) tabular project.
A column named City must be added to the table named Customer. The column will be
used in the definition of a hierarchy. The City column exists in the Geography table that is
related to the Customer table.
You need to add the City column to the Customer table.
How should you write the calculation?

A) Option B
B) Option E
C) Option D
D) Option A
E) Option C
F) Option F

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

3. You are designing a subscription strategy for a SQL Server Reporting Services (SSRS) report. You have an application that populates a table with user-specific subscription
schedules and report formats.
You need to ensure that users can receive reports by email according to their preferences. Email messages will be sent via an internal mail server.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

A) Create a data-driven SSRS subscription for each record in the schedule table.
B) Create a standard SSRS subscription for each record in the table.
C) Create a standard SSRS subscription for each subscription schedule.
D) Create one data-driven SSRS subscription. Schedule the subscription to frequently retrieve user preferences.

4. After you deploy the RegionalSales report, users report that they cannot see product data when they receive the reports by email.
You need to ensure that the sales department managers can see all of the data.
In the report, you update the Hidden property of each group.
What should you do next?

A) In When the report is initially run, select Show or hide based on an expression. Se: The expression to =NOT (GlobalslRenderFormat.IsInteractive)
B) In When the report is initially run, select Show or hide based on an expression. Set the expression to = (GlobalsIRenderFormaUsInteractive).
C) In when the report is initially run, select Show.
D) In When the report is initially run, select Hide.

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 part. Publish the report part to a SharePoint site. Add the report part to each new report that is created.
C) Create a report. Copy the report to source code control. Create each new report by using the report template in source code control.
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: