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

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

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

2. 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 Rssrvrpolicy.config file.
B) Modify the Rsmgrpolicy.config file.
C) From Central Administration, modify the properties of the Reporting Service Application.
D) From Central Administration, modify the SMTP settings of the SharePoint Server server farm.

3. You are developing a SQL Server Analysis Services (SSAS) tabular project.
You need to grant the minimum permissions necessary to enable users to query data in a tabular model.
Which role permission should you use?

A) Read Definition
B) Browser
C) Process
D) Select
E) Read
F) Explorer

4. 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 part. Publish the report part to a SharePoint site. Add the report part to each new report that is created.
B) 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
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.

5. You need to implement the Customer Sales and Manufacturing data models.
What should you do? (Each correct answer presents a partial solution. Choose all that
apply.)

A) Use SQL Server Data Tools (SSDT) to redevelop and deploy the projects.
B) Use SQL Server Integration Services (SSIS) to copy the database design to the SSAS instance, and specify tabular mode as the destination.
C) Install a new instance of SSAS in tabular mode.
D) Use the current SSAS instance.
E) Use the Database Synchronization Wizard to upgrade the database to tabular mode.

Solutions: