Tableau Desktop Specialist Prep - Questions With
Accurate Solutions
[Explain when to use a join versus a relationship] 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 Right Ans - c. You
wish to avoid data duplication when combining tables with different
granularity
[Add relationships to a data source] Relationships are created in which layer?
a. The data model Layer
b. The logical layer
c. The physical layer
d. The map layer Right Ans - 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 Right Ans - b. You want to save the default field properties such
as number formats and sort order.
[Add joins and unions] 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. Fields in
the union that do not have matching field names will contain null values.
[Explain when to use a join versus a relationship] In which of the following
situations would an outer join be preferred to a blend?
a. when you need to include all rows from both tables, even when the join or
blend criteria is not met
b. when the data is at different level of granularity
c. when you need to append rows from one table to rows in another table
d. when the tables are stored in different databases Right Ans - a. when you
need to include all rows from both tables, even when the join or blend criteria
is not met
Which of the following uses a primary and secondary data source?
a. Cross-database joins
b. Unions
c. Aggregation
d. Blending Right Ans - d. Blending
[Rename a data field] Which of the following can be renamed? [select 3] a.
Field names
b. Column values
c. Parameters
d. The Measure Names generated field
e. Sets Right Ans - a. Field names
c. Parameters
e. Sets
[Assign an alias to a data value] Which of the following can have an alias?
a. Field Names
b. Values of a continuous measure
c. Values of a discrete dimensions
d. Values of a discrete measure
e. Values of a date field Right Ans - c. Values of a discrete dimensions
, [Assign a geographic role to a data field] Which of the following are
predefined geographic roles? [select two]
a. Airport
b. Train terminal
c. Seaport
d. Geo code
e. Zip code Right Ans - a. Airport
e. Zip code
[Change default properties for a data field (number format, aggregation, color,
date format, etc.)] Which of the following are default properties which can be
assigned to a dimension? [select three]
a. Shape
b. Size
c. Color
d. Path
e. Sort Right Ans - a. Shape
c. Color
e. Sort
[Create sets by using marks and the data pane] You have a scatter plot
showing sales and profit by product subcategory. You wish to create a set
from a cluster of high values sub-categories. What steps should you take?
a. Hold down the control key and click on the sub-categories of interest. Then
right-click the data pane and select "Create set"
b. Highlight the sub-categories of interest. Then in the Marks card click "Set"
and "Create Set"
c. Click and hold down the mouse, drawing a rectangle to select the sub-
categories of interest. Right click and select 'create set'
d. Select the sub-categories in the color legend, then right click and select "set"
then "Create Set" Right Ans - c. Click and hold down the mouse, drawing a
rectangle to select the sub-categories of interest. Right click and select 'create
set'
[Display totals on a worksheet] A worksheet with a text table has the
dimension PRODUCTS and the measure AVG(Discount). If totals are added to
the worksheet, what default method will be used to calculate the totals?
a. The total value of discount divided by the number of rows in the text table
b. The average of the values in the text table
Accurate Solutions
[Explain when to use a join versus a relationship] 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 Right Ans - c. You
wish to avoid data duplication when combining tables with different
granularity
[Add relationships to a data source] Relationships are created in which layer?
a. The data model Layer
b. The logical layer
c. The physical layer
d. The map layer Right Ans - 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 Right Ans - b. You want to save the default field properties such
as number formats and sort order.
[Add joins and unions] 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. Fields in
the union that do not have matching field names will contain null values.
[Explain when to use a join versus a relationship] In which of the following
situations would an outer join be preferred to a blend?
a. when you need to include all rows from both tables, even when the join or
blend criteria is not met
b. when the data is at different level of granularity
c. when you need to append rows from one table to rows in another table
d. when the tables are stored in different databases Right Ans - a. when you
need to include all rows from both tables, even when the join or blend criteria
is not met
Which of the following uses a primary and secondary data source?
a. Cross-database joins
b. Unions
c. Aggregation
d. Blending Right Ans - d. Blending
[Rename a data field] Which of the following can be renamed? [select 3] a.
Field names
b. Column values
c. Parameters
d. The Measure Names generated field
e. Sets Right Ans - a. Field names
c. Parameters
e. Sets
[Assign an alias to a data value] Which of the following can have an alias?
a. Field Names
b. Values of a continuous measure
c. Values of a discrete dimensions
d. Values of a discrete measure
e. Values of a date field Right Ans - c. Values of a discrete dimensions
, [Assign a geographic role to a data field] Which of the following are
predefined geographic roles? [select two]
a. Airport
b. Train terminal
c. Seaport
d. Geo code
e. Zip code Right Ans - a. Airport
e. Zip code
[Change default properties for a data field (number format, aggregation, color,
date format, etc.)] Which of the following are default properties which can be
assigned to a dimension? [select three]
a. Shape
b. Size
c. Color
d. Path
e. Sort Right Ans - a. Shape
c. Color
e. Sort
[Create sets by using marks and the data pane] You have a scatter plot
showing sales and profit by product subcategory. You wish to create a set
from a cluster of high values sub-categories. What steps should you take?
a. Hold down the control key and click on the sub-categories of interest. Then
right-click the data pane and select "Create set"
b. Highlight the sub-categories of interest. Then in the Marks card click "Set"
and "Create Set"
c. Click and hold down the mouse, drawing a rectangle to select the sub-
categories of interest. Right click and select 'create set'
d. Select the sub-categories in the color legend, then right click and select "set"
then "Create Set" Right Ans - c. Click and hold down the mouse, drawing a
rectangle to select the sub-categories of interest. Right click and select 'create
set'
[Display totals on a worksheet] A worksheet with a text table has the
dimension PRODUCTS and the measure AVG(Discount). If totals are added to
the worksheet, what default method will be used to calculate the totals?
a. The total value of discount divided by the number of rows in the text table
b. The average of the values in the text table
