Question 1

Which of the following statements is true about SWITCH and IF functions in DAX?

Accepted Answer

SWITCH functions are a cleaner way to write embedded IF statements.

Answer

SWITCH functions can only be used with two conditions.

Answer

SWITCH functions are always faster than IF statements.

Answer

SWITCH functions cannot be used with text values.

Question 2

In the video, what was the first value used in the SWITCH function example for the survived column?

Accepted Answer

1

Answer

"Perished"

Answer

"Survived"

Question 3

What does the result argument in the SWITCH function represent?

Accepted Answer

The value to be returned if the specified condition is true.

Answer

A calculation to be performed.

Answer

The next condition to be evaluated.

Answer

A value to be compared to the selected value.

Question 4

How can you specify an ELSE condition in a SWITCH function?

Accepted Answer

By omitting the result argument for the last value.

Answer

By using the keyword "ELSE".

Answer

There is no way to specify an ELSE condition in a SWITCH function.

Answer

By using a separate IF statement.

Question 5

In the video, what was the column used in the example that demonstrated using SWITCH functions with non-constant values?

Accepted Answer

Age

Answer

Embarked

Answer

Survived

Answer

Class

Question 6

What modification was made to the IF function in the video to adapt it for use with a SWITCH function and a non-constant value?

Accepted Answer

The keyword "TRUE" was added at the beginning of the statement.

Answer

The calculation logic was rewritten.

Answer

The comparison operator was changed.

Answer

The ELSE statement was removed.

Question 7

Which of the following is NOT a benefit of using SWITCH functions over IF statements?

Accepted Answer

Improved readability for complex conditional logic.

Answer

Potential performance improvements in some cases.

Answer

Simpler syntax for basic IF statements.

Answer

Ability to handle more than two conditions.

Question 8

In the video, what was the result assigned to the first value (C) in the SWITCH function example for the embarked column?

Accepted Answer

"Queenstown"

Answer

"Embarked"

Answer

"Unknown"

Answer

"Southampton"

Related quizzes