Analyzing and Visualizing Data with Microsoft Excel — Question 41

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 Product Name.
What should you do?

Answer options

• A. Create a perspective that has only the ProductName field from DimProduct selected.
• B. Select all the columns in DimProduct except ProductName, right-click the columns, and then click Hide from Client Tools.
• C. Edit the Table behavior settings for DimProduct and add ProductName to the Default Label.
• D. Edit the Default Field Set for DimProduct and add ProductName to the Default Field.

Correct answer: B

Explanation

The correct answer is B because right-clicking and selecting 'Hide from Client Tools' effectively removes the visibility of all columns except for ProductName, making it suitable for other users. Option A is incorrect as creating a perspective does not hide columns but rather creates a new view. Options C and D do not effectively address the requirement to hide columns; they only change labels or field sets without limiting user visibility.