You work as a developer at ABC.com. The company uses a Microsoft SQL Server 2012
infrastructure.
An Analysis Services project you are developing contains multiple dimensions.
The attributes in one of the dimensions include a parent-child hierarchy, a key attribute and two
regular attributes.
Users are able to view all the hierarchies when they view the dimension.
How can you hide a hierarchy from the users?

You have been hired as a Business Intelligence (BI) developer at ABC.com. The company uses a
Microsoft SQL Server 2012 infrastructure.
A junior developer has created a multidimensional Microsoft SQL Server Analysis Services
project. The processing performance of the dimensions in the project needs to be optimized to
improve performance.
All dimension attributes in one of the dimensions directly relate to the key attribute. Relationships
between the non-key attributes are supported by the data in the dimension.
How can you increase the processing performance of the dimension?

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)