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

QUESTION: 26

You have data in a Microsoft Excel worksheet as shown in the following table.
You need to use Power Query to clean and transform the dataset. The solution must meet the following requirements:
• If the discount column returns an error, a discount of 0.05 must be used.
• All the rows of data must be maintained.
• Administrative effort must be minimized.
What should you do in Power Query Editor?

Select Replace Errors.
Edit the query in the Query Errors group.
Select Remove Errors.
Select Keep Errors.

Answer(s): A

Reveal Solution Next Question

QUESTION: 27

You have a CSV file that contains user complaints. The file contains a column named Logged. Logged contains the date and time each complaint occurred. The data in Logged is in the following format: 2018-12-31 at 08:59.
You need to be able to analyze the complaints by the logged date and use a built-in date hierarchy.
What should you do?

Apply the Parse function from the Data transformations options to the Logged column.
Change the data type of the Logged column to Date.
Split the Logged column by using at as the delimiter.
Create a column by example that starts with 2018-12-31.

Answer(s): C

Reveal Solution Next Question

QUESTION: 28

DRAG DROP (Drag and Drop is not supported)
You have two Microsoft Excel workbooks in a Microsoft OneDrive folder.
Each workbook contains a table named Sales. The tables have the same data structure in both workbooks.
You plan to use Power BI to combine both Sales tables into a single table and create visuals based on the data in the table. The solution must ensure that you can publish a separate report and dataset.
Which storage mode should you use for the report file and the dataset file? To answer, drag the appropriate modes to the correct files. Each mode may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.

See Explanation section for answer.

Answer(s): A

Explanation:

Reveal Solution Next Question

QUESTION: 29

You use Power Query to import two tables named Order Header and Order Details from an Azure SQL database. The Order Header table relates to the Order Details table by using a column named Order ID in each table.
You need to combine the tables into a single query that contains the unique columns of each table.
What should you select in Power Query Editor?

Merge queries
Combine files
Append queries

Answer(s): A

Reveal Solution Next Question

QUESTION: 30

You have a PBIX file that imports data from a Microsoft Excel data source stored in a file share on a local network.
You are notified that the Excel data source was moved to a new location.
You need to update the PBIX file to use the new location.
What are three ways to achieve the goal? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

From the Datasets settings of the Power BI service, configure the data source credentials.
From the Data source settings in Power BI Desktop, configure the file path.
From Current File in Power BI Desktop, configure the Data Load settings.
From Power Query Editor, use the formula bar to configure the file path for the applied step.
From Advanced Editor in Power Query Editor, configure the file path in the M code.

Answer(s): B,D,E

Reveal Solution Next Question

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

QUESTION: 26

QUESTION: 27

QUESTION: 28

Explanation:

QUESTION: 29

QUESTION: 30

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