TABLEAU CERTIFICATION
PREP QUESTIONS AND
ANSWERSzs
T/F Dates and times are automatically placed in the dimension area of the data pane?
(for relational data sources) - Answers -True
________ dates represent the chronological progression of time. - Answers -Continuous
_______ dates show the data organized by date units. - Answers -Discrete
_____ dates show up as blue pills. - Answers -Discrete
_____ dates show up as green pills. - Answers -Continuous
Data source files contain: - Answers -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? - Answers -True.
When using multiple data sources, the primary connection shows up as: - Answers -
Blue
T/F: The Average function in Tableau aggregates NULL values as 0's. - Answers -False.
Null values are ignored.
The Data Interpreter helps prepare ______ data for analysis - Answers -Excel
T/F Context Filters are executed after data source filters. - Answers -True
, T/F An aggregated calculation can be multiplied by a non-aggregated constant -
Answers -True
T/F When you sort data in a hierarchy, Tableau rearranges headers that appear before
the sorted field. - Answers -False
T/F A data source file can contain a single connection or multiple connections? -
Answers -True
T/F A TDE file contains both modified and original data attributes? - Answers -True
T/F Calculated fields, sets, and or parameters are contained in a TDE file? - Answers -
True
When using a cross-database join, data integration results at the _____ level, - Answers
-Row
T/F Store procedures are available for multi-connection data sources. - Answers -False
T/F Data from different sources cannot be used in a pivot? - Answers -True
T/F Data from different databases can be unioned? - Answers -False
T/F Data blending is an alternative to joining data when you may want to analyze data in
a single view. - Answers -True
The difference between data blending and joining is that the data comes from
_________ different databases. - Answers -Different
Data attributes can be changed using the __________. - Answers -Metadata grid
_______ is a relationship of two tables in a single database using a common field. -
Answers -A Join
______ is a relationship of data from different databases or text tables based on a
COMMON DIMENSION. Behaves like a left join. - Answers -A Blend
______ is a relationship across two different databases or text tables based on a
common field. - Answers -A cross database join
_____ appends rows fro different tables with the same column names. - Answers -A
Union
Use a ________ when you want to analyze data that exists in 2 separate tables within
the same database - Answers -Join
PREP QUESTIONS AND
ANSWERSzs
T/F Dates and times are automatically placed in the dimension area of the data pane?
(for relational data sources) - Answers -True
________ dates represent the chronological progression of time. - Answers -Continuous
_______ dates show the data organized by date units. - Answers -Discrete
_____ dates show up as blue pills. - Answers -Discrete
_____ dates show up as green pills. - Answers -Continuous
Data source files contain: - Answers -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? - Answers -True.
When using multiple data sources, the primary connection shows up as: - Answers -
Blue
T/F: The Average function in Tableau aggregates NULL values as 0's. - Answers -False.
Null values are ignored.
The Data Interpreter helps prepare ______ data for analysis - Answers -Excel
T/F Context Filters are executed after data source filters. - Answers -True
, T/F An aggregated calculation can be multiplied by a non-aggregated constant -
Answers -True
T/F When you sort data in a hierarchy, Tableau rearranges headers that appear before
the sorted field. - Answers -False
T/F A data source file can contain a single connection or multiple connections? -
Answers -True
T/F A TDE file contains both modified and original data attributes? - Answers -True
T/F Calculated fields, sets, and or parameters are contained in a TDE file? - Answers -
True
When using a cross-database join, data integration results at the _____ level, - Answers
-Row
T/F Store procedures are available for multi-connection data sources. - Answers -False
T/F Data from different sources cannot be used in a pivot? - Answers -True
T/F Data from different databases can be unioned? - Answers -False
T/F Data blending is an alternative to joining data when you may want to analyze data in
a single view. - Answers -True
The difference between data blending and joining is that the data comes from
_________ different databases. - Answers -Different
Data attributes can be changed using the __________. - Answers -Metadata grid
_______ is a relationship of two tables in a single database using a common field. -
Answers -A Join
______ is a relationship of data from different databases or text tables based on a
COMMON DIMENSION. Behaves like a left join. - Answers -A Blend
______ is a relationship across two different databases or text tables based on a
common field. - Answers -A cross database join
_____ appends rows fro different tables with the same column names. - Answers -A
Union
Use a ________ when you want to analyze data that exists in 2 separate tables within
the same database - Answers -Join
