Tableau Desktop Foundations (TDS-C01) · 23% practice allocation

Tableau TDS-C01: Connecting to and Preparing Data Practice Questions

5 free sample questions from the Connecting to and Preparing Data domain, with answers and explanations. The full TDS-C01 bank has 51 questions across 4 domains. Questions are scenario-based and written from the official Tableau exam guide.

1.

Which join type returns only the rows that have matching values in BOTH tables?

  • A. Inner join✓ Correct
  • B. Left join
  • C. Full outer join
  • D. Union
Explanation

An inner join returns only rows with matches in both tables. A left join (B) keeps all left-table rows plus matches, a full outer join (C) keeps all rows from both, and a union (D) stacks rows from tables (not a join at all).

2.

A user wants the fastest possible performance and the ability to work offline with a large dataset that doesn't need up-to-the-second freshness. Which connection type should they choose?

  • A. An extract✓ Correct
  • B. A live connection
  • C. Neither; Tableau requires the database to be online
  • D. A live connection with no caching
Explanation

An extract gives fast, offline-capable performance from a saved snapshot — ideal when real-time freshness isn't required. A live connection (B, D) queries the source each time and needs the source available, and option C is false.

3.

A user needs to combine two tables that have the SAME columns (e.g., January sales and February sales) by stacking their rows into one table. What should they use?

  • A. A union✓ Correct
  • B. An inner join
  • C. A calculated field
  • D. A filter
Explanation

A union appends rows from tables with the same structure (stacking Jan and Feb sales into one table). A join (B) combines columns by matching keys, a calculated field (C) derives new values, and a filter (D) limits rows shown.

4.

A user wants to reuse a cleaned, well-labeled connection across multiple workbooks. What should they create?

  • A. A saved (published) data source✓ Correct
  • B. A story
  • C. A dashboard action
  • D. A table calculation
Explanation

Saving/publishing a data source lets multiple workbooks reuse the same connection, field naming, and preparation. A story (B) and dashboard action (C) are presentation/interaction features, and a table calculation (D) computes values within a view.

5.

A wide table has monthly columns (Jan, Feb, Mar, …) that should be a single 'Month' dimension and a single 'Value' measure for analysis. Which data-prep action reshapes it?

  • A. Pivot the month columns from columns to rows✓ Correct
  • B. Hide the columns
  • C. Split the columns
  • D. Create a union
Explanation

Pivoting turns the wide month columns into two fields — a 'Month' dimension and a 'Value' measure — the tidy shape Tableau prefers. Split (C) divides a single field's text, union (D) stacks tables, and hiding (B) just removes fields from view.

Test yourself across every TDS-C01 domain

The free TDS-C01 practice test mixes about 20 questions weighted like the exam. The full 51-question bank adds instant grading, flashcards and a timed mock exam.

Study this domain

Connecting to and Preparing Data study guide (TDS-C01) →

Other TDS-C01 domains

← All Tableau Desktop Foundations study resources