Which function should you use in the query for Territory before you create the relationship?

Note This question it 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.

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 at 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.

You implement the Power BI model

You need to 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?

Note: This question it 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.

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 at 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.

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 Territory before you create the relationship?
A . Table.RemoveMatchingRows
B . Table.Distinct
C . Table.IsDistinct
D . Table.ReplaceMatchingRows

Answer: D

Latest 70-778 Dumps Valid Version with 147 Q&As

Latest And Valid Q&A | Instant Download | Once Fail, Full Refund

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments