TABLEAU DESKTOP SPECIALIST
CERTIFICATION EXAM QUESTIONS
& ANSWERS!!
live data connection - ANSWER*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 - ANSWERyou need a log in to the server and a driver
to create an extract - ANSWERright 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) - ANSWERlocally 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 - ANSWERcombines information
- new fields or colums based on a field that they share
inner join - ANSWERpreserves only the rows that have the same key fields
only get info for rows that are listed in both
left join - ANSWERuse all records from the left table and the matched records from
the right table - any records not matched result in a null
how to change the data type in the data pane - ANSWERclick on the icon to the left
of the field name, choose a new data type from the drop down list
sets - ANSWERcombinations of data
ex: corporate customers in latin america
how to create an interactive filter - ANSWERright click the field in the data pane and
select "show filter"
CERTIFICATION EXAM QUESTIONS
& ANSWERS!!
live data connection - ANSWER*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 - ANSWERyou need a log in to the server and a driver
to create an extract - ANSWERright 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) - ANSWERlocally 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 - ANSWERcombines information
- new fields or colums based on a field that they share
inner join - ANSWERpreserves only the rows that have the same key fields
only get info for rows that are listed in both
left join - ANSWERuse all records from the left table and the matched records from
the right table - any records not matched result in a null
how to change the data type in the data pane - ANSWERclick on the icon to the left
of the field name, choose a new data type from the drop down list
sets - ANSWERcombinations of data
ex: corporate customers in latin america
how to create an interactive filter - ANSWERright click the field in the data pane and
select "show filter"
