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
Leave a Reply