Tableau Desktop Specialist: Connecting to &
Preparing Data 1 Questions and answers 100%
Correct
Which of the following is the best reason to use a relationship
instead of a join?
a. You are working with multiple tables that you'd like to combine into a single
table for analysis
b. You know that you'd like unmatched values to be dropped from the secondary
tables
c. You wish to avoid data duplication when combining tables with different
granularity
d. You are combining tables based on geographic fields - CORRECT ANSWER-c.
You wish to avoid data duplication when combining tables with different
granularity
Relationships are created in which layer?
, a. The data model Layer
b. The logical layer
c. The physical layer
d. The map layer - CORRECT ANSWER-b. The logical layer
Which of the following is the best reason to create a saved data source as a .TDS
file
a. Those who wish to use the data do not have access to the underlying data.
b. You want to save the default field properties such as number formats and sort
order.
c. You want to save a snapshot of the data that will not update even when the
underlying data changes.
d. You need to apply an aggregation that takes too long when using a live
connection. - CORRECT ANSWER-b. You want to save the default field
properties such as number formats and sort order.
When creating a union between tables, what will happen if the field names do not
match?
a. Tableau will return an error message, explaining that you must modify the tables
so that all tables used in the union have the same field names.
© 2026 Copyright. All Rights Reserved. This document is
protected by copyright law
Preparing Data 1 Questions and answers 100%
Correct
Which of the following is the best reason to use a relationship
instead of a join?
a. You are working with multiple tables that you'd like to combine into a single
table for analysis
b. You know that you'd like unmatched values to be dropped from the secondary
tables
c. You wish to avoid data duplication when combining tables with different
granularity
d. You are combining tables based on geographic fields - CORRECT ANSWER-c.
You wish to avoid data duplication when combining tables with different
granularity
Relationships are created in which layer?
, a. The data model Layer
b. The logical layer
c. The physical layer
d. The map layer - CORRECT ANSWER-b. The logical layer
Which of the following is the best reason to create a saved data source as a .TDS
file
a. Those who wish to use the data do not have access to the underlying data.
b. You want to save the default field properties such as number formats and sort
order.
c. You want to save a snapshot of the data that will not update even when the
underlying data changes.
d. You need to apply an aggregation that takes too long when using a live
connection. - CORRECT ANSWER-b. You want to save the default field
properties such as number formats and sort order.
When creating a union between tables, what will happen if the field names do not
match?
a. Tableau will return an error message, explaining that you must modify the tables
so that all tables used in the union have the same field names.
© 2026 Copyright. All Rights Reserved. This document is
protected by copyright law
