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

 

Question 201.

An analyst has a field named Order Date stored as text, but Tableau needs to use it for date calculations. What should the analyst do?

1. Change the field’s data type to Date when the text can be interpreted correctly
   2. Convert the field to a measure
   3. Add the field to Color
   4. Create a set from the field

Correct Answer: 1

Explanation:

Changing the data type to Date allows Tableau to interpret the values as dates and enables date-specific functionality such as date hierarchies, date arithmetic, filtering, truncation, and time-series analysis. If Tableau cannot automatically interpret the text format, the analyst may need a calculated field using a function such as DATEPARSE where supported. Converting the field to a measure would not solve the underlying data-type issue. Color and sets affect visualization or membership behavior rather than data interpretation. Choosing the correct data type is an important early step because many Tableau functions depend on whether a field is recognized as string, number, date, Boolean, or another supported type.

Question 202.

Which Tableau feature allows an analyst to rename a field for use in the workbook without changing the underlying source column name?

1. Bin
   2. Rename the field in Tableau
   3. Union
   4. Extract filter

Correct Answer: 2

Explanation:

Tableau allows fields to be renamed within the workbook or data source interface without altering the original database column. This is useful when source fields have technical names such as cust_id but business users expect a clearer label such as Customer ID. Renaming improves readability in worksheets, dashboards, calculations, and the Data pane while preserving the original source structure. Bins group numerical values, unions append rows from similar tables, and extract filters restrict which records are stored in an extract. Renaming is therefore the simplest approach when only the Tableau-facing field name needs improvement.

Question 203.

An analyst finds that the value Corporate appears as Corp, Corporate, and CORP in a dimension and wants those values treated as one member in the analysis. Which Tableau feature is most appropriate for a quick workbook-level solution?

1. Forecast
   2. Parameter
   3. Group
   4. Reference line

Correct Answer: 3

Explanation:

A group can combine several dimension members into one custom category. The analyst could select Corp, Corporate, and CORP and group them under a common label such as Corporate. This provides a quick Tableau-level solution without changing the underlying source data. In some environments, correcting the values upstream may be preferable for long-term data governance, but a group works well when the requirement is limited to the workbook. Parameters store independent values, forecasts project time-series data, and reference lines provide visual benchmarks. Groups are designed specifically for consolidating multiple categorical members.

Question 204.

Which Tableau data operation is appropriate when two tables contain different columns but share a matching key and need to be combined row by row?

1. Union
   2. Bin
   3. Group
   4. Join

Correct Answer: 4

Explanation:

A join combines columns from two physical tables according to a matching condition such as Customer ID or Order ID. The result is a single row-level table structure containing fields from both sides. The selected join type determines whether unmatched rows are retained. A union instead appends rows from tables with similar column structures. Bins organize numerical values into ranges, while groups combine dimension members. Analysts should examine table granularity before joining because one-to-many or many-to-many joins can duplicate records and inflate measures. A join is appropriate when fields from different tables must be combined based on matching keys at the physical layer.

Question 205.

A table containing Orders has multiple rows per Customer, while another table contains exactly one row per Customer. Which join scenario can potentially repeat the customer-table values across multiple order rows?

1. A physical join between Orders and Customers on Customer ID
   2. A simple field rename
   3. A parameter action
   4. A reference band

Correct Answer: 1

Explanation:

Joining an Orders table containing multiple rows per Customer to a Customers table with one row per Customer creates a one-to-many relationship in the physical joined result. Customer-level attributes will repeat for each matching order row. Repeating descriptive fields is usually expected, but customer-level numerical measures can also be duplicated if analysts aggregate them carelessly. This is why understanding table grain is essential before choosing a physical join. Tableau relationships can sometimes be preferable when logical tables need to preserve their own granularity. Field renaming, parameter actions, and reference bands do not affect row multiplication in the data model.

Question 206.

Which Tableau data-modeling feature lets logical tables retain separate levels of detail and be queried based on the fields used in a visualization?

1. Full outer join
   2. Relationship
   3. Union
   4. Bin

Correct Answer: 2

Explanation:

Relationships operate in Tableau’s logical layer. Rather than immediately combining all rows into one physical table, each logical table retains its own level of detail. Tableau then determines how to query and combine the tables based on the fields used in the current visualization. This can help reduce unwanted duplication when tables have different grains. Relationships still require meaningful matching fields and appropriate data modeling. Physical joins merge rows earlier, while unions append records vertically. Bins have nothing to do with table relationships. For flexible multi-table analysis where separate granularities should be preserved, relationships are often the better design.

Question 207.

An analyst has four quarterly CSV files with the same columns and wants Tableau to treat them as one continuous table. Which operation should be used?

1. Join
   2. Relationship
   3. Union
   4. Blend

Correct Answer: 3

Explanation:

A union appends rows from tables or files with similar structures. If each quarterly CSV contains fields such as Order ID, Order Date, Customer, and Sales, a union can stack all records into one combined dataset. Tableau can also support wildcard unions in appropriate file-based scenarios, which is useful when many similarly named files need to be combined. A join adds columns based on matching keys, while relationships preserve separate logical tables. Data blending combines aggregated results from different sources rather than simply stacking rows. When identical or similar columns should be combined vertically, a union is the appropriate operation.

Question 208.

An analyst wants to limit a Tableau extract to only records from the last three years. Which feature should be applied when creating or configuring the extract?

1. Highlight action
   2. Table calculation filter
   3. Pages shelf
   4. Extract filter

Correct Answer: 4

Explanation:

An extract filter controls which records are stored in the Tableau extract. Filtering the extract to the last three years can reduce extract size, refresh time, and query workload if older records are not required. Because excluded records are not present in the extract, they cannot be recovered through an ordinary worksheet filter later unless the extract configuration is changed and refreshed. Table calculation filters operate much later in Tableau’s processing sequence and affect displayed marks rather than extract contents. Highlight actions and the Pages shelf affect presentation and interaction. For reducing the data physically stored in the extract, an extract filter is appropriate.

Question 209.

What is a potential advantage of hiding unused fields before creating a Tableau extract?

1. It can reduce extract size when unnecessary fields are excluded
   2. It guarantees every dashboard will refresh instantly
   3. It converts all dimensions to measures
   4. It creates a relationship automatically

Correct Answer: 1

Explanation:

Removing or hiding fields that are not needed can reduce the amount of data stored in an extract in applicable workflows. Smaller extracts may consume less storage and can improve refresh or query efficiency. However, hiding fields is not a universal performance guarantee because overall performance also depends on data volume, calculations, workbook design, source structure, filters, and hardware or server resources. Hiding fields does not convert field roles or create relationships automatically. Good extract design generally involves storing only the records and columns necessary for the intended analysis, while still preserving all data required by calculations and downstream workbook functionality.

Question 210.

Which Tableau connection is most appropriate when users require queries to reflect current source-system data and the database is designed to handle interactive workloads?

1. Static image
   2. Live connection
   3. PDF export
   4. Group

Correct Answer: 2

Explanation:

A live connection sends queries to the underlying data source as users interact with Tableau, allowing results to reflect the current data available in the source. This can be appropriate when data freshness is important and the database can support the expected interactive query workload. Performance depends on the database, network, query complexity, concurrency, and workbook design. An extract may be preferable when faster local analytics or reduced source-system load is more important than near-current data. Static images and PDF exports are not interactive data connections, while groups simply reorganize dimension members. A live connection is therefore the direct choice for querying source data dynamically.

Question 211.

An analyst needs a workbook to perform well even when the original database is temporarily unavailable. Which connection strategy may be most appropriate?

1. Context filter only
   2. Live connection only
   3. Tableau extract
   4. Trend line

Correct Answer: 3

Explanation:

A Tableau extract stores a copy or subset of the source data in Tableau’s optimized extract format. Because analysis can run against that stored data, the workbook may continue to operate even when the original database is temporarily unavailable, assuming the extract itself remains accessible. The trade-off is that the extract reflects the data as of its latest refresh rather than automatically showing every current source change. A live connection depends more directly on source availability. Context filters affect filtering order and trend lines provide statistical modeling. When reduced dependence on source-system availability is valuable, an extract can be an appropriate strategy.

Question 212.

A source receives new rows every hour and older rows never change. Which extract refresh method may be more efficient than rebuilding the extract each time?

1. Data blending
   2. Full refresh only
   3. Static parameter
   4. Incremental refresh

Correct Answer: 4

Explanation:

An incremental refresh can add newly created records without rebuilding the entire extract when a reliable incremental field identifies the new rows. An increasing ID or timestamp is a common choice. This approach is particularly suitable for append-only data where previously extracted records do not change. If historical rows are later updated or deleted, an incremental strategy may not capture those changes, so occasional full refreshes or a different data strategy might be needed. Data blending and parameters have nothing to do with extract refresh mechanics. When a dataset grows primarily by adding new rows, incremental refreshes can significantly reduce refresh workload.

Question 213.

Which Tableau field property allows a categorical text field to be displayed using a friendlier label while keeping its underlying member value unchanged?

1. Alias
   2. Bin
   3. Data role
   4. Sort only

Correct Answer: 1

Explanation:

Aliases allow analysts to display alternative labels for dimension members without changing the underlying source values. For example, a source value N could be displayed as North, or Cust_Seg_1 could appear as Enterprise. This improves readability in views and dashboards while preserving the source data. Aliases are different from renaming a field: renaming changes the displayed field name, whereas an alias changes how individual member values are displayed. Bins group numbers, and sorting changes order. Aliases are especially useful when source values are valid but too technical, abbreviated, or unfriendly for end users.

Question 214.

An analyst wants the states CA, OR, and WA to display as West Coast States in one combined category. Which feature is most appropriate?

1. Alias only
   2. Group
   3. Continuous axis
   4. Forecast

Correct Answer: 2

Explanation:

A group combines multiple members into a new categorical grouping. Selecting California, Oregon, and Washington and assigning them to West Coast States creates a broader category that can be used throughout the analysis. An alias only changes the display label of each individual member; it does not combine separate members into one analytical category. A continuous axis controls visualization behavior, while forecasting estimates future time-series values. Groups are useful for business-specific classifications, custom territories, and other situations where several existing dimension members should behave as a single higher-level category in the workbook.

Question 215.

Which Tableau feature is best for dividing customers into a selected cohort and everyone else without permanently merging customer members?

1. Group
   2. Hierarchy
   3. Set
   4. Bin

Correct Answer: 3

Explanation:

A set defines membership in a subset. Customers are classified as either IN the set or OUT of the set, which makes sets particularly useful for cohort comparisons. The analyst can manually select members, define membership using a condition, create a Top N set, or update membership interactively with a set action. A group instead combines members into categorical labels and does not naturally express IN-versus-OUT logic. Hierarchies organize drill paths, while bins divide numeric values into ranges. When the analytical requirement is to compare a selected cohort with the remaining population, a set provides the most flexible structure.

Question 216.

An analyst wants users to select a customer from a dashboard and dynamically add that customer to a comparison cohort. Which Tableau capability should be configured?

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

Correct Answer: 4

Explanation:

A set action updates set membership based on interaction with marks in a worksheet. Selecting a customer can therefore add that customer to a set that drives comparisons, calculated fields, colors, or other views. This is more flexible than simply filtering out unrelated customers because the full population can remain visible while Tableau distinguishes selected and unselected members. Filter actions restrict target data, highlight actions visually emphasize related marks without modifying a set, and URL actions navigate to external resources. Set actions are particularly useful for interactive cohorts, proportional brushing, selected-versus-rest analysis, and dynamic comparison dashboards.

Question 217.

Which Tableau feature allows a dashboard user to click a mark and update a numeric threshold used by a calculated field?

1. Parameter action
   2. Set action only
   3. Reference line only
   4. Extract filter

Correct Answer: 1

Explanation:

A parameter action can update a parameter value based on a field from a selected mark. If a numeric field is used as the source, clicking the mark can write that value into a parameter. Calculated fields that reference the parameter can then react immediately, making parameter actions useful for dynamic thresholds, comparisons, selected-measure logic, and interactive reference values. A set action changes set membership rather than a parameter. A reference line can use the resulting parameter but does not itself update it. Extract filters determine what records are stored and do not respond to dashboard selections.

Question 218.

Which Tableau action should be used when selecting a mark must restrict another worksheet to matching records?

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

Correct Answer: 2

Explanation:

A filter action passes selected values from a source worksheet to one or more target worksheets and limits the target data accordingly. For example, selecting a Product Category in one chart can cause a detailed table to display only records belonging to that category. This provides intuitive dashboard drill-down without requiring a separate visible filter control. Highlight actions retain all marks and simply emphasize related data. Parameter actions update parameter values, while URL actions open external resources. When the target worksheet should actually be reduced to matching records based on a selection, a filter action is the appropriate Tableau dashboard feature.

Question 219.

Which Tableau action is best when related marks should be visually emphasized in another worksheet while all unrelated marks remain visible?

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

Correct Answer: 3

Explanation:

A highlight action emphasizes marks that correspond to a user selection while leaving unrelated marks visible in the target view. This preserves the broader context, which can be valuable when the user needs to compare selected data with the rest of the population. A filter action would remove unrelated marks from the view, changing the visual context. Set actions modify set membership and support more complex calculations, while URL actions open external pages. Highlight actions are therefore well suited to linked views where users need to focus on one category, region, customer, or product while still seeing how it compares with the surrounding data.

Question 220.

A published dashboard should allow a user to click an Order ID and open that order in an external order-management website. Which Tableau feature should be used?

1. Highlight action
   2. Context filter
   3. Set action
   4. URL action

Correct Answer: 4

Explanation:

A URL action can open an external webpage in response to interaction with a mark. Tableau can insert field values such as Order ID into the URL so the destination page is specific to the selected record. This is useful for connecting analytics with operational applications such as CRM systems, support platforms, ticketing systems, or order-management portals. Highlight actions only change visual emphasis, context filters affect filter order, and set actions change set membership. When dashboard users need to navigate from a selected Tableau mark to a corresponding external web resource, a URL action is the correct feature.