nerdexam
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

70-778 question #11 exhibit 1
70-778 question #11 exhibit 2

Options

  • ATable.RemoveMatchingRows
  • BTable.Distinct
  • CTable.InDistinct
  • DTable.ReplaceMatchingRows

How the community answered

(27 responses)
  • A
    4% (1)
  • B
    70% (19)
  • C
    19% (5)
  • D
    7% (2)

Explanation

https://msdn.microsoft.com/en-us/library/mt260775.aspx

Topics

#Power BI#Power Query#Table.Distinct#data deduplication

Community Discussion

No community discussion yet for this question.

Full 70-778 Practice