Tableau Desktop Specialist — Question 153

A Data Analyst needs to calculate the first Tuesday of each month in the data.

Which set of functions should the analyst use to perform this calculation?

Answer options

• A. DATETRUNC, DATEPART
• B. DATEADD, DATENAME
• C. DATEDIFF, DATEPART
• D. DATETRUNC, DATEADD

Correct answer: D

Explanation

The correct answer is D, as DATETRUNC can be used to set the date to the beginning of the month, and DATEADD can then adjust that date to the first Tuesday. Options A and C do not provide the necessary functions for this specific calculation, while option B uses DATENAME, which is not applicable for this purpose.