Tableau Certification Prep UPDATED
Questions and CORRECT Answers
T/F Dates and times are automatically placed in the dimension area of the data pane? (for
relational data sources) - CORRECT ANSWER - True
________ dates represent the chronological progression of time. - CORRECT ANSWER -
Continuous
_______ dates show the data organized by date units. - CORRECT ANSWER - Discrete
_____ dates show up as blue pills. - CORRECT ANSWER - Discrete
_____ dates show up as green pills. - CORRECT ANSWER - Continuous
Data source files contain: - CORRECT ANSWER - 1. A single connection or multiple
connections
2. Modified data attributes
3. Calculated fields, sets, and/or parameters
T/F Data source files are reusable? - CORRECT ANSWER - True.
Data attributes can be changed using the __________. - CORRECT ANSWER - Metadata
grid
_______ is a relationship of two tables in a single database using a common field. - CORRECT
ANSWER - A Join
, ______ is a relationship of data from different databases or text tables based on a COMMON
DIMENSION. Behaves like a left join. - CORRECT ANSWER - A Blend
______ is a relationship across two different databases or text tables based on a common field. -
CORRECT ANSWER - A cross database join
_____ appends rows fro different tables with the same column names. - CORRECT
ANSWER - A Union
Use a ________ when you want to analyze data that exists in 2 separate tables within the same
database - CORRECT ANSWER - Join
Use a ________ when your data exits in different data sources. - CORRECT ANSWER -
Blend or cross database join
Full Outer Joins return ______ records from each table and displays _____ where there is no
match. - CORRECT ANSWER - All
Nulls
When using multiple data sources, the primary connection shows up as: - CORRECT
ANSWER - Blue
T/F: The Average function in Tableau aggregates NULL values as 0's. - CORRECT
ANSWER - False. Null values are ignored.
The Data Interpreter helps prepare ______ data for analysis - CORRECT ANSWER -
Excel
T/F Context Filters are executed after data source filters. - CORRECT ANSWER - True
Questions and CORRECT Answers
T/F Dates and times are automatically placed in the dimension area of the data pane? (for
relational data sources) - CORRECT ANSWER - True
________ dates represent the chronological progression of time. - CORRECT ANSWER -
Continuous
_______ dates show the data organized by date units. - CORRECT ANSWER - Discrete
_____ dates show up as blue pills. - CORRECT ANSWER - Discrete
_____ dates show up as green pills. - CORRECT ANSWER - Continuous
Data source files contain: - CORRECT ANSWER - 1. A single connection or multiple
connections
2. Modified data attributes
3. Calculated fields, sets, and/or parameters
T/F Data source files are reusable? - CORRECT ANSWER - True.
Data attributes can be changed using the __________. - CORRECT ANSWER - Metadata
grid
_______ is a relationship of two tables in a single database using a common field. - CORRECT
ANSWER - A Join
, ______ is a relationship of data from different databases or text tables based on a COMMON
DIMENSION. Behaves like a left join. - CORRECT ANSWER - A Blend
______ is a relationship across two different databases or text tables based on a common field. -
CORRECT ANSWER - A cross database join
_____ appends rows fro different tables with the same column names. - CORRECT
ANSWER - A Union
Use a ________ when you want to analyze data that exists in 2 separate tables within the same
database - CORRECT ANSWER - Join
Use a ________ when your data exits in different data sources. - CORRECT ANSWER -
Blend or cross database join
Full Outer Joins return ______ records from each table and displays _____ where there is no
match. - CORRECT ANSWER - All
Nulls
When using multiple data sources, the primary connection shows up as: - CORRECT
ANSWER - Blue
T/F: The Average function in Tableau aggregates NULL values as 0's. - CORRECT
ANSWER - False. Null values are ignored.
The Data Interpreter helps prepare ______ data for analysis - CORRECT ANSWER -
Excel
T/F Context Filters are executed after data source filters. - CORRECT ANSWER - True
