Exam 70-779 topic 1 question 47 discussion

Actual exam question from Microsoft's 70-779

Question #: 47
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 select the UserName and Location columns, and then you click Keep Duplicates.
Does this meet the goal?

A. Yes
B. No

Show Suggested Answer

Suggested Answer: B 🗳️

by Robc79 at Dec. 1, 2020, 11:10 a.m.

Comments

Submit Cancel

Robc79

4 years, 6 months ago

there isn't an option to Keep Duplicates, so NO

upvoted 1 times

FrdFrd

4 years, 5 months ago

The option exists. It is Keep Rows > Keep Duplicates, under Reduce Rows (Home ribbon). But NO is the correct answer. TESTED. "Keep duplicates" keeps duplicate rows for the selected columns. Only one row is kept per duplicate group. If you select UserName and Location columns nothing will be kept, so answer is definitely NO

upvoted 2 times

...