Tableau calculations quiz

Looking for a practice exam or questions to become a Certified Tableau Specialist? Our Tableau Desktop quizzes are designed to help you test your learning of Tableau Desktop technologies, or simply prepare for Tableau Software product certifications and exams! Assistance in preparing for Tableau Desktop Specialist and Qualified Associate certifications.

basic functions
Calculations
Calculation table

Créé le janvier 27, 2022

TS2 :Tableau Calculation Quiz

1 / 17

The LOOKUP function

A. Returns the number of rows from the current row to the first row in the partition.

B. Returns the value of the expression in a target row, specified as a relative offset from the current row.

C. Returns the number of rows from the current row to the last row in the partition.

D. Returns the value of this calculation in the previous row.

2 / 17

The REGEXP_EXTRACT function

A. Returns the portion of the string that matches the regular expression pattern. The substring is matched to the nth capturing group, where n is the given index. If index is 0, the entire string is returned.

B. Returns the portion of the string that matches the regular expression pattern.

C. Returns true if a substring of the specified string matches the regular expression pattern.

D. Returns a copy of the given string where the regular expression pattern is replaced by the replacement string.

3 / 17

The RANK_DENSE Table Calculation

A. Returns the rank for the current row in the partition. With this function, the set of values (6, 9, 9, 14) would be ranked (3, 2, 2, 1).

B. Returns the rank for the current row in the partition. With this function, the set of values (6, 9, 9, 14) would be ranked (0.25, 0.75, 0.75, 1.00).

C. Returns the rank for the current row in the partition. With this function, the set of values (6, 9, 9, 14) would be ranked (4, 2, 3, 1).

D. Returns the rank for the current row in the partition. With this function, the set of values (6, 9, 9, 14) would be ranked (4, 3, 3, 1).

4 / 17

The following is a valid DAY(#2018-04-15#)

True

False

5 / 17

An IF part of an expression can return a different data type from the ELSE part

True

False

6 / 17

The FIXED level of detail expressions

A. compute values using the specified dimensions in addition to whatever dimensions are in the view.

B. declare dimensions to omit from the view level of detail.

C. compute a value using the specified dimensions, without reference to the dimensions in the view.

7 / 17

10%7 is a valid expression.

A. Not a valid expression and returns an error.

B. Is a valid expression and returns a Boolean value.

C. Is a valid expression and returns 1.43.

D. Is a valid expression and returns 3.

8 / 17

Is 5^2 a valid expression?

True

False

9 / 17

The SCRIPT_ functions return results from an external service

A. True

B. False

10 / 17

Which of the following is NOT a function?

A. RUNNING_COUNTD

B. RUNNING_COUNT

C. RUNNING_SUM

D. RUNNING_AVG

11 / 17

The ZN function

A. Returns TRUE if the Value is zero.

B. Returns the value if the value is not NULL, or zero if the value is NULL.

C. Returns 1 if there is a value, or 0 if the value is null.

D. Returns TRUE if the value is ZERO, FALSE otherwise.

12 / 17

The following is a valid expression: DATE(2018-06-15 14:52:01)

True

False

13 / 17

When using DATEPART, which of the following is NOT a valid value?

month

days

dayofyear

iso-weekday

14 / 17

When using COUNT or COUNTD, NULL values are included.

True

False

15 / 17

ALL items in the Data Pane must have a unique name?

True

False

16 / 17

Which statement is TRUE about Calculated Field pill colors?

A. Dimensions are Blue, Measures are Green, Parameters are Purple, Errors are Red.

B. Dimensions are Blue, Facts are Green, Errors are Red.

C. Dimensions are Blue, Measures are Green, Errors are Red, Grey also appears in the Marks Card.

D. Data Source Fields are Blue, Calculated Fields are Green, Errors are Red.

17 / 17

In the Data Pane, Calculated Fields have an equals sign next to the type icon

True

False

Your score is

The average score is 60%

A propos des cours

Cours modèle

A propos des cours

Cours modèle

Tableau Software

The LOOKUP function

The REGEXP_EXTRACT function

The RANK_DENSE Table Calculation

The following is a valid DAY(#2018-04-15#)

An IF part of an expression can return a different data type from the ELSE part

The FIXED level of detail expressions

10%7 is a valid expression.

Is 5^2 a valid expression?

The SCRIPT_ functions return results from an external service

Which of the following is NOT a function?

The ZN function

The following is a valid expression: DATE(2018-06-15 14:52:01)

When using DATEPART, which of the following is NOT a valid value?

When using COUNT or COUNTD, NULL values are included.

ALL items in the Data Pane must have a unique name?

Which statement is TRUE about Calculated Field pill colors?

In the Data Pane, Calculated Fields have an equals sign next to the type icon

Quiz Tableau Desktop

Quiz Tableau calculation

A propos des cours

A propos des cours

Tableau Software

The LOOKUP function

The REGEXP_EXTRACT function

The RANK_DENSE Table Calculation

The following is a valid DAY(#2018-04-15#)

An IF part of an expression can return a different data type from the ELSE part

The FIXED level of detail expressions

10%7 is a valid expression.

Is 5^2 a valid expression?

The SCRIPT_ functions return results from an external service

Which of the following is NOT a function?

The ZN function

The following is a valid expression: DATE(2018-06-15 14:52:01)

When using DATEPART, which of the following is NOT a valid value?

When using COUNT or COUNTD, NULL values are included.

ALL items in the Data Pane must have a unique name?

Which statement is TRUE about Calculated Field pill colors?

In the Data Pane, Calculated Fields have an equals sign next to the type icon

You may also like

Login with your site account

Register a new account