Microsoft Power BI (PL-300) Practice
Test Exam Questions & Answers
(Grade A+)
Solution: Add Synonyms to the Sales Table
Does this solution meet the goal? -
correct answer ✅Yes
No
No
Yes
A visualization is created that shows the year, department, and
forecast sales as shown in the exhibit.
Which relationship should you reconfigure, and what you do to
resolve the issue? -
correct answer ✅Relationship to reconfigure: Chart of Accounts
and Budget
,Microsoft Power BI (PL-300) Practice
Test Exam Questions & Answers
(Grade A+)
How to reconfigure the relationship: Set the cross filter direction
option to both
You are planning to configure the relationship between Chart of
Accounts and Predicted Sales to meet the security requirements.
You need to be able to apply the security filter in both directions.
What should you do? -
correct answer ✅Set the Cross filter direction option to Both
You plan to create visualizations for the Income sheet and show the
data changes by year for country and territory.
You need to transform the Income table to enable these
visualizations.
Which four actions should you perform in sequence? -
correct answer ✅Use the First Row as Header transformation
,Microsoft Power BI (PL-300) Practice
Test Exam Questions & Answers
(Grade A+)
Select the Year columns and Unpivot the columns
Rename the fourth column as Year and the fifth column as Sales
Income
Create relationships to the Chart of Accounts, Territory, and Year
entities
You have a visualization that shows the Budget amount by Account
Number.
You need to enable the drill down on the Chart on Account
structure on the visualization.
Which four actions should you perform in sequence? -
correct answer ✅Click on the Parent Account Number column and
select New hierarchy
Click on Account Number and select add to hierarchy
, Microsoft Power BI (PL-300) Practice
Test Exam Questions & Answers
(Grade A+)
In the visualization, replace the Account number with the New
hierarchy
Enable drill down on the visualization
You need to create a table containing unique countries, and a table
of unique combinations of countries and territories.
Which DAX expressions should you use? -
correct answer ✅Country = VALUES ('Predicted Sales '[Country])
Territory = SUMMARIZ('Predicted Sales', [Territory], [Country])
How should you enable this feature?
Solution: Add the Q&A visual to the report page.
Does this solution meet the goal? -
correct answer ✅No
Test Exam Questions & Answers
(Grade A+)
Solution: Add Synonyms to the Sales Table
Does this solution meet the goal? -
correct answer ✅Yes
No
No
Yes
A visualization is created that shows the year, department, and
forecast sales as shown in the exhibit.
Which relationship should you reconfigure, and what you do to
resolve the issue? -
correct answer ✅Relationship to reconfigure: Chart of Accounts
and Budget
,Microsoft Power BI (PL-300) Practice
Test Exam Questions & Answers
(Grade A+)
How to reconfigure the relationship: Set the cross filter direction
option to both
You are planning to configure the relationship between Chart of
Accounts and Predicted Sales to meet the security requirements.
You need to be able to apply the security filter in both directions.
What should you do? -
correct answer ✅Set the Cross filter direction option to Both
You plan to create visualizations for the Income sheet and show the
data changes by year for country and territory.
You need to transform the Income table to enable these
visualizations.
Which four actions should you perform in sequence? -
correct answer ✅Use the First Row as Header transformation
,Microsoft Power BI (PL-300) Practice
Test Exam Questions & Answers
(Grade A+)
Select the Year columns and Unpivot the columns
Rename the fourth column as Year and the fifth column as Sales
Income
Create relationships to the Chart of Accounts, Territory, and Year
entities
You have a visualization that shows the Budget amount by Account
Number.
You need to enable the drill down on the Chart on Account
structure on the visualization.
Which four actions should you perform in sequence? -
correct answer ✅Click on the Parent Account Number column and
select New hierarchy
Click on Account Number and select add to hierarchy
, Microsoft Power BI (PL-300) Practice
Test Exam Questions & Answers
(Grade A+)
In the visualization, replace the Account number with the New
hierarchy
Enable drill down on the visualization
You need to create a table containing unique countries, and a table
of unique combinations of countries and territories.
Which DAX expressions should you use? -
correct answer ✅Country = VALUES ('Predicted Sales '[Country])
Territory = SUMMARIZ('Predicted Sales', [Territory], [Country])
How should you enable this feature?
Solution: Add the Q&A visual to the report page.
Does this solution meet the goal? -
correct answer ✅No
