PL-300 Microsoft Power BI Data Analyst Practice Exam

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

Slicers

Drillthrough

Bookmarks

Report Themes

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

To create a calculated column

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

To filter a table

To summarize data

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

Power Automate

Import

DirectQuery

Live Connection

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

Card

Multi-Row Card

Matrix

Table

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

In Power BI Desktop

In the cloud

In the original data source

In a temporary cache

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

It reduces the need for relationships

It speeds up query performance

It allows for multiple fact tables

It eliminates redundant data

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

Hybrid

DirectQuery

Live Connection

Import

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

To transform data in Power Query

To schedule report exports

To create calculated measures

To connect on-premises data sources to Power BI Service

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

To create relationships between tables

To filter data

To summarize data by category

To append queries

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

To filter data by user roles

To combine datasets

To remove duplicates

To explore lower levels of hierarchical data

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

Live Connection

Composite

Import

DirectQuery

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

Slicers

Tooltips

Bookmarks

Drillthrough

#13. 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

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

Column = SUM(Sales[Amount])

CreateMeasure(Sales[Amount])

Measure = SUM(Sales[Amount])

DAX(Sales[Amount])

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

Group By

Append Queries

Merge Queries

Pivot Columns

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

Scheduled Refresh

Live Connection

DirectQuery

Import

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

Importing data from different sources

Creating and managing relationships between tables

Visualizing trends

Defining measures and calculated columns

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

Displaying additional information when hovering over a visual

Highlighting selected data

Creating interactive filters

Exporting the report

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

.pbit

.pbix

.csv

.xlsx

#20. 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

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

Row-Level Security (RLS)

Bookmarks

Drillthrough

Power Query

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

Composite

Live Connection

DirectQuery

Import

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

Storing data

Cleaning data

Calculating aggregations dynamically

Creating relationships

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

Upload the report to the Power BI Service

Refresh the dataset

Save the report locally

Export the report as a PDF

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

Calculated Tables

Drillthrough

Bookmarks

Field Parameters

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

Dataflows

Data Gateway

Power Query

Bookmarks

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

M

Python

DAX

SQL

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

Dataflows

Bookmarks

Q&A

Drillthrough

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

Stacked Area Chart

Gauge Chart

Scatter Plot

Pie Chart

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

Filtering data

Creating relationships

Navigating to a detailed view of data

Exporting data

#31. 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?

YEAR(OrderDate)

DATEPART(YEAR, OrderDate)

EXTRACT(YEAR, OrderDate)

FORMAT(OrderDate, 'yyyy')

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

Bookmarks

Drillthrough

Drilldown

Q&A

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

Treemap

Card

Gauge

Line Chart

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

FILTER

ALL

REMOVEFILTERS

CALCULATE

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

Treemap

Stacked Column Chart

Funnel Chart

Gauge Chart

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

Enhance data relationships

Create measures

Allow users to ask questions in natural language

Improve performance

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

To create relationships between tables

To test different scenarios dynamically

To merge queries

To refresh data

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

Use GROUP BY

Use the DISTINCTCOUNT function

Apply a FILTER function

Use the REMOVE DUPLICATES option

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

SUMX

IF

ALL

FILTER

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

Conditional Formatting

Data Categorization

Row-Level Security (RLS)

Drillthrough

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

It helps analyze Power BI licensing costs

It automatically optimizes DAX calculations

It helps measure the efficiency of queries and visuals

It suggests new visuals based on data trends

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

Manually add a primary key

Use the UNION function

Use the RELATED function

Drag and drop in the Model view

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

Line Chart

Gauge

Pie Chart

Scatter Plot

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

Pie Chart

Gauge

Matrix

Line Chart

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

The relationship between tables

The key factors affecting a metric

The best-performing products

The top 10 items in a category

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

SUMX

TOTALYTD

RANKX

CALCULATE

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

Power BI Desktop

DAX Engine

Power BI Gateway

Power Query

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

Microsoft Excel

Google Docs

Azure Synapse Analytics

SQL Server

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

Bookmarks

Synonyms

Q&A

Drillthrough

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

TreeMap

Pie Chart

Stacked Column Chart

Bar Chart

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

A report designed for detailed, printable pages

A mobile-friendly report

A real-time report

A dashboard report

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

Opens Power Query Editor

Creates a calculated column

Refreshes the data source

Exports data to Excel

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

Power BI Desktop

Power Query Editor

Power BI Report Builder

Power BI Service

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

It creates a tooltip

It changes the colors of the highlighted section

It removes data from the dataset

It filters out other data

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

DirectQuery

Drillthrough

Dataflows

Row-Level Security

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

Sum

Average

Median

Count

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

Power BI Gateway

Power BI Report Builder

Power BI Service

Power BI Desktop

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

To perform row-level calculations

To create new tables using DAX

To clean data

To store raw data

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

Filtering data

Showing trends over time

Displaying categorical data

Displaying a single value comparison to a target

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

SUMX

COUNTROWS

CALCULATE

TOTALYTD

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

#31. 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?

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Results