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

 

Question 221.

Which Tableau function converts text into uppercase characters?

1. UPPER
2. PROPER
3. LOWER
4. CAPITALIZE

Correct Answer: 1

Explanation:

The UPPER function converts alphabetic characters in a text value to uppercase. It is useful when standardizing textual data for presentation or comparison. For example, customer codes or category labels may need consistent capitalization before being displayed or analyzed. LOWER performs the opposite conversion by producing lowercase text. PROPER is used for title-style capitalization where supported, while CAPITALIZE is not the standard Tableau function for this purpose. Text normalization can improve consistency when values originate from multiple systems and use different capitalization conventions.

Question 222.

Which Tableau feature combines fields into a drillable structure?

1. Worksheet
2. Container
3. Hierarchy
4. Caption

Correct Answer: 3

Explanation:

A hierarchy organizes related fields into levels that users can explore through drill-down and drill-up interactions. A common example is arranging geographic fields from country to state to city. Hierarchies make it easier to navigate from summarized information toward more detailed views without manually replacing fields each time. A worksheet contains a visualization, a container organizes dashboard objects, and a caption provides descriptive text. By structuring related dimensions into levels, hierarchies support efficient exploration of data at different granularities within Tableau.

Question 223.

What does a join primarily determine between database tables?

1. Visual formatting
2. Row matching
3. Color encoding
4. Axis scaling

Correct Answer: 2

Explanation:

A join determines how rows from two tables are combined according to matching fields. Different join types control which records remain in the resulting physical table. An inner join keeps matching records, while outer joins can preserve unmatched records from one or both sides. This behavior directly affects the resulting dataset and can sometimes introduce duplicated rows when tables contain multiple matching records. Visual formatting, color encoding, and axis scaling occur later during visualization. Analysts should understand join cardinality and matching keys before relying on the resulting data for calculations.

Question 224.

Which Tableau function extracts a portion from the beginning of a string?

1. RIGHT
2. REPLACE
3. LEFT
4. SPLIT

Correct Answer: 3

Explanation:

The LEFT function returns a specified number of characters from the beginning of a string. It can be useful when an identifier has a meaningful prefix or when analysts need to separate the leading portion of a text value through calculation. RIGHT retrieves characters from the opposite end, REPLACE substitutes text, and SPLIT separates a string using a delimiter. String functions are frequently used during data preparation when source systems store multiple logical components inside one text field. Selecting the appropriate function depends on the position and structure of the desired characters.

Question 225.

What does Tableau aggregation change about measure values?

1. It summarizes records
2. It renames dimensions
3. It changes permissions
4. It removes worksheets

Correct Answer: 1

Explanation:

Aggregation summarizes multiple underlying records into a value appropriate for the current level of detail in a visualization. Common aggregations include SUM, AVG, MIN, MAX, MEDIAN, and COUNT. For example, when a measure is aggregated as SUM by region, Tableau calculates the total for each displayed region rather than showing every underlying transaction separately. Aggregation therefore influences the numerical values presented in the view while respecting its dimensional granularity. It does not rename fields, modify permissions, or remove workbook objects. Analysts should always consider the selected aggregation when interpreting measures.

Question 226.

Which filter type limits values at the worksheet visualization level?

1. Extract filter
2. Data source filter
3. Dimension filter
4. Server restriction

Correct Answer: 3

Explanation:

A dimension filter restricts members of a categorical field used in the analysis. For example, an analyst can limit a view to selected regions, product families, or customer segments. The filter affects the relevant worksheet rather than universally changing the source data itself. Extract filters operate while creating or refreshing stored extract data, while data source filters can apply restrictions across worksheets using that source. Server restrictions relate to access or governance rather than ordinary visualization filtering. Understanding filter scope helps analysts control exactly where a filtering decision should take effect.

Question 227.

Which Tableau function returns the highest value in a set of records?

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

Correct Answer: 2

Explanation:

The MAX function returns the highest value from the records included in the calculation. It can be applied to numerical values, dates, and other supported comparable data types. For example, an analyst might use MAX to identify the latest transaction date or highest recorded sales amount within a particular level of detail. MIN returns the lowest value, AVG calculates an average, and COUNT counts records or values according to the expression. Selecting MAX is appropriate when the analytical requirement is to identify the uppermost value rather than summarize the dataset through a central tendency.

Question 228.

What does a discrete date field usually display as?

1. A separate header
2. A continuous axis
3. A calculated trend
4. A geographic mark

Correct Answer: 1

Explanation:

A discrete date field typically creates separate headers for its displayed date parts, such as individual years, quarters, or months. These values are treated as distinct categories rather than positions along one continuous scale. A continuous date field instead creates an axis where time progresses along a continuous range. This distinction affects the structure of the visualization and the way Tableau organizes marks. Analysts can switch between discrete and continuous date representations depending on whether they need categorical comparisons or a continuous temporal progression.

Question 229.

Which Tableau function can replace matching text with another value?

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

Correct Answer: 3

Explanation:

The REPLACE function substitutes occurrences of specified text with another text value. It is useful when analysts need to standardize labels, correct known text patterns, or transform values according to a consistent rule. FIND identifies the position of one string within another, CONTAINS checks whether a string includes specified text, and LEN measures string length. REPLACE therefore directly addresses situations where existing text must be changed. Careful use of string replacement can help clean inconsistent source values before they are grouped, filtered, or presented in dashboards.

Question 230.

Which visualization emphasizes changes in magnitude over time using filled regions?

1. Area chart
2. Scatter view
3. Box display
4. Symbol map

Correct Answer: 1

Explanation:

An area chart uses filled regions to emphasize how a measure changes across an ordered axis, commonly time. The filled area makes the magnitude and progression of values visually prominent and can be especially useful when showing cumulative or component trends. Scatter views focus on relationships between numerical variables, box displays summarize distributions, and symbol maps emphasize geographic locations. Area charts can also be used with multiple categories, although analysts should be cautious about excessive overlap because many filled regions can make comparisons harder to interpret.

Question 231.

What does a calculated field allow an analyst to create?

1. Derived analytical logic
2. Database credentials
3. Workbook ownership
4. Hardware configuration

Correct Answer: 1

Explanation:

A calculated field allows analysts to define new values using Tableau expressions based on existing data. Calculations can perform arithmetic, conditional logic, string manipulation, date operations, aggregations, and other analytical tasks. For example, an analyst can derive profit ratio from existing sales and profit measures. Calculated fields extend the analytical capabilities of a dataset without requiring the original source table to be permanently modified. They do not manage credentials, ownership, or hardware. Properly designed calculations can make recurring analytical logic reusable throughout a workbook.

Question 232.

Which Tableau feature can visually emphasize selected marks without removing others?

1. Filter interaction
2. Highlight action
3. Data-source rule
4. Extract refresh

Correct Answer: 2

Explanation:

A highlight action emphasizes related marks while keeping the other marks visible. This allows viewers to focus attention on a selected category or related data without filtering the rest of the visualization away. For example, selecting a customer segment can visually emphasize corresponding marks across another chart while preserving the broader context. A filter interaction removes or restricts records from the affected view, whereas data-source rules and extract refreshes address data handling. Highlight actions are therefore useful when context should remain visible while attention is directed toward a selected subset.

Question 233.

Which measure summarizes the arithmetic center of numerical observations?

1. MEDIAN
2. MODE
3. AVERAGE
4. RANGE

Correct Answer: 3

Explanation:

AVERAGE calculates the arithmetic mean of numerical observations by combining their values and dividing by the relevant number of observations. It is widely used to summarize typical numerical performance, although extreme values can substantially influence the result. MEDIAN identifies the middle position of ordered observations, MODE identifies the most frequently occurring value where applicable, and RANGE describes the spread between minimum and maximum values. Analysts should select the summary measure that matches the distribution and analytical purpose rather than assuming that an average always represents a typical observation.

Question 234.

What does a parameter action allow a dashboard user to do?

1. Modify a parameter value
2. Rename a workbook
3. Delete source tables
4. Change server licensing

Correct Answer: 1

Explanation:

A parameter action allows an interaction in a visualization to change the value of a parameter. This enables dashboards to respond dynamically to user selections without requiring the user to manually open a parameter control. The changed parameter can then influence calculations, reference values, or other analytical behavior. Renaming workbooks, deleting source tables, and changing server licensing are unrelated administrative activities. Parameter actions are especially useful for interactive analytical designs where a mark selection should directly control a calculation or visualization setting.

Question 235.

Which Tableau visualization is designed to compare parts within a hierarchy?

1. Treemap
2. Histogram
3. Dot plot
4. Line graph

Correct Answer: 1

Explanation:

A treemap represents hierarchical data through nested rectangular areas. The size of each rectangle can encode a measure, while color can represent another dimension or measure. This makes treemaps useful for examining how categories contribute to a larger hierarchy and identifying relatively large or small members quickly. Histograms show numerical distributions, dot plots compare individual or aggregated points, and line graphs emphasize trends along an ordered axis. Treemaps are most effective when the hierarchy and part-to-whole relationship are important components of the analytical question.

Question 236.

Which table-calculation function counts rows in the current partition?

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

Correct Answer: 2

Explanation:

The SIZE table calculation returns the number of rows in the current partition. This can help analysts understand partition length or build calculations that depend on how many marks are present. INDEX returns the position of the current mark, while FIRST and LAST provide offsets relative to the beginning or end of the partition. Because table calculations depend on the arrangement of marks, changing addressing or partitioning can affect the calculation context. SIZE is therefore useful when analytical logic needs to know the number of marks available within the current table-calculation partition.

Question 237.

Which Tableau feature can display a shaded interval around a reference value?

1. Reference band
2. Text annotation
3. Shape legend
4. Data label

Correct Answer: 1

Explanation:

A reference band displays a shaded range between two values or around a meaningful benchmark in a visualization. Analysts can use reference bands to show acceptable ranges, confidence-related intervals, target zones, or other meaningful boundaries. A reference line generally marks a single value, while annotations and labels provide textual information. A shape legend explains symbol encoding rather than defining an analytical interval. Reference bands are useful when the audience needs to compare marks against a range instead of evaluating them against only one threshold.

Question 238.

What does a live connection generally query?

1. Stored workbook images
2. Original data source
3. Dashboard cache only
4. Static worksheet notes

Correct Answer: 2

Explanation:

A live connection queries the original data source when Tableau needs data for analysis. This can provide access to relatively current source information without requiring the data to be stored as a Tableau extract. The exact freshness depends on the source system and connection behavior. A stored extract, by contrast, maintains a separate Tableau-managed representation of the data that can be refreshed. Choosing a live connection or extract depends on requirements such as data freshness, source performance, network conditions, and workbook responsiveness.

Question 239.

Which Tableau feature can divide a continuous numeric field into equal-width categories?

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

Correct Answer: 2

Explanation:

A bin divides numerical values into intervals according to a specified size. These intervals can then be used as categories in a visualization, making bins particularly useful for frequency distributions and histogram-style analysis. A hierarchy organizes fields into levels, an alias changes displayed member names, and a group combines selected categorical members. Binning does not alter the original numerical values; instead, it creates grouped ranges that provide another way to analyze them. Analysts should choose a bin size that provides useful detail without producing an overly fragmented visualization.

Question 240.

Which dashboard feature controls how content adapts to different screen dimensions?

1. Device layout
2. Data relationship
3. Calculation editor
4. Source credential

Correct Answer: 1

Explanation:

Device layouts allow dashboard designers to configure how dashboard content is presented for different device types and screen dimensions. This is useful when a workbook needs to remain readable across desktop, tablet, or phone displays. A dashboard designed only for a large monitor may not automatically provide the same usability on a smaller screen, so device-specific arrangements can improve presentation. Relationships, calculation editors, and source credentials address entirely different areas of Tableau. Device layouts are therefore an important consideration when publishing dashboards for audiences using varied display environments.