Pass the Salesforce Foundations Analytics-101 Questions and answers with Dumpstech

A basic bar chart can be created from a measure without requiring a dimension, making A correct. Tableau can construct an initial visualization automatically when a field is double-clicked in the Data pane. Official Tableau documentation demonstrates that double-clicking a quantitative measure such as Profit automatically adds it to the view and creates a bar chart. At this stage, no dimension is required; Tableau displays the aggregated value of the measure as a single bar. The remaining visualization types fundamentally depend on categorical partitioning. A highlight table uses dimensions to establish the table's row and column structure and measures to encode values through color or text. A treemap normally requires one or more dimensions to define individual rectangles, with measures controlling properties such as size and color. A stacked bar requires a categorical field to partition a bar into multiple stacked segments. A dimension can certainly be added later to a basic bar chart—for example, Category on Columns and Sales on Rows—to produce multiple bars. However, the question asks which visualization can be created without a dimension. Tableau's official field-dragging documentation specifically demonstrates that double-clicking a measure alone produces an automatic bar chart.

The associate should place Region on Color on the Marks card. A discrete dimension placed on Color partitions the marks according to the dimension's members. Consequently, the visualization produces a separate line for each Region while preserving the existing date field on Columns and Sales measure on Rows. For example, if Region contains Central, East, South, and West, Tableau separates the original Sales line into four distinct series and assigns a categorical color to each region. The lines remain plotted against the same continuous date and Sales axes, which satisfies the requirement for multiple distinct lines on the same axis. Placing Region on Rows or Columns would partition the visualization into separate panes or headers rather than overlaying distinct regional lines within the same plotting area. Path controls the order in which Tableau connects marks in a line or polygon and therefore does not provide the required categorical separation. Tableau's Marks card is specifically designed to encode fields by visual properties such as Color, Size, Label, Detail, Tooltip, and Path. Official Tableau documentation confirms that placing a discrete field—typically a dimension—on Color assigns a distinct categorical color to each value.

The supported choices are Country, Airport, and City, making A, B, and D correct. A geographic role tells Tableau how the values in a field should be interpreted geographically. Once Tableau recognizes the role, it can associate those values with built-in geocoding information and generate geographic fields such as Latitude (generated) and Longitude (generated) for map creation. Tableau's supported location data includes countries and regions, cities, states and provinces, postal codes, airport codes, and several other standardized geographic structures. Country and City are therefore standard geographic roles. Tableau also supports worldwide airport codes, enabling fields containing appropriate airport identifiers to be interpreted geographically. A general street Address is not one of the standard built-in geographic roles represented by the answer set. Exact street-address mapping normally requires appropriate coordinate information, spatial data, custom geocoding, or another supported technique. Time zone likewise is not a standard geographic role used by Tableau's built-in geocoding model. The distinction matters because assigning an unsupported semantic category does not automatically give Tableau coordinates. Official Tableau Desktop mapping guidance specifically identifies countries, cities, airport codes, and other supported geographic location categories for map creation.

STARTSWITH is the function that returns a Boolean result, so D is correct. The function evaluates whether one string begins with a specified substring. Its conceptual syntax is STARTSWITH(string, substring). If the original string begins with that substring, Tableau evaluates the expression as TRUE; otherwise, it evaluates as FALSE. For example, STARTSWITH([Customer Name], "A") returns TRUE for values beginning with A and FALSE for other values. Because the output is Boolean, STARTSWITH is particularly useful in calculated fields, conditional expressions, filters, classifications, and data-quality logic. The other listed functions return different data types. CHAR converts a numeric character code to its corresponding character and therefore returns a string. FIND searches for the position of a substring and returns a numeric position. UPPER converts the supplied text to uppercase and returns another string. Consequently, only STARTSWITH directly produces the TRUE/FALSE result required by the question. This distinction is fundamental when selecting functions for Boolean calculations because Tableau evaluates Boolean fields differently from numeric and string-returning expressions.

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.

Dimensions are fields Tableau uses primarily to categorize, segment, and describe data. They typically contain qualitative information such as names, geographic locations, categories, dates, and identifiers. Therefore, C is correct. Tableau also states that dimensions affect the level of detail in a visualization. Adding another dimension can partition existing marks into more granular groups because Tableau incorporates the field's members into the view's dimensional structure. Therefore, B is correct. The dimension/measure classification is independent from the discrete/continuous classification. Although dimensions are commonly discrete, a dimension can also be continuous. Date fields are a standard example: a date may be represented as a discrete date part or a continuous date value. Therefore, E is correct. Option D instead describes measures, which generally contain quantitative numeric values and are aggregated. Option A is not an inherent defining characteristic of dimensions; formatting behavior depends on how a field is used and whether it is discrete or continuous. Official Tableau guidance identifies dimensions as qualitative fields that group or segment data and explicitly states that dimensions affect the level of detail in the view.

To create a join in a data source that already uses relationships, the associate must double-click a logical table in the canvas, making C correct. Tableau's data model has two layers. The top-level logical layer contains logical tables connected by relationships. A join cannot be created directly between these logical tables because joins operate in the underlying physical layer. Double-clicking a logical table opens its physical Join/Union canvas. From there, the associate can drag or double-click additional physical tables and define the required join clauses and join type. This distinction is fundamental to Tableau's modern data model. Relationships connect logical tables while keeping them separate and preserving their natural level of detail. Joins merge physical tables into one logical table using an explicitly defined join configuration. Selecting Add in the Connections pane adds another connection; it does not itself create the join. Dragging a table directly onto the top-level logical canvas generally creates a relationship rather than a physical join. Double-clicking a table in the Tables pane is not the step used to enter the physical layer of an existing logical table. Tableau's official documentation explicitly instructs users to double-click a logical table to open the physical layer where joins and unions can be created.

Because the first measure is on the Rows shelf, Tableau creates a vertical quantitative axis in the visualization. To construct a combined axis, the associate should drag the second measure directly onto that existing vertical axis, making B correct. A combined axis allows multiple measures to share the same axis instead of displaying them in separate panes or on independent dual axes. When the second measure is dragged onto the existing axis and Tableau displays the appropriate drop indicator, Tableau creates a shared Measure Values-based view containing both measures. The orientation matters. Fields on Rows normally produce a vertical y-axis, whereas fields on Columns normally generate a horizontal x-axis. Consequently, because the first measure was specifically placed on Rows, the target is the vertical axis rather than the horizontal axis. Dropping the second measure on the Marks card would encode that field through a mark property rather than create a combined quantitative axis. Dropping it on Filters would restrict records or values and would not combine the measures. This mechanism should also be distinguished from a dual-axis chart, where two independent axes are layered. A combined axis instead places multiple measures on a shared axis and commonly uses Measure Names and Measure Values for differentiation.

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.

A continuous date field produces a green pill and generates an axis, making B and C correct. Tableau uses color as an immediate visual cue for discrete versus continuous fields. Green pills represent continuous fields, whereas blue pills represent discrete fields. A date can function in either form. When the analyst chooses a continuous date value such as continuous Month or continuous Year, Tableau represents the field as an unbroken temporal range rather than a finite collection of date-part headers. When this continuous date is placed on the Rows shelf, Tableau generates a continuous axis corresponding to the selected temporal granularity. The axis behaves similarly to other continuous quantitative axes in the sense that values occupy positions along an uninterrupted scale. Option A instead characterizes a discrete date part, such as discrete Month, where Tableau creates categorical headers or labels like January, February, and March. Option D is likewise associated with discrete fields because discrete pills are blue. Tableau's official Continuous Dates documentation states that continuous dates create an axis and that converting a date field to continuous causes the field to turn green. Tableau's general field-role documentation separately confirms that continuous fields create axes while discrete fields create headers.