Tableau Desktop Specialist Questions With Complete
Solutions
What can you edit from the manage metadata screen Right Ans - data type
and field name
what is stored in the .tds file Right Ans - data connection information
renamed dimensions and measures
folders created to organize dimensions and measures
when your data is stored in tables from different databases, what method
allows you to combine the data into a single viz? Right Ans - a data blend or
a cross-database join
what is useful when you want to join data but the database you're using
doesn't allow joins? Right Ans - a blend
what is useful when combining two tables that have the same fields (columns)
but different rows of data? Right Ans - a union
on the data source page, we add a cross-database join by: Right Ans -
clicking "Add" next to the word connections
what requires a primary data source and at least one secondary data source
Right Ans - a blend
data blending Right Ans - the order in which the fields are used determines
which source is primary and secondary
data blending behaves similarly to a left join which may result in missing data
data from secondary sources must always be aggregated calculations
you can ______ for members in a dimension so that their labels appear
differently in the view Right Ans - create aliases
shapes Right Ans - available for dimensions but not measures
if your scatter plot only has one mark, you can break this down into multiple
marks by: Right Ans - dragging a dimension to color
, if you use two measures in a line chart, Desktop may turn those into two
separate line charts. to merge those into one line chart with one measure on
the left Y-axis and the other measure on the right Y-axis: Right Ans - right
click the pill of the second measure and select Dual Axis
a single chart that shows multiple measures using multiple mark types is a
Right Ans - combination chart
to turn a bar chart into a stacked bar chart Right Ans - drag a dimension to
color
how do you create a highlight table Right Ans - by placing one or more
dimensions on the columns shelf and one or more dimensions on the rows
shelf, selecting the Square as the mark type, and placing the measure of
interest on the color shelf
to create a visual group where the grouped dimension is automatically added
to the Colors shelf, create the group Right Ans - using the dimension marks
when creating a group, which of the following methods automatically replaces
the original dimension with the grouped dimension in the view Right Ans -
using the dimension labels
what is true about sets Right Ans - the members of a set can change
dynamically when the underlying data changes
the members of a set can be fixed
sets appear at the bottom of the data pane
sets can display In/Out membership of the set
right-click to show the individual members included
sets can be combined with other sets
to create a custom hierarchy correctly for eventual drill down purposes, in the
Data pane: Right Ans - drag the more granular (detailed) dimension onto
the more aggregated (less detailed) dimension
this type of categorical filter can be thought of as an independent filter that
narrows down the data before other dependent filters are applied. it improves
Solutions
What can you edit from the manage metadata screen Right Ans - data type
and field name
what is stored in the .tds file Right Ans - data connection information
renamed dimensions and measures
folders created to organize dimensions and measures
when your data is stored in tables from different databases, what method
allows you to combine the data into a single viz? Right Ans - a data blend or
a cross-database join
what is useful when you want to join data but the database you're using
doesn't allow joins? Right Ans - a blend
what is useful when combining two tables that have the same fields (columns)
but different rows of data? Right Ans - a union
on the data source page, we add a cross-database join by: Right Ans -
clicking "Add" next to the word connections
what requires a primary data source and at least one secondary data source
Right Ans - a blend
data blending Right Ans - the order in which the fields are used determines
which source is primary and secondary
data blending behaves similarly to a left join which may result in missing data
data from secondary sources must always be aggregated calculations
you can ______ for members in a dimension so that their labels appear
differently in the view Right Ans - create aliases
shapes Right Ans - available for dimensions but not measures
if your scatter plot only has one mark, you can break this down into multiple
marks by: Right Ans - dragging a dimension to color
, if you use two measures in a line chart, Desktop may turn those into two
separate line charts. to merge those into one line chart with one measure on
the left Y-axis and the other measure on the right Y-axis: Right Ans - right
click the pill of the second measure and select Dual Axis
a single chart that shows multiple measures using multiple mark types is a
Right Ans - combination chart
to turn a bar chart into a stacked bar chart Right Ans - drag a dimension to
color
how do you create a highlight table Right Ans - by placing one or more
dimensions on the columns shelf and one or more dimensions on the rows
shelf, selecting the Square as the mark type, and placing the measure of
interest on the color shelf
to create a visual group where the grouped dimension is automatically added
to the Colors shelf, create the group Right Ans - using the dimension marks
when creating a group, which of the following methods automatically replaces
the original dimension with the grouped dimension in the view Right Ans -
using the dimension labels
what is true about sets Right Ans - the members of a set can change
dynamically when the underlying data changes
the members of a set can be fixed
sets appear at the bottom of the data pane
sets can display In/Out membership of the set
right-click to show the individual members included
sets can be combined with other sets
to create a custom hierarchy correctly for eventual drill down purposes, in the
Data pane: Right Ans - drag the more granular (detailed) dimension onto
the more aggregated (less detailed) dimension
this type of categorical filter can be thought of as an independent filter that
narrows down the data before other dependent filters are applied. it improves
