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

 

Question 161.

Which Tableau feature allows a user to change a displayed measure dynamically?

1. Data extract
2. Parameter
3. Reference line
4. Worksheet title

Correct Answer: 2

Explanation:

A parameter can let users select among different values or choices that influence a Tableau calculation. For example, a dashboard can allow a user to switch between Sales, Profit, and Quantity using a parameter-driven calculation. The parameter itself does not directly filter records; instead, calculated logic can reference its selected value. This makes parameters useful for interactive dashboards where one visualization needs to support multiple analytical perspectives. Designers should provide clear parameter labels and appropriate available values so users understand what their selection controls and how it changes the displayed analysis.

Question 162.

Which Tableau feature combines similar members under one label?

1. Extract
2. Hierarchy
3. Group
4. Calculation

Correct Answer: 3

Explanation:

A group combines selected members of a dimension into a single category for analysis. This is useful when several source values should be treated as one business category without changing the underlying database. For example, individual product categories can be grouped into broader market segments. Groups can then be used in worksheets, filters, and calculations like other dimensions. They are particularly useful when the desired analytical classification does not already exist in the source data. Analysts should review group membership carefully so that each category reflects the intended business definition.

Question 163.

Which Tableau feature organizes related dimensions into levels?

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

Correct Answer: 1

Explanation:

A hierarchy organizes related dimensions into a logical sequence of detail. A common example is a geographic hierarchy containing Country, State, and City. Users can expand or collapse levels to move between summarized and detailed views. Hierarchies make exploration easier because related fields can be navigated in an intuitive order. They do not change the original source data but provide a structured way to analyze it. When designing a hierarchy, analysts should place broader categories above more detailed fields and ensure that the sequence reflects the natural structure of the information being explored.

Question 164.

Which Tableau calculation can compare a value with its previous mark?

1. Running total
2. Percentile
3. Difference
4. Rank

Correct Answer: 3

Explanation:

The Difference From table calculation compares a value with another value according to the selected table-calculation direction. When configured to compare with the previous value, it can reveal increases or decreases between consecutive periods. For example, monthly revenue can be compared with the preceding month to show the change between periods. The calculation depends on the ordering and addressing of the visualization. Analysts should verify that dates or categories are sorted correctly before interpreting the results. Difference calculations are useful when absolute values alone do not clearly communicate how performance is changing.

Question 165.

Which Tableau calculation can express change relative to a prior value?

1. Percent difference
2. Index
3. Total count
4. Minimum

Correct Answer: 1

Explanation:

Percent difference expresses the change between values relative to a comparison value. It is useful for understanding proportional increases or decreases rather than only absolute differences. For example, an analyst can compare this month’s revenue with the previous month’s revenue and display the change as a percentage. The calculation depends on the chosen addressing and comparison direction. Analysts should make the comparison period clear because different reference points can produce different percentages. Percent-difference calculations are commonly useful in performance reporting, trend analysis, and period-over-period comparisons where relative movement is more informative than raw numerical change.

Question 166.

What does the Tableau ATTR aggregation indicate?

1. Multiple rows deleted
2. Single displayed value
3. Numeric field converted
4. Date hierarchy created

Correct Answer: 2

Explanation:

ATTR, or Attribute, is an aggregation that returns a value when the underlying members within the relevant level of detail are consistent. When multiple different values exist, Tableau can display an asterisk to indicate that the values are not uniquely determined at that level. ATTR is often useful for displaying descriptive fields in views where aggregation is required. It does not mean that the source contains only one record. Analysts should understand the level of detail of the visualization before interpreting ATTR results because the displayed value depends on the members included in the relevant partition.

Question 167.

Which Tableau function converts a string into a date using a format?

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

Correct Answer: 2

Explanation:

DATEPARSE converts text representing a date into a Tableau date value according to a specified format pattern. This is useful when source systems store dates as strings rather than native date fields. For example, a text value containing a month, day, and year can be interpreted as a proper date when the corresponding format is provided. Correct formatting is essential because Tableau needs to understand the arrangement of the components. Once converted, the resulting date can support filtering, sorting, date calculations, and time-based visualization. Analysts should validate unusual or incomplete source values before relying on the parsed results.

Question 168.

Which Tableau function calculates an absolute numerical value?

1. ABS
2. ROUND
3. CEILING
4. FLOOR

Correct Answer: 1

Explanation:

The ABS function returns the absolute value of a number, removing its negative sign when one exists. This is useful when the magnitude of a difference matters but its direction does not. For example, an analyst might use ABS to calculate the size of a variance regardless of whether the variance is positive or negative. ABS can be incorporated into larger calculated fields when measuring distances, deviations, or other numerical differences. Analysts should use it only when direction is intentionally irrelevant because converting negative values to positive values can otherwise hide important information about whether an outcome represents an increase or decrease.

Question 169.

Which function rounds a number to a specified decimal precision?

1. ABS
2. INT
3. ROUND
4. SIGN

Correct Answer: 3

Explanation:

ROUND adjusts a numerical value to a specified number of decimal places. It is useful when calculated results contain more precision than is necessary for reporting or presentation. For example, an analyst can round a calculated percentage to two decimal places to improve readability. Rounding should generally be applied thoughtfully because it changes the displayed or calculated result depending on where the function is used. Analysts should distinguish rounding for presentation from rounding used inside analytical logic. Excessive rounding can introduce small differences in totals or comparisons, particularly when many values are aggregated after individual rounding.

Question 170.

Which function returns the whole-number portion of a value?

1. ROUND
2. FLOOR
3. CEILING
4. INT

Correct Answer: 4

Explanation:

The INT function converts a numerical value to an integer according to Tableau’s integer conversion behavior. It is useful when a calculation requires whole-number output rather than decimal precision. Analysts may use INT when creating categories, simplifying numerical values, or preparing calculations that require integer results. It is important to understand how negative values are handled because integer conversion and mathematical rounding functions can behave differently. When precise rounding direction matters, functions such as FLOOR, CEILING, or ROUND may be more appropriate. Selecting the correct numerical function helps prevent unexpected results in analytical calculations.

Question 171.

Which Tableau feature can display a range between two reference values?

1. Reference band
2. Data group
3. Measure filter
4. Sheet container

Correct Answer: 1

Explanation:

A reference band displays a visual range between two defined values in a Tableau view. It can be used to show acceptable limits, target intervals, average ranges, or other meaningful boundaries. For example, a performance chart can include a band representing a desired operating range so users can immediately see whether observations fall inside or outside it. Reference bands add context without changing the underlying data. Analysts should define meaningful boundaries and provide clear labels when necessary. The interpretation of a reference band depends on the business context, so its values should be based on appropriate analytical or organizational criteria.

Question 172.

Which Tableau capability can show a value directly on a mark?

1. Detail shelf
2. Label
3. Pages shelf
4. Data source pane

Correct Answer: 2

Explanation:

The Label property can display text or values directly on marks in a Tableau visualization. Labels can help users identify categories, numerical values, or other relevant information without hovering over marks. They are particularly useful in charts where a limited number of marks need direct identification. However, adding labels to a visualization with many marks can create clutter and reduce readability. Analysts should select only the most useful information for display. Label formatting, positioning, and content should support the purpose of the visualization rather than overwhelming users with unnecessary details.

Question 173.

Which Tableau shelf controls the detail level of marks?

1. Detail
2. Pages
3. Filters
4. Caption

Correct Answer: 1

Explanation:

The Detail shelf controls which dimensions contribute to the level of detail represented by marks in a visualization. Adding a dimension to Detail can cause Tableau to create more granular marks without necessarily displaying that field as a visible label. This is useful when an analyst needs calculations or visual marks to reflect additional categories. For example, adding Customer ID to Detail can create customer-level marks while the customer names remain hidden. Understanding the Detail shelf is important because changing the level of detail can significantly affect aggregation, mark count, and the interpretation of measures displayed in the view.

Question 174.

Which Tableau shelf can animate changes across a field’s members?

1. Pages
2. Columns
3. Rows
4. Marks

Correct Answer: 1

Explanation:

The Pages shelf can divide a visualization into separate pages based on the members of a selected field. Users can move through those pages to examine how the visualization changes across the selected dimension. For example, placing a year field on Pages can allow users to inspect each year’s view sequentially. This can support exploratory analysis when comparing states across categories or time periods. The Pages shelf does not permanently filter the underlying dataset; it controls which page or member is currently displayed. Analysts should use it when sequential exploration provides value without making the visualization difficult to understand.

Question 175.

Which Tableau mark type is useful for displaying individual geographic locations?

1. Polygon
2. Circle
3. Line
4. Area

Correct Answer: 2

Explanation:

Circle marks are commonly used to represent individual geographic locations on a Tableau map. Their position indicates the geographic location, while properties such as size and color can represent measures or categories. For example, circles can show store locations with size representing sales volume. Circle-based maps are useful when the primary goal is to compare locations rather than display geographic boundaries. Analysts should consider overlapping marks when many locations are close together. Adjusting size, transparency, filtering, or other visual properties can help users distinguish locations while maintaining useful geographic context.

Question 176.

Which map mark type is suited to showing geographic boundaries?

1. Circle
2. Line
3. Polygon
4. Shape

Correct Answer: 3

Explanation:

Polygon marks are useful for representing geographic areas with boundaries, such as states, countries, sales territories, or custom regions. Instead of showing only a point location, polygons display the actual shape of the geographic area. Measures can be encoded using color or other supported visual properties. Polygon maps are particularly valuable when the area itself is analytically important. Analysts should ensure that geographic boundaries are appropriate for the level of analysis because very detailed shapes can increase visual complexity. Proper geographic fields and mapping data are also necessary for Tableau to draw meaningful polygon-based representations.

Question 177.

Which Tableau feature displays data at successive time periods interactively?

1. Pages control
2. Alias menu
3. Group editor
4. Format panel

Correct Answer: 1

Explanation:

The Pages control works with the Pages shelf to let users move through members of a selected field sequentially. When a time field is placed there, users can inspect how a visualization changes from one period to another. This provides an interactive way to explore temporal states without creating a separate worksheet for every period. Pages can also be used with other dimensions when sequential examination is useful. Analysts should ensure that the selected field has a meaningful order so that moving between pages communicates a logical progression rather than an arbitrary sequence.

Question 178.

Which Tableau feature allows one field to control several worksheets?

1. Workbook parameter
2. Dashboard filter
3. Data source name
4. Worksheet caption

Correct Answer: 2

Explanation:

A dashboard filter can be configured to affect multiple worksheets that use compatible fields or data sources. This allows users to make one selection and have several related visualizations respond together. For example, selecting a region can update sales, profit, and customer charts simultaneously. Applying a filter across worksheets helps create coordinated dashboard interactions and reduces the need for users to repeat the same selection. Analysts should confirm which worksheets are targeted because an overly broad filter can remove useful context. Clear filter titles and logical scope make multi-sheet filtering easier for users to understand.

Question 179.

Which Tableau capability can display several worksheets together?

1. Dashboard
2. Calculation
3. Data source
4. Extract

Correct Answer: 1

Explanation:

A dashboard combines multiple worksheets and supporting objects into a single interactive layout. This allows users to examine several related perspectives at the same time. Dashboards can contain charts, tables, filters, images, text, legends, and interactive controls. Analysts can arrange these elements according to the intended user workflow and screen size. The goal is to provide a coherent analytical experience rather than simply placing many charts together. Effective dashboards generally emphasize relevant information, consistent formatting, and useful interactions. Designers should test dashboards with realistic user scenarios to identify confusing navigation or excessive visual complexity.

Question 180.

Which Tableau feature can provide a guided sequence of analytical views?

1. Worksheet
2. Story
3. Data source
4. Extract

Correct Answer: 2

Explanation:

A Tableau story provides a sequence of story points that can present related visualizations in a guided order. Each point can contain a worksheet or dashboard and can communicate a particular stage of an analysis. Stories are useful when users need structured progression through findings rather than unrestricted exploration of a single dashboard. Analysts can use captions and annotations to explain important observations along the sequence. A story should maintain a logical narrative so that each point contributes to the overall analytical purpose. This format can be particularly useful for presentations, reporting walkthroughs, and structured data exploration.