Font size
S
M
L
XL
WorksheetsPower BI 2 Quiz
Total questions: 14
Worksheet time: 7mins
Name
Class
Date
1.
What is the main role of the DAX language in Power BI?
a)
Create pivot tables
b)
Connect to databases
c)
Create custom calculations and dynamic measures
d)
Style charts
2.
What major difference distinguishes a calculated column from a measure?
a)
The column is dynamic, the measure is static
b)
The column is filterable, the measure is a dynamic aggregation
c)
The measure is filterable, the column is fixed
d)
The column requires DAX, the measure doesn’t
3.
What type of table contains numerical observations to be aggregated?
a)
Dimension
b)
Fact Table
c)
Primary Key
d)
Pivot Table
4.
What is the benefit of a star schema in Power BI?
a)
Better compatibility with Excel
b)
Optimization of calculations and better readability
c)
Create complex cross relationships
d)
Improve network speed
5.
Which DAX function iterates row by row over a table?
a)
FILTER
b)
CALCULATE
c)
SUMX
d)
COUNT
6.
Which DAX function removes all filters from a visual?
a)
FILTER
b)
REMOVEFILTERS
c)
DISTINCT
d)
ALL
7.
What is the purpose of the CALCULATE function in DAX?
a)
Create dynamic visuals
b)
Modify the filter context to recalculate an expression
c)
Concatenate text
d)
Create relationships between tables
8.
Which function returns the unique values of a column?
a)
VALUES
b)
UNIQUE
c)
DISTINCT
d)
FILTER
9.
Which of the following is a time intelligence function?
a)
SAMEPERIODLASTYEAR
b)
TEXTJOIN
c)
LEFT
d)
SUMX
10.
What is the main advantage of Quick Measures?
a)
They reduce data volume
b)
They simplify DAX writing for beginners
c)
They create charts automatically
d)
They import Excel data
11.
Which DAX function returns a filtered version of a table based on a condition?
a)
ALL
b)
FILTER
c)
VALUES
d)
REMOVEFILTERS
12.
What type of result does a table function like FILTER or VALUES return?
a)
A number
b)
A chart
c)
A single value
d)
A table
13.
Select all examples of iterator (X) functions in DAX.
a)
SUMX
b)
AVERAGEX
c)
COUNTX
d)
MINX
14.
What is the purpose of the RELATED function in DAX?
a)
Returns the first row in a table
b)
Returns a related value from another table
c)
Creates a new table
d)
Filters a visual by time
Reset
