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?
A.
You should implement multiple perspectives for the table.
B.
You should implement multiple partitions for the table.
C.
You should implement multiple database roles for the table.
D.
You should implement multiple tables with a single perspective.
Explanation:
http://technet.microsoft.com/en-us/library/hh230976.aspx