TABLEAU DATA ANALYST CERTIFICATION EXAM QUESTIONS WITH CORRECT ANSWERS
LATEST UPDATE 2025/2026
What are the benefits of a Live Connection? - Answers Real time updates, efficiency in large
databases, avoiding data duplication
What are the drawbacks of Live Connection? - Answers Require constant connection to source
(can't be used offline), slower performance, security concerns
What are the benefits of an Extract? - Answers Offline analysis, faster performance, secure
environments, portable (usable independent of source)
What are the drawbacks of an Extract? - Answers Data requires manual refresh, needs extra
storage space, not as efficient with large datasets
What are the valid Tableau extract file extensions? - Answers .tde or .hyper
Should you use a live or extract source for small, frequently changing data? - Answers Live
Should you use a live or extract source for large, static data? - Answers Extract
Should you use a live or extract source when fast queries are important to the dashboard? -
Answers Extract
Should you use a live or extract source when you need to access your dashboard offline? -
Answers Extract
Should you use a live or extract source when working in a secure environment? - Answers
Extract
Should you use a live or extract source when you need to share and collaborate on dashboards?
- Answers Extract
What files does Tableau usually support? - Answers Local (Flat) Files (eg excel, CSV, JSON)
Database (Relational) Files (eg SQL, Redshift, Snowflake)
Cloud/Online Sources (eg Google Sheets, Salesforce)
Tableau Native Extracts (.tde, .hyper)
Misc: PDF, Web APIs
What does DATEPARSE do? - Answers Converts text strings into specific date
Convert 2025-08-03 into 08/03/2025 - Answers DATEPARSE("yyyy-MM=d", [original_date])
Convert 03/Aug/2025 16:45:12 to 08/03/2025 4:45:12 PM - Answers
, DATEPARSE("dd/MMM/yyyy HH:mm:ss", [original_date])
Convert Sunday 3-Aug-2025 04.05.06.789 AM to 8/3/2025 4:05:06 AM - Answers
DATEPARSE("EEEE d-MMM-yyyy hh.mm.ss.SSS a", [original_date])
What are all the ways you can format the year 2016, and how are they translated? - Answers y:
16 (minimum needed)
yy: 16 (last two digits)
yyyy: 2016
What are all the ways you can format November, and how are they translated? - Answers M: 11
(numeric minimum)
MM: 11 (numeric padded)
MMM: Nov (Abbr. Name)
MMMM: November (Full name)
Bonus:
MMMMM: N (single letter abbr. name)
What are all the ways you can format the 9th? - Answers d: 9 (numeric minimum)
dd: 09 (numeric padded)
Bonus:
D for Day of year
D: 9 (numeric minimum)
DDD: 009 (numeric padded)
F for Day of Week in Month (e.g. 2nd Friday)
What are all the ways you can format Tuesday - Answers E or EEE: Tue (3 Letter Abbr)
EEEE: Tuesday (Full name)
Bonus:
LATEST UPDATE 2025/2026
What are the benefits of a Live Connection? - Answers Real time updates, efficiency in large
databases, avoiding data duplication
What are the drawbacks of Live Connection? - Answers Require constant connection to source
(can't be used offline), slower performance, security concerns
What are the benefits of an Extract? - Answers Offline analysis, faster performance, secure
environments, portable (usable independent of source)
What are the drawbacks of an Extract? - Answers Data requires manual refresh, needs extra
storage space, not as efficient with large datasets
What are the valid Tableau extract file extensions? - Answers .tde or .hyper
Should you use a live or extract source for small, frequently changing data? - Answers Live
Should you use a live or extract source for large, static data? - Answers Extract
Should you use a live or extract source when fast queries are important to the dashboard? -
Answers Extract
Should you use a live or extract source when you need to access your dashboard offline? -
Answers Extract
Should you use a live or extract source when working in a secure environment? - Answers
Extract
Should you use a live or extract source when you need to share and collaborate on dashboards?
- Answers Extract
What files does Tableau usually support? - Answers Local (Flat) Files (eg excel, CSV, JSON)
Database (Relational) Files (eg SQL, Redshift, Snowflake)
Cloud/Online Sources (eg Google Sheets, Salesforce)
Tableau Native Extracts (.tde, .hyper)
Misc: PDF, Web APIs
What does DATEPARSE do? - Answers Converts text strings into specific date
Convert 2025-08-03 into 08/03/2025 - Answers DATEPARSE("yyyy-MM=d", [original_date])
Convert 03/Aug/2025 16:45:12 to 08/03/2025 4:45:12 PM - Answers
, DATEPARSE("dd/MMM/yyyy HH:mm:ss", [original_date])
Convert Sunday 3-Aug-2025 04.05.06.789 AM to 8/3/2025 4:05:06 AM - Answers
DATEPARSE("EEEE d-MMM-yyyy hh.mm.ss.SSS a", [original_date])
What are all the ways you can format the year 2016, and how are they translated? - Answers y:
16 (minimum needed)
yy: 16 (last two digits)
yyyy: 2016
What are all the ways you can format November, and how are they translated? - Answers M: 11
(numeric minimum)
MM: 11 (numeric padded)
MMM: Nov (Abbr. Name)
MMMM: November (Full name)
Bonus:
MMMMM: N (single letter abbr. name)
What are all the ways you can format the 9th? - Answers d: 9 (numeric minimum)
dd: 09 (numeric padded)
Bonus:
D for Day of year
D: 9 (numeric minimum)
DDD: 009 (numeric padded)
F for Day of Week in Month (e.g. 2nd Friday)
What are all the ways you can format Tuesday - Answers E or EEE: Tue (3 Letter Abbr)
EEEE: Tuesday (Full name)
Bonus:
