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

 

Question 281.

Which Tableau feature can combine several worksheets into a navigable presentation?

1. Story
2. Relationship
3. Extract
4. Data role

Correct Answer: 1

Explanation:

A Tableau story combines multiple views or dashboards into a sequence of story points. This allows an analyst to guide viewers through a series of related analytical findings or perspectives. Each point can contain a different visualization while contributing to a broader narrative. Relationships define how logical tables interact, extracts store prepared data, and data roles describe field interpretation. Stories are particularly useful when an analysis needs to communicate progression rather than present every visualization simultaneously. Analysts can arrange story points in an order that helps viewers understand the analytical sequence.

Question 282.

What does a Tableau alias primarily change?

1. Source data values
2. Displayed member names
3. Database permissions
4. Calculation results

Correct Answer: 2

Explanation:

An alias changes how a discrete member is displayed in Tableau without changing the underlying source value. This can make technical or abbreviated labels easier for dashboard viewers to understand. For example, a source system might use a short code while the workbook displays a more descriptive business label. Aliases affect presentation rather than permanently modifying the source database. They are especially useful when the underlying values must remain unchanged for data integrity, while the visualization requires clearer terminology for its audience.

Question 283.

Which Tableau function returns the position of a substring?

1. FIND
2. CONTAINS
3. TRIM
4. REPLACE

Correct Answer: 1

Explanation:

The FIND function searches for a specified substring and returns its position within another string. This can support text-processing calculations where the location of a character sequence determines subsequent logic. For example, an analyst could locate a delimiter before extracting another part of a text value. CONTAINS checks whether text occurs, TRIM removes surrounding spaces, and REPLACE substitutes matching text. FIND is therefore appropriate when the calculation needs the numerical location of the matching substring rather than simply a true-or-false result.

Question 284.

Which Tableau object is used to organize dashboard components spatially?

1. Parameter
2. Layout container
3. Calculated field
4. Geographic role

Correct Answer: 2

Explanation:

A layout container organizes dashboard objects into horizontal or vertical structures. Containers help analysts control alignment, spacing, and positioning of worksheets and other dashboard elements. They can make complex dashboards easier to maintain because related objects can be managed as a group rather than positioned individually. Parameters provide interactive values, calculated fields create derived logic, and geographic roles identify spatial meaning. Proper use of layout containers can also help dashboards adapt more consistently when their dimensions or device-specific layouts change.

Question 285.

Which Tableau aggregation identifies the earliest date?

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

Correct Answer: 3

Explanation:

When MIN is applied to a date field, it returns the earliest date within the relevant aggregation context. This can be useful for identifying the first transaction, initial activity, earliest shipment, or beginning of a reporting period. MAX returns the latest date, COUNT measures the number of records or values, and SUM adds numerical values. The result of MIN depends on the level of detail and filters affecting the visualization. Analysts should therefore verify the grouping context before interpreting the returned date as the overall earliest value in the entire dataset.

Question 286.

Which Tableau option can display multiple measures using separate axes?

1. Dual-axis
2. Story point
3. Data interpreter
4. Geographic role

Correct Answer: 1

Explanation:

A dual-axis visualization places two measures on separate axes within the same view. This can help analysts compare measures with different scales while maintaining a shared visual context. Synchronization can sometimes be applied when the measures should use comparable scales. Story points organize narrative views, Data Interpreter helps interpret spreadsheet structures, and geographic roles identify spatial fields. Dual-axis charts should be designed carefully because combining unrelated measures can make interpretation difficult. When two related measures need to be compared in one visualization, a dual-axis configuration can be useful.

Question 287.

What does Tableau’s ATTR aggregation display for a single distinct value?

1. The unique value
2. The total amount
3. The record count
4. The calculated rank

Correct Answer: 1

Explanation:

ATTR displays a field value when only one distinct value exists for the relevant mark. If multiple distinct values are present, Tableau displays an asterisk instead. This makes ATTR useful when an analyst expects a field to have one value at a particular level of detail but wants Tableau to indicate when that assumption is not true. ATTR is not equivalent to SUM, COUNT, or RANK. Understanding its behavior can help analysts diagnose differences in granularity and recognize situations where multiple underlying values exist behind a single displayed mark.

Question 288.

Which Tableau control can let viewers choose a numeric threshold?

1. Filter card
2. Parameter control
3. Legend selector
4. Sheet navigator

Correct Answer: 2

Explanation:

A parameter control allows viewers to select or enter a value that can influence workbook calculations. A numeric parameter can represent a threshold, target, comparison value, or other analytical input. A calculation can then use that parameter to determine conditions or displayed results. A filter card restricts members of a field, while a legend selector and sheet navigator serve different interactive purposes. Parameters are particularly valuable when the user needs to provide an analytical assumption rather than simply select existing members from a dataset.

Question 289.

Which Tableau calculation returns the largest value across a window?

1. WINDOW_MAX
2. WINDOW_SUM
3. WINDOW_AVG
4. WINDOW_COUNT

Correct Answer: 1

Explanation:

WINDOW_MAX returns the highest value of an expression across the specified table-calculation window. It can be useful when an analyst needs to compare each mark against the maximum value within a selected range. WINDOW_SUM calculates a total, WINDOW_AVG produces an average, and WINDOW_COUNT counts values or rows according to the expression and calculation context. The exact result depends on the window boundaries and the table-calculation partition. Analysts should verify addressing and partitioning settings to ensure that the intended marks are included in the maximum calculation.

Question 290.

Which dashboard action emphasizes related marks while keeping them visible?

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

Correct Answer: 2

Explanation:

A highlight action emphasizes related marks without removing the remaining marks from the visualization. This allows users to focus on a selected category while preserving the surrounding analytical context. A filter action restricts displayed data, a navigation action moves users to another workbook location, and a URL action opens an external destination. Highlighting is useful when the dashboard should show both the selected subset and the broader population. It is especially effective for exploratory dashboards where viewers need to understand how selected marks relate to other visible data.

Question 291.

Which Tableau feature represents numerical ranges as separate intervals?

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

Correct Answer: 3

Explanation:

A bin creates intervals from a continuous numerical field using a specified size. Each numerical observation is assigned to the appropriate interval, allowing the resulting ranges to be analyzed as categories. Bins are commonly used when creating frequency distributions or examining how values are spread across numerical ranges. Groups combine selected categorical members, sets represent collections of members, and aliases modify displayed names. Choosing a suitable bin size is important because very small intervals may create excessive detail, while very large intervals can hide meaningful variation.

Question 292.

What does a context filter create before dependent filters execute?

1. A filtered subset
2. A new workbook
3. A dashboard copy
4. A second data source

Correct Answer: 1

Explanation:

A context filter establishes a filtered subset that Tableau can use as the basis for subsequent filtering operations. This is useful when one filter needs to define the working population before another filter is evaluated. For example, an analyst may first restrict data to a particular business area and then apply another filter within that reduced population. Context filters do not create new workbooks or duplicate data sources. They influence Tableau’s filtering order and can be helpful for specific analytical requirements involving dependent filtering logic.

Question 293.

Which Tableau calculation can return a date shifted by several months?

1. DATEDIFF
2. DATEADD
3. YEAR
4. DATETRUNC

Correct Answer: 2

Explanation:

DATEADD shifts a date by a specified number of date units, including months. For example, an analyst can use it to calculate a date three months after an existing date or to reference a previous period by applying a negative offset. DATEDIFF measures the distance between two dates, YEAR extracts a year component, and DATETRUNC aligns a date with the beginning of a selected period. DATEADD is therefore appropriate when the requirement is to move an existing date forward or backward by a defined temporal interval.

Question 294.

Which visualization uses rectangles to compare hierarchical magnitudes?

1. Treemap
2. Histogram
3. Scatter diagram
4. Line display

Correct Answer: 1

Explanation:

A treemap uses nested rectangles to represent hierarchical categories, with area commonly encoding a quantitative measure. This allows viewers to compare relative magnitudes while also seeing how categories fit within larger groups. Histograms organize numerical observations into intervals, scatter diagrams compare quantitative measures, and line displays emphasize movement across an ordered dimension. Treemaps are particularly helpful when an analyst needs to communicate both hierarchy and part-to-whole relationships. They should be designed with care when many categories exist because small rectangles can become difficult to distinguish.

Question 295.

Which Tableau function counts unique members of a field?

1. COUNT
2. SUM
3. COUNTD
4. TOTAL

Correct Answer: 3

Explanation:

COUNTD counts distinct values in a field, making it useful when repeated occurrences should be counted only once. For example, a transaction dataset may contain many purchases from the same customer, but COUNTD can determine the number of unique customers represented. COUNT counts records or values depending on the expression, while SUM adds numerical values. TOTAL is not the standard aggregation used to count distinct members. Distinct counting is particularly important in customer, product, account, and other entity-based analyses where repeated transactions should not inflate the number of unique entities.

Question 296.

Which Tableau feature supports alternate dashboard arrangements for phones?

1. Device layout
2. Data blending
3. Source filter
4. Calculation editor

Correct Answer: 1

Explanation:

Device layouts allow dashboard authors to define how content should be arranged for different device categories, including phones. A desktop dashboard may contain several visualizations positioned side by side, while a phone layout may need a more compact or vertically organized arrangement. Data blending combines analytical information from separate sources, source filters restrict available records, and calculation editors define expressions. Device layouts therefore address presentation across screen types and can improve readability when the same dashboard must serve users with different display dimensions.

Question 297.

Which table calculation identifies the final position offset?

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

Correct Answer: 2

Explanation:

LAST returns the number of positions between the current mark and the final mark in the table-calculation partition. It is useful when calculations need to reference the relative location of a mark from the end of the partition. FIRST provides the corresponding offset from the beginning, INDEX returns the current position, and SIZE returns the total number of rows. Because these functions depend on the table-calculation structure, their results can change when addressing or partitioning changes. Understanding their positional behavior is important for advanced table calculations.

Question 298.

Which Tableau chart is commonly used to examine value concentration?

1. Density plot
2. Gantt chart
3. Bullet graph
4. Filled map

Correct Answer: 1

Explanation:

A density plot helps reveal where observations are concentrated by representing areas with greater or lower mark density. It can be useful for exploring distributions, especially when many individual marks overlap in a conventional visualization. Gantt charts focus on durations, bullet graphs compare performance with benchmarks, and filled maps emphasize geographic regions. Density views can make clusters and concentrations easier to recognize without requiring every individual mark to remain visually distinct. Analysts should still consider the underlying distribution and the selected dimensions when interpreting density patterns.

Question 299.

Which Tableau function returns the current mark’s sequential position?

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

Correct Answer: 2

Explanation:

INDEX returns the sequential position of the current mark within the table-calculation partition. It can be used when analytical logic depends on the order of marks, such as identifying positions or creating position-based calculations. FIRST and LAST provide offsets from the beginning and end of the partition, respectively, while SIZE returns the number of rows. The meaning of INDEX depends on how the table calculation is addressed and partitioned. Analysts should therefore configure the view carefully before interpreting the returned index as a meaningful ranking or sequence.

Question 300.

Which Tableau feature can show an expected value as a line across a chart?

1. Reference line
2. Data label
3. Layout container
4. Story point

Correct Answer: 4

Explanation:

A story point is used to organize a sequence of views within a Tableau story, not to draw a benchmark across a chart. A reference line is the Tableau feature designed to display a constant or calculated benchmark across an applicable axis. Data labels show values near marks, while layout containers organize dashboard objects. When analysts need to compare chart values against a target or statistical benchmark, a reference line provides the appropriate visual mechanism. This distinction is important because dashboard and story objects serve structural purposes rather than directly encoding analytical thresholds.