exam questions

Exam 70-778 All Questions

View all questions & answers for the 70-778 exam

Exam 70-778 topic 1 question 40 discussion

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

Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is exactly the same in each question in this series.
Start of repeated scenario.
You have a Microsoft SQL Server database that has the tables shown in the Database Diagram exhibit. (Click the Exhibit button.)

You plan to develop a Power BI model as shown in the Power BI Model exhibit. (Click the Exhibit button.)

You plan to use Power BI to import data from 2013 to 2015.
Product Subcategory[Subcategory] contains NULL values.
End of Repeated Scenario.
You implement the Power BI model.
You add another table named Territory to the model. A sample of the data is shown in the following table.

You need to create a relationship between the Territory table and the Sales table.
Which function should you use in the query for Territory before you create the relationship?

  • A. Table.Distinct
  • B. Table.IsDistinct
  • C. Table.ReplaceMatchingRows
  • D. Table.RemoveMatchingRows
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️
References:
https://msdn.microsoft.com/en-us/library/mt260775.aspx

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
Jew0598
2 years, 2 months ago
It's Table.Distinct as Table.RemoveMatchingRows requires a list of rows to be specified.
upvoted 1 times
...
raphidol
3 years, 6 months ago
I am of the opinion that Table.Distinct and Table.RemoveMatchingRows are both possibly in order
upvoted 1 times
...
CDL
4 years, 7 months ago
A is correct. (agree with PabloM as well) https://docs.microsoft.com/en-us/powerquery-m/table-distinct
upvoted 2 times
...
Bravo2061
4 years, 8 months ago
The answer would be option C -- Table.ReplaceMatchingRows
upvoted 1 times
...
emile
5 years, 7 months ago
Table.Distinct and Table.RemoveMatchingRows are both possible right?
upvoted 3 times
PabloM
5 years, 6 months ago
No, Table.RemoveMatchingRows will remove the rows matching a particular value, but will not remove duplicates. The correct answer is Table.Distinct https://docs.microsoft.com/en-us/powerquery-m/table-removematchingrows
upvoted 2 times
PabloM
5 years, 6 months ago
#"Removed Duplicates" = Table.Distinct(#"Previous Step", {"TerritoryKey"})
upvoted 15 times
...
...
...
AnetaK
5 years, 10 months ago
That does not change anything. There are still six rows.
upvoted 2 times
SteveKarr
5 years, 10 months ago
It works, you need to supply TerritoryKey as the 2nd argument to the Table.Distinct
upvoted 7 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
Loading ...