Quiz: Introduction to DAX Language – The Data Analyst Toolkit

This quiz will test your understanding about Introduction to DAX Language. Please answer the following 6 questions.

Quiz Summary

0 of 6 Questions completed

Questions:

You have already completed the quiz before. Hence you can not start it again.

Quiz is loading…

You must sign in or sign up to start the quiz.

You must first complete the following:

Results

Quiz complete. Results are being recorded.

Results

0 of 6 Questions answered correctly

Your time:

You have reached 0 of 0 point(s), (0)

Current
Review
Answered
Correct
Incorrect

Question 1 of 6

1. Question
Finish the following sentence: DAX ________ (select all that apply)
- is a programming language that enables you to create time intelligence functions
- is not a programming language, but a formula language
- stands for Data Analysis Expressions and is a collection of functions that can be used in a formula to calculate and return one or more values.
- stands for Data Analysis Expressions and allows the users to define custom calculations in calculated columns and calculated fields (also known as measures).
Correct

Incorrect
Question 2 of 6

2. Question
Which function would you use to extract a month out of the current day?
- day( today() )
- month( today() )
- month( day())
- month( currentdate() )
Correct

Incorrect
Question 3 of 6

3. Question
What are the two types of context?
- The row context and the evaluation context
- The row context and the filter context
- the date context and the row/filter context
- There is only one context: the evaluation context.
Correct

Incorrect
Question 4 of 6

4. Question
A filter function in DAX returns ___________ (select all that apply)
- a single value from a table to be filtered and based on a condition
- a table that has been filtered on a boolean (True/False) expression that is to be evaluated for each row of the table (FilterExpression)
- an entire table or a table with one or more columns, containing only the filtered rows.
- a value by grouped row
Correct

Incorrect
Question 5 of 6

5. Question
The difference between SUM() and SUMX() functions is that _______
- SUMX() removes any filter applied to calculations while SUM() performs a summation of numerical variables in the dataset.
- You can only use SUM() for a single variable, such as SUM(Sales[Amount]). If you want to sum and expression, such as Sales[Amount]*Sales[Quantity]), you need to use SUMX()
- SUMX() is considered an iterator whereas SUM() aggregates a column as a whole.
- SUM() and SUMX() are iterators, but SUM() is used in filter contexts.
Correct

Incorrect
Question 6 of 6

6. Question
Which DAX function from task 6 removes all filter contexts?
- RELATEDTABLE() because the filter is applied to a different table
- ALL() because it removes all previous filters and uses the whole table
- SUMX() because the X() removes any filter before the summation is performed
- There is no function to remove filters.
Correct

Incorrect

The Data Analyst Toolkit

Quiz Summary

Information

Results

Results

Categories

1. Question

2. Question

3. Question

4. Question

5. Question

6. Question