nerdexam
Microsoft

70-779 · Question #48

You have a Power Pivot data model that contains a table named DimProduct DimProduct has seven columns named ProductKey, ProductLabel, ProductName, ProductDescription, ProductSubCategoryKey…

The correct answer is B. Select all the columns in DimProduct except ProductName, right-click the columns, and then click. https://support.office.com/en-us/article/hide-columns-and-tables-in-power-pivot-ddf5b1f2-2ed2- 4bdb-8f78-6f94503ca87a

Model data by using Microsoft Excel

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.

How the community answered

(21 responses)
  • A
    5% (1)
  • B
    81% (17)
  • C
    5% (1)
  • D
    10% (2)

Explanation

https://support.office.com/en-us/article/hide-columns-and-tables-in-power-pivot-ddf5b1f2-2ed2- 4bdb-8f78-6f94503ca87a

Topics

#Power Pivot#perspectives#column visibility#data model

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 70-779 Practice