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: