Free Microsoft PL-300 Exam Actual Questions

The questions for PL-300 were last updated On Nov 11, 2024

Question No. 1

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

You have a Power BI report that imports a date table and a sales table from an Azure SQL database data source. The sales table has the following date foreign keys:

Due Date

Order Date

Delivery Date

You need to support the analysis of sales over time based on all the date foreign keys.

Solution: From Power Query Editor, you rename the date query as Due Date. You reference the Due Date query twice to make the queries for Order Date and

Delivery Date.

Does this meet the goal?

Show Answer Hide Answer
Correct Answer: A

Creating two additional tables in Power Query can be a possible solution:

Remove any inactive relationships.

Consider renaming the role-playing dimension-type table to better describe its role. In the example, the Airport table is related to the ArrivalAirport column of the Flight table, so it's renamed as Arrival Airport.

Create a copy of the role-playing table, providing it with a name that reflects its role. If it's an Import table, we recommend defining a calculated table. If it's a DirectQuery table, you can duplicate the Power Query query.

In the example, the Departure Airport table was created by using the following calculated table definition.


Question No. 2

You import two Microsoft Excel tables named Customer and Address into Power Query. Customer contains the following columns:

Customer ID

Customer Name

Phone

Email Address

Address ID

Address contains the following columns:

Address ID

Address Line 1

Address Line 2

City

State/Region

Country

Postal Code

The Customer ID and Address ID columns represent unique rows.

You need to create a query that has one row per customer. Each row must contain City, State/Region, and Country for each customer.

What should you do?

Show Answer Hide Answer
Correct Answer: A

There are two primary ways of combining queries: merging and appending.

When you have one or more columns that you'd like to add to another query, you merge the queries.

When you have additional rows of data that you'd like to add to an existing query, you append the query.


https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-shape-and-combine-data

Question No. 3

You have a Power Bl report named Report1 and a dashboard named Dashboard1, Report1 contains a line chart named Sales by month.

You pin the Sales by month visual to Dashboard1.

In Report1, you change the Sales by month visual to a bar chart.

You need to ensure that bar chart displays on Dashboard1.

What should you do?

Show Answer Hide Answer
Correct Answer: C

Question No. 4

You use Power BI Desktop to open a PBIX file that contains a Microsoft Excel data source.

You attempt to refresh the data and receive the following error message.

Expression.Error: The Colum 'cost' of the table wasn't found.

What is a possible cause of the error?

Show Answer Hide Answer
Correct Answer: A

Question No. 5

You publish a Microsoft Power BI dataset to powerbi.com. The dataset appends data from an on-premises Oracle database and an Azure SQL database by using one query.

You have admin access to the workspace and permission to use an existing On-premises data gateway for which the Oracle data source is already configured.

You need to ensure that the data is updated every morning. The solution must minimize configuration effort.

Which two actions should you perform when you configure scheduled refresh? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

Show Answer Hide Answer