DATA ANALYTICS · 2026/2027 LATEST UPDATE
Tableau Desktop Specialist
Certification Exam 2026
Data Connection, Calculations,
Dashboards - Complete Study Guide
75+ Verified Exam Questions · Rated A+ · Guaranteed Results
✔ Connecting to & Preparing Data ✔ Building Dashboards & Stories
✔ Basic Calculations & Expressions ✔ Visualizations & Formatting
75 Questions · 4 Sections · Passing Score: 70%
Instant PDF Download · 100% Verified Answers · Score 90%+
Tableau Desktop Specialist Certification Exam 2026 Data Connection, Calculations, Dashboards — 2026/2027 | Passing Score: 70% | Page 1 of 41
, BEST SELLER · DATA ANALYTICS
Tableau Desktop Specialist
Certification Exam 2026
Data Connection, Calculations,
Dashboards 2026/2027 - Q&A with
Verified Answers
Every section. Every topic. 100% correct answers guaranteed.
Used by 5,000+ data analytics students to pass on their
first attempt.
Connecting to & Preparing Data Basic Calculations & Expressions
Building Dashboards & Stories Visualizations & Formatting
A+
Rated
Used by 5,000+ students · 100% Verified Answers · 2026/2027 Latest Update
Instant PDF Download
Tableau Desktop Specialist Certification Exam 2026 Data Connection, Calculations, Dashboards — 2026/2027 | Passing Score: 70% | Page 2 of 41
,SECTION 1 | Connecting to & Preparing Data | Q1-Q19 | Tableau Desktop Specialist Certification Exam 2026 Data C
Q1 Question 1 of 75
Q1. A data analyst at a retail company opens Tableau Desktop and needs to connect to a Microsoft
SQL Server database that requires Windows Authentication. The analyst selects 'Microsoft SQL
Server' from the Connect pane and sees the authentication options. Which authentication method
should the analyst select to use their current Windows credentials automatically?
A. Windows Authentication
B. Database Authentication
C. Single Sign-On via SAML
D. Kerberos Delegation
Correct Answer: A
Rationale:
Windows Authentication passes the current Windows login credentials to SQL Server without prompting
for a username or password. Database Authentication requires explicit credentials, and SAML or
Kerberos are not native Tableau SQL Server auth options in the standard connection dialog.
Q2 Question 2 of 75
Q2. A marketing team stores campaign performance data in an Excel workbook with three sheets:
Campaigns, AdSpend, and Conversions. When connecting to this file in Tableau, the analyst sees all
three sheets listed separately in the left pane. What must the analyst do to combine AdSpend and
Conversions into a single logical table for analysis?
A. Define a relationship or join between the tables in the data source page
B. Merge the sheets in Excel first and then reconnect
C. Use the 'Combine' button on each sheet icon
D. Create a calculated field that unions the two sheets
Correct Answer: B
Rationale:
Tableau can join or relate multiple tables from the same data source directly on the data source page.
Merging in Excel is unnecessary extra work, there is no Combine button on sheet icons, and a calculated
field cannot union tables.
Tableau Desktop Specialist Certification Exam 2026 Data Connection, Calculations, Dashboards — 2026/2027 | Passing Score: 70% | Page 3 of 41
, Q3 Question 3 of 75
Q3. A healthcare analyst imports a CSV file of patient visits where the VisitDate column appears as a
string in 'MM/DD/YYYY' format. Tableau is treating it as a string dimension instead of a date. Which
action in the data source page will convert the field to a proper date type?
A. Click the data type icon on the field and change it from 'Abc' to the calendar icon
B. Rename the field to include 'Date' in the name
C. Create a calculated field using STR() and replace the original
D. Sort the field in ascending order so Tableau auto-detects dates
Correct Answer: C
Rationale:
Clicking the data type icon lets you manually change the field type to Date, which tells Tableau to parse
the string as a date. Renaming does not change data types, STR() converts to string not from it, and
sorting has no effect on type detection.
Q4 Question 4 of 75
Q4. A logistics company connects Tableau to a live PostgreSQL database tracking shipments.
Management wants the dashboard to always show the most current data without manual refresh.
Which data connection mode should the analyst choose when setting up the data source?
A. Hyper file imported into Tableau Desktop
B. Extract with incremental refresh every hour
C. Extract with full refresh every day
D. Live connection to the database
Correct Answer: D
Rationale:
A live connection queries the database in real time so the dashboard always reflects current data.
Extracts, whether incremental or full, create a static snapshot that must be refreshed, and a Hyper file is
just a local extract format.
Tableau Desktop Specialist Certification Exam 2026 Data Connection, Calculations, Dashboards — 2026/2027 | Passing Score: 70% | Page 4 of 41
Tableau Desktop Specialist
Certification Exam 2026
Data Connection, Calculations,
Dashboards - Complete Study Guide
75+ Verified Exam Questions · Rated A+ · Guaranteed Results
✔ Connecting to & Preparing Data ✔ Building Dashboards & Stories
✔ Basic Calculations & Expressions ✔ Visualizations & Formatting
75 Questions · 4 Sections · Passing Score: 70%
Instant PDF Download · 100% Verified Answers · Score 90%+
Tableau Desktop Specialist Certification Exam 2026 Data Connection, Calculations, Dashboards — 2026/2027 | Passing Score: 70% | Page 1 of 41
, BEST SELLER · DATA ANALYTICS
Tableau Desktop Specialist
Certification Exam 2026
Data Connection, Calculations,
Dashboards 2026/2027 - Q&A with
Verified Answers
Every section. Every topic. 100% correct answers guaranteed.
Used by 5,000+ data analytics students to pass on their
first attempt.
Connecting to & Preparing Data Basic Calculations & Expressions
Building Dashboards & Stories Visualizations & Formatting
A+
Rated
Used by 5,000+ students · 100% Verified Answers · 2026/2027 Latest Update
Instant PDF Download
Tableau Desktop Specialist Certification Exam 2026 Data Connection, Calculations, Dashboards — 2026/2027 | Passing Score: 70% | Page 2 of 41
,SECTION 1 | Connecting to & Preparing Data | Q1-Q19 | Tableau Desktop Specialist Certification Exam 2026 Data C
Q1 Question 1 of 75
Q1. A data analyst at a retail company opens Tableau Desktop and needs to connect to a Microsoft
SQL Server database that requires Windows Authentication. The analyst selects 'Microsoft SQL
Server' from the Connect pane and sees the authentication options. Which authentication method
should the analyst select to use their current Windows credentials automatically?
A. Windows Authentication
B. Database Authentication
C. Single Sign-On via SAML
D. Kerberos Delegation
Correct Answer: A
Rationale:
Windows Authentication passes the current Windows login credentials to SQL Server without prompting
for a username or password. Database Authentication requires explicit credentials, and SAML or
Kerberos are not native Tableau SQL Server auth options in the standard connection dialog.
Q2 Question 2 of 75
Q2. A marketing team stores campaign performance data in an Excel workbook with three sheets:
Campaigns, AdSpend, and Conversions. When connecting to this file in Tableau, the analyst sees all
three sheets listed separately in the left pane. What must the analyst do to combine AdSpend and
Conversions into a single logical table for analysis?
A. Define a relationship or join between the tables in the data source page
B. Merge the sheets in Excel first and then reconnect
C. Use the 'Combine' button on each sheet icon
D. Create a calculated field that unions the two sheets
Correct Answer: B
Rationale:
Tableau can join or relate multiple tables from the same data source directly on the data source page.
Merging in Excel is unnecessary extra work, there is no Combine button on sheet icons, and a calculated
field cannot union tables.
Tableau Desktop Specialist Certification Exam 2026 Data Connection, Calculations, Dashboards — 2026/2027 | Passing Score: 70% | Page 3 of 41
, Q3 Question 3 of 75
Q3. A healthcare analyst imports a CSV file of patient visits where the VisitDate column appears as a
string in 'MM/DD/YYYY' format. Tableau is treating it as a string dimension instead of a date. Which
action in the data source page will convert the field to a proper date type?
A. Click the data type icon on the field and change it from 'Abc' to the calendar icon
B. Rename the field to include 'Date' in the name
C. Create a calculated field using STR() and replace the original
D. Sort the field in ascending order so Tableau auto-detects dates
Correct Answer: C
Rationale:
Clicking the data type icon lets you manually change the field type to Date, which tells Tableau to parse
the string as a date. Renaming does not change data types, STR() converts to string not from it, and
sorting has no effect on type detection.
Q4 Question 4 of 75
Q4. A logistics company connects Tableau to a live PostgreSQL database tracking shipments.
Management wants the dashboard to always show the most current data without manual refresh.
Which data connection mode should the analyst choose when setting up the data source?
A. Hyper file imported into Tableau Desktop
B. Extract with incremental refresh every hour
C. Extract with full refresh every day
D. Live connection to the database
Correct Answer: D
Rationale:
A live connection queries the database in real time so the dashboard always reflects current data.
Extracts, whether incremental or full, create a static snapshot that must be refreshed, and a Hyper file is
just a local extract format.
Tableau Desktop Specialist Certification Exam 2026 Data Connection, Calculations, Dashboards — 2026/2027 | Passing Score: 70% | Page 4 of 41
