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

A is correct. The equals sign gives us a quick way of distinguishing between Data Source Fields and Calculated Fields. Personally, I also like to prefix the names of my Calculated Fields.

#### Q2. Which statement is TRUE about Calculated Field pill colors?

C is correct. Parameters cannot be added to a dashboard as a Pill with a color, and it is only Purple when a Parameter is used within a Calculated Field Calculation. Facts is a term from Dimensional Modelling and is referred to as Measures in Tableau. Answer D is just completely wrong.

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

B is correct. Dimensions, Measures and Sets must have a unique name, but Parameters also sit within the Data Pane and can have the same name as Dimensions, Measures and Sets.

#### Q4. When using COUNT or COUNTD, NULL values are included.

B is correct. COUNT counts the number of values, COUNTD counts the number of unique values. Neither include NULL values.

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

B is correct. The value should be 'day' and not 'days'.

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

B is correct. The DATE function takes in a string value and therefore quotation marks are required.

#### Q7. The ZN function

B is correct. The ZN value is very useful when it comes to doing maths and avoid NULL issues.

#### Q8. Which of the following is NOT a function?

A is correct. RUNNING_COUNTD is not a valid function in Tableau. RUNNING_COUNT is however and returns the running count of the given expression from the first row in the partition to the current row. RUNNING_SUM returns the running sum of a given expression from the first row of the partition to the current row. RUNNING_MIN returns the running minimum of a given expression from the first row of the partition to the current row. RUNNING_AVG returns the running average of a given expression from the first row of the partition to the current row.

#### Q9. The SCRIPT_ functions return results from an external service

A is correct. SCRIPT_BOOL, SCRIPT_INT, SCRIPT_REAL and SCRIPT_STR are used to bring back results from an external data service. Current this includes R and Python.

#### Q10. Is 5^2 a valid expression?

A is correct. The ^ operator is the power operator and this expression will return 25.

#### Q11. 10%7 is a valid expression.

D is correct. The % operator (modulo) returns the remainder of a division operation. For example, 9 % 2 returns 1 because 2 goes into 9 four times with a remainder of 1. Modulo can only operate on integers.

#### Q12. The FIXED level of detail expressions

C is correct. A describes INCLUDE. B describes EXCLUDE.

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

B is correct. All expressions must return the same data types so you will get the following error: "Return type from IF expressions must match"

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

A is correct. You can use # as a short cut for DATE, for example, you could have written the above as DAY(DATE("2018-04-15")).

#### Q15. The RANK_DENSE Table Calculation

A is correct. B describes RANK_PERCENTILE. C describes RANK_UNIQUE. D describes RANK_MODIFIED.

#### Q16. The REGEXP_EXTRACT function

B is correct. A describes REGEXP_EXTRACT_NTH. C describes REGEXP_MATCH. D describes REGEXP_REPLACE.

#### Q17. The LOOKUP function

B is correct. A describes FIRST. C describes LAST. D describes PREVIOUS_VALUE.

#### Q18. The DATETRUNC function

D is correct. A describes DATEPART. B describes DAY. C describes MAKEDATE.

#### Q19. The SCRIPT_STR Table Calculation

D is correct. A describes SCRIPT_BOOL. B describes SCRIPT_INT. C describes SCRIPT_REAL.

#### Q20. You can send SQL expressions directly to your database.

A is correct. RAWSQL pass-through functions can be used to send SQL expressions directly to the database, without first being interpreted by Tableau. If you have custom database functions that Tableau doesnâ€™t know about, you can use these pass-through functions to call these custom functions.

Share your Results: