Microsoft PL-300 Practice Exams
Last updated on Nov 16,2026- Exam Code: PL-300
- Exam Name: Microsoft Power BI Data Analyst
- Certification Provider: Microsoft
- Latest update: Nov 16,2026
You need to create relationships to meet the reporting requirements of the customer service department.
What should you create?
- A . an additional date table named ShipDate, a one-to-many relationship from Sales[sales_date_id] to Date[date_id], and a one-to-many relationship from Sales[sales_ship_date_id] to ShipDate[date_id]
- B . an additional date table named ShipDate, a many-to-many relationship from Sales[sales_date_id] to Date[date_id], and a many-to-many relationship from Sales[sales_ship_date_id] to ShipDate[date_id]
- C . a one-to-many relationship from Date[date_id] to Sales[sales_date_id] and another one-to-many relationship from Date[date_id] to Weekly_Returns[week_id]
- D . a one-to-many relationship from Sales[sales_date_id] to Date[date_id] and a one-to-many relationship from Sales[sales_ship_date_id] to Date[date_id]
- E . a one-to-many relationship from Date[date_id] to Sales[sales_date_id] and another one-to-many relationship from Date[date_id] to Sales[sales_ship_date_id]
Your company has training videos that are published to Microsoft Stream. You need to surface the videos directly in a Microsoft Power BI dashboard.
Which type of tile should you add?
- A . video
- B . custom streaming data
- C . text box
- D . web content
HOTSPOT
You need to create a visualization to meet the reporting requirements of the sales managers.
How should you create the visualization? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

HOTSPOT
You need to create a visualization to meet the reporting requirements of the sales managers.
How should you create the visualization? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

You have a CSV file that contains user complaints. The file contains a column named Logged. Logged
contains the date and time each compliant 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?
- A . Change the data type of the Logged column to Date.
- B . Apply a transform to extract the last 11 characters of the Logged column and set the data type of the new column to Date.
- C . Create a column by example that starts with 2018-12-31 and set the data type of the new column to Date.
- D . Apply a transform to extract the first 11 characters of the Logged column.
You build a report to help the sales team understand its performance and the drivers of sales. The team needs to have a single visualization to identify which factors affect success.
Which type of visualization should you use?
- A . Key influences
- B . Funnel chart
- C . Q&A
- D . Line and clustered column chart
DRAG DROP
You have a Microsoft Power Bl workspace.
You need to grant the user capabilities shown in the following table.

The solution must use the principle of least privilege.
Which user role should you assign to each user? To answer, drag the appropriate roles to the correct users. Each role 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.

You have an Azure SQL database that contains sales transactions. The database is updated frequently.
You need to generate reports from the data to detect fraudulent transactions. The data must be visible within five minutes of an update.
How should you configure the data connection?
- A . Add a SQL statement.
- B . Set Data Connectivity mode to DirectQuery.
- C . Set the Command timeout in minutes setting.
- D . Set Data Connectivity mode to Import.
HOTSPOT
You are creating a Microsoft Power Bl imported data model to perform basket analysis. The goal of the analysis is to identify which products are usually bought together in the same transaction across and within sales territories.
You import a fact table named Sales as shown in the exhibit. (Click the Exhibit tab.)

The related dimension tables are imported into the model.
For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.

You build a report to analyze customer transactions from a database that contains the tables shown in the following table.

You import the tables.
Which relationship should you use to link the tables?
- A . one-to-many from Customer to Transaction
- B . one-to-one between Customer and Transaction
- C . one-to-many from Transaction to Customer
- D . many-to-many between Customer and Transaction