PdfPrep.com

What should you do?

A database named DB2 uses the InMemory query mode.

Users frequently run the following query:

You need to ensure no users see the PriorYearSales measure in the field list for the Sales table.

What should you do?
A . Create a perspective, and ensure that the PriorYearSales measure is not added to the perspective. Ensure that users connect to the model by using the perspective.
B . Set the Display Folder property for PriorYearSales toHidden.
C . Remove the PriorYearSales measure from the default field set of the Sales table.
D . Create a role using Read permissions, and define a DAX expression to filter out the PriorYearSales measure. Add all users to the role.

Answer: A

Explanation:

Using perspectives in the data model might help you expose a subset of tables, columns, and measures that are useful for a particular type of analysis.

Usually, every user needs only a subset of data you create, and showing him or her the model through perspectives can offer a better user experience.

From scenario; The PriorYearSales measure is referenced by other measures, and is not intended to be analyzed directly by users.

References: Microsoft SQL Server 2012 Analysis Services, The BISM Tabular Model, Microsoft Press (July 2012), page 305

Exit mobile version