nerdexam
Microsoft

70-768 · Question #7

70-768 Question #7: Real Exam Question with Answer & Explanation

The correct answer is A. Create a perspective, and ensure that the PriorYearSales measure is not added to the. 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 be

Question

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?

Options

  • ACreate a perspective, and ensure that the PriorYearSales measure is not added to the
  • BSet the Display Folder property for PriorYearSales toHidden.
  • CRemove the PriorYearSales measure from the default field set of the Sales table.
  • DCreate a role using Read permissions, and define a DAX expression to filter out the

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.

Community Discussion

No community discussion yet for this question.

Full 70-768 Practice