You have been hired as a Business Intelligence (BI) developer at ABC.com. The company uses a
Microsoft SQL Server 2012 infrastructure.
The data warehouse contains a database with 10 terabytes of data. The volume of data is
forecast to increase by 10% every week.
You are developing a BISM model to analyze the database. The model will be queried by users
using Microsoft Excel 2010. A Windows Server 2008 R2 server with dual quad-core processors
and 32GB of RAM has been purchased to host the model.
Queries to your model must be scalable and run as quickly as possible.
What should you do?

You have been hired as a Business Intelligence (BI) developer at ABC.com. The company uses a
Microsoft SQL Server 2012 infrastructure.
You are using SQL Server Data Tools (SSDT) to create a BI Semantic Model (BISM).
Your model will pull data from multiple sources. Data latency is acceptable in your model. The
total amount of source data is 15GB.
You have been assigned a Windows Server 2008 R2 server with 48GB of RAM to host your

model.
You need to design your model to maximize performance.
Which two of the following elements are key to maximizing performance in your model? (Choose
two).

You work as a developer at ABC.com. The company uses a Microsoft SQL Server 2012
infrastructure.
An Analysis Services cube you are developing contains multiple dimensions. The cube also
contains linked measure groups and local measure groups.
Which two of the following statements about measure groups are true?

You work as a developer at ABC.com. The company uses a Microsoft SQL Server 2012
infrastructure.

An Analysis Services cube you are developing for the IT department contains a measure group
named Ping Times. The IT Manager has a program that sends pings to servers on the network to
test their network response times and records the information in a database.
One measure in the Ping Times measure group will be used to return the average ping time for a
server over a specified period of time.
Which AggregationFunction property should you configure for the average ping time measure?

You work as a developer at ABC.com. The company uses a Microsoft SQL Server 2012
infrastructure.
You are creating a SQL Server Analysis Services (SSAS) cube to return the total value of products
sold in a specified period, the total number of products sold in the specified period and the total
number of each product type sold in the specified period.
The specified period could run up to the current time so the data returned must include up-to-date
information.
Which of the following options should be included to maximize the performance of the query?
(Choose all that apply).

You have been hired as a Business Intelligence (BI) developer at ABC.com. The company uses a
Microsoft SQL Server 2012 infrastructure.
You are using SQL Server Data Tools (SSDT) to create a BI Semantic Model (BISM) that will be
used by company employees to create Power View reports.
The model will pull data from data hosted on a single SQL Server. As the volume of data is small
and static, you decide to configure the project to use the query mode of In-Memory and the project
type of Tabular.
Which two of the following options would also be appropriate for this model? (Choose two).

You have been hired as a Business Intelligence (BI) developer at ABC.com. The company uses a
Microsoft SQL Server 2012 infrastructure.
You are using SQL Server Data Tools (SSDT) to create a BI Semantic Model (BISM) that will be
used by company employees to create Power View reports.
The model will pull data from data hosted on a single SQL Server. As the volume of data is small
and static, you decide to configure the project to use the query mode of DirectQuery and the
project type of Tabular.
Which two of the following options would also be appropriate for this model? (Choose two).

You work as a SQL Developer at ABC.com. The company uses a Microsoft SQL Server 2012
infrastructure.
A cube is used by the Marketing department to view the number of product sales. The cube has
two measures in a single measure group. One measure is named Total Products Ordered and the
other is named Products Ordered Per Hour.
You have been asked to configure the cube so that the Total Products Ordered measure is
updated as soon as an order is received. The Products Ordered Per Hour measure needs to be
updated on the hour every hour.
Which of the following modifications to the cube should you perform? (Choose one of more
answers)

You work as a SQL Developer at ABC.com. The company uses a Microsoft SQL Server 2012
infrastructure.
A production application stores data in a SQL Server database. Production users want to be able
to view a report of the data stored by the production application.
You plan to create a report using SSRS (SQL Server Reporting Services) to display the production
data. Your report will include a table with three columns. The columns are named Start, Finish
and Duration.
Production users need to be able to view the report table and sort the data in the table by the
Duration column.
How should you configure the report?

You work as a SQL Developer at ABC.com. The company uses a Microsoft SQL Server 2012
infrastructure.
You are using SQL Server Reporting Services (SSRS) to create a report named Marketing Trends
for the Marketing department.
The Marketing Trends pulls data from a single SQL Server.
You need to modify the report to also pull data from a cloud database hosted on Microsoft SQL
Azure. The current SQL Server database must continue to be used by the report.
Which two of the following steps should you perform? (Choose two)