Salesforce Analytics-101 Exam Questions

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 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.

A relationship is particularly appropriate when the tables being combined contain data at different levels of detail, making D correct. Tableau relationships operate in the logical layer of the data model and preserve each logical table's native granularity. Tableau determines the necessary joins dynamically during analysis according to the fields used in the visualization. This behavior is materially different from a physical join. A join merges records into a single physical table before analysis. If tables have different granularities, a physical join can duplicate measure values or remove records depending on the join structure and matching keys. Relationships reduce that risk because Tableau aggregates relevant information according to each table's natural level of detail before combining results as required by the visualization. Official Tableau guidance explicitly recommends relationships for combining data from different levels of detail. Relationships also preserve independent logical tables rather than flattening them into a single physical table. Option B merely describes where tables reside and does not determine whether a relationship or join is preferable. Options A and C likewise do not identify the principal modeling scenario addressed by relationships. Relevant Tableau Desktop concepts include logical tables, physical tables, relationships, joins, aggregation behavior, and preservation of level of detail.

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.

A default aggregation can be specified for a measure, making A correct. Measures represent quantitative values and are normally aggregated when they are added to a visualization. For example, a Sales measure typically appears as SUM(Sales). Tableau allows the author to change the measure's default aggregation so that subsequent uses of the field can initially use AVG, MIN, MAX, COUNT, standard deviation, or another supported aggregation instead of SUM. The configuration is available from the Data pane by right-clicking the measure and selecting Default Properties > Aggregation. The choice becomes the default behavior when the field is subsequently added to a view, although the aggregation can still be overridden for an individual instance of the field. Dimensions do not use a default measure aggregation in this manner because their primary role is to partition and categorize the data. Bins are generated categorical fields representing numerical intervals. An already aggregated calculated expression also has restrictions because Tableau cannot arbitrarily aggregate an expression that is already defined at an aggregate level. Tableau's official Default Settings documentation specifically states that users can specify a default aggregation for any measure and documents the Data pane workflow for configuring it.