PL-300 Microsoft Power BI Data Analyst Practice Exam 2

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

Reducing the number of visuals

Using calculated columns instead of measures

Reducing cardinality of columns

Using multiple slicers

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

SUMMARIZE

LOOKUPVALUE

CALCULATE

RELATEDTABLE

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

Use a summarized table instead of raw transactions

Store data in DirectQuery mode

Increase the granularity of the data model

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

Counts unique values in a table

Filters out top-ranked values

Sorts values in ascending order

Assigns a rank to each row based on a specified expression

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

It relies on the data model structure and relationships

It does not support drillthrough

It cannot recognize synonyms

It requires predefined bookmarks

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

Unpivot Columns

Transpose

Pivot Columns

Split Columns

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

CSV

XLSX

XML

PBIX

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

When creating row-level security

When optimizing large datasets

When merging multiple tables in Power Query

When using a mix of Import and DirectQuery data sources

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

Create a one-to-one relationship

Use a composite model

Use a bridge table

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

Use USERELATIONSHIP in CALCULATE

Disable automatic date/time tables

Create a new calendar table

Use SUM instead of SUMX

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

They cannot be used in relationships

They require M language

They do not support filters

They reduce performance by increasing memory usage

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

Field Parameters

Visual-Level Filters

Sync Slicers

Bookmarks

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

Removes all filters from a column

Resets filters to the default state

Keeps filters from outside the visual while removing internal ones

Ignores all filters

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

Currency

Boolean

Whole Number

Time Series

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

Using calculated columns instead of measures

Using Import mode

Reducing the number of visuals per report

Creating aggregations at the source

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

Use complex DAX measures instead of aggregations

Minimize the number of visuals in reports

Enable bidirectional cross-filtering on all relationships

Use calculated columns extensively

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

Calculated columns refresh automatically, but measures require manual updates

Measures can only be used in pivot tables

Measures require M language, while calculated columns use DAX

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

Dataflows

Row-Level Security

Drillthrough

Calculated Tables

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

It enables bidirectional filtering

It removes inactive relationships

It improves query performance

It prevents circular dependencies

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

It automatically updates all reports

It allows users to edit data directly

It enables bidirectional filtering

It improves performance by reducing the number of rows scanned

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

It creates a cache for faster calculations

It prevents data duplication

It removes unnecessary columns

It enables both Import and DirectQuery storage modes

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

They automatically generate DAX measures

They remove duplicates

They work only in Import mode

They improve performance by reducing query complexity

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

To apply row-level security

To optimize DirectQuery performance

To combine Import and DirectQuery sources

To create calculated tables

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

Dynamic Reports

Drillthrough

Dataflows

Row-Level Security

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

To create calculated columns

To generate time-based aggregations

To create relationships between tables

To group data and apply filters efficiently

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

Use calculated tables instead of measures

Increase table relationships

Reduce the number of columns and aggregations

Enable bidirectional filtering

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

Data refresh speed increases

Time intelligence functions stop working

All date fields are removed

You must create a custom date table

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

OFFSET

PREVIOUSMONTH

DATESYTD

CALCULATE with SAMEPERIODLASTYEAR

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

Sync Slicers

Bookmarks

Drillthrough

Field Parameters

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

DISTINCTCOUNT

FILTER

COUNTROWS

CALCULATE with DATESINPERIOD

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

LASTNONBLANK

OFFSET

EARLIER

PREVIOUSVALUE

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

It automatically updates reports without a gateway

It optimizes DirectQuery performance

It allows you to create reusable ETL logic

It eliminates the need for relationships

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

Stacked Bar Chart

Matrix

Line Chart

Multi-Row Card

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

CALCULATE

SUMX

ALLSELECTED

DIVIDE

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

SUMX

COUNT

COUNTX

DISTINCTCOUNT

#36. 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 improve report security

They replace calculated columns

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

LOOKUPVALUE is faster than RELATED

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

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

Use Import mode with aggregations

Create calculated columns for filtering

Use a star schema with summarized tables

Use DirectQuery for all data

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

To rank values in a column

To filter a table based on conditions

To count the total number of rows

To check if a column contains only a single unique value

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

Bookmarks

Slicers

Drillthrough

Decomposition Tree

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

TOPN

FILTER

RANKX

SUMX

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

SELECTEDVALUE

FILTER

ALL

SUMX

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

Many-to-One

Many-to-Many

One-to-Many

One-to-One

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

It increases the dataset size

It resets all filters on the specified column or table

It applies default filters

It removes duplicate rows

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

DATESYTD

FILTER

TOTALYTD

CALCULATE

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

Automatic hierarchies

Better integration with Excel

Improved query performance and simpler relationships

More granular data storage

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

Using too many calculated columns

Using Import mode instead

Performing aggregations on large datasets

Creating too many relationships

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

Stacked Column Chart

TreeMap

Bullet Chart

Matrix

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

Power BI Service

DAX Editor

Power Query

Power BI Report Builder

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

AVERAGEX

CALCULATE with DATESINPERIOD

TOTALYTD

SUMMARIZE

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

AGGREGATE

CALCULATE

SUMMARIZE

SUMX

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

Pie Chart

Line Chart with Small Multiples

Stacked Column Chart

Bullet Chart

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

Transpose

Pivot Columns

Merge Queries

Append Queries

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

It combines columns from multiple tables

It applies security rules

It appends two tables

It removes duplicate values

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

Automatically detects data types

Improves performance of multi-column filtering

Removes duplicates from tables

Optimizes relationships for composite models

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

DirectQuery Refresh

Manual Refresh

Push Dataset

Scheduled Refresh

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

It speeds up query performance

It prevents data loss

It reduces storage costs

It avoids the need for DAX calculations

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

Use the built-in Auto Date/Time feature

Manually enter date values

Use a calculated column to generate dates

Create a date table and mark it as a date table

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

A calculated column

A measure

A parameter

A table join

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

Row-Level Security

Dataflows

Dynamic Aggregations

Role-Based Access Control

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Results