View Full Tableau TDA-C01 Exam Dumps and Practice Test Dumps

 

Question 81.

An analyst wants to create a view that shows one mark for every customer while still coloring the marks by Region. Where should Customer Name be placed if it does not need to appear as visible text?

1. Label
   2. Detail
   3. Tooltip only
   4. Pages

Correct Answer: 2

Explanation:

Placing Customer Name on Detail increases the level of detail of the visualization without necessarily displaying the customer names as visible labels. Tableau creates separate marks for the distinct customer values while other fields, such as Region, can still be used for Color. This is especially useful in scatter plots and maps where an analyst wants each entity represented individually without cluttering the view with text. Label displays the field directly on the mark, Tooltip only adds information that appears on hover, and Pages creates a sequence of views. Detail is therefore the correct Marks card property for increasing granularity while keeping the field visually unobtrusive.

Question 82.

A worksheet contains SUM(Sales) and SUM(Profit). The analyst wants to display both measures using the same continuous axis instead of two separate axes. Which Tableau feature is most appropriate?

1. Measure Names and Measure Values
   2. Context filters
   3. Sets
   4. Geographic roles

Correct Answer: 1

Explanation:

Measure Names and Measure Values provide a flexible way to display multiple measures in the same visualization. Measure Values contains the actual measure values, while Measure Names identifies which measure each value represents. By placing Measure Values on an axis and Measure Names on Color or another encoding, the analyst can display Sales and Profit within the same structure. This differs from a dual-axis chart, which creates two separate axes overlaid in the same pane. Context filters control Tableau’s filter order, sets define subsets of members, and geographic roles identify location fields. For displaying several measures through a shared axis, Measure Names and Measure Values are commonly used.

Question 83.

Which Tableau feature should an analyst use to create a dynamic title that changes when a parameter value changes?

1. Extract filter
   2. Geographic hierarchy
   3. Insert the parameter into the worksheet or dashboard title
   4. Convert the parameter to a dimension

Correct Answer: 3

Explanation:

Tableau titles can include dynamic fields, parameters, and other values. If a parameter controls which metric or category is being analyzed, inserting that parameter into the title allows the displayed title to update automatically when the user changes the parameter selection. This improves usability because viewers can immediately see the context of the visualization. The analyst does not need to convert the parameter into a dimension. Extract filters control which rows are stored in an extract, while geographic hierarchies support location-based drill-down. Dynamic titles are especially useful in dashboards that use parameters to switch measures, thresholds, scenarios, or display modes.

Question 84.

An analyst wants to display Sales and Profit on two axes in the same pane and use different mark types for each measure. Which Tableau feature should be used?

1. Union
   2. Story
   3. Highlight action
   4. Dual axis

Correct Answer: 4

Explanation:

A dual-axis visualization overlays two measures within the same pane while providing a separate Marks card for each measure. This allows the analyst to display one measure as bars and another as a line, for example. Each axis can have its own scale, and the axes can sometimes be synchronized when the units and analytical intent make synchronization appropriate. Analysts should clearly label dual-axis views because different scales can be misleading. A union combines rows from tables, a story organizes views into a sequence, and a highlight action emphasizes related marks. Dual axis is the feature specifically intended to display two measures together with independent mark configurations.

Question 85.

What is the purpose of the Measure Names field in Tableau?

1. It contains the names of measures available in the data source
   2. It stores all measure values in a single numeric field in the source database
   3. It converts measures to dimensions permanently
   4. It identifies geographic fields automatically

Correct Answer: 1

Explanation:

Measure Names is a generated field that contains the names of measures available in the Tableau data source. It is often used together with Measure Values to build views containing several measures. For example, Measure Names can be placed on Color or Columns to distinguish Sales, Profit, and Quantity, while Measure Values contains their corresponding values. The field is generated by Tableau rather than stored as a physical column in the source system. It does not permanently convert measures into dimensions or determine geographic roles. Understanding Measure Names and Measure Values is important for creating multi-measure text tables, charts, and dashboards.

Question 86.

What does the Measure Values field represent in Tableau?

1. Only calculated fields
   2. The values of multiple selected measures
   3. Only measures currently used as filters
   4. The number of measures in the workbook

Correct Answer: 2

Explanation:

Measure Values is a Tableau-generated field that can contain the values of multiple measures at once. When an analyst builds a visualization involving several measures, such as Sales, Profit, and Quantity, those measures can appear inside the Measure Values shelf. Measure Names can then be used to identify or differentiate them. This combination makes it possible to create multi-measure tables and charts without constructing separate worksheets for every metric. Measure Values is not limited to calculated fields or filters, and it does not simply count the number of measures. Instead, it provides a flexible container for displaying several quantitative fields in one visualization.

Question 87.

Which Tableau visualization is generally best for comparing values across two categorical dimensions using both position and color intensity?

1. Pie chart
   2. Line chart
   3. Highlight table
   4. Gantt chart

Correct Answer: 3

Explanation:

A highlight table combines a tabular structure with color encoding. One categorical dimension can be placed on Rows and another on Columns, while a measure controls the color intensity of each cell. This makes it easier to spot high, low, and unusual values across many category combinations. Text labels may also be added when exact values are useful. A pie chart is more appropriate for simple part-to-whole comparisons, a line chart shows trends over an ordered dimension such as time, and a Gantt chart emphasizes duration or progress. For identifying patterns across a two-dimensional categorical matrix, a highlight table is particularly effective.

Question 88.

An analyst wants to display how total Sales is distributed across Category and Sub-Category using nested rectangles sized by Sales. Which chart type is most appropriate?

1. Histogram
   2. Scatter plot
   3. Bullet graph
   4. Treemap

Correct Answer: 4

Explanation:

A treemap represents hierarchical or categorical data using rectangles whose sizes can encode a measure such as Sales. Color can encode an additional measure such as Profit. Category and Sub-Category can be used to organize the rectangles into nested groups, making it possible to compare relative contribution in a compact space. Treemaps are particularly useful when there are many categories and exact comparisons are less important than overall composition. Histograms show distributions, scatter plots compare two continuous measures, and bullet graphs compare actual performance against a target. For hierarchical part-to-whole analysis with rectangular sizing, a treemap is appropriate.

Question 89.

An analyst wants to create a chart that displays the duration of individual projects along a time axis. Which mark type is commonly associated with this type of visualization?

1. Gantt Bar
   2. Pie
   3. Circle
   4. Shape

Correct Answer: 1

Explanation:

The Gantt Bar mark type is commonly used to show duration or span along an axis. A project start date can define the position of the mark, while a duration field can control the size of the Gantt bar. This makes it useful for project timelines, task durations, machine operation periods, and other analyses where the length of an interval is meaningful. Pie marks emphasize part-to-whole relationships, while Circle and Shape marks represent points rather than durations. Tableau does not automatically create a full project-management Gantt chart, but the Gantt Bar mark type provides the core visual encoding needed for this kind of timeline.

Question 90.

Which Tableau feature allows an analyst to display a shaded range between two benchmark values across a chart?

1. Trend line
   2. Reference band
   3. Set action
   4. Group

Correct Answer: 2

Explanation:

A reference band displays a shaded area between two values on an axis. The limits can be constants, statistical values, parameters, or other supported expressions. For example, an analyst could show an acceptable performance range between a lower and upper threshold, making it easy to see which marks fall inside or outside that range. A reference line displays a single benchmark rather than a range. Trend lines model relationships in data, while sets and groups organize members. Reference bands are useful in dashboards that need to communicate target zones, expected intervals, tolerance ranges, or other bounded performance areas.

Question 91.

Which Tableau analytics feature is most appropriate for showing a confidence-like shaded area around a forecasted time-series projection?

1. Set control
   2. Pages shelf
   3. Forecast prediction interval
   4. Bin

Correct Answer: 3

Explanation:

When Tableau creates a forecast, it can display prediction intervals around the forecasted values. These intervals communicate uncertainty by showing a range within which future observations are expected to fall according to the selected model and confidence level. This is more informative than presenting forecast values as if they were certain. Analysts should still interpret forecasts carefully because unexpected business changes can make historical patterns less predictive. Set controls alter set membership, Pages steps through field values, and bins group numeric observations. Forecast prediction intervals are the feature directly associated with communicating uncertainty around projected time-series values.

Question 92.

A workbook uses an extract, and new records are added to the source every day while historical records remain unchanged. Which refresh strategy is likely to be most efficient?

1. Rebuild the entire workbook manually every day
   2. Replace the data source with a text file
   3. Disable all refreshes
   4. Use an incremental extract refresh when a suitable incremental field exists

Correct Answer: 4

Explanation:

An incremental extract refresh can add newly created records without rebuilding the entire extract, provided Tableau can identify new rows using an appropriate incremental field. This can reduce refresh time significantly when the source is append-oriented and historical rows do not need to be modified. A timestamp or increasing identifier is commonly used. If existing records are frequently updated or deleted, an incremental strategy may not capture every change and a full refresh may be necessary periodically. Disabling refreshes would allow data to become stale, while manually rebuilding workbooks or changing file formats would not address the underlying need efficiently.

Question 93.

What is one primary advantage of a Tableau extract compared with a live connection?

1. An extract can provide optimized local query performance and reduce dependency on the source system during analysis
   2. Extracts always contain real-time data automatically
   3. Extracts cannot be filtered
   4. Extracts eliminate the need for refresh planning

Correct Answer: 1

Explanation:

Tableau extracts use an optimized storage format designed for analytical queries and can often provide strong performance, particularly when the source system is slow or network access is constrained. Because the extracted data is stored separately, interactive analysis may place less direct workload on the original database. However, an extract represents data from the time of its last refresh and does not automatically provide real-time data unless refreshed appropriately. Extracts can be filtered, and refresh planning remains important when source data changes. The choice between live and extract connections depends on freshness requirements, source performance, data volume, governance, and operational constraints.

Question 94.

An analyst wants all worksheets using the same data source to exclude test records where Environment = “Test”. Which approach is most appropriate?

1. Add an independent worksheet filter to every sheet
   2. Use an appropriate data source filter
   3. Create a story point
   4. Add Environment to Detail

Correct Answer: 2

Explanation:

A data source filter restricts the records available from the data source and can consistently affect worksheets that rely on that source. If test records should never participate in workbook analysis, filtering them at the data-source level can be more reliable and maintainable than adding the same filter independently to many worksheets. A worksheet filter could work, but repeating it increases the chance of inconsistent configuration. Story points organize presentations, and placing Environment on Detail would change mark granularity rather than exclude records. Data source filters are useful when the workbook should consistently operate on a defined subset of the available source data.

Question 95.

Which Tableau field role should an analyst assign to a ZIP Code field so Tableau can use it in map visualizations?

1. Measure
   2. Bin
   3. Geographic role
   4. Parameter

Correct Answer: 3

Explanation:

Assigning the appropriate geographic role tells Tableau that the field represents a location, such as a ZIP Code or Postal Code. Tableau can then attempt to geocode the values and generate Latitude and Longitude fields for mapping. A ZIP Code may be stored as text or number, but its analytical meaning is geographic rather than quantitative. Treating it as a measure could result in meaningless aggregations. Bins are used for numeric ranges, while parameters hold user-controlled values. Correct geographic roles are essential when Tableau needs to interpret location fields and create symbol maps or filled maps.

Question 96.

An analyst wants to show one symbol for each city on a map, with symbol size based on Sales. Which type of map is most appropriate?

1. Filled map only
   2. Heat map only
   3. Treemap
   4. Symbol map

Correct Answer: 4

Explanation:

A symbol map displays marks at geographic locations, such as cities, and can encode measures through size, color, or other mark properties. Placing City in the geographic view and Sales on Size can create circles whose size represents sales magnitude. This approach is useful when locations represent points rather than complete geographic areas. A filled map colors geographic polygons such as states or countries and is less appropriate for point-level city comparisons. Treemaps are not geographic visualizations. A symbol map therefore provides the correct visual structure when each city should appear as a separate geographically positioned mark.

Question 97.

Which Tableau calculation is most appropriate for calculating total customer sales at the Customer ID level regardless of whether Product Category is added to the visualization?

1. { FIXED [Customer ID] : SUM([Sales]) }
   2. RUNNING_SUM(SUM([Sales]))
   3. SUM([Sales]) / COUNT([Sales])
   4. INDEX()

Correct Answer: 1

Explanation:

A FIXED level-of-detail expression computes an aggregation using the dimensions explicitly specified inside the expression. { FIXED [Customer ID] : SUM([Sales]) } therefore calculates each customer’s sales total at the Customer ID level. Adding Product Category to the visualization does not automatically cause the calculation to be recalculated separately for each Category because the LOD expression remains fixed at Customer ID. Filter behavior still depends on Tableau’s order of operations. Running sums and INDEX are table calculations tied to the displayed marks, while the ratio expression calculates an average-like metric. For a stable customer-level total, a FIXED LOD calculation is appropriate.

Question 98.

An analyst has Category and Sub-Category in a view but wants a calculation that ignores Sub-Category and returns the Category-level Sales total. Which LOD expression type is most suitable?

1. INCLUDE
   2. EXCLUDE
   3. WINDOW_SUM
   4. INDEX

Correct Answer: 2

Explanation:

An EXCLUDE LOD expression removes one or more dimensions from the level of detail used for a calculation. If Category and Sub-Category are displayed but the analyst needs a Category-level Sales value, an expression that excludes Sub-Category allows Tableau to calculate at the broader Category level while still showing Sub-Category marks in the view. INCLUDE performs the opposite operation by adding dimensions to the calculation’s granularity. WINDOW_SUM and INDEX are table calculations based on marks in the visualization. EXCLUDE is therefore a useful technique for comparing detailed marks with a broader parent-level aggregate.

Question 99.

A dashboard user selects a bar representing a product, and the analyst wants that product to become a member of a set that drives other calculations. Which feature should be configured?

1. URL action
   2. Highlight action
   3. Set action
   4. Forecast action

Correct Answer: 3

Explanation:

A set action allows user interaction with marks to modify the membership of a set. The updated set can then drive calculations, colors, filters, comparisons, or other dashboard logic. For example, selecting a product can place it in a set so another chart compares the selected product with all remaining products. This provides more analytical flexibility than simply filtering the dashboard. Highlight actions only emphasize related marks, and URL actions open external resources. Set actions are especially useful for interactive comparisons, cohort analysis, proportional brushing, and dynamic IN-versus-OUT calculations.

Question 100.

A dashboard contains several related views. The analyst wants users to click a mark in one worksheet and navigate to an external support portal using an identifier from that mark. Which action should be used?

1. Filter action
   2. Highlight action
   3. Parameter action
   4. URL action

Correct Answer: 4

Explanation:

A URL action opens an external web address when a user interacts with a mark. Tableau can insert field values into the URL dynamically, allowing an identifier such as Customer ID, Ticket ID, or Product ID to be passed to another web application. This makes it possible to move directly from analytical context in Tableau to a related record in a CRM, support system, or internal portal. A filter action changes which data is displayed in target worksheets, a highlight action emphasizes related marks, and a parameter action updates a parameter. When external navigation is the goal, a URL action is the appropriate Tableau dashboard feature.