Tableau Desktop Specialist — Question 96

You have a dashboard that contains a parameter named Start Date.

You need to create an extract from a Microsoft Excel file. The extract must be filtered based on Start Date.

What should you do?

Answer options

• A. Create a data source based on the Excel worksheet and create a calculated field based on Start Date. From the Data pane add the calculated field to the data source filter.
• B. Create a custom SQL query that references Start Date in the WHERE clause.
• C. Create a custom SQL query to define the data source and create a calculated field based on Start Date. Add the calculated field to the extract filter.
• D. Create a data source based on the Excel worksheet and create a calculated field based on Start Date. Add the calculated field to the extract filter.

Correct answer: D

Explanation

The correct answer is D because it involves creating a data source from the Excel worksheet and using a calculated field based on Start Date, which is essential for filtering the extract. Option A incorrectly adds the calculated field to the data source filter instead of the extract filter. Option B does not utilize the calculated field necessary for the filtering process, and option C misplaces the calculated field in the extract filter rather than applying it correctly.