View Full Salesforce Certified Tableau Data Analyst Exam Dumps and Practice Test Dumps

 

Question 201.

What does a relationship preserve between logical tables?

1. Separate table granularity
2. Identical row structures
3. Shared worksheet formatting
4. Unified field captions

Correct Answer: 1

Explanation:

A Tableau relationship allows logical tables to remain distinct while defining how they connect through related fields. This preserves each table’s level of detail until Tableau determines the appropriate query based on the fields used in the visualization. This behavior can help avoid unnecessary row duplication that may occur when tables are physically joined too early. Relationships are therefore useful when datasets have different granularities but still need to work together analytically. The analyst defines the related fields, while Tableau determines how the underlying tables should participate in the query for the selected visualization.

Question 202.

Which operation rotates fields from columns into rows?

1. Aggregation
2. Partitioning
3. Pivoting
4. Sampling

Correct Answer: 3

Explanation:

Pivoting restructures data by converting multiple columns into a more row-oriented format. This is particularly useful when source data contains several similarly structured columns that would be easier to analyze as records. For example, separate columns representing different measurement periods can sometimes be pivoted into a single field containing period names and another field containing corresponding values. This structure can make filtering, aggregation, and visualization more straightforward. Pivoting is a data-shaping operation rather than an aggregation technique, and it changes how source fields are organized before analytical work begins.

Question 203.

Which Tableau function removes spaces from both ends of text?

1. TRIM
2. LEFT
3. LOWER
4. SPLIT

Correct Answer: 1

Explanation:

The TRIM function removes leading and trailing spaces from a string and can help standardize text values during data preparation. Extra spaces can cause apparently identical values to behave differently in comparisons, grouping, or filtering. LEFT extracts characters from the beginning of a string, LOWER converts text to lowercase, and SPLIT separates a string according to a delimiter. TRIM is therefore appropriate when whitespace surrounding values is creating consistency problems. Cleaning these small formatting issues can improve grouping accuracy and reduce unexpected results in Tableau analyses.

Question 204.

Which Tableau concept controls whether a date appears as month or year?

1. Data source mode
2. Date level
3. Extract policy
4. Mark encoding

Correct Answer: 2

Explanation:

A date level determines the granularity at which a date field is displayed or analyzed. Depending on the selected level, a date can be represented by year, quarter, month, week, day, or another supported period. Changing the date level can substantially alter the number and arrangement of marks in a visualization because Tableau aggregates records according to that chosen temporal granularity. This is different from changing the underlying data source or extract configuration. Analysts should select the date level that matches the business question, especially when comparing trends across different time periods.

Question 205.

What does a data source filter restrict?

1. Workbook themes
2. Source records
3. Sheet dimensions
4. Mark labels

Correct Answer: 2

Explanation:

A data source filter restricts the records available from a particular data source before they are used throughout the workbook. This can be useful when analysts want every worksheet using that source to work with a defined subset of the available records. For example, a workbook may intentionally limit analysis to a particular business unit or reporting period. Because the restriction applies at the data-source level, it can affect multiple sheets that depend on that source. This makes data source filters useful for centralized filtering requirements across a workbook.

Question 206.

Which Tableau feature allows one field to contain multiple categorical members?

1. Grouping
2. Formatting
3. Sorting
4. Forecasting

Correct Answer: 1

Explanation:

Grouping allows related members of a categorical dimension to be combined into a larger analytical category. This can simplify visualizations when many individual members need to be treated as broader business segments. For example, several product categories could be grouped into a higher-level classification for reporting purposes. Formatting changes visual appearance, sorting controls ordering, and forecasting estimates future values from historical patterns. Grouping is therefore useful when the analyst needs to consolidate selected dimension members without modifying the original source records themselves.

Question 207.

What does a geographic role assign to a field?

1. A numerical aggregation
2. A spatial interpretation
3. A calculation dependency
4. A filter priority

Correct Answer: 2

Explanation:

A geographic role tells Tableau how to interpret a field as geographic information. When a field receives an appropriate geographic role, Tableau can use recognized geographic values to support map-based analysis. Examples can include countries, states, cities, postal codes, and other supported geographic categories. The role provides Tableau with information about the spatial meaning of the field rather than defining its aggregation or filter behavior. Correct geographic interpretation is important when creating maps because ambiguous or incorrectly classified values may prevent Tableau from locating records as expected.

Question 208.

What does the WINDOW_SUM function calculate?

1. A cumulative source total
2. A fixed member count
3. A window-based total
4. A row-level conversion

Correct Answer: 3

Explanation:

WINDOW_SUM calculates the sum of an expression across a specified window within a table calculation. The calculation operates over the marks defined by the table-calculation addressing and partitioning settings. This makes it useful for analytical tasks such as comparing an individual value with a broader total or calculating totals across a selected range of marks. It differs from an ordinary SUM because WINDOW_SUM works within the table-calculation framework of the visualization. Changing the addressing or window boundaries can therefore change which marks contribute to the resulting value.

Question 209.

Which Tableau object can store a reusable collection of selected records?

1. Set
2. Folder
3. Caption
4. Worksheet

Correct Answer: 1

Explanation:

A set stores a defined collection of members from a dimension and can be used repeatedly in analysis. Sets may be based on manually selected members or created through dynamic conditions. Once established, they can support comparisons, calculations, and interactive analytical scenarios. A folder organizes fields, a caption provides descriptive text, and a worksheet contains a visualization. Sets are particularly valuable when analysts need to distinguish a selected subset from the rest of a population and then use that distinction as part of the analytical logic.

Question 210.

Which Tableau action can move viewers to another dashboard?

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

Correct Answer: 2

Explanation:

A navigation action allows users to move from one dashboard or sheet to another through an interactive control or selected element. This can help create guided analytical experiences where viewers begin with an overview and then open a more detailed page. Highlight actions emphasize related marks, set actions modify set membership, and filter actions restrict displayed data. Navigation is therefore the appropriate action type when the intended interaction is movement between different workbook destinations. Analysts can use it to organize complex dashboards into logical stages without placing every visualization on one screen.

Question 211.

What does Tableau’s Data Interpreter primarily help with?

1. Cleaning spreadsheet structure
2. Creating database indexes
3. Scheduling server jobs
4. Publishing user accounts

Correct Answer: 1

Explanation:

Data Interpreter helps Tableau identify and clean common structural issues in spreadsheet-based data. It can assist with removing extraneous formatting, detecting table areas, and interpreting headers or other spreadsheet elements so the actual analytical dataset can be recognized more effectively. It is not a database-indexing system, server scheduling mechanism, or user-account management feature. This capability can be particularly helpful when working with spreadsheets designed for human presentation rather than analysis. Proper interpretation of the source structure can reduce preparation effort before fields are used in Tableau visualizations.

Question 212.

Which calculation compares a value with the immediately preceding mark?

1. RUNNING_AVG
2. LOOKUP
3. WINDOW_MEDIAN
4. RANK_PERCENTILE

Correct Answer: 2

Explanation:

LOOKUP can retrieve a value from a relative position within the table-calculation partition. Using an offset of -1 allows the current mark to reference the preceding mark, which is useful for period-over-period comparisons. Analysts can then subtract the previous value from the current value or calculate a percentage change. Other table calculations serve different purposes: running averages accumulate observations progressively, window medians summarize a range, and percentile ranking determines relative standing. LOOKUP is especially useful when the analytical question depends on accessing a neighboring value rather than aggregating an entire window.

Question 213.

Which Tableau view is useful for showing values across two categorical dimensions?

1. Filled map
2. Gantt view
3. Highlight table
4. Symbol timeline

Correct Answer: 3

Explanation:

A highlight table displays values in a tabular arrangement while using visual encoding, commonly color intensity, to emphasize differences. It is useful when analysts need to compare measures across two categorical dimensions while retaining the structure of a table. For example, products can appear along one dimension and regions along another, with cell appearance indicating performance. This combines the readability of a table with visual pattern recognition. It differs from geographic views, timelines, and duration-focused displays because its primary purpose is comparing values across categorical intersections.

Question 214.

What does a continuous field generally create on an axis?

1. A connected scale
2. A member checklist
3. A categorical header
4. A text annotation

Correct Answer: 1

Explanation:

A continuous field produces a continuous range of values and commonly appears as an axis in Tableau. The axis represents an ordered numerical or temporal scale, allowing marks to occupy positions throughout the available range. Discrete fields instead create separate headers or individual categories. Understanding the distinction between continuous and discrete fields is important because changing this characteristic can alter both the visual structure and the way Tableau displays the field. Continuous values are especially useful for showing trends, distributions, and relationships where the numerical distance between values has analytical meaning.

Question 215.

Which chart is specifically suited to displaying ranges and quartiles?

1. Heat map
2. Box plot
3. Funnel chart
4. Area chart

Correct Answer: 2

Explanation:

A box plot summarizes the distribution of numerical data using statistical elements such as quartiles, median, and overall spread. It can also help identify observations that fall unusually far from the central distribution. Box plots are useful when comparing distributions across multiple categories because each category can have its own summary structure. Heat maps emphasize values through color, funnel charts represent sequential stages, and area charts emphasize change over an ordered axis. When the analytical requirement involves understanding quartiles and distribution spread, a box plot is an appropriate Tableau visualization.

Question 216.

What does the EXCLUDE LOD expression remove from view-level detail?

1. A data source
2. A specified dimension
3. A workbook permission
4. A worksheet object

Correct Answer: 2

Explanation:

An EXCLUDE level-of-detail expression removes one or more specified dimensions from the level of detail used for the calculation. This can help analysts calculate a value at a broader granularity than the current visualization. For example, an analysis may display individual products while calculating a value that excludes product detail. FIXED expressions explicitly define a fixed dimensionality, while INCLUDE adds specified dimensions. EXCLUDE is therefore useful when the calculation should ignore a particular dimension that is otherwise present in the visualization’s level of detail.

Question 217.

Which dashboard layout method places objects independently of the grid?

1. Tiled placement
2. Floating placement
3. Automatic sizing
4. Standard spacing

Correct Answer: 2

Explanation:

Floating placement allows dashboard objects to be positioned independently and layered within the dashboard space. This provides greater control over precise placement and can be useful when creating custom dashboard compositions. Tiled objects participate in the dashboard’s layout structure and generally arrange themselves within containers. Automatic sizing concerns how the dashboard adapts to available display dimensions, while spacing controls separation between objects. Floating layouts can offer flexibility, but analysts should manage them carefully because highly customized positioning may require additional attention across different screen sizes.

Question 218.

Which Tableau feature can let users choose a reporting metric dynamically?

1. Parameter
2. Geographic role
3. Data relationship
4. Extract refresh

Correct Answer: 1

Explanation:

A parameter can provide a user-controlled value that drives dynamic analytical logic. One common design is allowing viewers to choose which metric should be displayed, with a calculation responding to the selected parameter value. This can reduce the need to create separate worksheets for every possible metric. Geographic roles describe spatial fields, relationships connect logical tables, and extract refresh controls how stored data is updated. Parameters are therefore valuable when dashboard designers want viewers to influence calculations or display behavior through a controlled selection.

Question 219.

What does an incremental extract refresh add?

1. Only newly available records
2. Entire workbook metadata
3. Dashboard formatting rules
4. Deleted worksheet objects

Correct Answer: 1

Explanation:

An incremental extract refresh is designed to add newly available records rather than rebuilding the entire extract from scratch. It can be useful when a data source continually receives additional records and historical data does not normally change. The refresh relies on an appropriate field that allows Tableau to identify records that should be added. This approach can reduce the amount of data that must be processed during each refresh compared with a full rebuild. Analysts should still verify that the source’s update pattern is compatible with incremental-refresh requirements.

Question 220.

Which Tableau capability identifies groups of similar observations?

1. Forecasting
2. Clustering
3. Aggregation
4. Formatting

Correct Answer: 2

Explanation:

Clustering groups observations according to similarities in selected measures or dimensions. Tableau can use clustering to help analysts explore natural groupings within a dataset without manually defining every category in advance. This can support exploratory analysis, segmentation, and pattern discovery. Forecasting focuses on estimating future values, aggregation summarizes records, and formatting changes presentation. Clustering should be interpreted as an analytical grouping technique rather than proof that the resulting groups represent definitive business categories. Analysts should review the variables and methodology used to understand what drives the resulting clusters.