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

1. You are designing a SQL Server Reporting Services (SSRS) report that sources data from a Microsoft Azure SQL Database database.
The report must display the value and status of a Key Performance Indicator (KPI).
Which report item should you use? (Each answer presents a complete solution. Choose all that apply.)

A) Indicator
B) Image
C) Gauge
D) Data Bar
E) Sparkline

2. 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) Add a measure that uses the DistinctCount aggregate function to an existing measure group.
B) Use the Business Intelligence Wizard to define dimension intelligence.
C) 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.
D) 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.
E) 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.
F) Create a dimension. Create regular relationships between the cube dimension and the measure group. Configure the relationships to use different dimension attributes.
G) 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.
H) Add a measure group that has one measure that uses the DistinctCount aggregate function.
I) 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.
J) Use role playing dimensions.
K) Add a hidden measure that uses the Sum aggregate function. Add a calculated measure aggregating the measure along the time dimension.
L) Create several dimensions. Add each dimension to the cube.
M) Add a calculated measure based on an expression that counts members filtered by the Exists and NonEmpty functions.
N) Create a dimension. Then add a cube dimension and link it several times to the measure group.
O) Add a measure that uses the Count aggregate function to an existing measure group.

3. HOTSPOT
A SQL Server Analysis Services (SSAS) cube contains billions of rows of data and is rapidly increasing in size. The cube consists of a single measure group and a single partition. The cube is currently processed by using the Process Full process option.
You have the following requirements to reduce the cube processing time:
Partition the measure group by month.
Create a staging table that contains only data which is more recent than the last
time the cube was processed.
Do not include data updates or deletions in the staging table.
Insert records from the staging table into the appropriate partition.
You need to change the process option to meet the requirements.
Which process option should you choose?
-- --
To answer, select the appropriate option from the drop-down list in the dialog box.

4. 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 A
B) Option F
C) Option E
D) Option D
E) Option C
F) Option B

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

Solutions: