SQL Roadmap from Zero to Advance

This Power BI online test helps you check your skills in the Power BI analysis. This Power BI mock test evaluates your knowledge of data visualization, reporting, and dashboard creation.

Power BI Test

Which DAX function can be used to evaluate an expression with a modified filter context?

When using DirectQuery mode in Power BI, which of the following operations can significantly degrade performance?

It returns only the common values between two tables

It performs a Cartesian product of two tables

It removes duplicate rows from two tables

What is the purpose of the CROSSJOIN function in DAX?

Merges two tables based on a common column

Adds all columns from both tables, even if they don’t match

Stacks the rows from one table on top of another

In Power BI, what happens when you use the "Append Queries" option in Power Query?

Which Power BI feature is used to create multiple versions of a report with different filters applied?

It minimizes the number of relationships needed for queries

In a Power BI model, what is the advantage of using a star schema over a snowflake schema?

It automatically creates a date hierarchy for every date column

It allows users to create custom date formats

In Power BI, which of the following best describes the AUTO DATE/TIME feature?

Which of the following can be used to apply row-level security in Power BI?

Use more calculated columns instead of measures

Reduce the number of visuals and use aggregations

Which of the following is the best way to optimize a Power BI report that is running slowly due to a large dataset?

It removes all filters applied in the report

It removes filters from a specific column or table in a DAX formula

It permanently deletes filters from a dataset

What happens when you use the REMOVEFILTERS function in DAX?

Measures are stored in tables, while calculated columns are stored in memory

Calculated columns are precomputed and stored, while measures are computed on demand

Measures can be used in table visualizations, while calculated columns cannot

Calculated columns can change dynamically, while measures are static

What is the key difference between a calculated column and a measure in Power BI?

It does not allow creating relationships between tables

It has a dependency on the performance of the data source

In Power BI, which of the following is a major limitation of using DirectQuery mode?

Which Power BI feature allows you to create a custom aggregation table to improve performance?

When you need to perform additional calculations on grouped data

When should you use the GROUPBY function in DAX instead of SUMMARIZE?

Sorting values in a Power Query transformation

Which of the following is NOT a valid use case for the RANKX function in DAX?