Exam 70-779 topic 1 question 2 discussion

Actual exam question from Microsoft's 70-779

Question #: 2
Topic #: 1

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have an Excel workbook that contains a table named Table1. A sample of the data in Table1 is shown in the following table.

You need to create a PivotTable in PowerPivot as shown in the exhibit. (Click the Exhibit button.)

Solution: You create a hierarchy named Products that contains ProductCategory, ProductSubCategory, and ProductName. You add a PivotTable. You drag
Products to the Rows field. You drag Price to the Values field.
Does this meet the goal?

A. Yes
B. No

Show Suggested Answer

Suggested Answer: A 🗳️

by Sachin08 at June 13, 2020, 2:03 a.m.

Comments

Submit Cancel

Waltmas

Highly Voted 4 years, 10 months ago

Actually this achieves the goal, it should be A. Then you expand by clicking the plus sign. I tested it it works.

upvoted 14 times

...

Vinni14

Most Recent 4 years, 7 months ago

To view the output of the table as mentioned in the question, you need to make changes in the Subtotal of the Pivot Table from Field Settings. Hence, answer should be B.

upvoted 1 times

...