Download Tableau Certification Prep Questions With Solved Solutions and more Exams Advanced Education in PDF only on Docsity!
Tableau Certification Prep Questions With
Solved Solutions
T/F Dates and times are automatically placed in the dimension area of the data pane? (for relational data sources) - ANSWER>>True
________ dates represent the chronological progression of time. - ANSWER>>Continuous
_______ dates show the data organized by date units. - ANSWER>>Discrete
_____ dates show up as blue pills. - ANSWER>>Discrete
_____ dates show up as green pills. - ANSWER>>Continuous
Data source files contain: - ANSWER>>1. A single connection or multiple connections
- Modified data attributes
- Calculated fields, sets, and/or parameters
T/F Data source files are reusable? - ANSWER>>True.
Data attributes can be changed using the __________. - ANSWER>>Metadata grid
_______ is a relationship of two tables in a single database using a common field.
______ is a relationship of data from different databases or text tables based on a COMMON DIMENSION. Behaves like a left join. - ANSWER>>A Blend
______ is a relationship across two different databases or text tables based on a common field. - ANSWER>>A cross database join
_____ appends rows fro different tables with the same column names. - ANSWER>>A Union
Use a ________ when you want to analyze data that exists in 2 separate tables within the same database - ANSWER>>Join
Use a ________ when your data exits in different data sources. - ANSWER>>Blend or cross database join
Full Outer Joins return ______ records from each table and displays _____ where there is no match. - ANSWER>>All Nulls
When using multiple data sources, the primary connection shows up as: - ANSWER>>Blue
T/F: The Average function in Tableau aggregates NULL values as 0's. - ANSWER>>False. Null values are ignored.
The Data Interpreter helps prepare ______ data for analysis - ANSWER>>Excel
T/F Context Filters are executed after data source filters. - ANSWER>>True
T/F An aggregated calculation can be multiplied by a non-aggregated constant - ANSWER>>True
T/F When you sort data in a hierarchy, Tableau rearranges headers that appear before the sorted field. - ANSWER>>False
T/F A data source file can contain a single connection or multiple connections? - ANSWER>>True
T/F Combined sets allow you to compare multiple sets to one another to determine intersections or differences across the sets. - ANSWER>>True
T/F Context filters improve performance when the data source is large. - ANSWER>>True
T/F Context filters do not use temp tables to reduce query size. - ANSWER>>False, context filters use temp tables to reduce query size
T/F Calculated fields are processed locally by tableau. - ANSWER>>False, calculated fields are processed in the database
T/F Table calculations are performed locally by tableau. - ANSWER>>True
T/F Comments in Tableau are denoted using - - ANSWER>>False, syntax comments are denoted by // in tableau
T/F In the formula editor, field names are represented with [Purple Text]. - ANSWER>>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. - ANSWER>>True
T/F When applying ATTR([]) to a field null values are ignored. - ANSWER>>True
T/F when using Min() or MAX() if either argument is null then the function returns null. - ANSWER>>True
T/F LOD calcs use data source level queries. - ANSWER>>True
T/F EXCLUDE AND INCLUDE functions behave relative to the view's current level of detail. - ANSWER>>True
T/F The include function calculates the results at a level greater than the lod present in the visualization. - ANSWER>>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. - ANSWER>>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%. - ANSWER>>True
T/F A moving average smooths short-term fluctuations in data to display clear long-term trends - ANSWER>>True
T/F Parameters are specific to a data source or worksheet. - ANSWER>>False - parameters are not data source or worksheets specific
T/F ATTR() is an aggregate function. - ANSWER>>True
A __________ _______________ _________________ is a user-defined data subset from a data source. - ANSWER>>tableau data extract
When updating a data extract, once can use an _______ extract, which only updates new rows since the previous extract. - ANSWER>>incremental
What type of chart is useful when wanting to evaluate two measures without stacking marks or expanding the axis? - ANSWER>>bar in bar
A ________ graph is a variation of a bar chart. - ANSWER>>bullet
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) - ANSWER>>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. - ANSWER>>False - there are 4 models
- Linear
- Log
- Exponent
- Poly/degree
T/F The is only one way to view summary data for a trend line. - ANSWER>>False - There a 3 ways to view the data
- Hovering over the trend line to show the tool tip
- Right clicking on the trend line > selecting describe trend line
- Analysis menu > describe trend line model
Average reference lines can be applied to the ____, each _____, or each ______. - ANSWER>>Table, pane, cell
T/F there is only one option for adding a forecast - ANSWER>>True
T/F You cannot forecast time series data in tableau. - ANSWER>>False - you can forecast time series data by using an exponential smoothing model.
T/F Forecasting is not supported for multidimensional data sources. - ANSWER>>True
Before you begin building a dashboard you should create a ______. - ANSWER>>Sketch
What is the 5 second rule? - ANSWER>>In 5 seconds or less, you can clearly understand the primary data story on the dashboard
Filters, ______, and ________ all allow for user input options. - ANSWER>>Actions, parameters
T/F Adding instructions to your dashboard enhances and guides the user experience. - ANSWER>>True
T/F Filters can be modified to appear like an instruction. - ANSWER>>True
T/F A Reference Band cannot be based on two fixed points. - ANSWER>>False
T/F A Reference Distribution plot cannot be along a continuous axis. - ANSWER>>False
Which of the following is not a Trend Line model
- Linear
- Exponential
- Binomial
- Log - ANSWER>>Binomial is not a trend line model
Is it possible to deploy a URL action on a dashboard object to open a Web Page within a dashboard rather than opening the system's web browser? - ANSWER>>Yes by using a web page object
T/F The Highlighting action can be disabled for the entire workbook. - ANSWER>>True - From the toolbar the Highlighting action can be disabled for the entire workbook.
T/F A sheet cannot be used within a story directly. Either sheets should be used within a dashboard, or a dashboard should be used within a story. - ANSWER>>False - A sheet can be used within a story directly.
