Exam 70-779 All Questions

View all questions & answers for the 70-779 exam

Exam 70-779 topic 1 question 9 discussion

Actual exam question from Microsoft's 70-779

Question #: 9
Topic #: 1

Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is the same in each question in this series.
Start of repeated scenario.
You have six workbook queries that each extracts a table from a Microsoft Azure SQL database. The tables are loaded to the data model, but the data is not loaded to any worksheets. The data model is shown in the Data Model exhibit. (Click the Exhibit button.)
Exhibit:

Your company has 100 product subcategories and more than 10,000 products.
End of repeated scenario.
You need to create a simplified view of the workbook for some users. The simplified view must only display data from FactSales, DimProduct, and DimDate.
What should you do in the data model?

A. Click Hide from Client Tools for all the tables except FactSales, DimProduct, and DimDate
B. Add the columns from FactSales, DimProduct, and DimDate to the Default Field Set
C. Create a new perspective
D. Modify the Table behavior settings for FactSales, DimProduct, and DimDate

Show Suggested Answer

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

by Aurelkb at Nov. 1, 2019, 1:15 p.m.

Comments

Submit Cancel

Aurelkb

Highly Voted 5 years, 7 months ago

I thinks C is correct

upvoted 15 times

...

Mag53

Highly Voted 5 years, 5 months ago

I stay with C. Question is: You need to create a simplified view of the workbook FOR SOME USERS". Hide from client tool would effect all users.

upvoted 13 times

...

Nastja

Most Recent 4 years, 5 months ago

Tested C: works

upvoted 1 times

...

babayoga

5 years, 1 month ago

Should be C. https://support.office.com/en-us/article/perspectives-in-power-pivot-43b4e178-3d89-486c-8acd-ebc63802fead

upvoted 2 times

...

Bobrlez

5 years, 1 month ago

I believe it is A, because the "Perspectives" don't affect viewing data in tables and pivots, but "Hide from Client Tools" does.

upvoted 8 times

PowerBIconsultant12

4 years, 8 months ago

"affecting" data was not necessary, only a simplified view and that is exactly what the perspective can give it to different groups of users => C

upvoted 2 times

...

jjorge1

5 years, 1 month ago

Going with coice C https://docs.microsoft.com/en-us/analysis-services/tutorial-tabular-1200/lesson-8-create-perspectives?view=asallproducts-allversions

upvoted 3 times

...

Vermonster

5 years, 3 months ago

Perspectives currently only work for filtering the data model, not the pivot table. I have tested this on SharePoint as well and despite some articles suggesting that it does something on SharePoint, it doesn't. Therefore, I would go with A since it is the only answer that simplifies the PivotTable view at all even though it would do it for all users.

upvoted 2 times

PowerBIconsultant12

4 years, 8 months ago

True, but a pivot table was not mentioned in the question: only a simplified view for some users (the key is "some" here). Please see: https://www.youtube.com/watch?v=-nJQd33ZSBI from 0min51sec

upvoted 1 times

...

cs3122

5 years, 5 months ago

Going with A on this one after much internal debate. Since the goal is to create a simplified view of the workbook, then you can do this with A. If you were to create perspectives, the user would have to know how to switch around to the correct perspective (goal is simplicity here). Plus the resource information tells us how to accomplish this. I was originally going with C, but changed my mind to A.

upvoted 8 times

Mrios

5 years, 4 months ago

Even when I create the new perspective, I can still see the tables when I create a pivot table. Not sure how C works, so I'd go with A as well.

upvoted 1 times

PowerBIconsultant12

4 years, 8 months ago

Nowhere it is mentioned that a pivot table is needed after. Only a simplified view was necessary: please see the following video: from 0 min 51 sec to 1 min 12 sec https://www.youtube.com/watch?v=-nJQd33ZSBI Therefore definitely the answer is C A does only work for ALL users not SOME users.

upvoted 3 times

...

lozqt

5 years, 3 months ago

Thank you for this explanation !!!

upvoted 1 times

...

AlkaLei

5 years, 5 months ago

You can achieve this by both A and C. I think A is better answer in this situation, because it is the simple way of achieving the result. Secondly, for C to be correct it should state somewhere that the wb is saved on SP, which it doesn't.

upvoted 2 times

...

Daviddy

5 years, 5 months ago

I think A is actually right. I'm not very yet familiar with perspective, but it seems to only exist inside data model. i.e. i can't create a pivot table based on the perspective, nor can i display perspective as a table in the workbook for other user to consume.

upvoted 3 times

...

Mag53

5 years, 6 months ago

Sorry, I switch to C as it best meetd:"simplified view of the workbook for some users" as a Perspectives is a custom view that we can define for a specific user group or business segment making it much easier to navigate through large data sets. But I´m not sure. Has somebody a good explanation why not A?

upvoted 4 times

...

Mag53

5 years, 6 months ago

Solution Link says: To hide an entire table, right-click the tab that contains the table and choose Hide from Client Tools --> A should be correct

upvoted 4 times

Melvin11

5 years, 4 months ago

Yes.. A is Correct Answer.

upvoted 1 times

...

tho

5 years, 7 months ago

Yes, agreed with Aurelkb, creating a new perspective for this specific group of user should be the answer.

upvoted 3 times

...