PL-300 Microsoft Power BI Data Analyst Practice Exam

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

In Power BI Desktop

In a temporary cache

In the original data source

In the cloud

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

Use the UNION function

Use the RELATED function

Drag and drop in the Model view

Manually add a primary key

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

SQL Server

Google Docs

Microsoft Excel

Azure Synapse Analytics

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

Stacked Column Chart

Pie Chart

Bar Chart

TreeMap

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

To combine datasets

To filter data by user roles

To remove duplicates

To explore lower levels of hierarchical data

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

Stacked Column Chart

Gauge Chart

Funnel Chart

Treemap

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

FORMAT(OrderDate, 'yyyy')

YEAR(OrderDate)

EXTRACT(YEAR, OrderDate)

DATEPART(YEAR, OrderDate)

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

Slicers

Bookmarks

Drillthrough

Report Themes

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

Refresh the dataset

Export the report as a PDF

Save the report locally

Upload the report to the Power BI Service

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

Line Chart

Pie Chart

Matrix

Gauge

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

Allow users to ask questions in natural language

Improve performance

Enhance data relationships

Create measures

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

A dashboard report

A mobile-friendly report

A real-time report

A report designed for detailed, printable pages

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

Power Query

Dataflows

Bookmarks

Data Gateway

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

Pie Chart

Gauge Chart

Scatter Plot

Stacked Area Chart

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

TOTALYTD

SUMX

RANKX

CALCULATE

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

To refresh data

To merge queries

To create relationships between tables

To test different scenarios dynamically

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

Importing data from different sources

Visualizing trends

Defining measures and calculated columns

Creating and managing relationships between tables

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

Bookmarks

Calculated Tables

Drillthrough

Field Parameters

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

Power BI Desktop

Power BI Service

Power BI Report Builder

Power Query Editor

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

Live Connection

Import

DirectQuery

Scheduled Refresh

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

COUNTROWS

SUMX

TOTALYTD

CALCULATE

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

Creating relationships

Storing data

Cleaning data

Calculating aggregations dynamically

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

Power BI Gateway

Power BI Desktop

Power BI Service

Power BI Report Builder

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

.pbix

.csv

.xlsx

.pbit

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

Drillthrough

Bookmarks

Tooltips

Slicers

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

Column = SUM(Sales[Amount])

CreateMeasure(Sales[Amount])

Measure = SUM(Sales[Amount])

DAX(Sales[Amount])

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

Exporting data

Creating relationships

Filtering data

Navigating to a detailed view of data

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

It changes the colors of the highlighted section

It filters out other data

It creates a tooltip

It removes data from the dataset

#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 summarize data

To create a calculated column

To filter a table

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

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

Q&A

Synonyms

Drillthrough

Bookmarks

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

DirectQuery

Live Connection

Import

Composite

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

To create new tables using DAX

To perform row-level calculations

To store raw data

To clean data

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

Drillthrough

Q&A

Bookmarks

Dataflows

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

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

It reduces the need for relationships

It eliminates redundant data

It allows for multiple fact tables

It speeds up query performance

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

Removes duplicate values

Combines multiple tables vertically

Joins tables based on a common column

Creates a pivot table

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

Exports data to Excel

Refreshes the data source

Creates a calculated column

Opens Power Query Editor

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

Average

Count

Median

Sum

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

DAX

Python

M

SQL

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

Import

Hybrid

Live Connection

DirectQuery

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

Pie Chart

Line Chart

Scatter Plot

Gauge

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

The best-performing products

The top 10 items in a category

The relationship between tables

The key factors affecting a metric

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

Use the REMOVE DUPLICATES option

Use GROUP BY

Use the DISTINCTCOUNT function

Apply a FILTER function

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

Import

DirectQuery

Live Connection

Power Automate

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

DirectQuery

Live Connection

Import

Composite

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

Power BI Desktop

Power BI Gateway

Power Query

DAX Engine

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

Drilldown

Q&A

Bookmarks

Drillthrough

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

Treemap

Card

Line Chart

Gauge

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

Displaying a single value comparison to a target

Filtering data

Showing trends over time

Displaying categorical data

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

Transforming and cleaning data

Writing DAX calculations

Building dashboards

Creating relationships between tables

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

IF

SUMX

ALL

FILTER

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

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

Multi-Row Card

Table

Matrix

Card

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

To filter data

To append queries

To summarize data by category

To create relationships between tables

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

Drillthrough

Power Query

Row-Level Security (RLS)

Bookmarks

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

Dataflows

DirectQuery

Drillthrough

Row-Level Security

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

Merge Queries

Pivot Columns

Append Queries

Group By

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

REMOVEFILTERS

FILTER

ALL

CALCULATE

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

Drillthrough

Row-Level Security (RLS)

Conditional Formatting

Data Categorization

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Results