Tableau Certification Prep UPDATED ACTUAL Questions and CORRECT Answers

Tableau Certification Prep UPDATED
ACTUAL 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

, T/F An aggregated calculation can be multiplied by a non-aggregated constant - CORRECT
ANSWER - True


T/F When you sort data in a hierarchy, Tableau rearranges headers that appear before the sorted
field. - CORRECT ANSWER - False


T/F A data source file can contain a single connection or multiple connections? - CORRECT
ANSWER - True


T/F A TDE file contains both modified and original data attributes? - CORRECT
ANSWER - True


T/F Calculated fields, sets, and or parameters are contained in a TDE file? - CORRECT
ANSWER - True


When using a cross-database join, data integration results at the _____ level, - CORRECT
ANSWER - Row


T/F Store procedures are available for multi-connection data sources. - CORRECT
ANSWER - False



T/F Data from different sources cannot be used in a pivot? - CORRECT ANSWER - True



T/F Data from different databases can be unioned? - CORRECT ANSWER - False


T/F Data blending is an alternative to joining data when you may want to analyze data in a single
view. - CORRECT ANSWER - True


The difference between data blending and joining is that the data comes from _________
different databases. - CORRECT ANSWER - Different