Microsoft Updated PL-300 Exam Questions and Answers by eleri

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 the same in each question in this series.

You have a Microsoft SQL Server database that contains the following tables.

The following columns contain date information:

- Date[Month] in the mmyyyy format

- Date[Date_ID] in the ddmmyyyy format

- Date[Date_name] in the mm/dd/yyyy format

- Monthly_returns[Month_ID] in the mmyyyy format

The Order table contains more than one million rows.

The Store table has a relationship to the Monthly_returns table on the Store_ID column. This is the only relationship between the tables.

You plan to use Power BI Desktop to create an analytics solution for the data.

You need to create a relationship between the Order table and the Store table on the Store_ID column.

What should you do before you create the relationship?

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 the same in each question in this series.

You have a Microsoft SQL Server database that contains the following tables.

The following columns contain date information:

- Date[Month] in the mmyyyy format

- Date[Date_ID] in the ddmmyyyy format

- Date[Date_name] in the mm/dd/yyyy format

- Monthly_returns[Month_ID] in the mmyyyy format

The Order table contains more than one million rows.

The Store table has a relationship to the Monthly_returns table on the Store_ID column. This is the only relationship between the tables.

You plan to use Power BI Desktop to create an analytics solution for the data.

You need to create a relationship between the Monthly_returns table and Date[Date_ID].

What should you do before you create the relationship?

You have the following table named Location.

The GeoCode column represents the country where each customer is located.

You create a map visualization as shown in the exhibit. (Click the Exhibit tab.)

You need to ensure that the map displays the country locations.

What should you do?

You have a Power Bl visual that uses indicators to show values that are out of range as shown in the following exhibit.