Tableau Desktop Specialist Exam Domain 1:
Connecting to & Preparing Data Questions and
answers 100% PASS
Live Connection - CORRECT ANSWER-- Directly queries the data source every
time the visualization is updated.
- Stored in the cloud by Tableau, which is more secure and reliable.
Extract - CORRECT ANSWER-- Create a static snapshot of time. Tableau copies
the data source and uses it internally.
- Are much faster and used with more complex visualizations and large datasets.
Logical Layer - CORRECT ANSWER-Enables the user to join data using
Relationships (Noodles).
Relationships - CORRECT ANSWER-- Way to connect tables with common
fields.
, - Are distinct from joins, useful when dealing with data from different
databases/sources.
- Combine primary key and foreign key.
Join - CORRECT ANSWER-- Physically combine tables into a single table on a
related column.
- Creates a horizontal (accordion) combination/ wider table.
Inner Join - CORRECT ANSWER-Retains only the matching records from both
tables.
Left Join - CORRECT ANSWER-Retains all records from the left (primary) table
and matching records from the right table.
Right Join - CORRECT ANSWER-Retains all records from the right table and
matching records from the left table.
Full Outer Join - CORRECT ANSWER-Retains all values from both tables.
Primary Key - CORRECT ANSWER-Uniquely identifies each record in the
primary table.
© 2026 Copyright. All Rights Reserved. This document is
protected by copyright law
Connecting to & Preparing Data Questions and
answers 100% PASS
Live Connection - CORRECT ANSWER-- Directly queries the data source every
time the visualization is updated.
- Stored in the cloud by Tableau, which is more secure and reliable.
Extract - CORRECT ANSWER-- Create a static snapshot of time. Tableau copies
the data source and uses it internally.
- Are much faster and used with more complex visualizations and large datasets.
Logical Layer - CORRECT ANSWER-Enables the user to join data using
Relationships (Noodles).
Relationships - CORRECT ANSWER-- Way to connect tables with common
fields.
, - Are distinct from joins, useful when dealing with data from different
databases/sources.
- Combine primary key and foreign key.
Join - CORRECT ANSWER-- Physically combine tables into a single table on a
related column.
- Creates a horizontal (accordion) combination/ wider table.
Inner Join - CORRECT ANSWER-Retains only the matching records from both
tables.
Left Join - CORRECT ANSWER-Retains all records from the left (primary) table
and matching records from the right table.
Right Join - CORRECT ANSWER-Retains all records from the right table and
matching records from the left table.
Full Outer Join - CORRECT ANSWER-Retains all values from both tables.
Primary Key - CORRECT ANSWER-Uniquely identifies each record in the
primary table.
© 2026 Copyright. All Rights Reserved. This document is
protected by copyright law
