Desktop Specialist · 25% of the exam

Connecting to and Preparing Data: free practice questions

5 sample questions from our 13-question bank for this domain — answers and explanations included. These are the same scenario-based style as the real Tableau exam.

1. 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.

2. Which statement about connecting to data in Tableau is TRUE?

  • A. Tableau can connect to many source types including files (Excel, CSV), relational databases, and cloud data sources✓ Correct
  • B. Tableau can only connect to Excel files
  • C. Tableau requires all data to be in a single CSV
  • D. Tableau cannot connect to databases
Explanation

Tableau connects to a wide range of sources: files (Excel, CSV, JSON), relational databases, cloud warehouses, and more. Options B, C, and D all understate Tableau's connectivity.

3. 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. Split the columns
  • C. Create a union
  • D. Hide the columns
Explanation

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

4. A left join between Orders (left) and Returns (right) on Order ID produces what result?

  • A. All rows from Orders, with matching Returns data where available and nulls where there is no matching return✓ Correct
  • B. Only orders that were returned
  • C. Only returns with no matching order
  • D. The two tables stacked as rows
Explanation

A left join keeps every row from the left table (Orders) and adds matching right-table (Returns) columns, filling nulls where there's no match. 'Only returned orders' (B) is an inner join, 'returns with no order' (C) isn't a left join result, and stacking rows (D) is a union.

5. In Tableau's relationships model (the default in the logical layer), how do relationships differ from traditional joins?

  • A. Relationships are flexible, noun-based associations that let Tableau generate appropriate joins automatically at the right level of detail per viz, without duplicating data upfront✓ Correct
  • B. Relationships permanently merge tables into one flattened table immediately
  • C. Relationships can only connect text files
  • D. Relationships are the same as unions
Explanation

Relationships define how tables relate and let Tableau choose the correct join type and aggregation level per visualization, avoiding premature flattening and duplication. They don't immediately flatten tables (B), aren't limited to text files (C), and differ from unions (D), which stack rows.

8 more questions in this domain

Practice the full bank with instant grading, flashcards, and a timed mock exam.

Start practicing free
Connecting to and Preparing Data — Free Desktop Specialist Practice Questions | DataCertPrep — Certification Prep