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 develop a SQL Server Analysis Services (SSAS)
cube for the Marketing department.
An Analysis Services database used by the Sales department contains a measure group that you
want to include in the Marketing department cube. The measure group must continue to reflect
changes in the Sales database when it is included in the new cube.
What should you do?

You work as a developer at ABC.com. The company uses a Microsoft SQL Server 2012
infrastructure.
You need to create a time dimension for the SQL Server Analysis Services (SSAS)
multidimensional model database. No time table exists in the external source database.

Which two of the following steps should you perform to implement the time dimension?

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.
Which permission needs to be assigned to a role to enable role members to make modifications to
the model schema?

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. All measure group partitions use
Multidimensional OLAP (MOLAP).
You need to write-enable a partition containing a linked measure group to enable business users
to explore scenarios by changing cell values and analyzing the effects of the changes on cube
data.
What should you do first?

You work as a developer at ABC.com. The company uses a Microsoft SQL Server 2012
infrastructure.
A SQL Server Analysis Services (SSAS) tabular project you are developing contains a table
named ABCEmployees. The table contains information about ABC.com employees. The table
includes the following columns: Last Name, First Name, LoginID, Department, DepartmentID.
The LoginID contains the logon username (domain\username) for each user.
You want to implement row level security based on the user name of the user currently logged so
that the users can only query data for their respective department.
Which of the following functions should you use as part of a DAX formula for your row filter?

(Choose all that apply).

You work as a developer at ABC.com. The company uses a Microsoft SQL Server 2012
infrastructure.
You are designing a database for a SQL Server Analysis Services (SSAS) multidimensional
project.
A requirement in your design specification states the need for a time dimension to track the times
that products are ordered, shipped, and received.
How can you meet the design requirement while minimizing the number of objects in the project?

You work as a Database Administrator (DBA) at ABC.com. The company uses a Microsoft SQL

Server 2012 infrastructure.
A server named ABC-Reports1 runs SQL Server Reporting Services (SSRS).
Several users have contacted the helpdesk saying that they receive timeout errors when running
reports on ABC-Reports1.
A helpdesk user informs you that helpdesk users are unable to increase the timeout period for
reports.
Which system-level task should you assign to the Helpdesk role to enable them to increase the
report timeout period?

You work as a Database Administrator (DBA) at ABC.com. The company uses a Microsoft SQL
Server 2012 infrastructure.
Company users use a SQL Server Analysis Services (SSAS) cube.
You receive reports that an MDX query takes a long time to run.
You are using SQL Server Profiler to troubleshoot the query performance issues. You need to
gather information about the MDX query that was submitted to Analysis Services.
Which SQL Server Profile Event Class should you select in the Event Selection tab of the Trace
Properties dialog box?