Microsoft Power BI Data Analyst - PL-300 Exam Questions
QUESTION NO: 1
You have the CSV file shown in the following table.
You use Power Query Editor to preview the data in the file.
You need to transform the data to meet the following requirements:
; The first column must contain the month.
; The second column must contain the year.
; The third column must contain the order amount for the month and year.
Which transformation should you use first?
You have the CSV file shown in the following table.
You use Power Query Editor to preview the data in the file.
You need to transform the data to meet the following requirements:
; The first column must contain the month.
; The second column must contain the year.
; The third column must contain the order amount for the month and year.
Which transformation should you use first?
Correct Answer: A
Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).
QUESTION NO: 2
You are creating a Power BI report by using Power BI Desktop.
You need to include a visual that identifies trends and other useful information automatically. The visual must update based on selections in other visuals.
Which type of visual should you use?
You are creating a Power BI report by using Power BI Desktop.
You need to include a visual that identifies trends and other useful information automatically. The visual must update based on selections in other visuals.
Which type of visual should you use?
Correct Answer: B
Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).
QUESTION NO: 3
You have a Fabric tenant that hosts the semantic models shown in the following table.
You have the following requirements:
The export of reports that contain Personally Identifiable Information (PII) must be prevented.
Data used for financial decisions must be reviewed and approved before use.
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 have a Fabric tenant that hosts the semantic models shown in the following table.
You have the following requirements:
The export of reports that contain Personally Identifiable Information (PII) must be prevented.
Data used for financial decisions must be reviewed and approved before use.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Correct Answer:
Explanation:
The scenario is asking for a way to Data used for financial decisions must be reviewed and approved before use. The completed mapping shown in the answer area is correct. Visual formatting or RLS can limit views but does not attach the information-classification and downstream handling signal supplied by a sensitivity label. Sensitivity labels and related classifications communicate handling requirements on Power BI items with minimal visual redesign. They are intended for identifying and governing sensitive business information.
The current skills outline describes this competency as " Apply sensitivity labels " . This keeps service access and operational behavior within the scope requested instead of granting or changing unrelated capabilities.
Microsoft Learn reference: https://learn.microsoft.com/en-us/power-bi/enterprise/service-security-sensitivity- label-overview | PL-300 objective: " Apply sensitivity labels " | Study guide: https://learn.microsoft.com/en-us
/credentials/certifications/resources/study-guides/pl-300
QUESTION NO: 4
You are creating a Power BI model and report.
You have a single table in a data mode) named Product Product contains the following fields:
; ID
; Name
; Color
; Category
; Total Sales
You need to create a calculated table that shows only the top eight products based on the highest value in Total Sales.
How should you complete the DAX expression? To answer, drag the appropriate values to the coned targets.
Each value 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.
You are creating a Power BI model and report.
You have a single table in a data mode) named Product Product contains the following fields:
; ID
; Name
; Color
; Category
; Total Sales
You need to create a calculated table that shows only the top eight products based on the highest value in Total Sales.
How should you complete the DAX expression? To answer, drag the appropriate values to the coned targets.
Each value 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.
Correct Answer:
Explanation:
Measures are evaluated in the current filter context, whereas calculated columns are stored at refresh. The selected DAX must therefore return the requested result at the correct grain without materializing unnecessary model data. The key constraint is to create a calculated table that shows only the top eight products based on the highest value in Total Sales. The retained answer-area mapping contains the correct selections. The relevant current PL-300 study-guide bullet is " Create calculated tables or columns " . A measure would not create the persistent row-level field or table needed for sorting, categorization, relationships, or reuse in the model. It also preserves predictable filter context and aggregation behavior when the result is used by several visuals or report pages.
Microsoft Learn reference: https://learn.microsoft.com/en-us/dax/ | PL-300 objective: " Create calculated tables or columns " | Study guide: https://learn.microsoft.com/en-us/credentials/certifications/resources/study- guides/pl-300
QUESTION NO: 5
You have a semantic model that contains two tables named Sales and Date. The Sales table relates to the Date table by using a many-to-one relationship. The Sales table contains the following columns:
; Date
; Product
; SalesAmount
You need to create a DAX measure for a rolling 31 -day sales total that will return the total sales amount for a selected date and the previous 30 days.
Which DAX expression should you use?
You have a semantic model that contains two tables named Sales and Date. The Sales table relates to the Date table by using a many-to-one relationship. The Sales table contains the following columns:
; Date
; Product
; SalesAmount
You need to create a DAX measure for a rolling 31 -day sales total that will return the total sales amount for a selected date and the previous 30 days.
Which DAX expression should you use?
Correct Answer: C
Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).
QUESTION NO: 6
You have a Power BI report that contains five bookmarks.
You need to add an object to the report from which users can navigate between three specific bookmarks.
How should you complete the task? To answer, drag the appropriate actions to the correct steps, each action may be used once more than once, or not at all. You may need to drag the split bar between panes or scroll lo view content.
NOTE: Each correct selection is worth one point.
You have a Power BI report that contains five bookmarks.
You need to add an object to the report from which users can navigate between three specific bookmarks.
How should you complete the task? To answer, drag the appropriate actions to the correct steps, each action may be used once more than once, or not at all. You may need to drag the split bar between panes or scroll lo view content.
NOTE: Each correct selection is worth one point.
Correct Answer:
Explanation:
What determines the answer is the need to add an object to the report from which users can navigate between three specific bookmarks. Each Power BI visual encodes a different relationship. The field wells, filters, and formatting must preserve the intended comparison, trend, hierarchy, or composition without implying a conclusion the data does not support. Use the selections preserved in the answer exhibit as the supported configuration. The other visual or configuration choices encode a different task, lose the required interaction, or fail one of the stated display constraints. Microsoft lists this skill in the current PL-300 outline as " Configure bookmarks " .
Microsoft Learn reference: https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualizations- overview | PL-300 objective: " Configure bookmarks " | Study guide: https://learn.microsoft.com/en-us
/credentials/certifications/resources/study-guides/pl-300
QUESTION NO: 7
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 scenario, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have several reports and dashboards in a workspace.
You need to grant all organizational users read access to a dashboard and several reports.
Solution: You create an Azure Active Directory group that contains all the users. You share each report and dashboard to the group.
Does this meet the goal?
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 scenario, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have several reports and dashboards in a workspace.
You need to grant all organizational users read access to a dashboard and several reports.
Solution: You create an Azure Active Directory group that contains all the users. You share each report and dashboard to the group.
Does this meet the goal?
Correct Answer: A
Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).
QUESTION NO: 8
You have a Power BI report that contains the visuals shown in the following table.
You need to modify the location of each visual.
What should you modify for each visual?
You have a Power BI report that contains the visuals shown in the following table.
You need to modify the location of each visual.
What should you modify for each visual?
Correct Answer: A
Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).
QUESTION NO: 9
You use Power Query Editor to Import three tables named Customers. Address, and Country.
In the source system, not every customer has a related address, but every address has a related country.
You need to merge all the tables into a single query. The solution must optimise query refresh performance.
Which type of join should you use for each merge operation? To answer, drag the appropriate join types to the correct operations. Each join type 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 it worth one point.
You use Power Query Editor to Import three tables named Customers. Address, and Country.
In the source system, not every customer has a related address, but every address has a related country.
You need to merge all the tables into a single query. The solution must optimise query refresh performance.
Which type of join should you use for each merge operation? To answer, drag the appropriate join types to the correct operations. Each join type 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 it worth one point.
Correct Answer:
Explanation:
The retained answer-area mapping contains the correct selections. The scenario is asking for a way to merge all the tables into a single query. The solution must optimise query refresh performance. Append stacks records vertically and therefore cannot bring related attributes onto the same row; that requires a key-based merge. A merge joins columns from related tables by matching key values. That is the appropriate operation when one output row must contain attributes from both sources; append would stack rows instead. In Microsoft ' s current exam outline, the corresponding objective is " Merge and append queries " . The join type also preserves the inclusion rule stated in the scenario while avoiding an unrelated increase in table grain.
Microsoft Learn reference: https://learn.microsoft.com/en-us/power-query/merge-queries-overview | PL-300 objective: " Merge and append queries " | Study guide: https://learn.microsoft.com/en-us/credentials
/certifications/resources/study-guides/pl-300
QUESTION NO: 10
What should you do to address the existing environment data concerns?
What should you do to address the existing environment data concerns?
Correct Answer: B
Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).
QUESTION NO: 11
You use Power BI Desktop to create a report named RPT1 that loads data from a Microsoft Excel file named File1. File1 is located in a network share.
File1 Is moved to a different folder.
When you open RPT1 in Power BI Desktop, you discover that the report displays outdated data.
You need to ensure that the data in File1 refreshes properly.
What should you do?
You use Power BI Desktop to create a report named RPT1 that loads data from a Microsoft Excel file named File1. File1 is located in a network share.
File1 Is moved to a different folder.
When you open RPT1 in Power BI Desktop, you discover that the report displays outdated data.
You need to ensure that the data in File1 refreshes properly.
What should you do?
Correct Answer: C
Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).
QUESTION NO: 12
You have a Power BI report.
You plan to use the Analyze feature to explain unusual distributions in visuals. You need to identify insights in the data. What should you do?
You have a Power BI report.
You plan to use the Analyze feature to explain unusual distributions in visuals. You need to identify insights in the data. What should you do?
Correct Answer: A
Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).
QUESTION NO: 13
You attempt to connect Purer 81 Desktop to a Cassandra database.
From the Get Data connector list you discover that there is no specific connector for the Cassandra database, You need to select an alternate data connector that will connect to the database.
Which of connector should you choose?
You attempt to connect Purer 81 Desktop to a Cassandra database.
From the Get Data connector list you discover that there is no specific connector for the Cassandra database, You need to select an alternate data connector that will connect to the database.
Which of connector should you choose?
Correct Answer: C
Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).
QUESTION NO: 14
You are creating a sales report in Power BI for the NorthWest region sales territory of your company. Data will come from a view in a Microsoft SQL Server database. A sample of the data is shown in the following table:
The report will facilitate the following analysis:
; The count of orders and the sum of total sales by Order Date
; The count of customers who placed an order
; The average quantity per order
You need to reduce data refresh times and report query times.
Which two actions should you perform? Each correct answer presents part of the solution NOTE: Each correct selection is worth one point.
You are creating a sales report in Power BI for the NorthWest region sales territory of your company. Data will come from a view in a Microsoft SQL Server database. A sample of the data is shown in the following table:
The report will facilitate the following analysis:
; The count of orders and the sum of total sales by Order Date
; The count of customers who placed an order
; The average quantity per order
You need to reduce data refresh times and report query times.
Which two actions should you perform? Each correct answer presents part of the solution NOTE: Each correct selection is worth one point.
Correct Answer: B,C
Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).
QUESTION NO: 15
You have a Microsoft Excel spreadsheet that contains the data shown in the following table.
You plan to build a data model for a Power BI report.
You need to prepare the data so that it is available to the model in the format shown in the following table.
Which three actions should you perform in sequence in Power Query Editor? 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 spreadsheet that contains the data shown in the following table.
You plan to build a data model for a Power BI report.
You need to prepare the data so that it is available to the model in the format shown in the following table.
Which three actions should you perform in sequence in Power Query Editor? 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:
The required outcome is to prepare the data so that it is available to the model in the format shown in the following table. The completed mapping shown in the answer area is correct. A visual, measure, or model relationship cannot repair the incoming tabular shape; those features operate after the query result has already been loaded. This is a shaping operation in Power Query. Performing it in the applied steps produces correctly typed, named, and structured columns before loading, which keeps report and model logic focused on analysis. The current skills outline describes this competency as " Create and transform columns " .
Microsoft Learn reference: https://learn.microsoft.com/en-us/power-query/best-practices | PL-300 objective: " Create and transform columns " | Study guide: https://learn.microsoft.com/en-us/credentials/certifications
/resources/study-guides/pl-300
