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

1. You need to implement the aggregation designs for the cube.
What should you do?

A) Use the Aggregation Design Wizard.
B) Implement cache warming in SSAS via an SSIS package.
C) Partition the cube by month.
D) Use the Usage-Based Optimization Wizard.

2. You need to use SQL Server Management Studio (SSMS) to make the SSAS databases available for application testing.
What should you do?

A) Restore the SSAS databases from the latest backup to SSAS01.
B) Script the databases as a Create script to a new window and then execute the script on SSAS01.
C) Detach the SSAS databases from the SSASCluster, and then attach them to SSAS01.
D) Use the Import/Export Wizard to copy the databases from the production server to the development server.

3. You are modifying a star schema data mart that feeds order data from a Microsoft Azure SQL Database database into a SQL Server Analysis Services (SSAS) cube. The data mart contains two large tables that include flags and indicators for some orders. There are 100 different flag columns, each with 10 different indicator values. Some flags reuse indicators. The tables both have a granularity that matches the fact table.
You have the following requirements:
- Allow users to slice data by all flags and indicators. - Modify the date dimension table to include a surrogate key of a numeric data type and add the surrogate key to the fact table. - Use the most efficient design strategy for cube processing and queries.
You need to modify the schema.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

A) Define the surrogate key as a BIGINT data type. Combine the distinct flag/indicator combinations into a single dimension.
B) Define the surrogate key as an INT data type. Combine the distinct flag/indicator combinations into a single dimension.
C) Define the surrogate key as a BIGINT data type. Create a single fact dimension in each table for its flags and indicators.
D) Define the surrogate key as an INT data type. Create a single fact dimension in each table for its flags and indicators.

4. You need to grant appropriate permissions to the SSISOwners SQL Server login. What should you do?

A) Map the login to the SSISDB database. Assign the user to the db.ssisadmin role.
B) Map the login to the msdb database. Assign the user to the db_owner role.
C) Map the login to the SSISDB database. Assign the user to the ssis.admin role.
D) Map the login to the SSISDB database. Assign the user to the db_owner role.
E) Map the login to the msdb database. Assign the user to the db_ssisadmin role.
F) Map the login to the msdb database. Assign the user to the ssis_admin role.

5. You are designing a SQL Server Reporting Services (SSRS) report based on a SQL Server Analysis Services (SSAS) cube.
The cube contains a Key Performance Indicator (KPI) to show if a salesperson's sales are off target, slightly off target, or on target.
You need to add a report item that visually displays the KPI status value as a red, yellow, or green circle.
Which report item should you add?

A) Radial Gauge
B) Indicator
C) Data Bar
D) Sparkline
E) Linear Gauge

Solutions: