PL-300 Microsoft Power BI Data Analyst Practice Exam

#1. What is the primary purpose of the ‘Measure’ in Power BI?

Creating relationships

Storing data

Calculating aggregations dynamically

Cleaning data

#2. In Power BI, what is a paginated report?

A mobile-friendly report

A real-time report

A dashboard report

A report designed for detailed, printable pages

#3. In Power BI, what does the ‘Key Influencers’ visual help you determine?

The relationship between tables

The top 10 items in a category

The best-performing products

The key factors affecting a metric

#4. You need to display a multi-row card with multiple values in Power BI. Which visual should you use?

Multi-Row Card

Table

Card

Matrix

#5. Which Power BI component allows users to build paginated reports?

Power BI Desktop

Power BI Service

Power Query Editor

Power BI Report Builder

#6. What is the primary use of calculated tables in Power BI?

To create new tables using DAX

To clean data

To perform row-level calculations

To store raw data

#7. You need to compare actual vs. target values in Power BI. Which visual should you use?

Treemap

Funnel Chart

Gauge Chart

Stacked Column Chart

#8. In Power BI, what is the default storage mode when importing data?

DirectQuery

Import

Hybrid

Live Connection

#9. Which of the following is a valid method to create a relationship between tables?

Manually add a primary key

Use the UNION function

Drag and drop in the Model view

Use the RELATED function

#10. Which type of Power BI visualization is best suited for showing the composition of data over time?

Pie Chart

Scatter Plot

Stacked Area Chart

Gauge Chart

#11. Which language is used to create calculated columns and measures in Power BI?

SQL

Python

DAX

M

#12. In Power BI, what does the ‘Append Queries’ feature do?

Combines multiple tables vertically

Removes duplicate values

Creates a pivot table

Joins tables based on a common column

#13. Which feature allows Power BI users to schedule automatic data refreshes?

Data Gateway

Dataflows

Power Query

Bookmarks

#14. You need to dynamically change a visual based on user selection. What feature should you use?

Drillthrough

Synonyms

Q&A

Bookmarks

#15. What is the purpose of the ‘Drillthrough’ feature in Power BI?

Navigating to a detailed view of data

Filtering data

Creating relationships

Exporting data

#16. Which visual in Power BI is best for displaying a trend over time?

Matrix

Pie Chart

Gauge

Line Chart

#17. Which chart is most suitable for showing the contribution of each category to a whole?

Pie Chart

Stacked Column Chart

TreeMap

Bar Chart

#18. Which function in DAX is used to calculate cumulative totals?

CALCULATE

TOTALYTD

COUNTROWS

SUMX

#19. Which of the following is NOT a valid Power BI data source?

Microsoft Excel

Google Docs

Azure Synapse Analytics

SQL Server

#20. Which file format is used to import a Power BI desktop report?

.pbix

.csv

.pbit

.xlsx

#21. Which formula correctly creates a new measure in Power BI?

Measure = SUM(Sales[Amount])

Column = SUM(Sales[Amount])

CreateMeasure(Sales[Amount])

DAX(Sales[Amount])

#22. Which of the following storage modes provides the fastest query performance in Power BI?

Composite

Import

DirectQuery

Live Connection

#23. In Power BI, what is the purpose of the ‘Group By’ operation in Power Query?

To summarize data by category

To filter data

To append queries

To create relationships between tables

#24. Which Power BI component is responsible for scheduled data refresh?

Power BI Gateway

DAX Engine

Power BI Desktop

Power Query

#25. What is the purpose of the ‘Synonyms’ feature in Power BI?

Enhance data relationships

Allow users to ask questions in natural language

Create measures

Improve performance

#26. You need to create a report that updates automatically every 5 minutes. Which connection type should you use?

DirectQuery

Live Connection

Power Automate

Import

#27. What is the main purpose of the Power Query editor in Power BI?

Writing DAX calculations

Creating relationships between tables

Transforming and cleaning data

Building dashboards

#28. You want to remove duplicate records in Power Query. What should you do?

Apply a FILTER function

Use the REMOVE DUPLICATES option

Use the DISTINCTCOUNT function

Use GROUP BY

#29. Which feature allows you to create reusable datasets in Power BI Service?

Drillthrough

DirectQuery

Row-Level Security

Dataflows

#30. You need to ensure that only authorized users can see sensitive data in a Power BI report. What feature should you use?

Row-Level Security (RLS)

Conditional Formatting

Drillthrough

Data Categorization

#31. What is the purpose of a ‘What-If Parameter’ in Power BI?

To test different scenarios dynamically

To refresh data

To merge queries

To create relationships between tables

#32. Which function in DAX returns a single value based on a condition?

SUMX

IF

FILTER

ALL

#33. In DirectQuery mode, where is the data stored?

In the cloud

In a temporary cache

In the original data source

In Power BI Desktop

#34. In Power BI, what is the purpose of a tooltip?

Creating interactive filters

Displaying additional information when hovering over a visual

Exporting the report

Highlighting selected data

#35. Which Power BI feature allows users to explore data interactively by clicking on different visual elements?

Bookmarks

Slicers

Report Themes

Drillthrough

#36. In Power BI, which of the following features allows users to ask questions about their data in natural language?

Dataflows

Q&A

Bookmarks

Drillthrough

#37. What is the purpose of the ‘Drilldown’ feature in Power BI?

To filter data by user roles

To remove duplicates

To combine datasets

To explore lower levels of hierarchical data

#38. Which storage mode should you use to enable real-time data updates in Power BI?

DirectQuery

Composite

Import

Live Connection

#39. Which Power BI component is best for creating and managing dashboards?

Power BI Gateway

Power BI Report Builder

Power BI Desktop

Power BI Service

#40. In Power BI, what does the ‘Transform Data’ button do?

Creates a calculated column

Opens Power Query Editor

Exports data to Excel

Refreshes the data source

#41. What is the default summarization for a numeric column in Power BI?

Average

Median

Count

Sum

#42. What is the primary purpose of the ‘Data Gateway’ in Power BI?

To transform data in Power Query

To create calculated measures

To schedule report exports

To connect on-premises data sources to Power BI Service

#43. You need to calculate the running total of sales per year. Which DAX function should you use?

CALCULATE

RANKX

TOTALYTD

SUMX

#44. What is the primary use of the KPI visual in Power BI?

Displaying categorical data

Filtering data

Showing trends over time

Displaying a single value comparison to a target

#45. Which of the following functions is used to remove filters from a column in DAX?

REMOVEFILTERS

ALL

FILTER

CALCULATE

#46. You need to create a calculated column in Power BI that extracts the year from a date column named ‘OrderDate’. Which DAX function should you use?

EXTRACT(YEAR, OrderDate)

DATEPART(YEAR, OrderDate)

YEAR(OrderDate)

FORMAT(OrderDate, 'yyyy')

#47. In Power BI, which action allows users to navigate from a summary report to a detailed report?

Q&A

Drillthrough

Drilldown

Bookmarks

#48. What happens when you set a visual interaction to ‘Highlight’ instead of ‘Filter’?

It removes data from the dataset

It creates a tooltip

It filters out other data

It changes the colors of the highlighted section

#49. You want to allow users to filter data dynamically by selecting specific criteria in Power BI. Which feature should you use?

Bookmarks

Drillthrough

Tooltips

Slicers

#50. In Power BI, what is the purpose of the ‘Publish’ button?

Export the report as a PDF

Upload the report to the Power BI Service

Refresh the dataset

Save the report locally

#51. In Power BI, which visual is best suited for displaying key performance indicators (KPIs)?

Line Chart

Gauge

Scatter Plot

Pie Chart

#52. What is the function of the ‘LOOKUPVALUE’ DAX function in Power BI?

To filter a table

To summarize data

To return a single value from a column based on a condition

To create a calculated column

#53. What is the main advantage of using a star schema in Power BI?

It eliminates redundant data

It allows for multiple fact tables

It speeds up query performance

It reduces the need for relationships

#54. What is the main purpose of the ‘Relationships’ view in Power BI?

Defining measures and calculated columns

Visualizing trends

Importing data from different sources

Creating and managing relationships between tables

#55. Which data connection mode in Power BI allows real-time data access?

Live Connection

Scheduled Refresh

DirectQuery

Import

#56. You need to restrict access to data based on user roles. Which feature should you use?

Drillthrough

Bookmarks

Power Query

Row-Level Security (RLS)

#57. You need to visualize hierarchical data. Which visual should you use?

Card

Gauge

Line Chart

Treemap

#58. You want to allow users to switch between different measures in a single visual. Which feature should you use?

Drillthrough

Field Parameters

Calculated Tables

Bookmarks

#59. You want to combine two tables in Power Query that have similar column structures. Which operation should you use?

Merge Queries

Group By

Pivot Columns

Append Queries

#60. What is the benefit of using the ‘Performance Analyzer’ in Power BI?

It automatically optimizes DAX calculations

It helps measure the efficiency of queries and visuals

It suggests new visuals based on data trends

It helps analyze Power BI licensing costs

#1. What is the primary purpose of the ‘Measure’ in Power BI?

#2. In Power BI, what is a paginated report?

#3. In Power BI, what does the ‘Key Influencers’ visual help you determine?

#4. You need to display a multi-row card with multiple values in Power BI. Which visual should you use?

#5. Which Power BI component allows users to build paginated reports?

#6. What is the primary use of calculated tables in Power BI?

#7. You need to compare actual vs. target values in Power BI. Which visual should you use?

#8. In Power BI, what is the default storage mode when importing data?

#9. Which of the following is a valid method to create a relationship between tables?

#10. Which type of Power BI visualization is best suited for showing the composition of data over time?

#11. Which language is used to create calculated columns and measures in Power BI?

#12. In Power BI, what does the ‘Append Queries’ feature do?

#13. Which feature allows Power BI users to schedule automatic data refreshes?

#14. You need to dynamically change a visual based on user selection. What feature should you use?

#15. What is the purpose of the ‘Drillthrough’ feature in Power BI?

#16. Which visual in Power BI is best for displaying a trend over time?

#17. Which chart is most suitable for showing the contribution of each category to a whole?

#18. Which function in DAX is used to calculate cumulative totals?

#19. Which of the following is NOT a valid Power BI data source?

#20. Which file format is used to import a Power BI desktop report?

#21. Which formula correctly creates a new measure in Power BI?

#22. Which of the following storage modes provides the fastest query performance in Power BI?

#23. In Power BI, what is the purpose of the ‘Group By’ operation in Power Query?

#24. Which Power BI component is responsible for scheduled data refresh?

#25. What is the purpose of the ‘Synonyms’ feature in Power BI?

#26. You need to create a report that updates automatically every 5 minutes. Which connection type should you use?

#27. What is the main purpose of the Power Query editor in Power BI?

#28. You want to remove duplicate records in Power Query. What should you do?

#29. Which feature allows you to create reusable datasets in Power BI Service?

#30. You need to ensure that only authorized users can see sensitive data in a Power BI report. What feature should you use?

#31. What is the purpose of a ‘What-If Parameter’ in Power BI?

#32. Which function in DAX returns a single value based on a condition?

#33. In DirectQuery mode, where is the data stored?

#34. In Power BI, what is the purpose of a tooltip?

#35. Which Power BI feature allows users to explore data interactively by clicking on different visual elements?

#36. In Power BI, which of the following features allows users to ask questions about their data in natural language?

#37. What is the purpose of the ‘Drilldown’ feature in Power BI?

#38. Which storage mode should you use to enable real-time data updates in Power BI?

#39. Which Power BI component is best for creating and managing dashboards?

#40. In Power BI, what does the ‘Transform Data’ button do?

#41. What is the default summarization for a numeric column in Power BI?

#42. What is the primary purpose of the ‘Data Gateway’ in Power BI?

#43. You need to calculate the running total of sales per year. Which DAX function should you use?

#44. What is the primary use of the KPI visual in Power BI?

#45. Which of the following functions is used to remove filters from a column in DAX?

#46. You need to create a calculated column in Power BI that extracts the year from a date column named ‘OrderDate’. Which DAX function should you use?

#47. In Power BI, which action allows users to navigate from a summary report to a detailed report?

#48. What happens when you set a visual interaction to ‘Highlight’ instead of ‘Filter’?

#49. You want to allow users to filter data dynamically by selecting specific criteria in Power BI. Which feature should you use?

#50. In Power BI, what is the purpose of the ‘Publish’ button?

#51. In Power BI, which visual is best suited for displaying key performance indicators (KPIs)?

#52. What is the function of the ‘LOOKUPVALUE’ DAX function in Power BI?

#53. What is the main advantage of using a star schema in Power BI?

#54. What is the main purpose of the ‘Relationships’ view in Power BI?

#55. Which data connection mode in Power BI allows real-time data access?

#56. You need to restrict access to data based on user roles. Which feature should you use?

#57. You need to visualize hierarchical data. Which visual should you use?

#58. You want to allow users to switch between different measures in a single visual. Which feature should you use?

#59. You want to combine two tables in Power Query that have similar column structures. Which operation should you use?

#60. What is the benefit of using the ‘Performance Analyzer’ in Power BI?

Results