Tableau Exam Prep Unit 2

Dynamic sets are preferable to fixed sets when you want to:

Analyze data that changes frequently.

Which of the following is true for a computed sort?

- Computed sort organizes the data by applying rules. - Computed sort is dynamic.

Which of the following features can be generated when clicking on two or more marks in the view, and then selecting a button in the tooltip? Select all that apply.

- Create a Set which becomes available in the Data Pane - Create a Group which automatically colors the marks by the new group - Create a filter which keeps only the selected marks

Select the option below that describes what happens the first time a group is created from marks in the view.

- The mark colors are updated in the view. - A group called Other is created. - A group field is created in the Data pane. - A group is created that combines all selected marks.

To display a set control for a set, it must be:

- dynamic set - Used in the view

What is a set in Tableau?

A custom field that defines a subset of the data based on specific conditions.

Which of the following statements about Dimensions and Measures is true?

A field used as a Dimension can be formatted as a Discrete or Continuous

If you change the default calendar for a data source to ISO-8601 Week-Based, what will it apply to?

All worksheets using the data source.

Select the best answer for the following question. On Columns or Rows, when expanding a date field that is a discrete date part, how many levels of detail for the field can you include in the view?

As many levels of detail as there are for the date field in the data source

How can you display the top 5 and bottom 5 sales in the same view?

Create a view using a combined set to include all member from the top 5 and bottom 5 sets.

Groups can be created directly from the view and the BLANK?

Data pane

You want to view the daily profits over a continuous range of time. What option on the date field menu will show you this?

Day (May 8, 2015)

A set can be used as a:

Dimension

What types of custom date fields do you need to create custom date hierarchies?

Discrete date parts

You have created a hierarchy in the Data pane, but some of the fields are in the wrong order. What can you do to reorder the fields?

Drag the fields into the proper order in the Data pane.

Which of the following statements is true for nested sorting in Tableau?

Nested sorting considers each pane independently and sorts the rows per pane.

Select the best answer for the following question. On Columns or Rows, when expanding the date field that is a continuous date value, how many levels of detail for the field can you include in the view?

One, a date value

The QA team in your company has shared a view that shows all the bugs logged against the new features for your next product launch. The bug review by your team only triages bugs logged in the last 30 days. Which date filter is the most ideal to quickly see this data?

Relative Data

You have manually sorted several dimension fields within a visualization and would like to clear the sort. What is one way to clear it?

Right-click the drop-down menu for a field, and select Clear Sort.

What is the best indication that Custom Months is a custom date field?

The equal sign before the Date icon

How do you expand and contract the display of related fields in a hierarchy?

Use the [+] and [-] to drill down and up