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

infrastructure.
A SQL Server 2012 Analysis Services (SSAS) tabular model project is used by users in all
company departments. The single model represents the contents of the entire companys data
warehouse and has many tables, measures, and dimensions.
The complexity of the model is daunting to some users in the Sales department. Users in the
Sales department only need to interact with a small part of the model for their business intelligence
and reporting requirements. Users in other departments need to use the complete model.
How can you simplify the view of the model so that Sales department users only see information
that is relevant to them?

You work as a Database Administrator (DBA) at ABC.com. The company uses a Microsoft SQL
Server 2012 infrastructure.
A server named ABC-SSAS1 runs SQL Server Analysis Services (SSAS). You are configuring
security for a tabular model on ABC-SSAS1.
You need to assign role permissions to a role to ensure that users can query the data in the
tabular model but cannot see the model database in SSMS (SQL Server Management Studio).
Which role permission should you assign to the role?

You work as a Database Administrator (DBA) at ABC.com. The company uses a Microsoft SQL
Server 2012 infrastructure.
A server named ABC-SSAS1 runs SQL Server Analysis Services (SSAS). You are configuring
security for a tabular model on ABC-SSAS1.
You create a database role in SSAS. You will assign permissions to the role to control access to
the model database.
Which of the following permissions is the default permission assigned to a new role?

You work as a Database Administrator (DBA) at ABC.com. The company uses a Microsoft SQL
Server 2012 infrastructure.
A server named ABC-SSAS1 runs SQL Server Analysis Services (SSAS). You are configuring
security for a tabular model on ABC-SSAS1.
You need to assign role permissions to roles in SSAS to control access to the model database.
You also plan to use DAX (Data Analysis Expressions) formulas to create row filters to restrict
views of the data.
To which of the following role permissions can row filters be applied? (Choose all that apply).

You work as a SQL Developer at ABC.com. The company uses a Microsoft SQL Server 2012
infrastructure.
You have a SQL Server Analysis Services (SSAS) tabular model.
You need to configure the model for DirectQuery mode to maximize performance.
You set the DirectQueryMode property to ON to enable Direct Query mode. You now need to set
the DirectQueryMode property to configure the preferred query data source.
Queries must use the relational data source by default unless otherwise specified in the
connection string from the client.
Which of the following options should you select?

You work as a SQL Developer at ABC.com. The company uses a Microsoft SQL Server 2012
infrastructure.
You have a SQL Server Analysis Services (SSAS) tabular model.

You need to configure the model for DirectQuery mode to maximize performance.
You set the DirectQueryMode property to ON to enable Direct Query mode. You now need to set
the DirectQueryMode property to configure the preferred query data source.
Queries must use the cache by default unless otherwise specified in the connection string from the
client.
Which of the following options should you select?

You work as a developer at ABC.com. The company uses a Microsoft SQL Server 2012
infrastructure.
You are using SQL Server Data Tools (SSDT) to author a SQL Server 2012 Analysis Services
(SSAS) tabular model project.
The model includes a very large table. The table includes some row sets that contain data that
rarely changes while other row sets have data that changes often. Queries to the table must be
able to return data from all rows in the table.
You need to improve the processing performance by enabling some row sets to be processed
more often that other row sets.
What should you implement to achieve this goal?

You work as a Database Administrator (DBA) at ABC.com. The company is in the process of
upgrading its SQL Server 2008 R2 infrastructure to Microsoft SQL Server 2012.
You are planning to upgrade an instance of SQL Server 2008 R2 Analysis Services (SSAS) to
SQL Server 2012.
You have a PowerPivot model created with version 2008 R2. You want to convert the PowerPivot
model to a 2012 SSAS Tabular Model.
You install an instance of 2012 SSAS.
Which two of the following steps should you perform next? (Choose two)

You work as a developer at ABC.com. The company uses a Microsoft SQL Server 2012
infrastructure.
A SQL Server Analysis Services (SSAS) cube is used by the Sales department. The database
has security roles defined for Sales users and managers.
You are developing an update to the SSAS cube. The development environment database has
security roles defined for the developers.
You need to deploy the update without changing the current security roles and members defined
for Sales users and managers. Roles and members included in the update must not be deployed.

How should you deploy the update?

You work as a Database Administrator (DBA) at ABC.com. The company uses a Microsoft SQL
Server 2012 infrastructure.
You discover an unused database dimension in a SQL Server Analysis Services (SSAS)
multidimensional database. You confirm that no cubes use the database dimension.
You want to delete the dimension.
How should you delete the dimension?