Tableau Desktop Certified Professional — Question 112

Which string function should you use to find a substring within a column and return a Boolean value?

Answer options

• A. RTRIM
• B. SPLIT
• C. CONTAINS
• D. ENDSWITH

Correct answer: C

Explanation

The correct answer, CONTAINS, is specifically designed to search for a substring within a larger string and returns a Boolean indicating its presence. RTRIM is used for trimming whitespace, SPLIT divides a string into parts, and ENDSWITH checks if a string ends with a specified substring, making them unsuitable for this particular task.