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

 

Question 181.

Which Tableau feature combines records from tables with matching columns?

1. Data blending
2. Union
3. Cross-database linking
4. Spatial matching

Correct Answer: 2

Explanation:

A union combines rows from tables that have compatible column structures. Tableau appends the records vertically, making it useful when datasets contain similar fields across multiple files or tables. For example, monthly sales files can be unioned into one larger dataset when their columns follow the same structure. Data blending works differently by combining aggregated results from separate data sources. Relationships and joins connect tables based on fields rather than simply stacking records. Understanding when to use a union helps analysts consolidate recurring datasets efficiently without manually combining every file.

Question 182.

What does Tableau’s logical layer primarily define?

1. Worksheet formatting
2. Dashboard navigation
3. Table relationships
4. Calculation syntax

Correct Answer: 3

Explanation:

Tableau’s logical layer defines how tables relate to one another within the data model. Analysts can connect tables using relationships without immediately forcing them into one physical joined table. Tableau determines how to query the related tables based on fields used in a visualization. This approach can help preserve each table’s level of detail and reduce unintended duplication that may occur with poorly designed joins. The physical layer sits underneath the logical layer and contains joins and unions used to construct individual logical tables. Therefore, logical relationships are the primary focus of this modeling layer.

Question 183.

Which calculation returns the number of characters in a text value?

1. LEN
2. MID
3. FIND
4. REPLACE

Correct Answer: 1

Explanation:

The LEN function returns the number of characters contained in a string. It is useful when analysts need to evaluate text length, identify unusually short or long values, or support data-quality checks. MID extracts a portion of a string based on a starting position and length. FIND searches for the location of one string within another. REPLACE substitutes one portion of text with another value. When the analytical requirement is specifically to measure the size of a text value, LEN is the appropriate Tableau string function.

Question 184.

What does a context filter establish in Tableau?

1. A workbook permission
2. A dashboard container
3. A temporary filtering subset
4. A separate filtering context

Correct Answer: 4

Explanation:

A context filter creates a separate filtering context that Tableau processes before certain other filters. This can be useful when a secondary filter should operate against a reduced subset of the data. Context filters are particularly helpful in scenarios involving dependent filtering logic or large datasets where narrowing the working data first may improve query efficiency. They differ from ordinary dimension filters because Tableau establishes the context before applying subsequent filters that depend on it. Context filtering should be used intentionally because unnecessary context filters can sometimes add processing overhead rather than improve performance.

Question 185.

Which chart is designed to display the distribution of numerical values?

1. Histogram
2. Treemap
3. Gantt chart
4. Symbol map

Correct Answer: 1

Explanation:

A histogram displays the distribution of numerical values by grouping observations into intervals called bins. The resulting bars show how frequently values occur within each range. This makes histograms useful for examining concentration, spread, skewness, and potential outliers in quantitative data. A treemap represents hierarchical proportions using nested rectangles. A Gantt chart focuses on durations across a timeline, while a symbol map places marks geographically. For Tableau analysts investigating how measurements are distributed across numeric ranges, a histogram provides a direct visual representation of the underlying frequency pattern.

Question 186.

What does the ATTR aggregation indicate when multiple values exist?

1. A hidden duplicate
2. A calculated average
3. A mixed-value condition
4. A missing relationship

Correct Answer: 3

Explanation:

ATTR, or attribute aggregation, displays a value when the underlying records contain a single distinct value for the relevant mark. When multiple distinct values exist, Tableau displays an asterisk to indicate that the values are not identical. This makes ATTR useful when a field is expected to have one value at a particular level of detail but the underlying data may contain several values. It is not itself an average or a direct indicator of duplicated records. Analysts should understand ATTR behavior when reviewing dimensions placed in views that involve aggregation.

Question 187.

Which Tableau object lets users choose among predefined values interactively?

1. Set control
2. Parameter control
3. Filter shelf
4. Measure selector

Correct Answer: 2

Explanation:

A parameter control allows users to select or enter a value that can influence calculations, reference lines, filters, or other workbook behavior. Unlike a conventional filter, a parameter is not inherently tied to the members of a particular field. It can provide a controlled input that drives dynamic analytical logic. For example, a parameter might let users select a comparison threshold or choose which measure a visualization displays. This makes parameters useful for interactive dashboards where the analyst wants viewers to modify analytical assumptions without changing the underlying data structure.

Question 188.

Which LOD expression calculates results at a specified fixed dimension level?

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

Correct Answer: 3

Explanation:

A FIXED level-of-detail expression calculates a result using the dimensions explicitly specified inside the expression, independently of the dimensions displayed in the visualization. This makes FIXED useful when an analyst needs a stable calculation at a particular granularity. INCLUDE adds specified dimensions to the view’s level of detail, while EXCLUDE removes specified dimensions from it. WINDOW functions belong to table calculations and operate across the marks available in the visualization. Choosing the correct LOD type depends on whether the desired calculation should be fixed, expanded, or reduced relative to the view’s dimensionality.

Question 189.

What does a Tableau set primarily represent?

1. A selected member collection
2. A numerical interval
3. A date hierarchy
4. A calculated aggregate

Correct Answer: 1

Explanation:

A Tableau set represents a defined collection of data members. Sets can be created manually or dynamically using conditions or top/bottom rules. They are useful for comparing selected groups against the remaining population, creating set-based calculations, and supporting interactive analysis. A set is different from a bin, which groups numeric values into intervals, and different from a hierarchy, which organizes fields into levels. Sets can also participate in dashboard interactions when users need to explore membership dynamically. Their ability to divide data into meaningful member collections makes them useful for comparative analytical scenarios.

Question 190.

Which function retrieves a value from a previous table-calculation position?

1. INDEX
2. FIRST
3. LOOKUP
4. SIZE

Correct Answer: 3

Explanation:

The LOOKUP table calculation retrieves the value of an expression from a specified relative position within the table calculation. For example, an offset of -1 can reference the preceding position, making LOOKUP useful for comparisons such as period-over-period changes. INDEX returns the current position of a mark within the calculation. FIRST identifies the offset from the first position, while SIZE returns the number of rows in the partition. LOOKUP therefore provides a convenient method for accessing values from neighboring positions when building comparative calculations across ordered marks in a Tableau view.

Question 191.

Which Tableau feature groups numeric values into defined intervals?

1. Bins
2. Aliases
3. Folders
4. Captions

Correct Answer: 1

Explanation:

Bins divide continuous numerical values into ranges of equal size based on the selected bin size. They are commonly used for histograms and frequency analysis. For example, a numerical field containing customer ages can be divided into defined intervals so the analyst can examine how many customers fall within each range. Aliases change displayed names for members, folders organize fields in the Data pane, and captions provide descriptive text. Bins are therefore specifically designed to transform individual numerical observations into grouped ranges that can be analyzed and visualized.

Question 192.

What does a table calculation primarily operate across?

1. Source-table schemas
2. Visible marks
3. Database indexes
4. File partitions

Correct Answer: 2

Explanation:

Table calculations operate across the marks present in a Tableau visualization. Their results depend on how the calculation is addressed and partitioned within the view. This allows analysts to calculate running totals, rankings, moving averages, differences, and other calculations based on the displayed arrangement of data. Because table calculations depend on the view, changing dimensions or the addressing direction can change their results. This behavior differs from many regular calculated fields and LOD expressions, which evaluate according to data-level logic rather than primarily following the visual table’s arrangement.

Question 193.

Which chart best compares actual performance against a target?

1. Bullet graph
2. Density chart
3. Packed bubble view
4. Highlight table

Correct Answer: 1

Explanation:

A bullet graph is designed to compare a primary measure against a target or reference value while also showing qualitative performance ranges. It provides a compact way to evaluate whether actual performance is below, near, or above an intended benchmark. Density charts emphasize concentrations of marks, packed bubbles use size and position for categorical comparison, and highlight tables use color to emphasize values in a tabular layout. Bullet graphs are particularly useful for KPI-style reporting where a target comparison is more important than displaying detailed individual observations.

Question 194.

What is the main purpose of a dashboard action?

1. Change workbook ownership
2. Trigger interactive behavior
3. Rename database columns
4. Compress an extract

Correct Answer: 2

Explanation:

Dashboard actions create interactive behavior between visual elements. Depending on the action type, selecting or hovering over a mark can filter another view, highlight related data, modify set membership, navigate to another dashboard, or support other interactive workflows. Actions help transform a static dashboard into an exploratory analytical interface. They do not primarily manage workbook ownership, rename database fields, or compress extracts. When designing dashboards, analysts can use actions to connect related views and allow users to investigate patterns without manually configuring each visualization separately.

Question 195.

Which aggregation returns the middle value of an ordered dataset?

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

Correct Answer: 3

Explanation:

MEDIAN returns the middle value of a dataset when the observations are ordered. If there is an even number of observations, the median is determined from the central values according to the calculation method. Median is often useful when the data contains extreme values because it can provide a more resistant measure of central tendency than an average. SUM totals values, COUNT determines the number of records or values depending on the expression, and MIN identifies the smallest value. Therefore, MEDIAN is the appropriate aggregation when the analytical requirement is the central ordered value.

Question 196.

Which feature can place a constant threshold directly across a view?

1. Reference line
2. Data relationship
3. Geographic role
4. Worksheet title

Correct Answer: 1

Explanation:

A reference line adds a visual benchmark at a specified value on an axis. Analysts can use it to represent targets, averages, thresholds, or other meaningful comparison points. For example, a sales visualization can include a reference line showing the required performance level. Data relationships define connections between tables, geographic roles identify how fields should be interpreted geographically, and worksheet titles describe the visualization. Reference lines are therefore a practical analytical aid for comparing displayed marks against a fixed or calculated benchmark.

Question 197.

Which Tableau capability predicts future values from historical time-series data?

1. Forecasting
2. Clustering
3. Grouping
4. Profiling

Correct Answer: 1

Explanation:

Tableau forecasting can generate estimates of future values from historical time-series data. It is useful when a visualization contains suitable chronological observations and the analyst wants to extend the displayed pattern into a future period. Forecasting is different from clustering, which groups observations based on similarity, and grouping, which combines selected dimension members. The resulting forecast should be interpreted as an analytical estimate rather than a guarantee of future performance. Analysts should also consider data quality, seasonality, historical patterns, and the limitations of the available time-series information.

Question 198.

What does an extract provide compared with a live connection?

1. Cached analytical data
2. Editable database schema
3. Automatic source ownership
4. Permanent transaction locking

Correct Answer: 1

Explanation:

A Tableau extract is a stored representation of data that can be queried efficiently by Tableau. Because the data is stored separately from the original source, extracts can support responsive analysis and can reduce dependence on repeated live queries against an external database. A live connection instead queries the underlying source as needed. Extracts can also support refresh strategies so the stored data remains current according to the configured schedule or process. Choosing between live connections and extracts depends on factors such as freshness requirements, source performance, data volume, and workbook usage patterns.

Question 199.

Which view is most suitable for showing geographic patterns by region?

1. Map view
2. Gantt timeline
3. Funnel diagram
4. Text-only report

Correct Answer: 1

Explanation:

A map view is appropriate when the analysis depends on geographic location or regional distribution. Tableau can use recognized geographic fields to generate marks positioned according to their locations. Analysts can encode measures using size, color, or other visual properties to reveal regional differences. A Gantt timeline is intended for duration-based analysis, while a funnel diagram focuses on sequential stages and a text-only report lacks spatial representation. When location is an important analytical dimension, a map can make geographic patterns and regional variation easier to identify.

Question 200.

Which table-calculation function returns the current mark’s position?

1. LAST
2. INDEX
3. WINDOW_MAX
4. RUNNING_SUM

Correct Answer: 2

Explanation:

INDEX returns the position of the current mark within the table-calculation partition. It is commonly used when analysts need to identify or work with the relative position of marks in a visualization. LAST returns the offset from the final position, while WINDOW_MAX calculates the maximum value across a specified window. RUNNING_SUM accumulates values progressively through the addressed sequence. Understanding these functions helps analysts build more advanced table calculations where the location of each mark within the partition affects the calculation logic or the resulting visualization.