Exam 70-779 topic 1 question 61 discussion

Actual exam question from Microsoft's 70-779

Question #: 61
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 the following data.

You need to retrieve a list of the unique ProductName entries.
Solution: Create a PivotTable that uses the ProductName field in the Rows area.
Does this meet the goal?

A. Yes
B. No

Show Suggested Answer

Suggested Answer: B 🗳️

by imran at Oct. 10, 2019, 5:41 a.m.

Comments

Submit Cancel

imran

Highly Voted 5 years, 9 months ago

YES THIS IS CORRECT. ROWS IN PIVOT TABLE ALWAYS GIVE UNIQUE VALUE

upvoted 37 times

...

mohroshdy

Highly Voted 5 years, 8 months ago

A is correct

upvoted 9 times

...

CDL

Most Recent 4 years, 9 months ago

the purpose here is to get a unique list as a dimension table probably? then"No", I will go PQ editor and then "refence" it and "remove other column" and then "group by" product" or "remove the duplicate".

upvoted 1 times

PowerBIconsultant12

4 years, 9 months ago

I just tried it => if you create the pivottable and only drag and drop the productname in the row and do nothing more you directly have a unique list of productname

upvoted 2 times

CDL

4 years, 9 months ago

but the purpose here is to retrieve a list, so that it could be used to a dim_Table? which means do it in PQ then load to Data Model for relationship purpose?

upvoted 1 times

...