What should the consultant tell the customer?

A client notices that while creating calculated fields, occasionally the new fields are created as strings, integers, or Booleans. The client asks a consultant if there is a performance difference among these three data types.

What should the consultant tell the customer?
A . Strings are fastest, followed by integers, and then Booleans.
B . Integers are fastest, followed by Booleans, and then strings.
C . Strings, integers, and Booleans all perform the same.
D . Booleans are fastest, followed by integers, and then strings.

View Answer

Answer: B

Explanation:

In Tableau, the performance of calculated fields can vary based on the data type used. Calculations involving integers and Booleans are generally faster than those involving strings. This is because numerical operations are typically more efficient for a computer to process than string operations, which can be more complex and time-consuming. Therefore, when performance is a consideration, it is advisable to use integers or Booleans over strings whenever possible.

References: The performance hierarchy of data types in Tableau calculations is documented in resources that discuss best practices for optimizing Tableau performance1.