Tableau Desktop Certified Professional — Question 6

You have the following string value: Sales Data.
Which calculated field produces an output of Sales?

Answer options

• A. LEFT (“Sales Data”)
• B. LEFT (“Sales Data”, 5)
• C. LTRIM (“Sales Data”)
• D. RTRIM (“Sales Data”)

Correct answer: B

Explanation

The correct answer is B because the LEFT function with a length of 5 retrieves the first five characters from 'Sales Data', resulting in 'Sales'. Option A does not specify a length, so it defaults to 1 character, which would return 'S'. Options C and D are used for trimming whitespace and do not affect the output as required.