Microsoft Power BI Data Analyst (PL-300) Free Practice Test
Question 1
You have a Microsoft Power BI Desktop report named Report1 that uses an Azure SQL database as a data source.
A user named User1 plans to create a report by using the same data source as Report1.
You need to simplify the connection to the data source for User1.
Which type of file should you create?
A user named User1 plans to create a report by using the same data source as Report1.
You need to simplify the connection to the data source for User1.
Which type of file should you create?
Correct Answer: B
Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).
Question 2
In the Power BI service, you create an app workplace that contains several dashboards.
You need to provide a user named [email protected] with the ability to edit and publish dashboards.
What should you do?
You need to provide a user named [email protected] with the ability to edit and publish dashboards.
What should you do?
Correct Answer: B
Question 3
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.
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.
Correct Answer: B,C
Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).
Question 4
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 the Fields pane, you rename the date table as Due Date. You use a DAX expression to create Order Date and Delivery Date as calculated tables. You create active relationships between the sales table and each date table.
Does this meet the goal?
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 the Fields pane, you rename the date table as Due Date. You use a DAX expression to create Order Date and Delivery Date as calculated tables. You create active relationships between the sales table and each date table.
Does this meet the goal?
Correct Answer: B
Question 5
Hotspot Question
You are designing the data model for a Power BI semantic model.
You have the following tables in the star schema.
Which table is the fact table of the star schema, and which column in the Patient table is the surrogate key of the star schema? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
You are designing the data model for a Power BI semantic model.
You have the following tables in the star schema.
Which table is the fact table of the star schema, and which column in the Patient table is the surrogate key of the star schema? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Correct Answer:
Question 6
Hotspot Question
You have a semantic model as 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.
You have a semantic model as 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.
Correct Answer:
Explanation:
Box 1: create an active relationship for PaymentDate
In a Microsoft Power BI semantic model with multiple relationships between the same two tables (e.g., FactSales and DimDate), only one relationship can be active at a time.
To select or compare values based on a secondary date, such as PaymentDate, while keeping OrderDate as the primary (active) link, you typically set the PaymentDate relationship as inactive and use the USERELATIONSHIP DAX function within a measure to invoke it.
Key Facts
Active vs. Inactive: Only one active relationship can exist between two tables; additional connections are automatically set as inactive (dotted line).
Invoking Inactive Relationships: To calculate metrics based on PaymentDate (the inactive link), you must wrap your measure in a CALCULATE function:
Total Payments = CALCULATE(SUM(FactSales[Amount]),
USERELATIONSHIP(DimDate[DateKey], FactSales[PaymentDate])).
Filtering Behavior: By default, any filter applied to the DimDate table will only propagate to FactSales through the active relationship (likely OrderDate).
Alternative (Role-Playing Dimensions): Instead of active/inactive relationships, you can create separate "role-playing" date tables (e.g., a DimOrderDate and a DimPaymentDate table) to allow independent filtering in the same visual without special DAX.
Box 2: role-playing
The DimDate table is a role-playing dimension. This is a common data modeling technique where a single physical dimension table is used multiple times within the same fact table, with each instance serving a different logical purpose or "role".
In your Power BI semantic model:
Single Physical Table: You have one physical DimDate table containing all date-related attributes.
Multiple Logical Roles: This single table is linked to the FactSales table through three different foreign keys: OrderDate, PaymentDate, and ShippingDate. Each of these columns represents a different "role" the date dimension plays.
Relationships in Power BI: In Power BI's data model, only one of these relationships can be active at a time (indicated by a solid line in the relationship view), while the others remain inactive (indicated by dotted lines).
Reference:
https://datasturdy.com/active-vs-inactive-relationships-in-power-bi-what-we-need-to-know
https://www.thedataschool.co.uk/svetlana-brazukevich/role-playing-dimensions-in-power-bi
Question 7
You have a PBiX file that imports several tables from an Azure SQL database. The data will be migrated to another Azure SQL database.
You need to change the connections in the PBIX file. The solution must minimize administrative effort.
What should you do?
You need to change the connections in the PBIX file. The solution must minimize administrative effort.
What should you do?
Correct Answer: A
Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).
Question 8
Drag and Drop Question
You have a Microsoft Excel workbook that contains two sheets named Sheet1 and Sheet2.
Sheet1 contains the following table named Table1.
Sheet2 contains the following table named Table2.
You need to use Power Query Editor to combine the products from Table1 and Table2 into the following table that has one column containing no duplicate values.
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.
You have a Microsoft Excel workbook that contains two sheets named Sheet1 and Sheet2.
Sheet1 contains the following table named Table1.
Sheet2 contains the following table named Table2.
You need to use Power Query Editor to combine the products from Table1 and Table2 into the following table that has one column containing no duplicate values.
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.
Correct Answer:
Explanation:
Reference:
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-shape-and-combine-data
Question 9
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: You create measures that use the USERELATIONSHIP DAX function to filter sales on the active relationship between the sales table and the date table.
Does this meet the goal?
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: You create measures that use the USERELATIONSHIP DAX function to filter sales on the active relationship between the sales table and the date table.
Does this meet the goal?
Correct Answer: A
Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).
Question 10
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 create a parameter named DataSourceExcel that holds the file name and location of a Microsoft Excel data source.
You need to update the query to reference the parameter instead of multiple hard-coded copies of the location within each query definition.
Solution: You create a new query that references DataSourceExcel.
Does this meet the goal?
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 create a parameter named DataSourceExcel that holds the file name and location of a Microsoft Excel data source.
You need to update the query to reference the parameter instead of multiple hard-coded copies of the location within each query definition.
Solution: You create a new query that references DataSourceExcel.
Does this meet the goal?
Correct Answer: A
Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).
Question 11
You use Power Query Editor to ingest data into Power BI Desktop from two Microsoft SharePoint Online lists named Customers and Locations.
Each list contains more than 25,000 rows. Locations is referenced in Customers to generate qualified values in a drop-down list.
You create the following query in Power Query Editor.
You experience long load times and discover that Power Query Editor makes calls to the URL of each row in the final dataset.
You need to optimize the query. The solution must minimize development effort.
What should you do?
Each list contains more than 25,000 rows. Locations is referenced in Customers to generate qualified values in a drop-down list.
You create the following query in Power Query Editor.
You experience long load times and discover that Power Query Editor makes calls to the URL of each row in the final dataset.
You need to optimize the query. The solution must minimize development effort.
What should you do?
Correct Answer: D
Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).
Question 12
You plan to use Power BI Desktop optimized for Power BI Report Server to create a report.
The report will be published to Power BI Report Server.
You need to ensure that all the visualization in the report can be consumed by users.
Which two types of visualizations should you exclude from the report? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
The report will be published to Power BI Report Server.
You need to ensure that all the visualization in the report can be consumed by users.
Which two types of visualizations should you exclude from the report? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
Correct Answer: C,E
Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).
Question 13
Hotspot Question
You are using Power Query Editor to preview the data in a column named Max Temp. The column statistics and value distribution are 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.
You are using Power Query Editor to preview the data in a column named Max Temp. The column statistics and value distribution are 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.
Correct Answer:
