PL-300 Microsoft Power BI Data Analyst Practice Exam 2

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

Use a calculated column to generate dates

Create a date table and mark it as a date table

Manually enter date values

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

Power Query

Power BI Report Builder

Power BI Service

DAX Editor

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

Use DirectQuery for all data

Create calculated columns for filtering

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

CALCULATE with DATESINPERIOD

COUNTROWS

FILTER

DISTINCTCOUNT

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

To rank values in a column

To count the total number of rows

To filter a table based on conditions

To check if a column contains only a single unique value

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

You must create a custom date table

Time intelligence functions stop working

Data refresh speed increases

All date fields are removed

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

To create relationships between tables

To group data and apply filters efficiently

To create calculated columns

To generate time-based aggregations

#8. 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 automatically updates all reports

It enables bidirectional filtering

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

Using multiple slicers

Reducing the number of visuals

Using calculated columns instead of measures

Reducing cardinality of columns

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

Minimize the number of visuals in reports

Use calculated columns extensively

Use complex DAX measures instead of aggregations

Enable bidirectional cross-filtering on all relationships

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

Field Parameters

Drillthrough

Bookmarks

Sync Slicers

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

They cannot be used in relationships

They require M language

They reduce performance by increasing memory usage

They do not support filters

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

TOTALYTD

SUMMARIZE

AVERAGEX

CALCULATE with DATESINPERIOD

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

It prevents data duplication

It creates a cache for faster calculations

It enables both Import and DirectQuery storage modes

It removes unnecessary columns

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

AGGREGATE

SUMX

SUMMARIZE

CALCULATE

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

Using Import mode

Creating aggregations at the source

Using calculated columns instead of measures

Reducing the number of visuals per report

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

One-to-Many

Many-to-One

Many-to-Many

One-to-One

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

They speed up DAX calculations

They improve report security

They allow dynamic filtering and transformation of data

They replace calculated columns

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

Assigns a rank to each row based on a specified expression

Sorts values in ascending order

Filters out top-ranked values

Counts unique values in a table

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

Transpose

Pivot Columns

Merge Queries

Append Queries

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

LOOKUPVALUE

CALCULATE

RELATEDTABLE

SUMMARIZE

#22. 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 can only be used in pivot tables

Measures require M language, while calculated columns use DAX

Calculated columns refresh automatically, but measures require manual updates

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

It prevents data loss

It reduces storage costs

It avoids the need for DAX calculations

It speeds up query performance

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

Disable automatic date/time tables

Use SUM instead of SUMX

Use USERELATIONSHIP in CALCULATE

Create a new calendar table

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

It combines columns from multiple tables

It removes duplicate values

It applies security rules

It appends two tables

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

It automatically updates reports without a gateway

It optimizes DirectQuery performance

It eliminates the need for relationships

It allows you to create reusable ETL logic

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

COUNTX

DISTINCTCOUNT

SUMX

COUNT

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

Create a one-to-one relationship

Use a bridge table

Use a composite model

Create a many-to-many relationship

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

It enables bidirectional filtering

It improves query performance

It prevents circular dependencies

It removes inactive relationships

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

Bullet Chart

Line Chart with Small Multiples

Stacked Column Chart

Pie Chart

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

To optimize DirectQuery performance

To apply row-level security

To create calculated tables

To combine Import and DirectQuery sources

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

DATESYTD

CALCULATE

FILTER

TOTALYTD

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

OFFSET

PREVIOUSVALUE

LASTNONBLANK

EARLIER

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

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

They improve performance by reducing query complexity

They automatically generate DAX measures

They remove duplicates

They work only in Import mode

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

CALCULATE with SAMEPERIODLASTYEAR

OFFSET

PREVIOUSMONTH

DATESYTD

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

When optimizing large datasets

When creating row-level security

When merging multiple tables in Power Query

When using a mix of Import and DirectQuery data sources

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

Bookmarks

Drillthrough

Decomposition Tree

Slicers

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

Using Import mode instead

Performing aggregations on large datasets

Creating too many relationships

Using too many calculated columns

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

TreeMap

Stacked Column Chart

Matrix

Bullet Chart

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

Visual-Level Filters

Bookmarks

Field Parameters

Sync Slicers

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

Drillthrough

Row-Level Security

Dataflows

Calculated Tables

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

RELATED requires a relationship, while LOOKUPVALUE does not

LOOKUPVALUE works only with numeric columns

LOOKUPVALUE is faster than RELATED

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

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

A parameter

A calculated column

A measure

A table join

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

Dataflows

Row-Level Security

Dynamic Aggregations

Role-Based Access Control

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

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

ALL

SELECTEDVALUE

FILTER

SUMX

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

Resets filters to the default state

Ignores all filters

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

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

FILTER

SUMX

TOPN

RANKX

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

Dynamic Reports

Drillthrough

Dataflows

Row-Level Security

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

Pivot Columns

Unpivot Columns

Transpose

Split Columns

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

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

Enable bidirectional filtering

Use calculated tables instead of measures

Increase table relationships

Reduce the number of columns and aggregations

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

Use a summarized table instead of raw transactions

Use a calculated column instead of a measure

Increase the granularity of the data model

Store data in DirectQuery mode

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

SUMX

ALLSELECTED

CALCULATE

DIVIDE

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

Scheduled Refresh

Push Dataset

DirectQuery Refresh

Manual Refresh

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

It resets all filters on the specified column or table

It applies default filters

It increases the dataset size

It removes duplicate rows

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

It relies on the data model structure and relationships

It requires predefined bookmarks

It does not support drillthrough

It cannot recognize synonyms

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

Whole Number

Time Series

Currency

Boolean

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Results