PL-300 Microsoft Power BI Data Analyst Practice Exam

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

Export the report as a PDF

Save the report locally

Refresh the dataset

Upload the report to the Power BI Service

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

To create relationships between tables

To refresh data

To test different scenarios dynamically

To merge queries

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

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

Removes duplicate values

Creates a pivot table

Combines multiple tables vertically

Joins tables based on a common column

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

Treemap

Gauge

Line Chart

Card

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

IF

ALL

FILTER

SUMX

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

DirectQuery

Import

Hybrid

Live Connection

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

FILTER

CALCULATE

ALL

REMOVEFILTERS

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

To connect on-premises data sources to Power BI Service

To transform data in Power Query

To create calculated measures

To schedule report exports

#10. 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)

YEAR(OrderDate)

DATEPART(YEAR, OrderDate)

FORMAT(OrderDate, 'yyyy')

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

Dataflows

Bookmarks

Power Query

Data Gateway

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

Count

Median

Sum

Average

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

The key factors affecting a metric

The top 10 items in a category

The relationship between tables

The best-performing products

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

.pbit

.xlsx

.pbix

.csv

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

Scatter Plot

Pie Chart

Line Chart

Gauge

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

Power BI Service

Power BI Gateway

Power BI Desktop

Power BI Report Builder

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

Exports data to Excel

Creates a calculated column

Refreshes the data source

Opens Power Query Editor

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

Composite

Import

DirectQuery

Live Connection

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

Card

Matrix

Table

Multi-Row Card

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

Power Query

Power BI Desktop

Power BI Gateway

DAX Engine

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

It allows for multiple fact tables

It eliminates redundant data

It reduces the need for relationships

It speeds up query performance

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

Building dashboards

Writing DAX calculations

Creating relationships between tables

Transforming and cleaning data

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

Matrix

Pie Chart

Gauge

Line Chart

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

Pivot Columns

Append Queries

Group By

Merge Queries

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

Power BI Desktop

Power BI Service

Power Query Editor

Power BI Report Builder

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

Q&A

Dataflows

Drillthrough

Bookmarks

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

Field Parameters

Calculated Tables

Bookmarks

Drillthrough

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

COUNTROWS

TOTALYTD

CALCULATE

SUMX

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

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

To create a calculated column

To filter a table

To summarize data

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

Create measures

Improve performance

Enhance data relationships

Allow users to ask questions in natural language

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

Row-Level Security

Drillthrough

Dataflows

DirectQuery

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

Drillthrough

Bookmarks

Q&A

Drilldown

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

SUMX

CALCULATE

TOTALYTD

RANKX

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

To summarize data by category

To filter data

To create relationships between tables

To append queries

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

Column = SUM(Sales[Amount])

DAX(Sales[Amount])

CreateMeasure(Sales[Amount])

Measure = SUM(Sales[Amount])

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

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

In the original data source

In the cloud

In Power BI Desktop

In a temporary cache

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

Import

DirectQuery

Power Automate

Live Connection

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

Azure Synapse Analytics

SQL Server

Google Docs

Microsoft Excel

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

Pie Chart

Stacked Area Chart

Scatter Plot

Gauge Chart

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

Gauge Chart

Funnel Chart

Stacked Column Chart

Treemap

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

Q&A

Bookmarks

Synonyms

Drillthrough

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

DirectQuery

Scheduled Refresh

Import

Live Connection

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

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

Bar Chart

Pie Chart

Stacked Column Chart

TreeMap

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

To combine datasets

To remove duplicates

To filter data by user roles

To explore lower levels of hierarchical data

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

A real-time report

A dashboard report

A report designed for detailed, printable pages

A mobile-friendly report

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

Creating relationships

Storing data

Calculating aggregations dynamically

Cleaning data

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

Drillthrough

Bookmarks

Slicers

Tooltips

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

Drillthrough

Slicers

Report Themes

Bookmarks

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

Exporting data

Navigating to a detailed view of data

Filtering data

Creating relationships

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

Drillthrough

Bookmarks

Power Query

Row-Level Security (RLS)

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

Manually add a primary key

Drag and drop in the Model view

Use the RELATED function

Use the UNION function

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

Composite

Live Connection

DirectQuery

Import

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

Use the DISTINCTCOUNT function

Use the REMOVE DUPLICATES option

Apply a FILTER function

Use GROUP BY

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

Conditional Formatting

Row-Level Security (RLS)

Data Categorization

Drillthrough

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

To store raw data

To perform row-level calculations

To create new tables using DAX

To clean data

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

DAX

SQL

Python

M

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

Displaying additional information when hovering over a visual

Highlighting selected data

Exporting the report

Creating interactive filters

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

Creating and managing relationships between tables

Defining measures and calculated columns

Visualizing trends

Importing data from different sources

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Results