Tableau Desktop Specialist Questions and
answers 100% Solved
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.
,TDS files save the data source metadata, such as the connection information,
default field formatting, and sort order. They do not save the data source itself, and
hence you should use this format if everyone who will use the data source has
access to the underlying file or database defined in the connection information.
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.
b. Tableau will automatically merge the fields, combining fields with similar field
names.
c. Fields in the union that do not have matching field names will contain null
values.
d. Fields with non-matching field names will be dropped, so that the union will
contain only those fields with matching field names - CORRECT ANSWER-C.
© 2026 Copyright. All Rights Reserved. This document is
protected by copyright law
,If the field names do not match, the fields will be included in the UNION but will
contain null values for the rows from the table that is missing the field.
After setting up two data source connections, how can you create a blend?
a. Add at least one field from the primary data source to your view. Then, in the
Data pane, click the data source that you want to designate as the secondary data
source and click the broken link icon.
b. On the data sources pane, drag tables from both connections onto the canvas.
Then click the venn diagram and select the blending fields.
c. On the data source page, double-click New Blend to set up the blend. Drag a
table from the left pane to the blend dialog box.
d. Select Data, then Edit Relationships, tthen Select the secondary data source in
the Secondary data source pane, select Custom in the relationships list, and then
click the Add button. - CORRECT ANSWER-A.
, Editing the relationships will not by itself establish a blend.
Which of the following uses a primary and secondary data source?
a. Cross-database joins
b. Unions
c. Aggregation
d. Blending - CORRECT ANSWER-D.
Data blending involves a primary and secondary data source.
Union the Stocks 2010-2013 and Stocks 2014 tables, and then create a chart
showing average Open by year and for each Company from 2010 to 2014. In
which year was the average open for Biogen Idec closest to Amazon's average
open?
a. 2011
b. 2012
c. 2013
d. 2014 - CORRECT ANSWER-d. 2014
© 2026 Copyright. All Rights Reserved. This document is
protected by copyright law
answers 100% Solved
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.
,TDS files save the data source metadata, such as the connection information,
default field formatting, and sort order. They do not save the data source itself, and
hence you should use this format if everyone who will use the data source has
access to the underlying file or database defined in the connection information.
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.
b. Tableau will automatically merge the fields, combining fields with similar field
names.
c. Fields in the union that do not have matching field names will contain null
values.
d. Fields with non-matching field names will be dropped, so that the union will
contain only those fields with matching field names - CORRECT ANSWER-C.
© 2026 Copyright. All Rights Reserved. This document is
protected by copyright law
,If the field names do not match, the fields will be included in the UNION but will
contain null values for the rows from the table that is missing the field.
After setting up two data source connections, how can you create a blend?
a. Add at least one field from the primary data source to your view. Then, in the
Data pane, click the data source that you want to designate as the secondary data
source and click the broken link icon.
b. On the data sources pane, drag tables from both connections onto the canvas.
Then click the venn diagram and select the blending fields.
c. On the data source page, double-click New Blend to set up the blend. Drag a
table from the left pane to the blend dialog box.
d. Select Data, then Edit Relationships, tthen Select the secondary data source in
the Secondary data source pane, select Custom in the relationships list, and then
click the Add button. - CORRECT ANSWER-A.
, Editing the relationships will not by itself establish a blend.
Which of the following uses a primary and secondary data source?
a. Cross-database joins
b. Unions
c. Aggregation
d. Blending - CORRECT ANSWER-D.
Data blending involves a primary and secondary data source.
Union the Stocks 2010-2013 and Stocks 2014 tables, and then create a chart
showing average Open by year and for each Company from 2010 to 2014. In
which year was the average open for Biogen Idec closest to Amazon's average
open?
a. 2011
b. 2012
c. 2013
d. 2014 - CORRECT ANSWER-d. 2014
© 2026 Copyright. All Rights Reserved. This document is
protected by copyright law
