PL-300 Exam Questions and Answers | Exam-Dumps (Page: 5)

QUESTION: 21

HOTSPOT (Drag and Drop is not supported)
You have the Azure SQL databases shown in the following table.
You plan to build a single PBIX file to meet the following requirements:
• Data must be consumed from the database that corresponds to each stage of the development lifecycle.
• Power BI deployment pipelines must NOT be used.
• The solution must minimize administrative effort.
What should you do? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

See Explanation section for answer.

Answer(s): A

Explanation:

Reveal Solution Next Question

QUESTION: 22

You are creating a query to be used as a Country dimension in a star schema.
A snapshot of the source data is shown in the following table.
You need to create the dimension. The dimension must contain a list of unique countries.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

Delete the Country column.
Remove duplicates from the table.
Remove duplicates from the City column.
Delete the City column.
Remove duplicates from the Country column.

Answer(s): D,E

Reveal Solution Next Question

QUESTION: 23

DRAG DROP (Drag and Drop is not supported)
You use Power Query Editor to preview the data shown in the following exhibit.
You need to clean and transform the query so that all the rows of data are maintained, and error values in the discount column are replaced with a discount of 0.05. The solution must minimize administrative effort.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

See Explanation section for answer.

Answer(s): A

Explanation:

Reveal Solution Next Question

QUESTION: 24

HOTSPOT (Drag and Drop is not supported)
You attempt to use Power Query Editor to create a custom column and receive the error message shown in the following exhibit.
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.

See Explanation section for answer.

Answer(s): A

Explanation:

Reveal Solution Next Question

QUESTION: 25

From Power Query Editor, you attempt to execute a query and receive the following error message.
Datasource.Error: Could not find file.
What are two possible causes of the error? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

You do not have permissions to the file.
An incorrect privacy level was used for the data source.
The file is locked.
The referenced file was moved to a new location.

Answer(s): A,D

Reveal Solution Next Question

Microsoft PL-300 Exam (page: 5) Microsoft Power BI Data Analyst Updated on: 25-Dec-2025

QUESTION: 21

Explanation:

QUESTION: 22

QUESTION: 23

Explanation:

QUESTION: 24

Explanation:

QUESTION: 25

Microsoft PL-300 Exam (page: 5)
Microsoft Power BI Data Analyst
Updated on: 25-Dec-2025