Exam 70-779 All Questions

View all questions & answers for the 70-779 exam

Exam 70-779 topic 1 question 48 discussion

Actual exam question from Microsoft's 70-779

Question #: 48
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 a query named Query1 that retrieves the user information from two Excel files. One of the Excel files does not contain location information. A sample of the data retrieved by the query is shown in the following table.

You need to ensure that values in UserName are unique. The solution must ensure that the locations are retained. A sample of desired output is shown in the following table.

Solution: You use the Group By function to group the rows by UserName and you specify output columns for UserID and Location by using the Max operation.
Does this meet the goal?

A. Yes
B. No

Show Suggested Answer

Suggested Answer: B 🗳️

by JohnFan at Oct. 7, 2019, 7:07 a.m.

Comments

Submit Cancel

imran

Highly Voted 5 years, 8 months ago

a IS CORRECT DEFENITELY

upvoted 12 times

...

JohnFan

Highly Voted 5 years, 8 months ago

I have tried, this worked, though you need to specify user5 by yourself.

upvoted 11 times

lozqt

5 years, 3 months ago

It also worked for me, hence correct answer is A but as you said above, user 5 does not just come up...

upvoted 2 times

...

Tancredii

Most Recent 4 years, 6 months ago

Tested. A is correct. step1, import to PQ editor step2, Group by UserName step3, select "Advanced" in pop-up interface step4, output the other 2 columns "UserID" & "Location" with "MAX" operation. step5, load to..

upvoted 1 times

...

P_S09

4 years, 6 months ago

the Answer is A, you can use group by filter option for user name, ADVANCED TAB, ADD AGGREATION to select the Userid, and Location column setting the operation to MAX

upvoted 1 times

...

Robc79

4 years, 7 months ago

tested, and the answer is definitely A

upvoted 1 times

...

CDL

4 years, 8 months ago

A is correct, Tested. step1, import to PQ editor step2, Group by UserName step3, select "Advanced" in pop-up interface step4, output the other 2 columns "UserID" & "Location" with "MAX" operation. step5, load to..

upvoted 3 times

...

Sober

4 years, 9 months ago

Using the MAX operation gives me null, MIN gives me the correct answer

upvoted 1 times

...

Outsider

5 years ago

Answer A is correct. Tested. forget User 5 even if you added on the original table you will get the correct result

upvoted 1 times

...

Vermonster

5 years, 3 months ago

Example has no correct answer. If you just Group By UserName, you can only specify one column so you'll lose the other. However, if you select both UserName and UserID and then Group By on those columns using Max on Location, you will get the result shown.

upvoted 2 times

Vermonster

5 years, 3 months ago

A is correct. You need to click Advanced to be able to specify more than one column to aggregate. If you specify MAX, you will get the desired result

upvoted 2 times

...

Arklur

5 years, 4 months ago

A is not correct. For this example this *might be* correct, for sure, but you get the "MAX" for each column separately, which means you may get the the UserId and the Location from 2 different rows. Sure, it SureName will be unique, but it won't be correct, so I would say "No" rather than yes...

upvoted 1 times