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

 

Question 41

Which join returns unmatched rows from both tables?

1. Full outer join
2. Inner join
3. Left join
4. Right join

Correct Answer: 1

Explanation:

A full outer join preserves all records from both tables. Matching records are combined, while records without a counterpart remain in the result with null values for the missing side. This join is useful when an analyst needs to identify both matching and unmatched records across datasets. For example, comparing two customer lists can reveal customers appearing in only one of the sources.

Question 42

What does a right join preserve from the second table?

1. Matching records only
2. All records
3. Left-side records
4. Shared columns

Correct Answer: 2

Explanation:

A right join preserves every record from the right-hand table while bringing in matching information from the left-hand table. When no corresponding left-side record exists, Tableau returns null values for those fields. The right join is useful when the second table represents the population that must remain complete. It is conceptually the reverse of a left join because the preserved side changes.

Question 43

What does disaggregation do to measure values?

1. Converts them to dimensions
2. Removes all measures
3. Displays individual values
4. Creates new bins

Correct Answer: 3

Explanation:

Disaggregation causes Tableau to display individual underlying measure values instead of combining them into an aggregate. This can expose the distribution of observations and make individual records visible in a visualization. It is useful when the analyst needs to inspect record-level variation rather than summarize the data. Disaggregation can also increase the number of marks substantially, so it should be used carefully with large datasets.

Question 44

What does aggregation generally do to multiple records?

1. Splits them into rows
2. Converts fields to strings
3. Removes dimensions
4. Summarizes their values

Correct Answer: 4

Explanation:

Aggregation summarizes multiple underlying records into a value based on a chosen aggregation such as SUM, AVG, MIN, MAX, or COUNT. Tableau commonly aggregates measures automatically when they are placed in a visualization. Aggregation reduces many underlying observations into a smaller number of displayed results according to the view’s level of detail. Selecting an appropriate aggregation is essential for accurate interpretation.

Question 45

Which function counts distinct values in a field?

1. COUNTD
2. COUNT
3. MEDIAN
4. WINDOW_SUM

Correct Answer: 1

Explanation:

COUNTD counts distinct values in a field rather than counting every non-null record. For example, COUNTD(Customer ID) can determine how many unique customers are represented, even when individual customers have multiple transactions. This differs from COUNT, which counts non-null values and can therefore count the same customer multiple times. Distinct counting is particularly useful for customer, account, product, or transaction analysis.

Question 46

What does ATTR return when a field has one value?

1. A running sum
2. That single value
3. A sorted rank
4. A percentage

Correct Answer: 2

Explanation:

The ATTR aggregation displays a field’s value when all records represented by the mark contain the same value. When multiple different values exist, Tableau indicates that the value is not uniquely determined. ATTR is frequently useful for displaying descriptive fields in views where Tableau expects an aggregation. It can therefore help expose whether the underlying records represented by a mark share a common attribute.

Question 47

Which calculation returns the median of numerical values?

1. TOTAL
2. WINDOW_AVG
3. MEDIAN
4. COUNTD

Correct Answer: 3

Explanation:

MEDIAN returns the middle value of an ordered dataset, or the midpoint between two middle values when the number of observations is even. It can provide a useful measure of central tendency when extreme values might distort an average. For example, median delivery time can sometimes represent typical performance differently from mean delivery time. Tableau supports MEDIAN as an aggregation for suitable numerical fields.

Question 48

What is a dual-axis chart designed to display?

1. One dimension twice
2. Two filters together
3. Separate dashboards
4. Two measures on shared space

Correct Answer: 4

Explanation:

A dual-axis chart displays two measures using separate axes in the same visualization. This allows analysts to compare measures that may have different scales, such as revenue and profit margin. Tableau can synchronize the axes when appropriate, although synchronization should be used only when the scales can meaningfully be compared. Dual-axis views should also be designed carefully to avoid confusing users with mismatched scales.

Question 49

What does a combined axis place together?

1. Multiple measures on one axis
2. Multiple filters in one pane
3. Separate data sources
4. Several dashboard actions

Correct Answer: 1

Explanation:

A combined axis places multiple measures along the same axis, allowing them to share a common scale and visual space. This can create a compact comparison when the measures have compatible units and ranges. It differs from a dual-axis visualization, where each measure receives its own axis. Analysts should use a combined axis when a shared scale provides a meaningful comparison rather than merely reducing visual space.

Question 50

Which Tableau feature creates numerical ranges automatically?

1. Sets
2. Bins
3. Groups
4. Aliases

Correct Answer: 2

Explanation:

Bins divide continuous numerical values into defined ranges. They are commonly used to support histograms and distribution analysis. For example, customer ages can be divided into five-year ranges to show how observations are distributed. Bin size influences the resulting visualization, so analysts should choose intervals that provide useful detail without creating excessive fragmentation.

Question 51

What does a context filter establish for other filters?

1. A calculated field
2. A dashboard action
3. A primary filtering context
4. A geographic role

Correct Answer: 3

Explanation:

A context filter creates a filtering context that other filters can use as a basis for further restriction. Tableau evaluates the context filter first, after which dependent filters operate on the resulting subset. This can be useful when one filter needs to define a smaller working dataset before another condition is applied. Context filters can also affect performance, so they should be used for a clear analytical purpose.

Question 52

Which filter type is commonly applied to aggregated measures?

1. Dimension filter
2. Extract filter
3. Data source filter
4. Measure filter

Correct Answer: 4

Explanation:

A measure filter operates on aggregated numerical results. For example, an analyst can filter a visualization to display categories whose total sales exceed a specified threshold. This differs from a dimension filter, which restricts categorical members before the measure result is evaluated. Understanding the distinction helps analysts create filtering logic that behaves as intended within Tableau’s order of operations.

Question 53

Which filter can restrict a view to the highest-ranked members?

1. Top filter
2. Null filter
3. Date filter
4. Measure-only filter

Correct Answer: 1

Explanation:

A Top filter can restrict a dimension to members with the highest or lowest values according to a selected measure. For example, an analyst can display the top ten products based on sales. This is useful for focusing a dashboard on leading performers without manually selecting individual members. Top filters can also be combined with other filtering logic depending on the analytical requirement.

Question 54

What does a relative date filter use as its reference?

1. A fixed category
2. A current date relationship
3. A worksheet color
4. A parameter name

Correct Answer: 2

Explanation:

A relative date filter selects dates relative to a reference point, commonly the current date. It can identify periods such as the previous week, current month, or recent number of days. Relative filtering is useful for dashboards that should remain current without requiring the analyst to manually update specific calendar dates. The chosen relative period determines which records remain visible.

Question 55

What does date truncation primarily change?

1. The data connection
2. The measure aggregation
3. The date’s level
4. The worksheet type

Correct Answer: 3

Explanation:

Date truncation changes a date to a specified level while retaining it as a date value. For example, truncating individual dates to the month level produces values representing the corresponding months. This differs from extracting a date part, which returns a component such as a month number or weekday. Understanding this distinction is important when building time-based analyses and choosing appropriate date fields.

Question 56

Which function calculates the difference between two dates?

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

Correct Answer: 4

Explanation:

DATEDIFF calculates the difference between two dates using a selected date unit such as day, week, month, or year. It is useful for measuring durations including customer tenure, delivery intervals, or time between events. The selected date part determines the unit of the returned result. Analysts should select the appropriate granularity because the same pair of dates can produce very different results depending on the chosen unit.

Question 57

Which function adds a specified interval to a date?

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

Correct Answer: 1

Explanation:

DATEADD adds a specified number of date units to a date. An analyst can use it to move dates forward or backward by days, weeks, months, quarters, or years. For example, DATEADD can generate a date several months after an existing date. This makes it useful for creating comparison periods, projected dates, and other calculations that require controlled movement along a calendar.

Question 58

What does ZN primarily do in a Tableau calculation?

1. Converts text fields
2. Replaces null numeric values
3. Extracts date parts
4. Creates geographic roles

Correct Answer: 2

Explanation:

ZN returns a numeric value when the expression is non-null and returns zero when the expression evaluates to null. This is useful when missing numerical values should be treated as zero for a particular calculation. For example, a null sales amount can be represented as zero before being included in a mathematical expression. Analysts should use this behavior intentionally because null and zero can have different business meanings.

Question 59

Which function checks whether an expression is null?

1. ROUND
2. FLOAT
3. ISNULL
4. SPLIT

Correct Answer: 3

Explanation:

ISNULL tests whether an expression contains a null value and returns a Boolean result. It can be used within conditional calculations to identify missing information and handle it appropriately. For example, an analyst can create logic that substitutes a label when a customer field is missing. ISNULL is particularly useful when data quality issues need to be identified or treated explicitly in a visualization.

Question 60

Which Tableau function selects logic based on matching values?

1. IFNULL
2. ZN
3. IIF
4. CASE

Correct Answer: 4

Explanation:

CASE evaluates an expression against multiple possible values and returns the result associated with the matching condition. It is useful when an analyst needs straightforward value-based classification, such as assigning labels to product codes or regions. CASE can make multi-value conditional logic easier to read than numerous nested conditions. An ELSE clause can also provide a result when none of the specified values match.