Tableau Desktop Specialist - Questions & Accurate
Solutions
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. Right Ans - 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 Right Ans - C.
,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. Right Ans - 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 Right Ans - 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 Right Ans - d. 2014
,Blend the Southern Region table from the South_Superstore file with the
Subcategory Profit Targets table from the Subcategory Profit Targets file. Add
subcategory, AVG(Profit) and Profit Target to the view. For which of the
following subcategories was average profit higher than the target?
a. Appliances
b. Art
c. Binders
d. Bookcases Right Ans - a. Appliances
Inner join Southern_Region with Returns using Order ID. This will limit the
data to only those orders which were returned by the customer. Create a chart
that shows sales by year of order date. In which year was the sales value of the
returned items the lowest?
a. 2013
b. 2014
c. 2015
d. 2016 Right Ans - a. 2013
Open the Flights data and assign the geographic role for Airport Code as
airport. Add the airport code to the view and drag the Airport Name to the
Label mark. Which airport shown on the map is closest to HartsfieldJackson
Atlanta (ATL)?
a. Chattanooga Metropolitan Airport (CHA)
b. Charlotte Douglas International (CTL)
c. Orlando International (MCO)
d. George Bush Intercontinental (IAH) Right Ans - b. Charlotte Douglas
International (CTL)
In the Southern Region Superstore data, the Product Category, Product
Subcategory, and Product Name might be combined using which of the
following:
a. Set
b. Group
c. Hierarchy
, d. Parameter Right Ans - C - Hierarchy. Hierarchies allow you combine
similar fields while Groups and Sets combine values within a field. Parameters
allow the user to change a value, which can then be used in calculations,
filters, and reference lines
Which chart type will best visualize the relationship between two continuous
measures?
a. Bar chart
b. Scatter Plot
c. Line Chart
d. Stacked Bar Right Ans - B - Scatter Plot. Scatter plots to visualize
relationships between numerical variables. Bar charts to compare data across
categories. Line charts compare numeric data over time. Stacked bar charts
compare numeric data over two dimensions.
Which of the following is a table calculation?
a. SUM
b. TOTAL
c. AVG
d. STDEV Right Ans - B - Of these, only TOTAL is a table calculation
You would like a view that displays a filter allowing you to select the state, and
use a Set to display the top 5 products with the greatest total sales within the
selected state. What type of filter should you use to filter on the state?
a. Multiselect Filter
b. Dimension Filter
c. Context Filter
d. Wildcard Filter Right Ans - c. Context Filter
You need a filter which will execute before the Set. Dimension filters execute
after sets, so they are the wrong choice.
Bins can be created for which type of field?
a. Dimension
b. Discrete
Solutions
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. Right Ans - 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 Right Ans - C.
,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. Right Ans - 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 Right Ans - 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 Right Ans - d. 2014
,Blend the Southern Region table from the South_Superstore file with the
Subcategory Profit Targets table from the Subcategory Profit Targets file. Add
subcategory, AVG(Profit) and Profit Target to the view. For which of the
following subcategories was average profit higher than the target?
a. Appliances
b. Art
c. Binders
d. Bookcases Right Ans - a. Appliances
Inner join Southern_Region with Returns using Order ID. This will limit the
data to only those orders which were returned by the customer. Create a chart
that shows sales by year of order date. In which year was the sales value of the
returned items the lowest?
a. 2013
b. 2014
c. 2015
d. 2016 Right Ans - a. 2013
Open the Flights data and assign the geographic role for Airport Code as
airport. Add the airport code to the view and drag the Airport Name to the
Label mark. Which airport shown on the map is closest to HartsfieldJackson
Atlanta (ATL)?
a. Chattanooga Metropolitan Airport (CHA)
b. Charlotte Douglas International (CTL)
c. Orlando International (MCO)
d. George Bush Intercontinental (IAH) Right Ans - b. Charlotte Douglas
International (CTL)
In the Southern Region Superstore data, the Product Category, Product
Subcategory, and Product Name might be combined using which of the
following:
a. Set
b. Group
c. Hierarchy
, d. Parameter Right Ans - C - Hierarchy. Hierarchies allow you combine
similar fields while Groups and Sets combine values within a field. Parameters
allow the user to change a value, which can then be used in calculations,
filters, and reference lines
Which chart type will best visualize the relationship between two continuous
measures?
a. Bar chart
b. Scatter Plot
c. Line Chart
d. Stacked Bar Right Ans - B - Scatter Plot. Scatter plots to visualize
relationships between numerical variables. Bar charts to compare data across
categories. Line charts compare numeric data over time. Stacked bar charts
compare numeric data over two dimensions.
Which of the following is a table calculation?
a. SUM
b. TOTAL
c. AVG
d. STDEV Right Ans - B - Of these, only TOTAL is a table calculation
You would like a view that displays a filter allowing you to select the state, and
use a Set to display the top 5 products with the greatest total sales within the
selected state. What type of filter should you use to filter on the state?
a. Multiselect Filter
b. Dimension Filter
c. Context Filter
d. Wildcard Filter Right Ans - c. Context Filter
You need a filter which will execute before the Set. Dimension filters execute
after sets, so they are the wrong choice.
Bins can be created for which type of field?
a. Dimension
b. Discrete
