nerdexam
Microsoft

70-779 · Question #48

70-779 Question #48: Real Exam Question with Answer & Explanation

Sign in or unlock 70-779 to reveal the answer and full explanation for question #48. The question stem and answer options stay visible for context.

Question

You have a Power Pivot data model that contains a table named DimProduct DimProduct has seven columns named ProductKey, ProductLabel, ProductName, ProductDescription, ProductSubCategoryKey, Manufacturer, and Brand. Only the members of the product team use all the data in the DimProduct table. You need to simplify the model for other users by hiding all the columns except ProductName. What should you do?

Options

  • ACreate a perspective that has only the ProductName field from DimProduct selected.
  • BSelect all the columns in DimProduct except ProductName, right-click the columns, and then click
  • CEdit the Default Field Set for DimProduct and add ProductName to the Default Field.
  • DEdit the Table Behavior settings for DimProduct and add ProductName to the Default Label.

Unlock 70-779 to see the answer

You've previewed enough free 70-779 questions. Unlock 70-779 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Full 70-779 Practice