Question 176 of 388
Single answerNote: 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 scenarioYou have a Microsoft SQL Server database that has the tables shown in the Database Diagram exhibit. You plan to develop a Power BI model as shown in the Power BI Model 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?
✓ATable.RemoveMatchingRowsB.Table.DistinctC.Table.InDistinctD.Table.ReplaceMatchingRows
BAdditional option
✓
Correct Answer: A
Table.RemoveMatchingRowsB.Table.DistinctC.Table.InDistinctD.Table.ReplaceMatchingRows
▥
Explanation
The correct answer is highlighted above. Review the wording carefully, then use the next question to continue building your understanding of Microsoft certification topics.