Tableau Desktop Specialist Certification - Questions
And Accurate Answers
Automatic folder created by Tableau in the Documents folder. Right Ans -
My Tableau Repository
Each column in a dataset has... Right Ans - a Role and a Type
Role Right Ans - Either a dimension (qualitative) or a measure (numeric).
Each column in a dataset has a Role.
Type Right Ans - Data type (number (decimal), number (whole), date &
time, date, string, boolean, geographic). Each column in a dataset has a Type.
Continuous Right Ans - - Green
- Creates Axes
- Usually Measures
Discrete Right Ans - - Blue
- Creates Headers
- Usually Dimensions
Auto-generated Fields Right Ans - - Measure Names
- Measure Values
- Latitude
- Longitude
- Number of Records
Connections Right Ans - - Live (default)
- Extract (saved subset)
Live Connection Right Ans - default
Extract Connection Right Ans - - 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 Right Ans - - 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 Right Ans - - 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 Right Ans - - .tds (Data Sorce)
- .tdsx (Packaged Data Source)
.twb Right Ans - - Workbook
- Workbooks hold one or more worksheets, plus zero ro more dashboards and
stories
- Visualizations, but no copy of the data
.twbx Right Ans - - 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 Right Ans - - .twb (Workbook)
- .twbx (Packaged Workbook)
Joins Right Ans - - 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
- Combines data, and then aggregates
Inner Join Right Ans - Contains values that have matches in both tables
Left Join Right Ans - Contains all values from the left table and
corresponding matches from the right table
When a value in left doesn't have corresponding match from right, you will
have null values
Right Join Right Ans - Contains all values from the right table and
coresponding matches from the left table
When a value in right doesn't have corresponding matches from left, you will
have null values
Unions Right Ans - - Combine two or more tables by appending values
(rows) from one table to another
- Increases number of rows
- When field names in the Union do not match, then both field names are
present in the Union, but contain several null values
Wildcard Search Right Ans - Set up criteria to automatically include tables
in a Union
Blends Right Ans - - Combines data from multiple sources
- Brings in additional info from a secondary data source and displays it with
data from the primary data source directly in the view
- An asterik (*) in a view with blended data indicates multiple values
- Never truly combines data
And Accurate Answers
Automatic folder created by Tableau in the Documents folder. Right Ans -
My Tableau Repository
Each column in a dataset has... Right Ans - a Role and a Type
Role Right Ans - Either a dimension (qualitative) or a measure (numeric).
Each column in a dataset has a Role.
Type Right Ans - Data type (number (decimal), number (whole), date &
time, date, string, boolean, geographic). Each column in a dataset has a Type.
Continuous Right Ans - - Green
- Creates Axes
- Usually Measures
Discrete Right Ans - - Blue
- Creates Headers
- Usually Dimensions
Auto-generated Fields Right Ans - - Measure Names
- Measure Values
- Latitude
- Longitude
- Number of Records
Connections Right Ans - - Live (default)
- Extract (saved subset)
Live Connection Right Ans - default
Extract Connection Right Ans - - 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 Right Ans - - 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 Right Ans - - 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 Right Ans - - .tds (Data Sorce)
- .tdsx (Packaged Data Source)
.twb Right Ans - - Workbook
- Workbooks hold one or more worksheets, plus zero ro more dashboards and
stories
- Visualizations, but no copy of the data
.twbx Right Ans - - 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 Right Ans - - .twb (Workbook)
- .twbx (Packaged Workbook)
Joins Right Ans - - 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
- Combines data, and then aggregates
Inner Join Right Ans - Contains values that have matches in both tables
Left Join Right Ans - Contains all values from the left table and
corresponding matches from the right table
When a value in left doesn't have corresponding match from right, you will
have null values
Right Join Right Ans - Contains all values from the right table and
coresponding matches from the left table
When a value in right doesn't have corresponding matches from left, you will
have null values
Unions Right Ans - - Combine two or more tables by appending values
(rows) from one table to another
- Increases number of rows
- When field names in the Union do not match, then both field names are
present in the Union, but contain several null values
Wildcard Search Right Ans - Set up criteria to automatically include tables
in a Union
Blends Right Ans - - Combines data from multiple sources
- Brings in additional info from a secondary data source and displays it with
data from the primary data source directly in the view
- An asterik (*) in a view with blended data indicates multiple values
- Never truly combines data
