Tableau Desktop Specialist Exam Domain 1- Connecting to & Preparing Data Questions and
Answers Already Passed
Live Connection - Answers - Directly queries the data source every time the visualization is
updated.
- Stored in the cloud by Tableau, which is more secure and reliable.
Extract - Answers - 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 - Answers Enables the user to join data using Relationships (Noodles).
Relationships - Answers - 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 - Answers - Physically combine tables into a single table on a related column.
- Creates a horizontal (accordion) combination/ wider table.
Inner Join - Answers Retains only the matching records from both tables.
Left Join - Answers Retains all records from the left (primary) table and matching records from
the right table.
Right Join - Answers Retains all records from the right table and matching records from the left
table.
Full Outer Join - Answers Retains all values from both tables.
Primary Key - Answers Uniquely identifies each record in the primary table.
Foreign Key - Answers A primary key of one table that appears as an attribute in another table
and acts to provide a logical relationship between the two tables.
Answers Already Passed
Live Connection - Answers - Directly queries the data source every time the visualization is
updated.
- Stored in the cloud by Tableau, which is more secure and reliable.
Extract - Answers - 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 - Answers Enables the user to join data using Relationships (Noodles).
Relationships - Answers - 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 - Answers - Physically combine tables into a single table on a related column.
- Creates a horizontal (accordion) combination/ wider table.
Inner Join - Answers Retains only the matching records from both tables.
Left Join - Answers Retains all records from the left (primary) table and matching records from
the right table.
Right Join - Answers Retains all records from the right table and matching records from the left
table.
Full Outer Join - Answers Retains all values from both tables.
Primary Key - Answers Uniquely identifies each record in the primary table.
Foreign Key - Answers A primary key of one table that appears as an attribute in another table
and acts to provide a logical relationship between the two tables.
