PL-300 Microsoft Power BI Data Analyst Practice Exam 2

#1. In Power BI, which visualization is best for comparing values across multiple categories and subcategories?

Bullet Chart

Stacked Column Chart

TreeMap

Matrix

#2. What is a key limitation of Power BI’s Q&A feature?

It requires predefined bookmarks

It relies on the data model structure and relationships

It does not support drillthrough

It cannot recognize synonyms

#3. Which Power BI feature allows users to explore data dynamically without predefined filters?

Bookmarks

Drillthrough

Decomposition Tree

Slicers

#4. What is the advantage of using a star schema over a snowflake schema in Power BI?

Improved query performance and simpler relationships

Better integration with Excel

More granular data storage

Automatic hierarchies

#5. In Power BI, what is the key difference between a calculated column and a measure?

Calculated columns are stored in the data model, while measures are computed on demand

Measures require M language, while calculated columns use DAX

Calculated columns refresh automatically, but measures require manual updates

Measures can only be used in pivot tables

#6. You need to calculate a rolling 12-month average of sales. Which DAX function should you use?

AVERAGEX

SUMMARIZE

CALCULATE with DATESINPERIOD

TOTALYTD

#7. You need to visualize sales trends while comparing multiple product categories over time. Which chart is best?

Pie Chart

Stacked Column Chart

Bullet Chart

Line Chart with Small Multiples

#8. What is the purpose of the ALLSELECTED function in DAX?

Removes all filters from a column

Keeps filters from outside the visual while removing internal ones

Ignores all filters

Resets filters to the default state

#9. You need to analyze daily sales trends over the past three years while maintaining performance. What should you do?

Use a calculated column instead of a measure

Increase the granularity of the data model

Use a summarized table instead of raw transactions

Store data in DirectQuery mode

#10. Which DAX function can be used to apply a custom filter context to a calculation?

SUMX

SELECTEDVALUE

ALL

FILTER

#11. You need to create a measure that calculates the percentage of total sales for each product category. Which DAX function should you use?

DIVIDE

ALLSELECTED

CALCULATE

SUMX

#12. In Power BI, what is the purpose of the ‘Composite Model’ feature?

To create calculated tables

To optimize DirectQuery performance

To combine Import and DirectQuery sources

To apply row-level security

#13. You need to apply time-based calculations to a dataset without a built-in date column. What should you do?

Use a calculated column to generate dates

Manually enter date values

Use the built-in Auto Date/Time feature

Create a date table and mark it as a date table

#14. You want to dynamically highlight the top 5 products by sales. Which DAX function should you use?

RANKX

FILTER

SUMX

TOPN

#15. How can you ensure a measure calculates correctly when switching between different date hierarchies?

Create a new calendar table

Disable automatic date/time tables

Use SUM instead of SUMX

Use USERELATIONSHIP in CALCULATE

#16. What happens if you disable ‘Auto Date/Time’ in Power BI?

You must create a custom date table

Data refresh speed increases

All date fields are removed

Time intelligence functions stop working

#17. You need to optimize a large dataset in DirectQuery mode for performance. What is the best practice?

Enable bidirectional cross-filtering on all relationships

Use complex DAX measures instead of aggregations

Use calculated columns extensively

Minimize the number of visuals in reports

#18. Which DAX function is used to count the distinct values in a column?

SUMX

COUNT

COUNTX

DISTINCTCOUNT

#19. What is the primary purpose of the HASONEVALUE function in DAX?

To check if a column contains only a single unique value

To filter a table based on conditions

To count the total number of rows

To rank values in a column

#20. You need to create a custom aggregation that dynamically updates based on user selections. Which DAX function is most suitable?

CALCULATE

SUMX

AGGREGATE

SUMMARIZE

#21. You need to display total sales broken down by year and quarter while allowing drilldown. Which visual should you use?

Multi-Row Card

Line Chart

Stacked Bar Chart

Matrix

#22. In Power BI, what is the best way to handle large datasets with millions of rows efficiently?

Use Import mode with aggregations

Use a star schema with summarized tables

Create calculated columns for filtering

Use DirectQuery for all data

#23. Which method improves DirectQuery performance in Power BI?

Reducing the number of visuals per report

Creating aggregations at the source

Using Import mode

Using calculated columns instead of measures

#24. What is a key disadvantage of using calculated columns in a large dataset?

They reduce performance by increasing memory usage

They require M language

They do not support filters

They cannot be used in relationships

#25. In Power BI, which component allows you to schedule and automate data refreshes?

Power Query

DAX Editor

Power BI Report Builder

Power BI Service

#26. What is the function of the RANKX DAX function?

Filters out top-ranked values

Sorts values in ascending order

Counts unique values in a table

Assigns a rank to each row based on a specified expression

#27. What is the purpose of the AUTOEXIST feature in Power BI?

Removes duplicates from tables

Automatically detects data types

Improves performance of multi-column filtering

Optimizes relationships for composite models

#28. What happens when you set a relationship’s cross-filter direction to ‘Both’ in Power BI?

It prevents circular dependencies

It improves query performance

It enables bidirectional filtering

It removes inactive relationships

#29. When using DirectQuery, what is the recommended way to optimize query performance?

Use calculated tables instead of measures

Enable bidirectional filtering

Reduce the number of columns and aggregations

Increase table relationships

#30. In Power BI, what is the benefit of aggregating data at the source instead of in Power BI?

It speeds up query performance

It reduces storage costs

It prevents data loss

It avoids the need for DAX calculations

#31. In Power Query, which operation allows you to transform column values into row headers?

Unpivot Columns

Pivot Columns

Transpose

Split Columns

#32. What is a key advantage of using a dataflow in Power BI?

It automatically updates reports without a gateway

It eliminates the need for relationships

It allows you to create reusable ETL logic

It optimizes DirectQuery performance

#33. When should you use a composite model in Power BI?

When merging multiple tables in Power Query

When creating row-level security

When optimizing large datasets

When using a mix of Import and DirectQuery data sources

#34. What is the main function of the SUMMARIZECOLUMNS DAX function?

To create calculated columns

To generate time-based aggregations

To group data and apply filters efficiently

To create relationships between tables

#35. Which of the following techniques is best for creating user-specific data views in Power BI?

Calculated Tables

Row-Level Security

Dataflows

Drillthrough

#36. Which DAX function returns the previous value of a column, considering a specific order?

EARLIER

LASTNONBLANK

PREVIOUSVALUE

OFFSET

#37. What is the difference between the RELATED and LOOKUPVALUE functions?

LOOKUPVALUE works only with numeric columns

RELATED requires a relationship, while LOOKUPVALUE does not

RELATED is used in measures, while LOOKUPVALUE is used in queries

LOOKUPVALUE is faster than RELATED

#38. You need to create a calculated column that dynamically changes based on slicer selections. What should you use?

A parameter

A measure

A calculated column

A table join

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

Boolean

Time Series

Whole Number

Currency

#40. In Power BI Service, which refresh method is used for real-time dashboards?

Manual Refresh

Scheduled Refresh

Push Dataset

DirectQuery Refresh

#41. Which of the following DAX functions can be used to retrieve a single value from a table based on a condition?

CALCULATE

LOOKUPVALUE

SUMMARIZE

RELATEDTABLE

#42. In Power BI, when using DirectQuery, what is a common cause of slow performance?

Performing aggregations on large datasets

Creating too many relationships

Using too many calculated columns

Using Import mode instead

#43. In Power BI, which operation is best suited for combining multiple tables with similar structures?

Merge Queries

Pivot Columns

Append Queries

Transpose

#44. You need to create a measure that returns the total sales only for the current year. Which DAX function should you use?

TOTALYTD

DATESYTD

FILTER

CALCULATE

#45. What happens when you use the REMOVEFILTERS function in a DAX measure?

It increases the dataset size

It removes duplicate rows

It applies default filters

It resets all filters on the specified column or table

#46. In Power Query, what is the function of the ‘Merge Queries’ operation?

It applies security rules

It combines columns from multiple tables

It removes duplicate values

It appends two tables

#47. In Power BI, which file format is used to export and import a full Power BI report including data and visuals?

PBIX

XLSX

CSV

XML

#48. What is the primary benefit of using an aggregated table in Power BI?

It allows users to edit data directly

It improves performance by reducing the number of rows scanned

It enables bidirectional filtering

It automatically updates all reports

#49. You need to apply a security rule so that users only see their own department’s data. Which feature should you use?

Role-Based Access Control

Dataflows

Row-Level Security

Dynamic Aggregations

#50. What is a major advantage of using aggregations in Power BI?

They work only in Import mode

They remove duplicates

They improve performance by reducing query complexity

They automatically generate DAX measures

#51. You need to create a relationship between two tables with non-unique values in both columns. What should you do?

Create a many-to-many relationship

Use a bridge table

Create a one-to-one relationship

Use a composite model

#52. You need to create a report where users can toggle between different data perspectives. What feature should you use?

Sync Slicers

Field Parameters

Bookmarks

Drillthrough

#53. In Power BI, what is the main advantage of using parameters in Power Query?

They allow dynamic filtering and transformation of data

They speed up DAX calculations

They replace calculated columns

They improve report security

#54. You need to ensure that a visual updates dynamically based on slicer selections. Which feature should you enable?

Sync Slicers

Visual-Level Filters

Field Parameters

Bookmarks

#55. You need to track the number of active customers over time. Which DAX function should you use?

DISTINCTCOUNT

COUNTROWS

FILTER

CALCULATE with DATESINPERIOD

#56. Which performance optimization technique is most effective for improving Power BI report speed?

Reducing cardinality of columns

Using multiple slicers

Reducing the number of visuals

Using calculated columns instead of measures

#57. You need to calculate the percentage change in sales compared to the previous period. Which DAX function should you use?

OFFSET

CALCULATE with SAMEPERIODLASTYEAR

PREVIOUSMONTH

DATESYTD

#58. In Power BI, what does setting a table as ‘Dual Storage Mode’ allow?

It removes unnecessary columns

It prevents data duplication

It creates a cache for faster calculations

It enables both Import and DirectQuery storage modes

#59. In Power BI, which type of relationship should be avoided for performance reasons?

Many-to-Many

Many-to-One

One-to-Many

One-to-One

#60. Which feature allows you to set up different views of the same report based on user roles?

Dataflows

Row-Level Security

Dynamic Reports

Drillthrough

#1. In Power BI, which visualization is best for comparing values across multiple categories and subcategories?

#2. What is a key limitation of Power BI’s Q&A feature?

#3. Which Power BI feature allows users to explore data dynamically without predefined filters?

#4. What is the advantage of using a star schema over a snowflake schema in Power BI?

#5. In Power BI, what is the key difference between a calculated column and a measure?

#6. You need to calculate a rolling 12-month average of sales. Which DAX function should you use?

#7. You need to visualize sales trends while comparing multiple product categories over time. Which chart is best?

#8. What is the purpose of the ALLSELECTED function in DAX?

#9. You need to analyze daily sales trends over the past three years while maintaining performance. What should you do?

#10. Which DAX function can be used to apply a custom filter context to a calculation?

#11. You need to create a measure that calculates the percentage of total sales for each product category. Which DAX function should you use?

#12. In Power BI, what is the purpose of the ‘Composite Model’ feature?

#13. You need to apply time-based calculations to a dataset without a built-in date column. What should you do?

#14. You want to dynamically highlight the top 5 products by sales. Which DAX function should you use?

#15. How can you ensure a measure calculates correctly when switching between different date hierarchies?

#16. What happens if you disable ‘Auto Date/Time’ in Power BI?

#17. You need to optimize a large dataset in DirectQuery mode for performance. What is the best practice?

#18. Which DAX function is used to count the distinct values in a column?

#19. What is the primary purpose of the HASONEVALUE function in DAX?

#20. You need to create a custom aggregation that dynamically updates based on user selections. Which DAX function is most suitable?

#21. You need to display total sales broken down by year and quarter while allowing drilldown. Which visual should you use?

#22. In Power BI, what is the best way to handle large datasets with millions of rows efficiently?

#23. Which method improves DirectQuery performance in Power BI?

#24. What is a key disadvantage of using calculated columns in a large dataset?

#25. In Power BI, which component allows you to schedule and automate data refreshes?

#26. What is the function of the RANKX DAX function?

#27. What is the purpose of the AUTOEXIST feature in Power BI?

#28. What happens when you set a relationship’s cross-filter direction to ‘Both’ in Power BI?

#29. When using DirectQuery, what is the recommended way to optimize query performance?

#30. In Power BI, what is the benefit of aggregating data at the source instead of in Power BI?

#31. In Power Query, which operation allows you to transform column values into row headers?

#32. What is a key advantage of using a dataflow in Power BI?

#33. When should you use a composite model in Power BI?

#34. What is the main function of the SUMMARIZECOLUMNS DAX function?

#35. Which of the following techniques is best for creating user-specific data views in Power BI?

#36. Which DAX function returns the previous value of a column, considering a specific order?

#37. What is the difference between the RELATED and LOOKUPVALUE functions?

#38. You need to create a calculated column that dynamically changes based on slicer selections. What should you use?

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

#40. In Power BI Service, which refresh method is used for real-time dashboards?

#41. Which of the following DAX functions can be used to retrieve a single value from a table based on a condition?

#42. In Power BI, when using DirectQuery, what is a common cause of slow performance?

#43. In Power BI, which operation is best suited for combining multiple tables with similar structures?

#44. You need to create a measure that returns the total sales only for the current year. Which DAX function should you use?

#45. What happens when you use the REMOVEFILTERS function in a DAX measure?

#46. In Power Query, what is the function of the ‘Merge Queries’ operation?

#47. In Power BI, which file format is used to export and import a full Power BI report including data and visuals?

#48. What is the primary benefit of using an aggregated table in Power BI?

#49. You need to apply a security rule so that users only see their own department’s data. Which feature should you use?

#50. What is a major advantage of using aggregations in Power BI?

#51. You need to create a relationship between two tables with non-unique values in both columns. What should you do?

#52. You need to create a report where users can toggle between different data perspectives. What feature should you use?

#53. In Power BI, what is the main advantage of using parameters in Power Query?

#54. You need to ensure that a visual updates dynamically based on slicer selections. Which feature should you enable?

#55. You need to track the number of active customers over time. Which DAX function should you use?

#56. Which performance optimization technique is most effective for improving Power BI report speed?

#57. You need to calculate the percentage change in sales compared to the previous period. Which DAX function should you use?

#58. In Power BI, what does setting a table as ‘Dual Storage Mode’ allow?

#59. In Power BI, which type of relationship should be avoided for performance reasons?

#60. Which feature allows you to set up different views of the same report based on user roles?

Results