Tableau-Desktop-Found Connecting to and Preparing Data Practice Question
You are connecting to a CSV file that contains dates in the format 'DD-MM-YYYY'. When you drag the date field into the view, Tableau interprets it as a string. How can you fix this?
⚠ Common exam trap
Candidates try to change the date format inside a worksheet instead of modifying the data type at the data source level.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Change the data type to Date in the Data Source pane.
Tableau needs specific formatting to recognize dates. If a format isn't standard, it defaults to a string. You can change the data type to Date in the Data Source tab. If the format remains unrecognized, you can use a calculated field with the DATEPARSE function to explicitly define the format, ensuring Tableau correctly interprets the temporal information for time-series analysis.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Change the data type to Date in the Data Source pane.
Why this is correct
In the Data Source tab, clicking the icon for the column and selecting 'Date' triggers Tableau's internal parsing logic. For many standard formats, this is sufficient to convert the data type. It is the first and simplest step to ensure temporal functionality without writing custom calculations.
- ✗
Convert the column to a Measure.
Why it's wrong here
Converting a date field to a measure would treat it as a continuous number, which loses all the beneficial date hierarchy features like drill-downs by year, quarter, and month. It does not solve the underlying issue of date recognition, as the data remains incorrectly categorized as numerical.
- ✗
Use the Split function to separate the date parts.
Why it's wrong here
Splitting the date into three separate columns for day, month, and year does not help Tableau recognize the field as a single, cohesive date. You would still need to perform complex logic to combine them back into a single date object, which is highly inefficient.
- ✗
Rename the column to start with 'Date'.
Why it's wrong here
Renaming a column does not affect how Tableau interprets the underlying data. The data type is determined by the values within the column, not the column header. Changing the name will not force Tableau to change a string field into a functional date field.
About these practice questions
One of 126 original Tableau-Desktop-Found practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official Tableau (Salesforce) exam blueprint
This Tableau-Desktop-Found practice question is part of Courseiva's free Tableau (Salesforce) certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the Tableau-Desktop-Found exam.