PrepAway - Latest Free Exam Questions & Answers

What should you implement to achieve this goal?

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?

PrepAway - Latest Free Exam Questions & Answers

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:

One Comment on “What should you implement to achieve this goal?


Leave a Reply