Tableau Data Analyst Certification Exam
UPDATED ACTUAL Questions and
CORRECT Answers
Which of the following best describes the fundamental end to end workflow for providing
insights from data using Tableau ?A - Connect to, Clean & Share the DataB - Connect to, Build
Views to Analyse & Share the DataC - Connect to, Build Views to Analyse & Certify the DataD
- Connect to, Certify & Share the Data - CORRECT ANSWER - B - The Tableau Desktop
workflow consists of connecting to, analyzing, and sharing your data
What is the difference in functionality between tableau Desktop and Tableau Online when it
comes to configuring reference lines and reference bands? - CORRECT ANSWER -
Desktop has an option for Box Plot, web version does not
What does the box in a box plot represent? - CORRECT ANSWER - middle 50% of data,
the 2 middle quartiles of the data distribution
How do dynamic sets work? - CORRECT ANSWER - The members of a dynamic set
change when the underlying data changes. Dynamic sets can only be based on a single
dimension.
how do fixed sets work? - CORRECT ANSWER - The members of a fixed set do not
change, even if the underlying data changes. A fixed set can be based on a single dimension or
multiple dimensions.
What options do you have when creating a combined set? - CORRECT ANSWER - - All
members in both sets
- shared members in both sets
- Except shared members
What is the wildcard tab for when filtering on dimensions? - CORRECT ANSWER -
(Tableau Desktop only): Use the Wildcard tab to define a pattern to filter on. For example, when
, filtering on email addresses you might want to only include emails from a specific domain. You
can define a wildcard filter that ends with "@gmail.com" to only include Google email
addresses.
Are reference lines added to a discrete or continuous axis in a view? - CORRECT
ANSWER - continuous
3 ways you can sort on a visualization in tableau - CORRECT ANSWER - you can sort
from the header, axis, or field label
What is the condition tab for when filtering on dimensions? - CORRECT ANSWER - Use
the Condition tab in the Filter dialog box to define rules to filter by. For example, in a view
showing the average Unit Price for a collection of products, you may want to only show the
Products that have an average unit price that is greater than or equal to $25. You can use the
built-in controls to write a condition or you can write a custom formula.
What is the order of operations of Filters in Tableau? - CORRECT ANSWER - 1. Extract
filters
2. Data source filters
3. Context filters
4. Filters on dimensions (whether on the Filters shelf or in filter cards in the view)
5. Filters on measures (whether on the Filters shelf or in filter cards in the view)
How do you add members to an existing group? - CORRECT ANSWER - -In the Data
pane, right-click the group field, and then click Edit Group.
- In the Edit Group dialog box, select one or more members and drag them into the group you
want.
Click OK.
What does the table calculation 'Table (across)' do ? - CORRECT ANSWER - Computes
across the length of the table and restarts after every partition
UPDATED ACTUAL Questions and
CORRECT Answers
Which of the following best describes the fundamental end to end workflow for providing
insights from data using Tableau ?A - Connect to, Clean & Share the DataB - Connect to, Build
Views to Analyse & Share the DataC - Connect to, Build Views to Analyse & Certify the DataD
- Connect to, Certify & Share the Data - CORRECT ANSWER - B - The Tableau Desktop
workflow consists of connecting to, analyzing, and sharing your data
What is the difference in functionality between tableau Desktop and Tableau Online when it
comes to configuring reference lines and reference bands? - CORRECT ANSWER -
Desktop has an option for Box Plot, web version does not
What does the box in a box plot represent? - CORRECT ANSWER - middle 50% of data,
the 2 middle quartiles of the data distribution
How do dynamic sets work? - CORRECT ANSWER - The members of a dynamic set
change when the underlying data changes. Dynamic sets can only be based on a single
dimension.
how do fixed sets work? - CORRECT ANSWER - The members of a fixed set do not
change, even if the underlying data changes. A fixed set can be based on a single dimension or
multiple dimensions.
What options do you have when creating a combined set? - CORRECT ANSWER - - All
members in both sets
- shared members in both sets
- Except shared members
What is the wildcard tab for when filtering on dimensions? - CORRECT ANSWER -
(Tableau Desktop only): Use the Wildcard tab to define a pattern to filter on. For example, when
, filtering on email addresses you might want to only include emails from a specific domain. You
can define a wildcard filter that ends with "@gmail.com" to only include Google email
addresses.
Are reference lines added to a discrete or continuous axis in a view? - CORRECT
ANSWER - continuous
3 ways you can sort on a visualization in tableau - CORRECT ANSWER - you can sort
from the header, axis, or field label
What is the condition tab for when filtering on dimensions? - CORRECT ANSWER - Use
the Condition tab in the Filter dialog box to define rules to filter by. For example, in a view
showing the average Unit Price for a collection of products, you may want to only show the
Products that have an average unit price that is greater than or equal to $25. You can use the
built-in controls to write a condition or you can write a custom formula.
What is the order of operations of Filters in Tableau? - CORRECT ANSWER - 1. Extract
filters
2. Data source filters
3. Context filters
4. Filters on dimensions (whether on the Filters shelf or in filter cards in the view)
5. Filters on measures (whether on the Filters shelf or in filter cards in the view)
How do you add members to an existing group? - CORRECT ANSWER - -In the Data
pane, right-click the group field, and then click Edit Group.
- In the Edit Group dialog box, select one or more members and drag them into the group you
want.
Click OK.
What does the table calculation 'Table (across)' do ? - CORRECT ANSWER - Computes
across the length of the table and restarts after every partition
