Tableau Core Tableau Concepts Questions and Answers 1 — Questions and Answers
Question 1: Which of the following statements most accurately describes the primary distinction between a dimension and a measure in Tableau?
- Dimensions are always text or dates, while measures are always numbers.
- Dimensions are qualitative and used to segment data, while measures are quantitative and are typically aggregated. (Correct answer)
- Dimensions generate headers in the view, while measures generate axes, with no exceptions.
- Dimensions must be placed on the Rows shelf, and measures must be placed on the Columns shelf.
Correct answer: Dimensions are qualitative and used to segment data, while measures are quantitative and are typically aggregated.
The core difference is functional. Dimensions are categorical fields (like names, dates, or regions) used to set the level of detail or 'slice' the data. Measures are numerical fields (like sales or profit) that you can perform mathematical operations on, and Tableau aggregates them by default (e.g., SUM, AVG).
Question 2: A colleague has asked you to share a Tableau workbook that includes all necessary data, custom images, and calculations so they can open and view the dashboard without needing access to the original data source. Which file type should you send them?
- Tableau Workbook (.twb)
- Tableau Data Source (.tds)
- Tableau Packaged Workbook (.twbx) (Correct answer)
- Tableau Data Extract (.hyper)
Correct answer: Tableau Packaged Workbook (.twbx)
A Tableau Packaged Workbook (.twbx) is a zip archive that contains the workbook (.twb) along with any local data sources (like extracts or Excel files) and background images. This makes it a self-contained file ideal for sharing with users who do not have access to the original live data connection.
Question 3: In the Tableau interface, a field on a shelf is colored green. What does this color signify about the field?
- The field is a dimension.
- The field is being treated as a continuous value, which generates an axis in the view. (Correct answer)
- The field is a calculated field.
- The field has been added to the context.
Correct answer: The field is being treated as a continuous value, which generates an axis in the view.
Green pills in Tableau signify that a field is being treated as continuous. Continuous fields are treated as an infinite range of values and draw an axis in the view. Blue pills signify discrete fields, which are treated as finite, individual values and draw headers. While measures are often continuous (green) and dimensions are often discrete (blue), this is not a strict rule.
Question 4: Which of the following visual encodings is controlled directly from the Marks card in a Tableau worksheet?
- Adding a reference line to an axis.
- Changing the size of the entire dashboard.
- Encoding the color, size, and shape of data points. (Correct answer)
- Creating a calculated field.
Correct answer: Encoding the color, size, and shape of data points.
The Marks card is a fundamental component of the Tableau worksheet used to control the visual properties of the data points (marks). It contains shelves for Color, Size, Label, Detail, Tooltip, and Shape, which allow you to encode your data visually.
Question 5: You are building a dashboard for specific departments. You want to ensure that each user, upon opening the workbook, sees only the data for their department and cannot view data from other departments. This filter must be applied before any worksheet-level filters. Which type of filter is most appropriate for this requirement?
- A Dimension Filter on [Department].
- A Data Source Filter. (Correct answer)
- A Context Filter.
- A Measure Filter.
Correct answer: A Data Source Filter.
A Data Source Filter is the best choice for this scenario because it restricts the data at the highest level, right after it enters Tableau but before it is used in any worksheet. This ensures the excluded data is not available anywhere in the workbook, making it ideal for row-level security. It is applied before Context, Dimension, or Measure filters.
Question 6: When a quantitative field (a measure) is first dragged into the view, what is the default aggregation Tableau applies to it?
- AVG() (Average)
- MEDIAN() (Median)
- SUM() (Summation) (Correct answer)
- ATTR() (Attribute)
Correct answer: SUM() (Summation)
By default, Tableau automatically aggregates measures using Summation (SUM) when they are brought into the view. This is because summing up values is one of the most common analytical operations. The user can then change this aggregation to Average, Median, Count, or others as needed.
Tableau Core Tableau Concepts Questions and Answers 1
Which of the following statements most accurately describes the primary distinction between a dimension and a measure in Tableau?