ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam 70-779 All Questions

View all questions & answers for the 70-779 exam
Go to Exam

Exam 70-779 topic 1 question 46 discussion

Actual exam question from Microsoft's 70-779
Question #: 46
Topic #: 1
[All 70-779 Questions]

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 Remove Duplicates.
Does this meet the goal?

  • A. Yes
  • B. No
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️
by JohnFan at Oct. 7, 2019, 6:54 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
HiJaak
Highly Voted 5 years, 8 months ago
Te answer should be No. And just for curiosity... how does the user5 appeared in the second picture?
upvoted 16 times
...
swise001
Highly Voted 5 years, 3 months ago
The answer is B. Remove duplicates keeps the "first" entry and removes all subsequent ones. In the case of User1 and User2 - the rows with "Seattle" would be removed. I tested this in Excel and found that "B" is the answer.
upvoted 8 times
...
iaaqq
Most Recent 4 years, 5 months ago
TESTED : correct ans is A
upvoted 1 times
...
Tancredii
4 years, 6 months ago
Tested it : B is correct! Remove Duplicates either makes no difference or deletes the Location info: Select UserName & Location, then Remove Duplicates = No Difference Select UserName only or UserName & ID = Unique rows with Null locations
upvoted 3 times
...
kyliek7
4 years, 8 months ago
Remove duplicates with selected first 2 columns will work ;)
upvoted 1 times
...
lyniguez
4 years, 9 months ago
you would use Group By not remove duplicates for this situation
upvoted 1 times
...
Mar_tin
5 years, 2 months ago
A also did not work in my case. My workaround consists of filling up the Seattle values for User1&2, mark all columns & delete duplicates.
upvoted 2 times
...
mihenova
5 years, 4 months ago
The answer is B
upvoted 3 times
...
adavogl
5 years, 4 months ago
the answer is no because the locations was not retained
upvoted 2 times
...
SN22
5 years, 4 months ago
The answer should be B
upvoted 6 times
...
AnetaK
5 years, 6 months ago
= Table.Distinct(#"Change type", {"UserName", "UserId}) It works.
upvoted 1 times
mohroshdy
5 years, 6 months ago
I think you modified the M Code, But the question mentioned that YOU SELECT 2 columns and you click Remove Duplicate which is NOT possible.
upvoted 2 times
SPG
5 years, 5 months ago
Yes, it is. But anyway, if you select UserName and Location you will get a row for every Location of the user, so the table will remain the same.
upvoted 4 times
...
...
...
ammu
5 years, 7 months ago
Answer should be NO
upvoted 3 times
...
JohnFan
5 years, 8 months ago
Remove Duplicates?
upvoted 5 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel