Power BI 2 Quiz

What is the main role of the DAX language in Power BI?

• Create pivot tables
• Connect to databases
• Create custom calculations and dynamic measures
• Style charts

What major difference distinguishes a calculated column from a measure?

• The column is dynamic, the measure is static
• The column is filterable, the measure is a dynamic aggregation
• The measure is filterable, the column is fixed
• The column requires DAX, the measure doesn’t

What type of table contains numerical observations to be aggregated?

• Dimension
• Fact Table
• Primary Key
• Pivot Table

What is the benefit of a star schema in Power BI?

• Better compatibility with Excel
• Optimization of calculations and better readability
• Create complex cross relationships
• Improve network speed

Which DAX function iterates row by row over a table?

• FILTER
• CALCULATE
• SUMX
• COUNT

Which DAX function removes all filters from a visual?

• FILTER
• REMOVEFILTERS
• DISTINCT
• ALL

What is the purpose of the CALCULATE function in DAX?

• Create dynamic visuals
• Modify the filter context to recalculate an expression
• Concatenate text
• Create relationships between tables

Which function returns the unique values of a column?

• VALUES
• UNIQUE
• DISTINCT
• FILTER

Which of the following is a time intelligence function?

• SAMEPERIODLASTYEAR
• TEXTJOIN
• LEFT
• SUMX

What is the main advantage of Quick Measures?

• They reduce data volume
• They simplify DAX writing for beginners
• They create charts automatically
• They import Excel data