Microsoft
70-778 · Question #11
Note: This question is a part of a series of questions that present the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and…
The correct answer is B. Table.Distinct. https://msdn.microsoft.com/en-us/library/mt260775.aspx
Manage big data solutions
Question
Note: This question is a part of a series of questions that present 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.) You plan to develop a Power BI model as shown in the Power BI Model exhibit. (Click the Exhibit). 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?
Exhibits
Options
- ATable.RemoveMatchingRows
- BTable.Distinct
- CTable.InDistinct
- DTable.ReplaceMatchingRows
How the community answered
(27 responses)- A4% (1)
- B70% (19)
- C19% (5)
- D7% (2)
Explanation
Topics
#Power BI#Power Query#Table.Distinct#data deduplication
Community Discussion
No community discussion yet for this question.

