Tableau Desktop Specialist Certification Exam -
Questions With Correct Solutions
live data connection Right Ans - *Default
you can refresh views within tableau to see the most up to date information
Tableau is not importing your data so you can get started immediately
connecting to a server Right Ans - you need a log in to the server and a
driver
to create an extract Right Ans - right click data source > Extract data
note: if your workbook is saved as .TWBX file, the extract will be saved as a
part of your file. If it is saved as a .TDS, you will be prompted to save the
extract file elsewhere.
Save metadata properties (colors, etc) Right Ans - locally saving this or
publish to TOL or Tableau Server
right click data source>Add to Saved Data Sources
will save at a . TDS
- just info about the connection
- not the actual data source
joining tables Right Ans - combines information
- new fields or colums based on a field that they share
inner join Right Ans - preserves only the rows that have the same key fields
only get info for rows that are listed in both
left join Right Ans - use all records from the left table and the matched
records from the right table - any records not matched result in a null
right join Right Ans - tables from the right prioritized
, outer join Right Ans - joins all fields listed in all tables and fills in nulls
where there is not information in a specific cell
union Right Ans - bring together and 2 or more tables
vertical
adding rows to an existing table
data blending Right Ans - combining data from multiple data sources in one
view
sends separate queries from separate data sources
common fields Right Ans - data menu > edit relationships > custom >add
relationship
how to blend Right Ans - bring your dimension and measure into the
columns and rows pane
move to your second data source
- notice the links - this shows blends
- clicking on a grey link activates a data blend
primary and secondary data sources Right Ans - defined on a sheet by
sheet basis
measures Right Ans - Green
metrics or numerical data
value depends on context of dimensions
ex: SUM(Shipping Cost) is dependent on if we mean overall, or per Order
Priority.
Dimensions Right Ans - Blue
categorical fields
Questions With Correct Solutions
live data connection Right Ans - *Default
you can refresh views within tableau to see the most up to date information
Tableau is not importing your data so you can get started immediately
connecting to a server Right Ans - you need a log in to the server and a
driver
to create an extract Right Ans - right click data source > Extract data
note: if your workbook is saved as .TWBX file, the extract will be saved as a
part of your file. If it is saved as a .TDS, you will be prompted to save the
extract file elsewhere.
Save metadata properties (colors, etc) Right Ans - locally saving this or
publish to TOL or Tableau Server
right click data source>Add to Saved Data Sources
will save at a . TDS
- just info about the connection
- not the actual data source
joining tables Right Ans - combines information
- new fields or colums based on a field that they share
inner join Right Ans - preserves only the rows that have the same key fields
only get info for rows that are listed in both
left join Right Ans - use all records from the left table and the matched
records from the right table - any records not matched result in a null
right join Right Ans - tables from the right prioritized
, outer join Right Ans - joins all fields listed in all tables and fills in nulls
where there is not information in a specific cell
union Right Ans - bring together and 2 or more tables
vertical
adding rows to an existing table
data blending Right Ans - combining data from multiple data sources in one
view
sends separate queries from separate data sources
common fields Right Ans - data menu > edit relationships > custom >add
relationship
how to blend Right Ans - bring your dimension and measure into the
columns and rows pane
move to your second data source
- notice the links - this shows blends
- clicking on a grey link activates a data blend
primary and secondary data sources Right Ans - defined on a sheet by
sheet basis
measures Right Ans - Green
metrics or numerical data
value depends on context of dimensions
ex: SUM(Shipping Cost) is dependent on if we mean overall, or per Order
Priority.
Dimensions Right Ans - Blue
categorical fields
