Free Salesforce Certified Tableau Data Analyst Sample Questions

Correct answer: A — Right-click the field in the Data pane, select Rename, and type 'Last Name'.

• A. Correct. Right-clicking the field in the Data pane and selecting Rename is the most direct and efficient method to change a field's display name. This updates how the field appears throughout the Tableau workbook while leaving the underlying database column name unchanged.
• B. Incorrect. Aliases are used to provide user-friendly names for individual data values (members) within a field, such as changing 'Y' to 'Yes'. They cannot be used to rename the field itself.
• C. Incorrect. There is no 'Title' setting within the Default Properties menu for a field. Default Properties include settings like Number Format, Aggregation, Color, and Sort. You must rename the field to change its label in the Data pane.
• D. Incorrect. Creating a calculated field would technically result in a field named 'Last Name', but it is an unnecessary step that creates duplicate metadata and adds complexity. Simply renaming the existing field is the preferred best practice.

Correct answer: A — Folder

• A. Correct. In the Tableau Data pane, the 'Group by' setting allows you to toggle how fields are organized. By default, fields are grouped by 'Data Source Table'. Changing this setting to 'Folder' enables the ability to create custom organizational containers. This is the standard method for managing large datasets (100+ fields), as it allows you to manually group related fields—such as all geographic items—into a single folder for easy access.
• B. Incorrect. While hierarchies are used to create drill-down relationships between related fields (e.g., Country > State > City) and do group those specific fields together, 'Hierarchy' is not a selection available in the 'Group by' menu of the Data pane.
• C. Incorrect. Although geographic fields share a common metadata role and data type icons exist in the Data pane, Tableau does not provide an option to 'Group by Data Type'. The grouping toggle is limited to 'Folder' and 'Data Source Table'.

Correct answers: A, B — Drag the first file to the canvas, then drag the remaining files directly underneath it to create a manual union.; Use a wildcard union to automatically combine all files in the folder matching a specific naming pattern.

• A. Dragging the first file to the canvas and then dragging subsequent files directly underneath it in the Data Source page creates a manual union. This vertically stacks the data, which is the correct way to combine files with the exact same schema into a single table.
• B. Wildcard unions allow Tableau to automatically detect and combine all files in a folder that match a specific naming convention (e.g., *.csv). This is an efficient way to union multiple files with identical structures without manual intervention for each file.
• C. Relationships link tables logically based on common fields but keep the data in separate tables. This is used for joining data rather than unioning identical files, and would result in an unnecessarily complex logical model for 12 identical monthly files.
• D. Data blending is performed at the worksheet level and is used to combine data from different data sources at an aggregate level. It is not used on the Data Source page to union multiple files into a single dataset.
• E. Pivoting is an operation used to transform data from a wide format (multiple columns) to a tall format (multiple rows) within a single dataset. It does not serve the purpose of merging multiple external files together.

Correct answer: B — Add an Aggregate step

• A. A Pivot step is used to reshape data by converting columns into rows (Pivot Columns to Rows) or rows into columns (Pivot Rows to Columns). While it changes the structure of the data, it is not primarily used for grouping multiple records into summarized totals.
• B. The Aggregate step is specifically designed to group data based on dimensions and perform calculations (such as Sum, Average, or Count) on measures. This process consolidates multiple records into a single row based on the defined grain of the aggregation.
• C. A Join step combines two separate data sources horizontally based on a related field or key. While joins can filter or duplicate rows depending on the join type, they are used to add columns from another source rather than summarizing multiple rows into one.
• D. A Union step appends rows from one table to another vertically, stacking the datasets. This increases the total row count of the combined dataset and does not perform any grouping or mathematical summarization.

Correct answer: B — Add a Union step

• A. A Join step is used to combine tables horizontally (side-by-side) based on matching key fields. It produces a wider table by adding columns from multiple sources but does not stack rows vertically.
• B. A Union step is used to combine data vertically by stacking or appending rows from multiple tables or files that share the same or similar schemas. This is the correct method for consolidating records into a single dataset.
• C. An Aggregate step is used to summarize data by grouping values and performing mathematical calculations (such as Sum or Average). This changes the row-level detail (granularity) but does not combine separate datasets via appending.
• D. A Pivot step is used to reshape the data structure by converting columns into rows or vice-versa. While it is a key transformation tool for normalizing data, it is not used for appending or stacking multiple tables together.

Correct answer: B — Tableau Extract (.hyper)

• A. Incorrect. A live connection requires continuous network connectivity to the data source. Queries run in real-time against the source database, making it impossible to work offline. Additionally, live connections can be slower than extracts when dealing with large datasets.
• B. Correct. A Tableau Extract (.hyper) is a local snapshot of your data optimized for performance using Tableau's Hyper in-memory data engine. Because the data is stored locally on your machine, it allows you to continue developing and querying large datasets without an internet connection.
• C. Incorrect. A published data source is hosted on Tableau Server or Tableau Cloud. While these are excellent for data governance and sharing, they require an active internet connection to access the hosted data and metadata.

Correct answer: B — The field names in the new data source do not exactly match the field names in the old data source.

• A. Incorrect. Switching between an extract and a live connection does not inherently produce red exclamation marks. These marks indicate missing or broken field references, not connection type issues. While an extract may improve performance, it will not break field mappings unless the underlying schema was also changed.
• B. Correct. Red exclamation marks in the Data pane indicate that Tableau cannot find specific fields referenced in the workbook's worksheets, calculations, or filters. This commonly happens after replacing a data source if the field names (or metadata) in the new source do not exactly match the field names in the old source. Tableau relies on name-matching to map existing workbook elements to the new data.
• C. Incorrect. Differences in row counts affect data volume and the results of visualizations, but they do not cause field references to break. Red exclamation marks are specifically indicators of schema mismatches or missing fields, not record volume.
• D. Incorrect. Tableau Server being down for maintenance might prevent publishing or refreshing server-hosted extracts, but it does not cause field-level errors in the local Data pane during a data source replacement process.

Correct answer: B — Create a dynamic set using the Top condition.

• A. Groups are static categorizations. They are manual groupings of members and do not automatically recalculate or maintain a Top N list as underlying data changes.
• B. A dynamic set with a Top condition is designed to automatically update based on the criteria specified (e.g., Top 10 by Sales). As new data is added or sales figures change, Tableau recalculates the set members to ensure the dashboard remains current without manual intervention.
• C. Bins are used to divide continuous numeric values into discrete ranges (buckets), typically for creating histograms. They are not a mechanism for ranking or selecting top categorical members.
• D. Fixed sets created by selecting marks in a view are static snapshots. They only contain the specific members selected at the time of creation and do not dynamically update when new data arrives or sales values change.

Correct answer: A — Right-click the Profit field in the hierarchy and select 'Remove from Hierarchy'.

• A. Correct. Right-clicking the specific field (Profit) within the hierarchy and selecting 'Remove from Hierarchy' is the standard Tableau method to remove a single item while preserving the rest of the hierarchy's structure.
• B. Incorrect. Dragging a field to the Filters shelf adds a filter to the current worksheet but does not change the metadata structure or remove the field from a hierarchy in the Data pane.
• C. Incorrect. There is no standard 'Revert to Default' command for hierarchies that selectively removes accidentally added members; you must either remove the specific field or recreate the hierarchy.
• D. Incorrect. Converting 'Profit' from a measure to a dimension changes its data role in the Data pane, but it remains a member of the hierarchy. It does not address the issue of the field being in the hierarchy.

Correct answer: A — Set Mark type to Map and place Profit Margin on Color

• A. Correct. In Tableau, selecting the 'Map' mark type (specifically a Filled Map) uses built-in geographic roles to define the boundaries of countries. Placing a measure on the Color shelf will fill the entire geographic area (a choropleth map) based on the data value.
• B. Incorrect. Setting the Mark type to Circle and placing a measure on Size creates a proportional symbol map. This places a marker at the country's centroid rather than shading the entire geographic area.
• C. Incorrect. Density marks are used to create heatmaps that show the concentration of data points across a surface. They do not fill predefined geographic boundaries like countries based on a specific measure.
• D. Incorrect. While maps are technically polygons, the 'Polygon' mark type in Tableau is specifically used for custom shapes where you provide your own path coordinates. For standard geographic roles, the 'Map' mark type is the correct configuration. Additionally, placing a measure on Detail would not color the shape.

Correct answers: A, B, C — Toggling the visibility of the school layer on and off; Using different mark types (Map, Circle, Polygon) for each layer; Applying a different color palette to each layer

• A. Correct. Tableau allows users to control the visibility of individual map layers. Each layer on the Marks card has a visibility toggle (eye icon), enabling users to show or hide specific data layers dynamically without affecting others in the view.
• B. Correct. Tableau’s map layering feature allows each layer to have its own independent Marks card. This means you can assign unique mark types (such as Filled Map for neighborhoods, Circle for schools, and Polygon for parks) to different layers within the same visualization.
• C. Correct. Since each layer is managed by its own Marks card, you can apply independent color encodings and distinct color palettes to each layer. This enables clear visual differentiation between various data types like residential zones and public parks.
• D. Incorrect. Map layers are integrated components of a specific worksheet and cannot be exported individually as standalone Tableau workbooks. To reuse a layer, you would typically copy the worksheet or the underlying data source.
• E. Incorrect. Tooltips are configured independently for each layer's Marks card. Tableau provides the flexibility to customize tooltips to show specific information relevant to each individual layer rather than forcing a universal configuration.

Correct answer: A — Create a string parameter with 'Sales' and 'Profit', then create a calculated field using a CASE statement to return the respective measure, and place it on the Rows shelf.

• A. Correct. Creating a string parameter with 'Sales' and 'Profit' and then a calculated field (using a CASE or IF statement) to return the respective measure is the standard Tableau pattern for dynamic measure swapping. Placing that calculated field on the Rows (or Columns) shelf allows the parameter control to determine which measure is visualized, providing a clean and efficient toggle.
• B. Incorrect. Dragging both measures to the Rows shelf would display both measures simultaneously. Furthermore, there is no 'Show Parameter' option when right-clicking measures on a shelf that would automatically create a toggle between them.
• C. Incorrect. Sets are typically used to group or isolate members of a dimension, not to select between separate measure fields like Sales and Profit. You cannot create a standard set containing different measures to toggle them in this manner.
• D. Incorrect. While using 'Measure Names' on the Filters shelf as a single-value dropdown is a valid way to filter measures, it does not fulfill the specific requirement to use a parameter. Parameters offer higher flexibility, such as being usable within other calculated fields or across multiple data sources.

Correct answer: A — Create a date parameter, then create a calculated field `[Order Date] <= [Parameter] AND [Order Date] >= DATEADD('day', -7, [Parameter])` and filter for True.

• A. Correct. Creating a date parameter provides the user with a calendar interface to select a specific date. A boolean calculated field that checks if the Order Date falls between the selected parameter date and 7 days prior (using the DATEADD function) effectively filters the view to the desired rolling window.
• B. Incorrect. Standard relative date filters in Tableau are anchored to the current system date (today) or the maximum date in the dataset. They do not allow an end-user to dynamically change the anchor date via a parameter or dropdown once published.
• C. Incorrect. A parameter action updates a parameter's value based on a user's interaction with a mark in a visualization (like clicking a bar or point). It does not, by itself, filter the data to a specific range; the logic provided in option A would still be required.
• D. Incorrect. Bins create fixed, non-overlapping buckets of data. They cannot produce a dynamic rolling window that adjusts based on an arbitrary date selected by the user.

Correct answer: A — DISTANCE(MAKEPOINT([Store Lat], [Store Lon]), MAKEPOINT([Cust Lat], [Cust Lon]), 'mi')

• A. Correct. This formula correctly uses the DISTANCE function, which requires two spatial point geometries and a unit string. The MAKEPOINT function is used to convert the numeric latitude and longitude values into the necessary point geometries, and 'mi' is the correct Tableau abbreviation for miles.
• B. Incorrect. The MAKELINE function creates a spatial line geometry connecting two points. While it is a valid spatial function, it returns a geometry object rather than the numeric distance value required by the prompt.
• C. Incorrect. This syntax is invalid. The MAKELINE function requires spatial points (created via MAKEPOINT) as arguments, not raw numeric coordinates. Additionally, while LENGTH can measure a line, DISTANCE is the standard and more direct function for points.
• D. Incorrect. The DISTANCE function requires spatial geometries (points) as its first two arguments. It cannot accept four raw numeric coordinate values directly. Furthermore, Tableau's spatial unit for miles is 'mi'.

Correct answer: A — The view contains a table calculation based on the Sales measure.

• A. Correct. According to Tableau's technical constraints, you cannot add a forecast to a view if it contains table calculations, disaggregated measures, grand totals, or percentages. If the Sales measure has a table calculation applied (such as a Running Total or Moving Average), the Forecast tool will be disabled in the Analytics pane.
• B. Incorrect. Forecasting in Tableau actually requires at least one date dimension and one measure. It works perfectly fine—and is often preferred—with continuous dates on a line chart axis. Being continuous would not cause the tool to be grayed out.
• C. Incorrect. There is no specific limit of 500 data points that grays out the Forecast tool. While Tableau requires at least five data points to create a forecast (and enough points to identify seasonality), a high number of points does not disable the feature.
• D. Incorrect. Filtering the data to a specific range, such as the last 5 years, does not prevent forecasting as long as the remaining data meets the minimum requirements for the modeling engine (at least five data points and sufficient seasonal cycles).

Correct answers: A, B, C — DATEPART('month', [Order Date]); DATENAME('month', [Order Date]); MONTH([Order Date])

• A. Correct. DATEPART('month', [Order Date]) returns the month part of the date as an integer (e.g., 1 for January). This isolates the month component from the year, allowing all Januarys from different years to be grouped together.
• B. Correct. DATENAME('month', [Order Date]) returns the month name as a string (e.g., 'January'). Like DATEPART, it isolates the month portion without year information, making it ideal for grouping and readable labels across multiple years.
• C. Correct. MONTH([Order Date]) is a shorthand function in Tableau that specifically returns the numeric month (1-12) from a date. It is equivalent in behavior to DATEPART('month', ...) and effectively groups all January sales regardless of year.
• D. Incorrect. DATETRUNC('month', [Order Date]) truncates the date to the first day of the month, but it returns a full date value that still includes the year (e.g., January 1, 2022, and January 1, 2023). Therefore, it treats different years as distinct groups rather than isolating the month part.
• E. Incorrect. DATEADD('month', 1, [Order Date]) adds a specified interval (one month) to the existing date. It results in a new full date including year and day, rather than isolating or extracting the month component for grouping.
• F. Incorrect. DATEDIFF('month', #2023-01-01#, [Order Date]) calculates the number of months between a reference date and the order date. The result is a relative measurement that changes depending on the year, not a standalone month identifier.

Correct answer: B — Pane

• A. The Table scope computes a single aggregate across the entire view. Dropping an Average Line on Table would result in one average line for the whole table, ignoring the partitioning of individual Regions.
• B. In Tableau, panes are defined by the headers created by the fields on the shelves. With Region and State on the Rows shelf, each Region defines a separate pane. Dropping the Average Line on Pane partitions the calculation by Region, resulting in a separate average line for each Region as desired.
• C. The Cell scope applies the aggregation at the most granular level—the individual cell. In this scenario, it would create an average line for every State row within the view rather than a single summarized line for each Region.

Correct answer: B — Create a calculated field using RUNNING_SUM(SUM([Profit])) / TOTAL(SUM([Profit])).

• A. While the 'Add secondary calculation' feature in the Edit Table Calculation dialog is the UI method used to layer a 'Percent of Total' on top of a 'Running Total', this option is incomplete as it does not specify which secondary calculation type to select. Without selecting 'Percent of Total' as the secondary type, the goal is not achieved.
• B. This is the correct mathematical and functional approach. RUNNING_SUM(SUM([Profit])) computes the cumulative sum of the measure, and dividing it by TOTAL(SUM([Profit]))—which represents the grand total of the partition—yields the running percentage of the total.
• C. Dual Axis is a visualization technique used to compare two different measures or the same measure with different mark types on the same chart; it does not perform cumulative or percentage calculations.
• D. Tableau does not have a standard menu option called 'Secondary Percent' when dragging a pill into the view. Users typically use Quick Table Calculations or the Calculation Editor to achieve this.
• E. WINDOW_SUM aggregates values over a specified window (often the entire partition), whereas RUNNING_SUM is specifically purpose-built to aggregate cumulatively from the first row to the current row. Using WINDOW_SUM alone would not inherently create a cumulative running total.

Correct answer: B — Specific Dimensions (checking all dimensions)

• A. The 'Cell' setting treats each individual mark as its own computation unit. It does not allow the calculation to aggregate or compare values across different dimensions or records, making it the most granular but least comparative scope available.
• B. 'Specific Dimensions' allows for explicit control over addressing and partitioning. By checking all dimensions in the list, you designate every dimension in the view as an addressing field. This effectively removes all partitioning, causing the calculation to compute across the entire table or view.
• C. 'Pane (Down)' is a relative computing option that restricts the calculation to run within the boundaries of a pane (a partition created by the dimensions on the rows or columns). It does not compute across all dimensions globally unless the pane itself encompasses the entire view.

Correct answer: A — AVG({INCLUDE [State] : SUM([Sales])})

• A. Correct. This calculation uses an INCLUDE LOD expression to ensure the State dimension is included in the computation grain. It first calculates the sum of sales for each State, and then the outer AVG aggregation calculates the average of those state-level sums. This is the standard pattern for performing an 'average of sums' aggregation.
• B. Incorrect. This calculation fixes the scope at the Region level and calculates the average of row-level sales records. Summing these averages at the Region level does not satisfy the requirement to calculate an average based on the sum of sales per state.
• C. Incorrect. The EXCLUDE LOD is used to remove a dimension already present in the view from the calculation. It does not introduce the State dimension required to calculate state-level totals.
• D. Incorrect. This calculation calculates the average of individual sales records within each state (AVG) rather than the sum of sales per state. Furthermore, as a FIXED LOD, it would require a secondary aggregation in the view to average these results by Region.

Correct answers: A, E — {FIXED [Customer ID] : MIN(IIF([Order Date] > [First Purchase Date], [Order Date], NULL))}; {FIXED [Customer ID] : MIN(IF [Order Date] > [First Purchase Date] THEN [Order Date] END)}

• A. Correct. This formula uses a FIXED LOD to find the minimum order date where the date is strictly greater than the first purchase date for each customer. Using IIF to return NULL for the first purchase (or any non-matching rows) ensures that the MIN function ignores those values, successfully identifying the second purchase date.
• B. Incorrect. The INCLUDE LOD expression is dependent on the visualization's level of detail, which may lead to inconsistent results depending on which dimensions are in the view. Furthermore, using '!=' instead of '>' is less precise for identifying subsequent dates.
• C. Incorrect. This formula attempts to find the maximum date that is earlier than the first purchase date. Since the first purchase date is defined as the minimum order date for that customer, no such dates exist, and the calculation will return NULL.
• D. Incorrect. The EXCLUDE LOD removes the Customer ID from the calculation context. This would return the minimum order date for the entire dataset (or the remaining dimensions in the view) rather than the specific second purchase for each customer.
• E. Correct. This formula is functionally identical to Option A, using standard IF/THEN syntax instead of IIF. It isolates all order dates occurring after the first purchase date and identifies the earliest one among them, which is the definition of the second purchase.

Correct answer: B — Right-click the Region filter, select 'Apply to Worksheets', and choose 'Selected Worksheets...', then check Sales Map and Profit Trend.

• A. Incorrect. Choosing 'All Using This Data Source' applies the filter to every worksheet using that specific data source. In this scenario, it would affect more worksheets than intended, as it has a global scope across the data source rather than a targeted one.
• B. Correct. Using 'Apply to Worksheets' -> 'Selected Worksheets...' is the standard method in Tableau to precisely control the scope of a filter. This allows you to check only the specific sheets (Sales Map and Profit Trend) that you want the filter to influence.
• C. Incorrect. Layout containers are used for visual organization and placement on a dashboard. Tableau does not support applying data filters to a layout container to control the worksheets inside it.
• D. Incorrect. A context filter changes the order of operations (how filters are evaluated) and can improve performance or affect Top N filters. However, making a filter a 'Context Filter' does not define or restrict which worksheets are affected by that filter.

Correct answer: B — gray

• A. Incorrect. Green is the color used for continuous field pills (such as continuous measures or continuous dates) on the Filters shelf, but it does not indicate that a filter has been added to the context.
• B. Correct. In Tableau, when you 'Add to Context' a filter, the pill on the Filters shelf turns gray. This visual cue indicates that the filter is now a context filter, which is processed before standard dimension filters in the Tableau Order of Operations.
• C. Incorrect. Orange is the color Tableau uses to represent parameters in the Data pane and within the calculation editor; it is not used for filter pills on the shelf.

Correct answer: C — A boolean field that returns a single value

• A. Incorrect. A continuous date field is not strictly required because Dynamic Zone Visibility expects a boolean (True/False) result. While a calculation could be built comparing a date to a specific value, the raw date field type itself cannot drive visibility.
• B. Incorrect. A discrete string field cannot directly control visibility. Tableau requires a boolean expression to evaluate whether a zone should be shown or hidden. A string field would first need to be converted into a boolean calculation (e.g., [Field] = 'Value').
• C. Correct. Dynamic Zone Visibility requires a boolean field (calculated field or parameter) that returns a single, constant value independent of the visualization's dimensions. This binary (True/False) condition determines whether a dashboard object is visible or hidden.
• D. Incorrect. A measure with a table calculation is not the requirement. Table calculations depend on the data structure in a specific view, whereas Dynamic Zone Visibility requires a field that evaluates to a single boolean value for the entire dashboard zone.

Correct answer: A — Click Color on the Marks card, select Border, and choose black.

• A. Correct. In Tableau, you can add a border to most mark types (including circles used in scatter plots) by clicking the Color button on the Marks card. Under the 'Effects' section of the Color menu, there is a 'Border' dropdown where you can select a color (like black) to outline each mark.
• B. Incorrect. The Shape card allows you to change the type of shape (e.g., square, circle, triangle), but it does not provide a specific shape that automatically includes a separate border color. Border colors for filled marks are controlled via the Color card.
• C. Incorrect. Right-clicking the view and selecting 'Format' opens the formatting pane for worksheet-level elements like grid lines, axis lines, and cell borders. It does not control the formatting of the data marks themselves.
• D. Incorrect. The Size card is strictly used to adjust the relative size of marks. There is no 'Add Border' option within the Size menu.

Correct answer: A — Right-click the Profit Ratio field in the Data pane, select Default Properties > Number Format, and choose Percentage.

• A. Setting the Number Format under Default Properties in the Data pane is the most efficient and standard way to change how a field is displayed globally. This automatically updates the value in the tooltip to 15% (multiplying the decimal by 100 and adding the symbol) without requiring manual text edits, which preserves the tooltip's text structure.
• B. Typing a '%' sign in the tooltip editor only appends the character to the existing text. If the underlying value is 0.15, the tooltip would display '0.15%', which is incorrect. It does not perform the mathematical conversion needed for a percentage display.
• C. The Format pane usually targets specific headers, axes, or panes in the view. While you can format specific pills on the Marks card, setting the Default Property is a more robust way to ensure the format updates correctly inside the tooltip string references.
• D. Creating a new calculation is unnecessary and complicates the workbook with redundant fields. Tableau's built-in formatting tools are the preferred, non-destructive approach for changing data display.

Correct answer: D — Drag Category and Sub-Category to Detail, Sales to Size and Color, and change Mark type to Circle.

• A. Incorrect. Dragging dimensions to Columns and a measure to Rows creates a standard bar chart or a nested table layout with axes, not a packed visualization.
• B. Incorrect. Placing Category on Rows and Sub-Category on Columns creates a grid or matrix. While Sales on Size would size marks within that grid, it does not produce a packed bubble layout.
• C. Incorrect. Using the Square mark type with measures on Size and Color is the configuration for a Treemap, not a packed bubble chart.
• D. Correct. To create a packed bubble chart, you must place the dimensions on Detail to define the marks, assign a measure to Size (and optionally Color), and change the mark type to Circle. This allows Tableau to cluster the circles together in a packed layout based on the measure values.

Correct answer: B — Region on Rows, Category on Columns, Profit on Text, Mark type set to Text.

• A. Incorrect. Placing Profit on Color with mark type set to Square will create a heatmap or highlight table view where squares are colored by profit, but it will not display the numeric values unless Profit is also placed on the Label/Text shelf.
• B. Correct. Putting Region on Rows and Category on Columns with Profit on Text and the mark type set to Text is the standard way to create a text table (crosstab) in Tableau. This configuration displays the aggregated profit values as numeric labels at each cell intersection.
• C. Incorrect. Using Profit on Size with the mark type set to Square will vary the physical size of the squares based on the profit magnitude. While this encodes the data visually, it does not display the numeric text labels required for a text table.
• D. Incorrect. Polygon marks are intended for drawing custom shapes and require specific path ordering. Putting Profit on Detail will include the data in the underlying level of detail for the view but will not render the numeric values as text.

Correct answer: B — Download object configured to export the 'Detailed Metrics' dashboard.

• A. A Navigation object is used to create buttons or links that let users move between dashboards, sheets, or external URLs. While it facilitates navigation, it does not provide the functionality to export or download the dashboard content.
• B. Correct. A Download object (often called an Export button) allows users to quickly export the dashboard or specific sheets to various formats, such as PDF, Image, PowerPoint, or CSV/Excel. This is the standard tool for enabling content distribution and exporting.
• C. A Web Page object embeds external web content directly into the dashboard. While it can display a URL, it does not provide native Tableau exporting features for the dashboard being viewed.
• D. An Extension object adds custom functionality through third-party applications or custom-coded web apps. While extensions can be used for advanced features like cross-dashboard filtering or write-back, they are not the standard or simplest method for basic dashboard exporting.

Correct answer: A — Click the 'Revert' button on the story toolbar above the navigator.

• A. Correct. In Tableau, when you modify a filter, sort, or parameter within a story point, a 'Revert' icon (and sometimes text) appears on the story toolbar directly above the navigator area. Clicking this button specifically restores the story point to its last saved/captured state.
• B. Incorrect. While deleting and recreating a story point would technically achieve the result, it is a destructive and inefficient workaround. Tableau provides a dedicated 'Revert' feature specifically to avoid this.
• C. Incorrect. The 'Update' button is used to save the current, modified state to the story point, overwriting the previously captured state. It does not reset changes.
• D. Incorrect. While Undo (Ctrl+Z) can reverse recent session actions, it is not the standard interface feature for resetting a story point to its originally saved snapshot, especially if multiple changes were made or the session state has changed.

Correct answer: C — Explorer (can publish)

• A. The Viewer site role is the most basic level and allows users to view and interact with content. It does not permit publishing or creating new content.
• B. The standard Explorer site role allows users to interact with and edit existing published content through web editing, but it does not include the permission to publish new workbooks to the server.
• C. Explorer (can publish) is the minimum site role that includes the 'Publish' capability. While Creators can also publish, Explorer (can publish) is the lowest-tier license that allows a user to publish new workbooks and data sources to a project.
• D. Unlicensed users cannot log in to the server and have no permissions to interact with or publish content.

Correct answers: B, C — You can check the 'Make it public' or 'Visible to others' option when saving the custom view.; Other users can set your shared custom view as their own default view.

• A. Incorrect. You do not need the Creator site role specifically to make a custom view visible to others. Users with appropriate interaction permissions (such as Explorer or Creator) and the 'Share Custom' permission can create and save public custom views.
• B. Correct. When saving a custom view, selecting the 'Make it public' or 'Visible to others' checkbox is the standard way to share that view so it appears in the Custom Views list for other users with access to the workbook.
• C. Correct. Once a custom view is made public, other users can select it and then set it as their own personal default view for that specific workbook. This only affects their individual experience and does not change the default for other users.
• D. Incorrect. Custom views are separate metadata layers that store specific filter, sorting, and parameter selections. They do not modify the underlying workbook file or affect how other users see the workbook unless they specifically choose to open the custom view.
• E. Incorrect. The owner (creator) of a custom view can delete their own view at any time. While Site Administrators also have the authority to manage and delete views, the capability is not exclusive to them.

Correct answers: A, B, D — Check the 'Background Tasks for Extracts' administrative view for error messages; Verify that the embedded credentials for Snowflake are still valid; Manually trigger a 'Run Now' task to see if it succeeds or fails

• A. The 'Background Tasks for Extracts' administrative view is a primary troubleshooting tool. It provides a history of recent extract refresh jobs, including specific error messages, failure codes, and timestamps which are essential for identifying the root cause of the failure.
• B. Authentication is a common cause for refresh failures. If credentials were not embedded or have expired, rotated, or been revoked in Snowflake, the scheduled refresh will fail. Verifying and re-authenticating the connection is a critical troubleshooting step.
• C. Tableau Bridge is used to facilitate communication between Tableau Cloud and data stored on a private network or on-premises. Since Snowflake is a cloud-based data source, Tableau Cloud can connect to it directly, making Bridge unnecessary in this scenario.
• D. Manually triggering a 'Run Now' task allows you to test the refresh process immediately rather than waiting for the next scheduled interval. This helps determine if the issue is a persistent connectivity/credential problem or a one-time intermittent failure.
• E. Converting to a live connection avoids the use of extracts entirely, but it does not fix the underlying issue with the refresh schedule. Additionally, live connections to Snowflake may impact performance and increase compute costs on the database side.

Correct answers: A, B — Schedule large full extract refreshes during off-peak hours (e.g., overnight); Use incremental refreshes for large datasets that only append new records

• A. Scheduling large full extract refreshes during off-peak hours is a standard best practice. This minimizes the impact on system performance during peak business hours, ensuring that Backgrounder resources are available for critical tasks and that VizQL processes are not competing with intensive refresh jobs while users are viewing dashboards.
• B. Incremental refreshes are highly efficient for large datasets that only append new rows. By only pulling the new data since the last refresh rather than the entire dataset, you significantly reduce the processing time and the load on both the Tableau Backgrounder and the source database.
• C. Setting all extract refreshes to Priority 1 is counterproductive. The priority system is designed to allow the server to manage task order effectively. Giving everything the highest priority creates resource contention and prevents critical data from being prioritized over less urgent tasks.
• D. Triggering all extracts manually at 9:00 AM creates a massive, simultaneous spike in resource usage at the start of the business day. This leads to long queue times, potential system instability, and degraded performance for users logging in to view their data. Automated, staggered schedules are preferred.
• E. Changing connections to Live shifts the processing load from the Tableau Backgrounder to the underlying database and Tableau VizQL servers. This does not necessarily optimize resources; it often results in slower dashboard performance and can overwhelm the database server, making it an unsuitable solution for managing Tableau resource load.

Correct answer: B — Embed passwords

• A. Incorrect. 'Show sheets as tabs' is a presentation setting that determines whether individual sheets in a workbook appear as clickable navigation tabs in the web environment; it does not handle database authentication or credential management.
• B. Correct. 'Embed passwords' is the configuration used when publishing to store database credentials within the published asset. This allows Tableau Server or Tableau Cloud to connect to the underlying database for extracts or live queries without requiring each user to manually provide credentials.
• C. Incorrect. Although Tableau allows you to specify a user context for thumbnail generation when user filters (Row-Level Security) are applied, this setting only controls the static preview image of the workbook. It does not facilitate the persistent database connection or credential storage for the workbook's data.