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

 

Question 241.

Which Tableau function returns characters from the end of text?

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

Correct Answer: 3

Explanation:

The RIGHT function extracts a specified number of characters from the end of a string. It is useful when identifiers contain meaningful suffixes, such as region codes, product endings, or final digits. LEFT performs the same type of extraction from the beginning, while MID retrieves characters from a specified position. SPLIT separates text according to a delimiter. Using the appropriate string function helps analysts transform source values into useful analytical fields without changing the original data. RIGHT is therefore suitable whenever the required text appears at the end of the source string.

Question 242.

What does an inner join retain from two related tables?

1. Matching records only
2. Left-side records only
3. Right-side records only
4. Unmatched records exclusively

Correct Answer: 1

Explanation:

An inner join retains records where the specified join conditions match between the participating tables. Records without a corresponding match are excluded from the resulting joined table. This makes an inner join useful when analysis should focus only on entities represented in both datasets. Other join types behave differently: left joins preserve all records from the left table, right joins preserve records from the right table, and full outer joins can preserve unmatched records from both sides. Analysts should select the join type according to which records need to remain available for analysis.

Question 243.

Which Tableau function checks whether text contains a specified sequence?

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

Correct Answer: 2

Explanation:

The CONTAINS function tests whether a string includes a specified substring and returns a Boolean result. This makes it useful for conditional calculations and text-based filtering logic. For example, analysts can check whether a customer description contains a particular keyword before assigning a category. FIND instead returns the position of a substring, while STARTSWITH and ENDSWITH evaluate whether text begins or ends with a specified sequence. Choosing CONTAINS is appropriate when the requirement is simply to determine whether the target text occurs anywhere within another string.

Question 244.

Which Tableau object can contain multiple worksheets on a single canvas?

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

Correct Answer: 2

Explanation:

A dashboard combines multiple worksheets and other supported objects into one interactive canvas. This allows analysts to present complementary visualizations together and create a consolidated analytical experience. For example, a dashboard might contain a trend chart, a categorical comparison, and a geographic view. A data source provides the underlying data, a calculation creates derived analytical logic, and an extract stores a prepared data representation. Dashboards are therefore the primary Tableau object used when multiple visual views need to be presented together for exploration or reporting.

Question 245.

What does a full outer join preserve?

1. Left matches exclusively
2. Right matches exclusively
3. Records from both sides
4. Only identical keys

Correct Answer: 3

Explanation:

A full outer join preserves records from both participating tables, including rows that do not have a matching key on the opposite side. Where a match does not exist, fields from the other table can contain null values. This makes a full outer join useful when analysts need to identify both matching and unmatched records across two datasets. An inner join keeps matching rows only, while left and right joins prioritize one side. Understanding these differences helps prevent accidental data loss when combining tables for analytical purposes.

Question 246.

Which Tableau calculation determines the rank of a value?

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

Correct Answer: 1

Explanation:

The RANK family of table calculations determines the relative position of values within a partition according to their ordering. Ranking can help analysts identify high-performing products, customers, regions, or other categories. INDEX instead provides the current positional index, SIZE counts rows in the partition, and FIRST provides an offset from the first position. Ranking behavior depends on the selected addressing and ordering of the visualization. Analysts should therefore verify how the table calculation is configured before interpreting the resulting positions as meaningful rankings.

Question 247.

Which Tableau feature can restrict access using user-specific data values?

1. Data blending
2. Row-level security
3. Visual sorting
4. Workbook styling

Correct Answer: 2

Explanation:

Row-level security restricts which records a user can access based on an identifying value such as username, department, region, or another security attribute. This allows different users to work with the same analytical asset while receiving only the records they are authorized to view. Data blending combines information from separate sources, visual sorting changes mark order, and workbook styling controls presentation. Row-level security is therefore a governance mechanism rather than a visualization feature. Its implementation should be carefully tested to ensure that access rules consistently restrict the intended records.

Question 248.

What does the COUNTD aggregation measure?

1. Total numeric magnitude
2. Distinct value quantity
3. Highest observed value
4. Average record size

Correct Answer: 2

Explanation:

COUNTD returns the number of distinct values represented by a field. It is useful when repeated records should count as one unique entity. For example, analysts can use COUNTD to determine how many different customers appear in a transaction dataset, regardless of how many purchases each customer made. SUM measures a numerical total, MAX identifies the highest value, and AVG calculates an arithmetic mean. COUNTD is particularly valuable when the business question concerns unique entities rather than the total number of rows or transactions.

Question 249.

Which Tableau visualization is useful for displaying correlation between two measures?

1. Scatter plot
2. Text table
3. Filled map
4. Area chart

Correct Answer: 1

Explanation:

A scatter plot places observations according to two numerical measures, allowing analysts to examine relationships, concentration, and potential outliers. Patterns in the plotted marks can reveal whether higher values of one measure tend to occur with higher or lower values of another. A text table emphasizes exact values, a filled map emphasizes geographic regions, and an area chart focuses on change along an ordered axis. Scatter plots are therefore especially useful during exploratory analysis when the relationship between two quantitative variables is an important part of the question.

Question 250.

Which Tableau feature can divide a dashboard into structured sections?

1. Worksheet title
2. Layout container
3. Data role
4. Reference line

Correct Answer: 2

Explanation:

A layout container organizes dashboard objects into structured horizontal or vertical sections. Containers help maintain consistent positioning and spacing when multiple worksheets, filters, text objects, or other components are placed together. They can also make dashboard resizing and alignment easier to manage than positioning every object independently. Worksheet titles describe individual views, data roles provide field interpretation, and reference lines establish visual benchmarks. Layout containers are therefore an important design mechanism for building organized dashboards with predictable structure and relationships among their components.

Question 251.

Which date function returns the year component of a date?

1. DATEPART
2. YEAR
3. DATETRUNC
4. MAKEDATE

Correct Answer: 2

Explanation:

The YEAR function returns the year component from a date value. It can be useful when analysts need to categorize records by calendar year or create calculations involving annual comparisons. DATEPART can retrieve different date components depending on the requested part, while DATETRUNC changes a date to the beginning of a specified period. MAKEDATE constructs a date from supplied components. YEAR is therefore the direct choice when the analytical requirement is to extract the calendar year from an existing date field.

Question 252.

What does a left join preserve regardless of matching?

1. Right-table rows
2. Left-table rows
3. Matching rows only
4. Duplicate keys only

Correct Answer: 2

Explanation:

A left join preserves every record from the left table, whether or not a corresponding record exists in the right table. When no match is found, the fields contributed by the right table are typically null for that record. This join type is useful when the left dataset represents the primary population that must remain complete while additional information is optionally added from another table. An inner join would remove unmatched left records. Understanding which side must remain complete is essential when selecting a join type for analytical data preparation.

Question 253.

Which Tableau function truncates a date to a specified period?

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

Correct Answer: 3

Explanation:

DATETRUNC changes a date value to the beginning of a specified date period, such as the beginning of a month, quarter, or year. This is useful when analysts need dates to align at a consistent temporal granularity for grouping or comparison. DATEADD shifts a date by a specified interval, DATEDIFF calculates the difference between dates, and TODAY returns the current date. DATETRUNC is therefore appropriate when the objective is to normalize dates to the start of a selected period rather than calculate an offset or difference.

Question 254.

Which Tableau chart emphasizes individual observations along an axis?

1. Dot plot
2. Filled map
3. Treemap
4. Gantt chart

Correct Answer: 1

Explanation:

A dot plot represents individual or aggregated observations as points positioned along an axis. It can make differences between categories easier to compare while keeping the marks relatively simple. Filled maps use geographic regions, treemaps use nested rectangles to represent hierarchical proportions, and Gantt charts emphasize duration. Dot plots are particularly useful when analysts want to compare discrete observations without the visual complexity of bars or areas. They can also support distribution-focused analysis when multiple marks are displayed across a shared quantitative scale.

Question 255.

What does the DATEADD function do?

1. Extracts a date component
2. Shifts a date value
3. Counts calendar records
4. Identifies duplicate dates

Correct Answer: 2

Explanation:

DATEADD shifts a date by a specified number of units, such as days, months, quarters, or years. It is useful for calculations that require a date offset, including comparisons against prior periods or creating future reference dates. DATETRUNC serves a different purpose by aligning dates to the beginning of a selected period. DATEDIFF calculates the distance between dates rather than moving one. DATEADD therefore fits analytical scenarios where an existing date needs to be systematically moved forward or backward by a defined interval.

Question 256.

Which Tableau feature changes displayed member names without altering source values?

1. Alias
2. Bin
3. Parameter
4. Extract

Correct Answer: 1

Explanation:

An alias allows an analyst to change how a discrete member is displayed without modifying the underlying source value. This can improve readability when source labels are technical, abbreviated, or inconsistent with business terminology. The original data remains unchanged, while Tableau presents the assigned alias in the relevant view. Bins create numerical ranges, parameters provide user-controlled values, and extracts store prepared data. Aliases are therefore useful for presentation and labeling needs when the source values should remain intact for other processes or systems.

Question 257.

Which Tableau option can automatically generate suggested analytical explanations?

1. Explain Data
2. Data Interpreter
3. Measure Names
4. Metadata grid

Correct Answer: 1

Explanation:

Explain Data can provide automated analytical insights about selected marks when Tableau identifies supported relationships or unusual values worth investigating. It can help users explore possible factors associated with an observation without manually constructing every potential comparison. Data Interpreter instead focuses on improving the interpretation of spreadsheet structure. Measure Names is a special field used for organizing measures in visualizations, while a metadata grid is not the primary feature for automated analytical explanations. Explain Data can therefore support exploratory analysis by suggesting additional views or relationships for investigation.

Question 258.

What does a parameter differ from a standard dimension filter?

1. It accepts controlled input
2. It always removes rows
3. It requires geographic data
4. It permanently changes source records

Correct Answer: 1

Explanation:

A parameter provides a controlled value that can be used by calculations and other workbook logic. Unlike a standard dimension filter, it is not inherently limited to selecting members from a particular field. A parameter can represent numbers, strings, dates, or other supported value types and can influence dynamic analytical behavior. A dimension filter directly restricts members from its associated field. Parameters therefore provide greater flexibility when dashboard designers need user input to control calculations, thresholds, metric selection, or other visualization behavior.

Question 259.

Which Tableau function calculates the difference between two dates?

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

Correct Answer: 3

Explanation:

DATEDIFF calculates the difference between two date values according to a specified date part, such as days, weeks, months, or years. It is useful for measuring durations such as customer tenure, order processing time, or the number of days between events. DATEADD shifts dates by an interval, DATETRUNC aligns them to a period boundary, and MAKEDATE constructs a date from supplied components. DATEDIFF should be selected when the analytical requirement is to determine the elapsed amount between two dates rather than modify either date.

Question 260.

Which dashboard action can change membership in a set?

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

Correct Answer: 2

Explanation:

A set action allows interactions in a visualization to add or remove members from a set. This enables dashboards to support interactive segmentation and comparison scenarios. For example, selecting marks can dynamically determine which members belong to a set, while calculations can use that set to compare selected and unselected populations. URL actions open external destinations, navigation actions move between workbook locations, and highlight actions emphasize related marks. Set actions are therefore particularly useful when user selections should dynamically influence set-based analytical logic.