PrepAway - Latest Free Exam Questions & Answers

How can you prevent the tables being visible to users without adversely affecting the calculations performed b

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 the Marketing and
Sales departments. The Marketing department uses sales trends and forecasts to plan the
company marketing strategy and the Sales users use the sales forecasts to focus their sales
targets.
The tables used by the calculations in the model contain data that should not be visible to
company users.
How can you prevent the tables being visible to users without adversely affecting the calculations
performed by the model?

PrepAway - Latest Free Exam Questions & Answers

A.
By right clicking on the tables in Diagram View and selecting the Hide option in the menu.

B.
By right clicking on the tables in Diagram View and selecting the Delete option in the menu.

C.
By right clicking on the tables in Diagram View and selecting the Create Relationship option in
the menu.

D.
By right clicking on the tables in Diagram View and selecting the Hide from Client Tools option
in the menu.

Explanation:

One Comment on “How can you prevent the tables being visible to users without adversely affecting the calculations performed b


Leave a Reply