PL-300 Microsoft Power BI Data Analyst Practice Exam

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

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

Navigating to a detailed view of data

Filtering data

Creating relationships

Exporting data

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

To remove duplicates

To combine datasets

To filter data by user roles

To explore lower levels of hierarchical data

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

Scheduled Refresh

Live Connection

DirectQuery

Import

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

Pie Chart

Matrix

Line Chart

Gauge

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

A dashboard report

A mobile-friendly report

A report designed for detailed, printable pages

A real-time report

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

YEAR(OrderDate)

FORMAT(OrderDate, 'yyyy')

EXTRACT(YEAR, OrderDate)

DATEPART(YEAR, OrderDate)

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

To summarize data

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

To filter a table

To create a calculated column

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

Matrix

Card

Multi-Row Card

Table

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

Creating relationships

Calculating aggregations dynamically

Cleaning data

Storing data

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

DirectQuery

Power Automate

Import

Live Connection

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

Refreshes the data source

Opens Power Query Editor

Exports data to Excel

Creates a calculated column

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

Live Connection

DirectQuery

Import

Hybrid

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

Line Chart

Card

Treemap

Gauge

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

Google Docs

Azure Synapse Analytics

SQL Server

Microsoft Excel

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

Merge Queries

Group By

Append Queries

Pivot Columns

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

Pie Chart

Gauge

Scatter Plot

Line Chart

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

Transforming and cleaning data

Building dashboards

Writing DAX calculations

Creating relationships between tables

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

Average

Median

Count

Sum

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

SUMX

ALL

IF

FILTER

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

It helps measure the efficiency of queries and visuals

It helps analyze Power BI licensing costs

It automatically optimizes DAX calculations

It suggests new visuals based on data trends

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

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

Gauge Chart

Stacked Area Chart

Pie Chart

Scatter Plot

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

Refresh the dataset

Upload the report to the Power BI Service

Save the report locally

Export the report as a PDF

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

Apply a FILTER function

Use the REMOVE DUPLICATES option

Use GROUP BY

Use the DISTINCTCOUNT function

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

In the cloud

In a temporary cache

In the original data source

In Power BI Desktop

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

Synonyms

Q&A

Bookmarks

Drillthrough

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

Drillthrough

Row-Level Security (RLS)

Power Query

Bookmarks

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

Dataflows

Drillthrough

Bookmarks

Q&A

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

Drilldown

Q&A

Drillthrough

Bookmarks

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

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

Drillthrough

Conditional Formatting

Data Categorization

Row-Level Security (RLS)

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

Creating and managing relationships between tables

Importing data from different sources

Visualizing trends

Defining measures and calculated columns

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

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

CALCULATE

COUNTROWS

TOTALYTD

SUMX

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

Drillthrough

Slicers

Bookmarks

Report Themes

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

TreeMap

Bar Chart

Pie Chart

Stacked Column Chart

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

Bookmarks

Field Parameters

Drillthrough

Calculated Tables

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

Power BI Desktop

Power BI Report Builder

Power BI Service

Power BI Gateway

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

Tooltips

Bookmarks

Slicers

Drillthrough

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

It creates a tooltip

It removes data from the dataset

It changes the colors of the highlighted section

It filters out other data

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

Power Query

Dataflows

Data Gateway

Bookmarks

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

Power BI Gateway

Power BI Desktop

Power Query

DAX Engine

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

CALCULATE

REMOVEFILTERS

FILTER

ALL

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

Joins tables based on a common column

Removes duplicate values

Combines multiple tables vertically

Creates a pivot table

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

CreateMeasure(Sales[Amount])

Column = SUM(Sales[Amount])

DAX(Sales[Amount])

Measure = SUM(Sales[Amount])

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

It speeds up query performance

It allows for multiple fact tables

It eliminates redundant data

It reduces the need for relationships

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

Row-Level Security

Drillthrough

Dataflows

DirectQuery

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

To create new tables using DAX

To store raw data

To perform row-level calculations

To clean data

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

Use the RELATED function

Use the UNION function

Manually add a primary key

Drag and drop in the Model view

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

To filter data

To create relationships between tables

To append queries

To summarize data by category

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

M

Python

DAX

SQL

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

.csv

.pbix

.pbit

.xlsx

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

Power BI Service

Power BI Report Builder

Power Query Editor

Power BI Desktop

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

Showing trends over time

Displaying a single value comparison to a target

Filtering data

Displaying categorical data

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

SUMX

RANKX

TOTALYTD

CALCULATE

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

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

Composite

DirectQuery

Import

Live Connection

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

Live Connection

DirectQuery

Import

Composite

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

Gauge Chart

Stacked Column Chart

Treemap

Funnel Chart

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

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

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

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

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

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

#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. What is the function of the ‘LOOKUPVALUE’ DAX function in Power BI?

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Results