Tableau Certification Prep Exam (Q&A)2022

T/F Dates and times are automatically placed in the dimension area of the data pane? (for relational data sources) True ________ dates represent the chronological progression of time. Continuous _______ dates show the data organized by date units. Discrete _____ dates show up as blue pills. Discrete _____ dates show up as green pills. Continuous Data source files contain: 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? True. Data attributes can be changed using the __________. Metadata grid _______ is a relationship of two tables in a single database using a common field. A Join ______ is a relationship of data from different databases or text tables based on a COMMON DIMENSION. Behaves like a left join. A Blend ______ is a relationship across two different databases or text tables based on a common field. A cross database join _____ appends rows fro different tables with the same column names. A Union Use a ________ when you want to analyze data that exists in 2 separate tables within the same database Join Use a ________ when your data exits in different data sources. Blend or cross database join Full Outer Joins return ______ records from each table and displays _____ where there is no match. All Nulls When using multiple data sources, the primary connection shows up as: Blue T/F: The Average function in Tableau aggregates NULL values as 0's. False. Null values are ignored. The Data Interpreter helps prepare ______ data for analysis Excel T/F Context Filters are executed after data source filters. True T/F An aggregated calculation can be multiplied by a non-aggregated constant True T/F When you sort data in a hierarchy, Tableau rearranges headers that appear before the sorted field. False T/F A data source file can contain a single connection or multiple connections? True T/F A TDE file contains both modified and original data attributes? True T/F Calculated fields, sets, and or parameters are contained in a TDE file? True When using a cross-database join, data integration results at the _____ level, Row T/F Store procedures are available for multi-connection data sources. False T/F Data from different sources cannot be used in a pivot? True T/F Data from different databases can be unioned? False T/F Data blending is an alternative to joining data when you may want to analyze data in a single view. True The difference between data blending and joining is that the data comes from _________ different databases. Different Data blends use a ______ join to incorporate the secondary data source with the primary. Left Data blends can be created by using data sources with common fields or by establishing_____________ relationships. custom T/F filters can be used across multiple data sources. True T/F Sets are fields created on existing dimensions. True T/F Sets cannot be used as a filter. 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. True T/F Context filters improve performance when the data source is large. True T/F Context filters do not use temp tables to reduce query size. False, context filters use temp tables to reduce query size T/F Calculated fields are processed locally by tableau. False, calculated fields are processed in the database T/F Table calculations are performed locally by tableau. True T/F Comments in Tableau are denoted using - False, syntax comments are denoted by // in tableau T/F In the formula editor, field names are represented with [Purple Text]. False, field names appear in [orange text] and parameters appear in [purple text] T/F You will need to use an aggregated when data from multiple dimensions doesn't a consistent level of detail. True T/F When applying ATTR([]) to a field null values are ignored. True T/F when using Min() or MAX() if either argument is null then the function returns null. True T/F LOD calcs use data source level queries. True T/F EXCLUDE AND INCLUDE functions behave relative to the view's current level of detail. True T/F The include function calculates the results at a level greater than the lod present in the visualization. False - the include function calculates the results at a level lower than the LOD present in the Viz. T/F The EXCLUDE function calculates the results at a level greater than the LOD present in the Viz. True T/F the default behavior for a table calc is to apply the calculation across the row, giving the row a grand total of 100%. True T/F A moving average smooths short-term fluctuations in data to display clear long-term trends True T/F Parameters are specific to a data source or worksheet. False - parameters are not data source or worksheets specific T/F ATTR() is an aggregate function. True A __________ _______________ _________________ is a user-defined data subset from a data source. tableau data extract When updating a data extract, once can use an _______ extract, which only updates new rows since the previous extract. incremental What type of chart is useful when wanting to evaluate two measures without stacking marks or expanding the axis? bar in bar A ________ graph is a variation of a bar chart. bullet Bullet graphs are useful for comparing the performance of a _______ measure to _______ measures Primary, other T/F When using map tools the last active tool will be remembers when you save, package, or publish the workbook. True The _________ selection tool is the default when creating a map in desktop. Rectangular Area code boundaries, streets, and place names are all what kind of map feature? Map Layers Layers that show census information are called ______ layers. Data A _____ is a chart that displays the shape of a frequency distribution. Histogram T/F The difference between a bar chart and a histogram is that the bar chart uses bins or ranges. False - the histogram uses bins or ranges _____ plots are useful for seeing and contrasting the distribution of data within a category. Box Plot The boxes of a box plot show the _____ ____% of the data middle 50, or middle two quartiles of data Whiskers of a box plot typically show the _________ of the data. However, they can show 1.5x the _________ range. extremes, interquartile Trend lines help analyst to make _____ about the data. Predictions T/F To add a trend line to a view, only the x-axis has to be a numeric value (also includes date/time fields) False. Both axes must contain a field that can be interpreted as a number. T/F there are 3 different model types for trend lines. False - there are 4 models 1. Linear 2. Log 3. Exponent 4. Poly/degree