Microsoft Power BI Data Analyst - PL-300 Exam Practice Test
You plan to use Power BI to create sales invoices for customers. The solution must meet the following requirements:
; Sales invoices must be exported in a PDF format
; The PDF exports must show all columns and rows clearly.
What should you create?
; Sales invoices must be exported in a PDF format
; The PDF exports must show all columns and rows clearly.
What should you create?
Correct Answer: D
Vote an answer
Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).
ion have a Power BI semantic model that contains a table named Temperature Readings. Temperature Readings contains the columns shown in the following table.
The table has 12 million rows. All the columns are needed for analysis.
You need to optimize the semantic model to decrease the model size. The solution must not affect the precision of the data.
What should you do?
The table has 12 million rows. All the columns are needed for analysis.
You need to optimize the semantic model to decrease the model size. The solution must not affect the precision of the data.
What should you do?
Correct Answer: A
Vote an answer
Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).
You have a Microsoft SharePoint Online site that contains several document libraries. One of the document libraries contains manufacturing reports saved as Microsoft Excel files. All the manufacturing reports have the same data structure.
You need to load only the manufacturing reports to a table for analysis.
What should you do in Microsoft Power BI Desktop?
You need to load only the manufacturing reports to a table for analysis.
What should you do in Microsoft Power BI Desktop?
Correct Answer: C
Vote an answer
Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).
You have a dashboard that contains tiles pinned from a single report as shown in the Original Dashboard exhibit.
You need to modify the dashboard to appear as shown in the Modified Dashboard exhibit.
What should you do?
You need to modify the dashboard to appear as shown in the Modified Dashboard exhibit.
What should you do?
Correct Answer: B
Vote an answer
Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).
You plan to use Power BI to create a quarterly profit report that meets the following requirements:
; Emphasizes the percentage of total profits contributed by each product category in dollars and as a percentage
; Compares profit margins across sales regions
Which type of visual should you use for each requirement? To answer, drag the appropriate visuals to the correct requirements. Each visual 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.
; Emphasizes the percentage of total profits contributed by each product category in dollars and as a percentage
; Compares profit margins across sales regions
Which type of visual should you use for each requirement? To answer, drag the appropriate visuals to the correct requirements. Each visual 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.
Correct Answer:
Explanation:
The selections in the retained answer exhibit are the verified configuration. 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. The scenario establishes that you plan to use Power BI to create a quarterly profit report that meets the following requirements:; Emphasizes the percentage of total profits contributed by each product category in dollars. The other visual or configuration choices encode a different task, lose the required interaction, or fail one of the stated display constraints. For exam alignment, this is assessed under " Select an appropriate visual " in the current study guide.
Microsoft Learn reference: https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualizations- overview | PL-300 objective: " Select an appropriate visual " | Study guide: https://learn.microsoft.com/en-us
/credentials/certifications/resources/study-guides/pl-300
You have a Power BI report that contains the table shown in the following exhibit.
The table contains conditional formatting that shows which stores are above, near, or below the monthly quota for returns. You need to ensure that the table is accessible to consumers of reports who have color vision deficiency. What should you do?
The table contains conditional formatting that shows which stores are above, near, or below the monthly quota for returns. You need to ensure that the table is accessible to consumers of reports who have color vision deficiency. What should you do?
Correct Answer: A
Vote an answer
Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).
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?
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?
Correct Answer: D
Vote an answer
Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).
You have a Power BI data model that analyzes product sales ever time. The data model contains the following tables.
A one-to-many relationship exists between the tables.
The auto date/time option for the data model enabled.
You need to reduce the size of the data model while maintaining the ability to analyze product sales by month and quarter.
Which two actions should you perform?
A one-to-many relationship exists between the tables.
The auto date/time option for the data model enabled.
You need to reduce the size of the data model while maintaining the ability to analyze product sales by month and quarter.
Which two actions should you perform?
Correct Answer: B,D
Vote an answer
Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).
You have a semantic model named Pens that contains the following columns:
Item
Unit Price
Quantity Ordered
You need to create a visualization that shows the relationship between Unit Price and Quantity Ordered. The solution must highlight orders that have a similar unit price and ordered quantity.
Which type of visualization and which feature should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Item
Unit Price
Quantity Ordered
You need to create a visualization that shows the relationship between Unit Price and Quantity Ordered. The solution must highlight orders that have a similar unit price and ordered quantity.
Which type of visualization and which feature should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Correct Answer:
Explanation:
The technical decision turns on how to create a visualization that shows the relationship between Unit Price and Quantity Ordered. The retained answer area specifies 1) A scatter plot; 2) Automatically find clusters. A sound report design pairs the user task with the visual ' s strengths, then configures fields and interactions so selections, drill actions, and filtering behave exactly as the scenario requires. The other visual or configuration choices encode a different task, lose the required interaction, or fail one of the stated display constraints. The current PL-300 study guide places this under the objective " Detect outliers and anomalies " . The result remains understandable to report consumers and responds correctly to the interaction or filtering behavior described in the question.
Microsoft Learn reference: https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualizations- overview | PL-300 objective: " Detect outliers and anomalies " | Study guide: https://learn.microsoft.com/en- us/credentials/certifications/resources/study-guides/pl-300