Exam 70-779 topic 1 question 73 discussion

Actual exam question from Microsoft's 70-779

Question #: 73
Topic #: 1

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?

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.

Show Suggested Answer

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

by The_Marv at Nov. 13, 2019, 6:55 a.m.

Comments

Submit Cancel

The_Marv

Highly Voted 5 years, 7 months ago

I think the answer should be A, cause if you hide the columns the setting will apply for all the users

upvoted 26 times

mohroshdy

5 years, 6 months ago

I think the correct answer is A too, the new perspective that shown the "Product Name" only will be available to the other users

upvoted 1 times

...

cs3122

Highly Voted 5 years, 4 months ago

B is incorrect, because that implies it would hide the columns for all users. The question specifically asks us to do something for a subset of the users.

upvoted 5 times

...

CDL

Most Recent 4 years, 8 months ago

Perspective Link: https://www.sumproduct.com/blog/article/power-pivot-principles/ppp-perspectives Hide from Client Link: https://support.microsoft.com/en-us/office/power-pivot-reporting-properties-hiding-tables-columns-and-fields-from-power-pivot-and-power-view-a9c1142f-7b27-4c60-8e31-67edf41fbf4b I go with B. Differences: Hide from the Clients is about hiding the fields Only in PV field lists, when we open the “Data Model” in power pivot, we still could see complete data set(all the columns) there, even in “Diagram View”, the hidden fields/columns will show in gray. Perspective is about hiding the fields not only in PV fields lists, but also into the “Data Model”, unless we know the trick of the under “Advanced”-“Create and Manage perspective”; Let’s assume the ordinary Users only know how to use pivot table, then “option B” is enough. And the team members still could go into “Data Model” to add whatever measures or calculated columns.

upvoted 1 times

...

Aleksoo

4 years, 11 months ago

The answer is B. It is looking for to simplify the model. Read the Note part. https://support.microsoft.com/en-us/office/power-pivot-reporting-properties-hiding-tables-columns-and-fields-from-power-pivot-and-power-view-a9c1142f-7b27-4c60-8e31-67edf41fbf4b

upvoted 1 times

...

PowerLjubica

4 years, 11 months ago

I think that in order to distinguish "hide from clients view" from"perspective" one should look weather it affects model or workbook. In this case it is said model, and perspective changes the look of the model, not a workbook.

upvoted 1 times

Ganimet

4 years, 11 months ago

so whats the right answer? :)

upvoted 1 times

...

Melvin11

5 years, 4 months ago

B is correct.. Tested!!

upvoted 1 times

Arklur

5 years, 3 months ago

"Tested" --> it will work, for sure, but as others already pointed out, it will be applied to **all users**, not just for a subset of users, hence the solution should be "A".

upvoted 11 times

...