Salesforce Certified Tableau Desktop Foundations Analytics-101 Exam Questions

Answer : B

The correct answer is Treemaps. A treemap represents data as a set of rectangles. Tableau uses one or more dimensions to define the rectangular structure, while a measure placed on Size determines each rectangle's relative area. Tableau automatically lays out the rectangles to use the available visualization space efficiently. The analyst therefore controls relative size through the measure encoded on Size rather than manually resizing the generated rectangles with the ordinary Marks card size slider. For example, if Sub-Category defines the rectangles and Sales is placed on Size, categories with larger aggregated Sales values receive proportionally larger rectangles. Changing the Sales values or replacing the field on Size changes the relative areas, while Tableau recalculates the layout automatically. Pie charts have mark-size controls and can be resized through the Marks card. Area charts derive their visual area from their axes and underlying measures. Histograms use bars representing bins and frequencies and have different bar-sizing behavior. Tableau's official Treemap documentation identifies Size and Color as the crucial encodings and explains that a measure on Size determines the areas of the rectangles. The resulting treemap geometry is automatically laid out according to those values rather than manually sized mark by mark.

Answer : A, B

Relationships are designed to preserve each table's level of detail and keep logical tables separate within the data source, making A and B correct. Unlike physical joins, relationships do not flatten participating tables into one combined row-level table when the data source is created. Tableau keeps each logical table distinct and evaluates the relationship dynamically based on fields actually used in a visualization. This architecture helps Tableau analyze data residing at different granularities while reducing the duplication and data-loss risks that can occur with fixed physical joins. Tableau's official relationship documentation explicitly states that relationships maintain each table's native level of detail and create independent domains at multiple granularities. The tables are not merged together in the data source. Option C describes the behavior of joins or unions in the physical layer. Physical tables can be combined to form one logical table, but this is not what a relationship does. Option D is also incorrect because relationships do not require the author to choose a fixed join type such as inner, left, right, or full outer. Tableau determines appropriate joins contextually during analysis. Relevant Tableau Desktop concepts include logical tables, physical tables, relationships, contextual joins, cardinality, and preservation of granularity.

Answer : C

Standard deviation is available as a native aggregation for a measure and does not require the author to create either a table calculation or a calculated field. Therefore, C is correct. When a measure is used in a Tableau view, its aggregation can be changed through the field menu. In addition to commonly used functions such as SUM, AVG, MIN, MAX, and COUNT, Tableau provides Standard Deviation and Standard Deviation (Population) as built-in aggregation choices. The calculation is performed directly over the records contributing to the current mark. Running Total and Percent of Total are different because they are table calculations. They operate on already aggregated values after Tableau has constructed the visualization and depend on the addressing and partitioning of the view. Sample covariance is supported through calculation functionality such as covariance functions but is not presented as the equivalent direct aggregation option in the basic measure aggregation menu represented by this question. Implementing covariance typically involves specifying the two expressions whose covariance is required. Tableau's official Data Aggregation documentation explicitly lists standard deviation among the aggregations available for measures, including sample and population forms. Consequently, it can be selected directly without constructing an additional calculated field or applying a quick table calculation.

Answer : A, C

Dimension filters support Multiple Values (drop-down) and Wildcard Match, making A and C correct. Dimensions typically contain categorical values. When a dimension filter is displayed as an interactive filter card, Tableau provides several categorical selection modes. Multiple Values (drop-down) presents dimension members in a compact drop-down control where the viewer can select multiple categories simultaneously. This is useful when a field contains several discrete members but screen space needs to be conserved. Wildcard Match provides a text input field that dynamically selects dimension members whose text matches a supplied character pattern. Tableau supports the asterisk as a wildcard. For example, entering tab* can match values beginning with 'tab.' This mode is appropriate for searchable text-based categorical dimensions. By contrast, Range of Values is associated primarily with continuous quantitative filters, where users specify minimum and maximum values. At most is likewise an open-ended quantitative/date filtering mode used to establish an upper boundary rather than a categorical dimension-selection mode. Tableau's official filtering documentation explicitly lists Multiple Values (Dropdown) and Wildcard Match among the available filter card modes for dimensions. It separately describes quantitative range and open-ended filtering behavior for measures and continuous fields.

Answer : C

The correct configuration is Logical tables that use a single table extract, making C correct. In Tableau's data model, a union operates in the physical layer. The two unioned physical tables are merged into one resulting logical table. Tableau explicitly describes logical tables as containers that can contain multiple physical tables joined or unioned together. When an extract is stored using Logical Tables, Tableau creates one extract table for each logical table in the data source. Because the scenario contains one logical table composed of the two unioned physical tables, the extract is consequently represented as a single extract table. This is different from using Physical Tables storage. Physical storage retains an extract table for each physical table and is subject to additional eligibility restrictions. Tableau's current terminology replaced the older 'Single Table' and 'Multiple Tables' extract terminology with Logical Tables and Physical Tables, respectively. Official Tableau documentation states that physical tables joined or unioned inside a logical table are merged as part of that logical table, and that Logical Tables extract storage creates one extract table per logical table. Therefore, a two-table union forming one logical table corresponds to a logical/single-table extract structure.

Answer : B, C

Tableau allows a field to be renamed directly in the Data pane by making the field name editable or by selecting Rename from the field's contextual menu. Therefore, B and C are correct. For the first method, Tableau documentation specifies that the user can click a field name in the Data pane and hold the mouse button until the field name appears in an editable text box. The new name can then be entered and confirmed. Tableau also provides keyboard alternatives such as F2 or Ctrl+Enter. The second standard workflow is to open the field's contextual or drop-down menu and choose Rename. This changes the field name used within Tableau without changing the column name in the underlying data source. Replace References serves a different function. It substitutes one field for another throughout the workbook and is commonly used when replacing broken or obsolete field references; it is not simply a renaming command. Field Labels under formatting controls how field labels appear in a view rather than changing the Data pane field name. Tableau explicitly documents Data pane renaming and confirms that renamed fields retain the new Tableau-facing name within the workbook.

Answer : D

To convert the existing bar chart into a stacked bar chart, the associate should drag another dimension to Color on the Marks card. The initial bar chart already contains a dimension on Columns and a measure on Rows. Adding another categorical dimension to Color partitions each bar according to the members of that second dimension. Tableau assigns a separate color to each resulting group and, because automatic stacking is enabled for bar marks by default, those groups are displayed cumulatively within each bar. For example, if Category is on Columns and SUM(Sales) is on Rows, adding Segment to Color divides each Category bar into Consumer, Corporate, and Home Office segments while preserving the bar's total Sales magnitude. Dragging another dimension to Size changes the visual size encoding rather than creating standard stacked segments. Adding another measure to Rows typically introduces an additional axis or measure structure. A measure placed on Color generally creates a quantitative gradient rather than categorical stacked segments. Tableau's official Stack Marks documentation describes this exact construction: a dimension on Columns, a measure on Rows, and another dimension used to color-encode the marks.