Tableau Desktop Specialist Certification
ACTUAL UPDATED Questions and
CORRECT Answers
Automatic folder created by Tableau in the Documents folder. - CORRECT ANSWER -
My Tableau Repository
Each column in a dataset has... - CORRECT ANSWER - a Role and a Type
Role - CORRECT ANSWER - Either a dimension (qualitative) or a measure (numeric).
Each column in a dataset has a Role.
Type - CORRECT ANSWER - Data type (number (decimal), number (whole), date &
time, date, string, boolean, geographic). Each column in a dataset has a Type.
Continuous - CORRECT ANSWER - - Green
- Creates Axes
- Usually Measures
Discrete - CORRECT ANSWER - - Blue
- Creates Headers
- Usually Dimensions
Auto-generated Fields - CORRECT ANSWER - - Measure Names
- Measure Values
- Latitude
- Longitude
- Number of Records
,Connections - CORRECT ANSWER - - Live (default)
- Extract (saved subset)
Live Connection - CORRECT ANSWER - default
Extract Connection - CORRECT ANSWER - - Saved subset
- Can use filters/et.c to get a subset of a large dataset
- Resides in Tableau
- Creats a .hyper file
Advantages:
- Supports large data sets
- Help improve performance
- Support additional functionality (ex. allows you to compute Count Distinct)
- Provide offline access to data
- Full refresh or incremental refresh (only rows that are new since previous refresh)
.tds - CORRECT ANSWER - - Data Source
- Info necessary to connect to the data, but no visualizations
- Data source type
- Connection information
- Groups, sets, calculated fields, and bins
- Default file properties (formats, aggregation, and sort order)
Use Data Source (.tds) if everyone who will use the data source has access to the underlying file
or database
, .tdsx - CORRECT ANSWER - - Packaged Data Source
- Contains all info in the data source (.tds) file, as well as a copy of any local file-based data or
extracts
- A single zipped file
Use Packaged Data Source (.tdsx) if you want to share your data with people who do no thave
access to the underlying data
Data Source File Types - CORRECT ANSWER - - .tds (Data Sorce)
- .tdsx (Packaged Data Source)
.twb - CORRECT ANSWER - - Workbook
- Workbooks hold one or more worksheets, plus zero ro more dashboards and stories
- Visualizations, but no copy of the data
.twbx - CORRECT ANSWER - - Packaged Workbook
- A single zip file that contains a workbook along with anly supporting local file data and
background images
- Includes data and visualizations
Best for sharing with those who don't have access to the data
Workbook Data Types - CORRECT ANSWER - - .twb (Workbook)
- .twbx (Packaged Workbook)
Joins - CORRECT ANSWER - - A method of combining data based on common fields
- Increases number of columns
- Join a max of 32 tables
- Can cause data loss or duplication
ACTUAL UPDATED Questions and
CORRECT Answers
Automatic folder created by Tableau in the Documents folder. - CORRECT ANSWER -
My Tableau Repository
Each column in a dataset has... - CORRECT ANSWER - a Role and a Type
Role - CORRECT ANSWER - Either a dimension (qualitative) or a measure (numeric).
Each column in a dataset has a Role.
Type - CORRECT ANSWER - Data type (number (decimal), number (whole), date &
time, date, string, boolean, geographic). Each column in a dataset has a Type.
Continuous - CORRECT ANSWER - - Green
- Creates Axes
- Usually Measures
Discrete - CORRECT ANSWER - - Blue
- Creates Headers
- Usually Dimensions
Auto-generated Fields - CORRECT ANSWER - - Measure Names
- Measure Values
- Latitude
- Longitude
- Number of Records
,Connections - CORRECT ANSWER - - Live (default)
- Extract (saved subset)
Live Connection - CORRECT ANSWER - default
Extract Connection - CORRECT ANSWER - - Saved subset
- Can use filters/et.c to get a subset of a large dataset
- Resides in Tableau
- Creats a .hyper file
Advantages:
- Supports large data sets
- Help improve performance
- Support additional functionality (ex. allows you to compute Count Distinct)
- Provide offline access to data
- Full refresh or incremental refresh (only rows that are new since previous refresh)
.tds - CORRECT ANSWER - - Data Source
- Info necessary to connect to the data, but no visualizations
- Data source type
- Connection information
- Groups, sets, calculated fields, and bins
- Default file properties (formats, aggregation, and sort order)
Use Data Source (.tds) if everyone who will use the data source has access to the underlying file
or database
, .tdsx - CORRECT ANSWER - - Packaged Data Source
- Contains all info in the data source (.tds) file, as well as a copy of any local file-based data or
extracts
- A single zipped file
Use Packaged Data Source (.tdsx) if you want to share your data with people who do no thave
access to the underlying data
Data Source File Types - CORRECT ANSWER - - .tds (Data Sorce)
- .tdsx (Packaged Data Source)
.twb - CORRECT ANSWER - - Workbook
- Workbooks hold one or more worksheets, plus zero ro more dashboards and stories
- Visualizations, but no copy of the data
.twbx - CORRECT ANSWER - - Packaged Workbook
- A single zip file that contains a workbook along with anly supporting local file data and
background images
- Includes data and visualizations
Best for sharing with those who don't have access to the data
Workbook Data Types - CORRECT ANSWER - - .twb (Workbook)
- .twbx (Packaged Workbook)
Joins - CORRECT ANSWER - - A method of combining data based on common fields
- Increases number of columns
- Join a max of 32 tables
- Can cause data loss or duplication
