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

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

2. 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 an INT data type. Create a single fact dimension in each table for its flags and indicators.
B) Define the surrogate key as a BIGINT data type. Create a single fact dimension in each table for its flags and indicators.
C) Define the surrogate key as an INT data type. Combine the distinct flag/indicator combinations into a single dimension.
D) Define the surrogate key as a BIGINT data type. Combine the distinct flag/indicator combinations into a single dimension.

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

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

4. 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) Explorer
B) Select
C) Read
D) Read Definition
E) Browser
F) Process

5. DRAG DROP
You are developing a SQL Server Reporting Services (SSRS) report that sources data from a SQL Azure database and a SQL Server Analysis Services (SSAS) cube. The cube contains a date dimension and other dimensions. The report design includes two report
parameters named StartDate and FinishDate as shown in the following diagram.

The Data Type property of the parameters is set to Date/Time.
You need to create the dataset based on the SSAS cube. You also need to ensure that the dataset is filtered by the existing report parameters.
Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)

Solutions: