Free Practice Questions for the Salesforce Foundations Analytics-101 Exam (2026 Updated)

The associate should save the workbook as a Tableau Packaged Workbook (.twbx). A packaged workbook can contain the workbook itself together with copies of supported local data sources, Tableau extracts, background images, and other workbook resources. This directly addresses the scenario because the recipient does not have access to the original underlying data. When appropriate data is packaged with the workbook, the recipient can open the workbook in Tableau Desktop and interact with or modify its existing worksheets and visualizations without requiring the author's original file paths. A .twb file contains the workbook definition but normally references external data rather than packaging the required local resources. Therefore, it would not reliably solve the access problem. Creating a .hyper file alone provides an extract but does not contain the complete Tableau workbook, including worksheets, dashboards, calculations, formatting, parameters, and visualization definitions. Exporting views produces presentation-oriented outputs and does not satisfy the requirement to modify the existing Tableau visualizations. Tableau specifically recommends packaged workbooks when sharing with someone who does not have access to referenced resources or the original environment.

The associate should select More under To a Server, making D correct. Tableau Desktop organizes available connectors on the Connect pane into broad categories such as To a File and To a Server. Frequently used server connectors may be displayed directly, but Tableau provides the More option to expose the complete list of supported server-based connection types available in the installation. Official Tableau connector documentation repeatedly states: For a complete list of data connections, select More under To a Server. This workflow is used when locating database and server connectors such as Microsoft SQL Server, PostgreSQL, SharePoint Lists, and other supported platforms. Selecting More under To a File instead displays file-based connection types and therefore does not satisfy a requirement specifically involving server connections. Choosing File > New creates a new workbook and does not expose the complete server connector list. "Connecting to Data" is not the command required to reveal all server options. This distinction is operationally important because the Connect pane intentionally surfaces common connector choices while More exposes the broader connector catalog. Current Tableau documentation for multiple server connectors confirms the More under To a Server workflow for viewing the complete connection list.

Tableau supports creating groups either directly from selected marks in a visualization or from a field in the Data pane. Therefore, A and D are correct. For the first method, the analyst selects one or more marks in the view. Tableau exposes a grouping control in the selection tooltip or toolbar. Activating the Group command combines the dimension members represented by those marks into a new group. This method is particularly effective when the analyst identifies categories visually during exploration. For the second method, the analyst can right-click a dimension in the Data pane and select Create > Group. Tableau opens the Create Group dialog, where multiple members can be selected and grouped explicitly. Option C represents another Tableau capability, but not grouping: dragging one dimension directly onto another in the Data pane is used to create a hierarchy. Hierarchies organize related dimensions into drillable levels rather than consolidating dimension members into a group. Opening the general drop-down menu at the top of the Data pane is likewise not the specified procedure for creating a visual group. Tableau's official Group Your Data documentation identifies exactly these two core workflows: create a group by selecting data in the view or create a group from a field in the Data pane.

The associate can access the palette controls from the Color legend, making A correct. When a discrete dimension is placed on Color, Tableau generates a categorical color legend that identifies each dimension member and its assigned color. From the Color legend, the analyst can access Edit Colors, where a different palette can be selected and individual members can be assigned specific colors. This provides an alternative to opening the color configuration from the Marks card. The Format menu controls broader formatting characteristics such as fonts, borders, alignment, shading, and other presentation settings. Although newer Tableau versions include workbook-level palette functionality, the question concerns changing the palette associated with the dimension already encoded in the visualization, for which the Color legend is the direct alternative to the Marks card. Edit Caption modifies descriptive text associated with an object or field rather than its visual encoding. Edit in Shelf is also unrelated to palette management. Official Tableau documentation states that users can open the menu in the upper-right corner of a categorical color legend and select Edit Colors, after which they can choose or modify the palette assigned to the field's members.

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.

Tableau visualization animations can use either a Simultaneous or Sequential animation style, and their analytical purpose is to make changes in the data easier to perceive. Therefore, A and D are correct. Under Format > Animations, Tableau provides two animation styles. With Simultaneous, all applicable transitions occur at the same time. With Sequential, Tableau stages the transition—for example, fading marks, moving or sorting them, and then displaying the updated state. This directly confirms option A. Animations are particularly useful when filters, sorts, parameters, or other changes alter the position or composition of marks. Instead of immediately replacing one static state with another, the transition helps a viewer understand how the marks changed, making patterns, movements, and differences easier to track. This supports D. The Pages shelf is a separate Tableau feature for stepping through members of a field and can create a sequence of views, but it does not define visualization animations themselves. Likewise, animation is a workbook/sheet formatting capability rather than a feature specifically defined by map visualization usage. Tableau's official Animations documentation identifies Simultaneous and Sequential as the available animation styles and describes animations as a mechanism for visually communicating changes in the view.

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.

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.