PrepAway - Latest Free Exam Questions & Answers

How can you simplify the view of the model so that Sales department users only see information that is relevan

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?

PrepAway - Latest Free Exam Questions & Answers

A.
By configuring separate measures for the Sales department.

B.
By configuring separate partitions for the all departments except the Sales department.

C.
By configuring separate perspectives for the Sales department.

D.
By configuring separate partitions for the Sales department.

Explanation:

One Comment on “How can you simplify the view of the model so that Sales department users only see information that is relevan


Leave a Reply