Tableau Certification Prep questions with 100% correct answers

Tableau Certification Prep. 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