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

 

Question 1.

A Tableau analyst connects to a data source containing one row for each sales transaction. Which field is most likely to be classified as a measure by default?

1. Sales Amount
   2. Customer Name
   3. Product Category
   4. Region

Correct Answer: 1

Explanation:

Measures generally contain quantitative values that Tableau can aggregate, such as sales, profit, quantity, or cost. Sales Amount is numeric and can be summarized using functions such as SUM, AVG, MIN, or MAX. Customer Name, Product Category, and Region are descriptive categorical fields and are therefore more likely to be dimensions. Tableau automatically classifies many fields based on their data type, although analysts can manually convert a field between a dimension and measure when the analytical requirement calls for different behavior.

Question 2.

What happens when a discrete field is placed on the Rows shelf in Tableau?

1. Tableau always creates a continuous axis
   2. Tableau creates headers for the distinct values
   3. Tableau converts the field into a measure
   4. Tableau automatically creates a trend line

Correct Answer: 2

Explanation:

Discrete fields divide the view into separate categories and usually generate headers rather than continuous axes. For example, placing a discrete Region field on Rows produces one header for each region represented in the data. Discrete pills are typically shown in blue in Tableau. Continuous fields, represented by green pills, generally create axes and support a range of values. Understanding the distinction between discrete and continuous fields is essential because it directly affects the structure and appearance of Tableau visualizations.

Question 3.

An analyst wants to show monthly sales across a two-year period. Which visualization is generally most appropriate?

1. Packed bubbles
   2. Treemap
   3. Line chart
   4. Text table

Correct Answer: 3

Explanation:

A line chart is well suited to displaying how a measure changes over time. Placing Month of Order Date on Columns and Sales on Rows can show trends, seasonality, increases, and decreases across the two-year period. Treemaps and packed bubbles are more appropriate for showing relative magnitude across categories, while a text table emphasizes exact values rather than temporal patterns. Line charts make it easier to see direction and continuity in time-series data, which is why they are commonly used for monthly sales analysis.

Question 4.

Which Tableau feature allows an analyst to limit the data displayed in a worksheet based on selected values?

1. Story
   2. Parameter only
   3. Hierarchy
   4. Filter

Correct Answer: 4

Explanation:

Filters control which data is included in a Tableau view. An analyst can filter dimensions, measures, dates, and other fields to focus the visualization on relevant records. Filters may be applied at several levels, including extract filters, data source filters, context filters, and worksheet filters. Parameters can influence calculations or other behavior but do not filter data automatically unless incorporated into a calculation or filter condition. Using filters effectively helps users focus dashboards and worksheets on the subset of information needed for analysis.

Question 5.

What is the primary purpose of a calculated field in Tableau?

1. Create a new value or field from existing data using an expression
   2. Permanently change the source database
   3. Delete unused columns from the original table
   4. Replace every dimension with a measure

Correct Answer: 1

Explanation:

Calculated fields allow analysts to derive new values using existing fields, constants, functions, and logical expressions. For example, an analyst might calculate Profit Ratio as SUM([Profit]) / SUM([Sales]) or create a category based on a conditional expression. These calculations are evaluated within Tableau and do not normally alter the underlying source system. Calculated fields can support segmentation, ratios, date logic, string transformations, and many other analytical requirements, making them a fundamental part of Tableau analysis.

Question 6.

Which aggregation does Tableau commonly apply to a numeric measure such as Sales when it is first added to a view?

1. COUNT
   2. SUM
   3. MEDIAN
   4. ATTR

Correct Answer: 2

Explanation:

Tableau commonly aggregates numeric measures using SUM by default. For example, adding Sales to Rows generally produces SUM(Sales) unless the field’s default aggregation has been changed. Analysts can change the aggregation to AVG, MIN, MAX, MEDIAN, COUNT, or other supported functions depending on the analytical question. The aggregation level also depends on the dimensions in the view because Tableau computes the measure for each mark defined by the view’s level of detail.

Question 7.

An analyst wants to compare sales across product categories and display the categories from highest sales to lowest. What should the analyst do?

1. Convert Sales to a dimension
   2. Add a forecast
   3. Sort Product Category by SUM(Sales) in descending order
   4. Create a geographic role

Correct Answer: 3

Explanation:

Sorting Product Category by SUM(Sales) in descending order places the category with the largest sales value first and the smallest last. This makes comparisons easier and can help viewers identify leading and underperforming categories quickly. Tableau provides several sorting methods, including manual sorting, alphabetical sorting, and sorting by a field or measure. Converting Sales to a dimension would change how Tableau treats the field but would not solve the ranking requirement. A forecast or geographic role is unrelated to category ordering.

Question 8.

Which type of join returns all rows from the left table and matching rows from the right table?

1. Inner join
   2. Right join
   3. Full outer join
   4. Left join

Correct Answer: 4

Explanation:

A left join returns every row from the left table and matching rows from the right table. When no matching record exists in the right table, the right-side fields are typically null. An inner join retains only rows with matching keys in both tables. A right join preserves all rows from the right table, while a full outer join preserves all rows from both tables. Selecting the appropriate join type is important because joins can change row counts and affect downstream calculations in Tableau.

Question 9.

What is a primary advantage of using relationships rather than physical joins in Tableau’s logical data model?

1. Tables can retain their own level of detail until Tableau determines how they should be combined for the visualization
   2. Relationships permanently merge all tables into one table
   3. Relationships require every table to have identical columns
   4. Relationships eliminate the need for matching fields

Correct Answer: 1

Explanation:

Relationships allow logical tables to remain separate and preserve their individual levels of detail until Tableau generates the query needed for the current visualization. This can reduce problems such as duplicated measures that may occur when tables of different granularities are physically joined. Tableau uses relationship fields to determine how the logical tables should interact. Relationships do not eliminate the need for related fields and do not permanently merge data into one physical table. They provide a flexible modeling approach for multi-table analysis.

Question 10.

Which Tableau feature is used to allow a user to select a single value that can be referenced in calculations, filters, or reference lines?

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

Correct Answer: 2

Explanation:

A parameter is a workbook variable that can hold a value such as a number, string, date, or Boolean. Analysts can expose parameter controls to users and reference the parameter in calculated fields, reference lines, filters, or other logic. Unlike normal filters, parameters are not inherently tied to a specific field’s current values unless they are configured that way. They are especially useful for what-if analysis, dynamic metric selection, adjustable thresholds, and user-controlled calculations.

Question 11.

What is the primary purpose of a Tableau set?

1. Change a field’s data type
   2. Create a database extract
   3. Define a subset of data members as IN or OUT
   4. Create a new data connection

Correct Answer: 3

Explanation:

A set defines a subset of dimension members, dividing members conceptually into IN and OUT categories. Sets can be created manually, conditionally, or by using top-N logic. They are useful for comparative analysis, such as comparing selected customers against all other customers or identifying top-performing products. Sets can also participate in calculations and set actions, allowing interactive dashboard behavior. They differ from groups, which combine dimension members into broader categories rather than defining membership in a subset.

Question 12.

Which Tableau feature groups continuous numeric values into equal-sized ranges?

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

Correct Answer: 4

Explanation:

Bins divide continuous numeric values into ranges of a specified size. For example, an analyst could create Sales bins of 100 to analyze how many transactions fall within 0–99, 100–199, and so on. Bins are commonly used when building histograms because they transform continuous data into discrete intervals. Sets define subsets of members, parameters store user-controlled values, and hierarchies organize related dimensions for drill-down analysis. Bins are specifically intended to group numerical values into intervals.

Question 13.

An analyst wants users to drill from Category to Sub-Category to Product Name. What should the analyst create?

1. Hierarchy
   2. Context filter
   3. Extract filter
   4. Data source filter

Correct Answer: 1

Explanation:

A hierarchy organizes related dimensions into levels that users can drill through in a visualization. Creating a hierarchy with Category, Sub-Category, and Product Name would allow viewers to start at the category level and progressively reveal more detailed data. Tableau also automatically provides certain geographic and date hierarchies. Filters restrict the data included in the visualization but do not inherently create drill-down levels. Hierarchies improve navigation and enable analysts to present summary and detail within the same analytical structure.

Question 14.

Which expression calculates profit ratio correctly when the analyst wants the ratio of total profit to total sales?

1. [Profit] / [Sales] only
   2. SUM([Profit]) / SUM([Sales])
   3. AVG([Profit] + [Sales])
   4. COUNT([Profit]) / COUNT([Sales])

Correct Answer: 2

Explanation:

SUM([Profit]) / SUM([Sales]) calculates the ratio between aggregated profit and aggregated sales at the level of detail defined by the visualization. This is typically the desired calculation for an overall profit ratio. Using row-level [Profit] / [Sales] and then aggregating the result may produce a different outcome because it calculates individual ratios before Tableau aggregates them. Count-based calculations measure record availability rather than profitability. Understanding the distinction between row-level and aggregate calculations is important for accurate Tableau analysis.

Question 15.

Which Tableau calculation type is performed on the results already present in a visualization rather than directly on the underlying data rows?

1. Row-level calculation
   2. Data source filter
   3. Table calculation
   4. Join calculation

Correct Answer: 3

Explanation:

Table calculations operate on the aggregated values in the visualization after Tableau has queried and aggregated the underlying data. Examples include running total, percent of total, difference from, rank, and moving average. Their results depend strongly on how the calculation is addressed and partitioned within the view. This is different from row-level calculated fields, which are evaluated on individual records before aggregation. Table calculations are useful when the analyst needs calculations based on the layout and marks already displayed in the worksheet.

Question 16.

An analyst wants to display cumulative sales month by month. Which quick table calculation should be applied to Sales?

1. Percent of Total
   2. Rank
   3. Difference
   4. Running Total

Correct Answer: 4

Explanation:

A Running Total table calculation accumulates a measure across the selected direction or addressing field. Applied to monthly Sales, it displays the cumulative sales amount as each month is added. This is useful for year-to-date analysis and progress tracking. Percent of Total shows each mark’s contribution to a total, Rank assigns relative positions, and Difference calculates the change from another mark. The analyst should also verify the table calculation’s Compute Using setting to ensure Tableau accumulates values across months in the intended sequence.

Question 17.

Which type of calculation can return a fixed value independent of most dimensions currently displayed in the view?

1. FIXED level-of-detail expression
   2. Running Total
   3. Table calculation only
   4. Bin

Correct Answer: 1

Explanation:

A FIXED level-of-detail expression calculates a value using dimensions explicitly specified in the expression rather than simply following the dimensions currently displayed in the view. For example, { FIXED [Customer ID] : SUM([Sales]) } calculates sales at the customer level even if other dimensions appear in the visualization. This makes FIXED expressions useful when analysts need calculations at a consistent granularity. Table calculations are dependent on the displayed aggregated marks, while bins simply group numeric values into ranges.

Question 18.

Which LOD expression type adds specified dimensions to the level of detail currently present in the view?

1. FIXED
   2. INCLUDE
   3. EXCLUDE
   4. WINDOW

Correct Answer: 2

Explanation:

An INCLUDE level-of-detail expression adds one or more specified dimensions to the level of detail used for the calculation, even if those dimensions are not currently displayed in the view. Tableau calculates the expression at that finer level and then aggregates the result back to the visualization’s level. EXCLUDE removes selected view dimensions from the calculation, while FIXED calculates according to explicitly specified dimensions independently of most view dimensions. INCLUDE expressions are useful when a calculation requires more detailed data than the visible chart currently displays.

Question 19.

A Tableau dashboard contains several worksheets. The analyst wants selecting a mark in one worksheet to filter data shown in another worksheet. Which feature should be used?

1. Trend line
   2. Forecast
   3. Filter action
   4. Extract refresh

Correct Answer: 3

Explanation:

A filter action allows interactions in one worksheet to filter the data shown in another worksheet or dashboard component. For example, selecting a region on a map can filter a sales chart to display only that region’s data. Filter actions can be triggered by selection, hover, or menu depending on configuration. They are a powerful way to make dashboards interactive without requiring separate filter controls for every use case. Trend lines and forecasts support analytical modeling, while extract refreshes update stored extract data rather than control dashboard interactions.

Question 20.

An analyst wants a dashboard to show only the top 10 customers by sales. Which approach is most appropriate?

1. Convert Customer Name to a measure
   2. Create a geographic hierarchy
   3. Use only a manual sort
   4. Apply a Top N filter to Customer Name based on SUM(Sales)

Correct Answer: 4

Explanation:

A Top N filter on Customer Name can dynamically retain the customers with the highest aggregated sales. The analyst can configure the dimension filter to show the top 10 members by SUM(Sales). Unlike a manual sort, this actually removes customers outside the top 10 from the view rather than merely changing their order. The filter also recalculates as data changes, which makes it appropriate for refreshed dashboards. Analysts should remember that Tableau’s order of operations can affect Top N results when other filters are involved, particularly when context filters are used.