2025/2026
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.
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
Use a ________ when your data exits in different data sources. - Answers Blend or cross
database join
Full Outer Joins return ______ records from each table and displays _____ where there is no
match. - Answers All
Nulls
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 blends use a ______ join to incorporate the secondary data source with the primary. -
Answers Left
Data blends can be created by using data sources with common fields or by
establishing_____________ relationships. - Answers custom
T/F filters can be used across multiple data sources. - Answers True
T/F Sets are fields created on existing dimensions. - Answers True
T/F Sets cannot be used as a filter. - Answers False, sets can be used a filter.
T/F Combined sets allow you to compare multiple sets to one another to determine
intersections or differences across the sets. - Answers True
T/F Context filters improve performance when the data source is large. - Answers True
T/F Context filters do not use temp tables to reduce query size. - Answers False, context filters