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

 

Question 61

Which calculation can conditionally return different results?

1. IF
2. COUNT
3. MIN
4. INDEX

Correct Answer: 1

Explanation:

The IF function evaluates a logical condition and returns one result when the condition is true and another when it is false. It is commonly used to create classifications, conditional measures, and business rules. For example, an analyst can classify orders as high or low value based on a sales threshold. IF expressions can also be extended with ELSEIF and ELSE clauses for more complex conditional logic.

Question 62

Which function returns the first non-null expression?

1. ISNULL
2. IFNULL
3. COUNTD
4. ATTR

Correct Answer: 2

Explanation:

IFNULL checks whether an expression is null and returns an alternative value when it is. If the original expression contains a valid value, that value is retained. This makes IFNULL useful for replacing missing labels, values, or descriptive information. Unlike ZN, which specifically substitutes zero for null numeric results, IFNULL allows the analyst to specify the replacement expression.

Question 63

Which function converts a value into a string?

1. INT
2. FLOAT
3. STR
4. DATE

Correct Answer: 3

Explanation:

STR converts an expression into a string value. This can be useful when numerical or other values need to be combined with text or displayed as labels. For example, an analyst might convert a numeric identifier into text before concatenating it with another textual field. Data-type conversion should be used carefully because converting a field to text can change how Tableau handles sorting and mathematical operations.

Question 64

Which function rounds a numerical expression?

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

Correct Answer: 4

Explanation:

ROUND changes a numerical value to a specified number of decimal places. It is useful when calculations produce excessive precision that is unnecessary for reporting. For example, an analyst can round a calculated margin to two decimal places for clearer presentation. ROUND differs from FLOOR and CEILING because it uses conventional rounding rather than always moving toward a particular numerical direction.

Question 65

Which function returns the absolute value of a number?

1. ABS
2. SIGN
3. SQRT
4. POWER

Correct Answer: 1

Explanation:

ABS returns the absolute value of a number, removing its negative sign when necessary. For example, ABS(-25) returns 25. This can be useful when an analysis focuses on magnitude rather than direction, such as measuring the size of a variance. The function does not change positive values and does not itself indicate whether the original value was above or below zero.

Question 66

What does the FLOOR function do?

1. Finds a square root
2. Rounds downward
3. Calculates a percentage
4. Returns a remainder

Correct Answer: 2

Explanation:

FLOOR returns the largest integer that is less than or equal to a specified numerical value. It therefore moves a value downward toward the next lower integer. This can be useful when calculations require whole-number grouping or controlled numerical thresholds. FLOOR differs from ROUND because it does not use conventional rounding rules and from CEILING because CEILING moves values upward.

Question 67

Which function extracts a portion of text using a delimiter?

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

Correct Answer: 3

Explanation:

SPLIT separates a string into parts based on a specified delimiter. For example, an email address can potentially be separated using the appropriate character to isolate different components. This is useful when a single source field contains multiple pieces of information that should be analyzed separately. SPLIT can help transform structured text without requiring changes to the original source database.

Question 68

Which function removes leading and trailing spaces?

1. LOWER
2. UPPER
3. CONTAINS
4. TRIM

Correct Answer: 4

Explanation:

TRIM removes unnecessary spaces from the beginning and end of a string. This can help standardize textual values before comparisons, grouping, or matching operations. Extra spaces in source data can cause values that appear identical to behave differently in analysis. Cleaning strings with TRIM can therefore improve consistency without changing the meaningful characters contained within the field.

Question 69

Which function checks whether text contains a specified pattern?

1. CONTAINS
2. STARTSWITH
3. ENDSWITH
4. FIND

Correct Answer: 1

Explanation:

CONTAINS tests whether a string includes a specified sequence of characters and returns a Boolean result. It can be used in calculated fields to classify records based on text content. For example, an analyst could identify descriptions containing a particular keyword. This function is useful for flexible text-based conditions when the matching text can occur anywhere within the target string.

Question 70

Which function returns the position of text within another string?

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

Correct Answer: 2

Explanation:

FIND returns the position where a specified substring occurs within another string. This can help analysts locate text patterns or build calculations that depend on where certain characters appear. It is particularly useful when working with structured strings that contain information in predictable positions. FIND differs from CONTAINS because it provides a location rather than simply indicating whether the text exists.

Question 71

Which chart is particularly useful for showing magnitude through color intensity?

1. Symbol map
2. Area chart
3. Heat map
4. Circle chart

Correct Answer: 3

Explanation:

A heat map uses color intensity to communicate quantitative differences across categories or combinations of dimensions. It can make concentration and variation easier to recognize within a compact space. For example, an analyst can compare product categories against regions and use shading to represent sales. Careful use of color intensity is important so that differences remain understandable and the visualization does not become visually overwhelming.

Question 72

Which map type fills geographic areas with color?

1. Density map
2. Symbol map
3. Point map
4. Filled map

Correct Answer: 4

Explanation:

A filled map shades geographic areas according to a selected measure or category. This is useful when the analytical question concerns values associated with regions such as states, provinces, or countries. Color intensity can communicate differences among those areas. Filled maps differ from symbol maps, which typically place marks at geographic locations rather than filling the boundaries of geographic regions.

Question 73

What does a density map emphasize?

1. Concentrations of marks
2. Field descriptions
3. Table calculations
4. Date hierarchies

Correct Answer: 1

Explanation:

A density map emphasizes areas where geographic marks are concentrated. Instead of showing each point equally, it helps reveal clusters and high-density regions through visual intensity. This is particularly useful with large numbers of geographic observations, such as locations of customers or service requests. Density visualizations can make spatial patterns easier to identify when individual marks would otherwise overlap heavily.

Question 74

Which dashboard layout keeps objects arranged in a structured grid?

1. Floating
2. Tiled
3. Layered
4. Freeform

Correct Answer: 2

Explanation:

Tiled dashboard objects are arranged within a structured layout where objects occupy designated areas of the dashboard. As additional objects are added, Tableau organizes them within the available layout. This approach can make dashboards easier to maintain and align consistently across different sections. Floating objects, in contrast, can be positioned more freely and may overlap other dashboard elements.

Question 75

What does a floating dashboard object allow?

1. Automatic aggregation
2. Data blending
3. Independent positioning
4. Extract encryption

Correct Answer: 3

Explanation:

A floating dashboard object can be positioned independently within the dashboard rather than being constrained to the tiled layout structure. This provides greater control over placement and can allow objects to overlap. Floating elements are useful when precise visual positioning is required, although excessive use can make dashboards harder to maintain consistently. Analysts should balance flexibility with a clear and stable layout.

Question 76

Which dashboard feature provides different layouts for device types?

1. Containers
2. Sheets
3. Device layouts
4. Pages

Correct Answer: 4

Explanation:

Device layouts allow analysts to design dashboard presentations for different screen types, such as desktop, tablet, or phone. Because available screen space varies considerably, a dashboard that works well on a large monitor may require rearrangement on a smaller display. Device-specific layouts help preserve usability and readability by adapting dashboard objects to the characteristics of the target device.

Question 77

What does a filter action typically do between dashboard views?

1. Restricts related data
2. Changes workbook ownership
3. Creates an extract
4. Alters field data types

Correct Answer: 1

Explanation:

A filter action allows an interaction in one dashboard view to filter related information in another view. Selecting a mark, category, or other source element can therefore narrow the data displayed elsewhere. This creates interactive dashboards where users can explore details without manually adjusting each worksheet. The action depends on correctly configured source and target sheets and appropriate linking fields.

Question 78

Which action can open an external webpage from a dashboard?

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

Correct Answer: 2

Explanation:

A URL action can direct users to a specified web address based on an interaction within a Tableau dashboard. The URL can incorporate field values when dynamic navigation is needed. This can connect dashboard analysis with external documentation, websites, or related resources. URL actions differ from filter and highlight actions because their primary purpose is navigation rather than changing the displayed marks.

Question 79

Which dashboard element can display additional details on hover?

1. Caption
2. Legend
3. Tooltip
4. Header

Correct Answer: 3

Explanation:

A tooltip appears when users hover over a mark and can provide additional contextual information without adding permanent visual elements to the chart. Analysts can configure tooltips to display relevant dimensions, measures, and explanatory text. Well-designed tooltips can support exploration while keeping the primary visualization uncluttered. They are particularly useful for providing exact values behind marks that communicate broader patterns visually.

Question 80

Which feature can control visibility of dashboard zones based on conditions?

1. Parameters
2. Filters
3. Containers
4. Dynamic zone visibility

Correct Answer: 4

Explanation:

Dynamic zone visibility allows dashboard zones to appear or disappear based on a controlling condition. This can create more responsive interfaces by showing content only when it is relevant to the user’s selection or state. For example, an additional detail panel can remain hidden until a particular condition is met. This approach can help reduce visual clutter while still providing access to deeper information when needed.