PL-300: Microsoft Power BI Data Analyst
Questions and Answers Already Passed
When would you use a "Slicer" in a Power BI dashboard?
✔✔A) To filter visuals interactively
B) To delete unused data
C) To format report backgrounds
D) To change report languages
What does the "Refresh" button do in Power BI Desktop?
A) Deletes all existing data
✔✔B) Updates reports with the latest data from sources
C) Changes the report theme
D) Saves the report to OneDrive
What does the DAX function “CALCULATE” primarily help with?
A) Exporting reports
✔✔B) Modifying context filters in a calculation
C) Printing dashboards
1
,D) Changing visualization types
Which Power BI visual would you use to display trends over time?
✔✔A) Line Chart
B) Pie Chart
C) Matrix
D) Gauge
To limit data visibility based on user roles, what feature is used?
A) Data Transform
✔✔B) Row-level Security
C) Drill Mode
D) Conditional Formatting
What feature in Power BI lets you ask questions in natural language to generate visuals?
✔✔A) Q&A
B) Merge Queries
C) Power Pivot
2
,D) Column Chart
If you wanted to create a quick summary of your data with visual highlights, which feature
would you use?
A) Data Import
✔✔B) Smart Narrative
C) Model View
D) Bookmarks
How can you optimize your Power BI report to run faster?
✔✔A) Use Aggregations
B) Add more visuals
C) Increase data refresh frequency
D) Export to PDF
Which Power BI component allows you to directly import data from an Excel file?
A) Dataflows
B) DAX Formulas
3
, ✔✔C) Power Query
D) Row-level Security
In Power BI, what is the primary function of the "Drill Through" feature?
A) To delete unnecessary data
✔✔B) To view detailed data related to a specific category
C) To export reports to Excel
D) To modify data relationships
If you want to highlight high and low sales in a report, which feature would you use?
✔✔A) Conditional Formatting
B) Data Validation
C) Calculated Columns
D) Table Relationships
What is the best tool to use when combining multiple tables from different sources in Power BI?
A) Data Model
B) Export Tool
4
Questions and Answers Already Passed
When would you use a "Slicer" in a Power BI dashboard?
✔✔A) To filter visuals interactively
B) To delete unused data
C) To format report backgrounds
D) To change report languages
What does the "Refresh" button do in Power BI Desktop?
A) Deletes all existing data
✔✔B) Updates reports with the latest data from sources
C) Changes the report theme
D) Saves the report to OneDrive
What does the DAX function “CALCULATE” primarily help with?
A) Exporting reports
✔✔B) Modifying context filters in a calculation
C) Printing dashboards
1
,D) Changing visualization types
Which Power BI visual would you use to display trends over time?
✔✔A) Line Chart
B) Pie Chart
C) Matrix
D) Gauge
To limit data visibility based on user roles, what feature is used?
A) Data Transform
✔✔B) Row-level Security
C) Drill Mode
D) Conditional Formatting
What feature in Power BI lets you ask questions in natural language to generate visuals?
✔✔A) Q&A
B) Merge Queries
C) Power Pivot
2
,D) Column Chart
If you wanted to create a quick summary of your data with visual highlights, which feature
would you use?
A) Data Import
✔✔B) Smart Narrative
C) Model View
D) Bookmarks
How can you optimize your Power BI report to run faster?
✔✔A) Use Aggregations
B) Add more visuals
C) Increase data refresh frequency
D) Export to PDF
Which Power BI component allows you to directly import data from an Excel file?
A) Dataflows
B) DAX Formulas
3
, ✔✔C) Power Query
D) Row-level Security
In Power BI, what is the primary function of the "Drill Through" feature?
A) To delete unnecessary data
✔✔B) To view detailed data related to a specific category
C) To export reports to Excel
D) To modify data relationships
If you want to highlight high and low sales in a report, which feature would you use?
✔✔A) Conditional Formatting
B) Data Validation
C) Calculated Columns
D) Table Relationships
What is the best tool to use when combining multiple tables from different sources in Power BI?
A) Data Model
B) Export Tool
4
