PL-300 Microsoft Power BI Data Analyst Practice Exam

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

A dashboard report

A report designed for detailed, printable pages

A real-time report

A mobile-friendly report

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

In the original data source

In the cloud

In a temporary cache

In Power BI Desktop

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

Filtering data

Creating relationships

Exporting data

Navigating to a detailed view of data

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

Drilldown

Drillthrough

Bookmarks

Q&A

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

Live Connection

Composite

DirectQuery

Import

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

Treemap

Gauge Chart

Funnel Chart

Stacked Column Chart

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

Create measures

Allow users to ask questions in natural language

Improve performance

Enhance data relationships

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

It removes data from the dataset

It changes the colors of the highlighted section

It creates a tooltip

It filters out other data

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

CALCULATE

ALL

FILTER

REMOVEFILTERS

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

Bookmarks

Dataflows

Drillthrough

Q&A

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

#12. 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 filter a table

To create a calculated column

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

Transforming and cleaning data

Creating relationships between tables

Building dashboards

Writing DAX calculations

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

SUMX

IF

FILTER

ALL

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

Opens Power Query Editor

Creates a calculated column

Exports data to Excel

Refreshes the data source

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

Dataflows

DirectQuery

Row-Level Security

Drillthrough

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

It helps measure the efficiency of queries and visuals

It suggests new visuals based on data trends

It helps analyze Power BI licensing costs

It automatically optimizes DAX calculations

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

M

SQL

DAX

Python

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

Synonyms

Q&A

Bookmarks

Drillthrough

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

Drillthrough

Report Themes

Bookmarks

Slicers

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

Live Connection

DirectQuery

Import

Composite

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

Use the RELATED function

Use the UNION function

Drag and drop in the Model view

Manually add a primary key

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

Drillthrough

Row-Level Security (RLS)

Bookmarks

Power Query

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

Power BI Gateway

Power BI Service

Power BI Report Builder

Power BI Desktop

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

Power Query

DAX Engine

Power BI Gateway

Power BI Desktop

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

Pie Chart

Scatter Plot

Gauge Chart

Stacked Area Chart

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

DirectQuery

Scheduled Refresh

Live Connection

Import

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

Visualizing trends

Importing data from different sources

Defining measures and calculated columns

Creating and managing relationships between tables

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

Drillthrough

Slicers

Tooltips

Bookmarks

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

The relationship between tables

The top 10 items in a category

The key factors affecting a metric

The best-performing products

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

Line Chart

Scatter Plot

Gauge

Pie Chart

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

To append queries

To create relationships between tables

To summarize data by category

To filter data

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

Displaying additional information when hovering over a visual

Creating interactive filters

Exporting the report

Highlighting selected data

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

To clean data

To perform row-level calculations

To create new tables using DAX

To store raw data

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

FORMAT(OrderDate, 'yyyy')

YEAR(OrderDate)

DATEPART(YEAR, OrderDate)

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

Creates a pivot table

Joins tables based on a common column

Combines multiple tables vertically

Removes duplicate values

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

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

CALCULATE

RANKX

SUMX

TOTALYTD

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

DirectQuery

Hybrid

Import

Live Connection

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

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

Power Automate

DirectQuery

Import

Live Connection

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

SQL Server

Microsoft Excel

Azure Synapse Analytics

Google Docs

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

Stacked Column Chart

TreeMap

Pie Chart

Bar Chart

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

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

Power Query Editor

Power BI Service

Power BI Desktop

Power BI Report Builder

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

It eliminates redundant data

It reduces the need for relationships

It allows for multiple fact tables

It speeds up query performance

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

Data Categorization

Row-Level Security (RLS)

Conditional Formatting

Drillthrough

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

Data Gateway

Dataflows

Power Query

Bookmarks

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

Refresh the dataset

Upload the report to the Power BI Service

Export the report as a PDF

Save the report locally

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

Displaying categorical data

Displaying a single value comparison to a target

Filtering data

Showing trends over time

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

Pie Chart

Line Chart

Gauge

Matrix

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

Drillthrough

Bookmarks

Calculated Tables

Field Parameters

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

To refresh data

To merge queries

To test different scenarios dynamically

To create relationships between tables

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

CreateMeasure(Sales[Amount])

DAX(Sales[Amount])

Column = SUM(Sales[Amount])

Measure = SUM(Sales[Amount])

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

Card

Treemap

Gauge

Line Chart

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

.csv

.pbit

.xlsx

.pbix

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

Sum

Average

Median

Count

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

SUMX

COUNTROWS

CALCULATE

TOTALYTD

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

To transform data in Power Query

To connect on-premises data sources to Power BI Service

To create calculated measures

To schedule report exports

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

Calculating aggregations dynamically

Storing data

Creating relationships

Cleaning data

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Results