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

 

Question 21

Which join keeps only matching records from both tables?

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

Correct Answer: 1

Explanation:

An inner join returns only records where matching values exist in both connected tables. For example, joining Customers and Orders by Customer ID with an inner join excludes customers without matching orders and orders without matching customers. This makes inner joins useful when the analysis should focus exclusively on intersecting records. Other join types preserve unmatched records from one or both sides, depending on their configuration.

Question 22

What does a left join preserve from the first table?

1. Matching rows only
2. All rows
3. Right-side records
4. Duplicate columns

Correct Answer: 2

Explanation:

A left join preserves every record from the left table while adding matching information from the right table when available. If no matching record exists, the right-side fields generally contain null values. This is useful when the primary dataset must remain complete, such as retaining every customer even when some customers have no transactions. The order of the tables therefore matters when creating a left join.

Question 23

What is a key benefit of relationships in Tableau’s data model?

1. They permanently merge tables
2. They remove all nulls
3. They preserve table-level detail
4. They require identical structures

Correct Answer: 3

Explanation:

Relationships allow Tableau to maintain separate logical tables while determining how data should be combined during analysis. Tableau can use the appropriate level of detail from each table instead of immediately flattening everything into one physical table. This can reduce unintended duplication and preserve the natural structure of the underlying data. Relationships are therefore different from traditional physical joins, which combine rows earlier in the data-modeling process.

Question 24

Which Tableau feature combines separate data sources during analysis?

1. Union
2. Relationship
3. Join
4. Data blending

Correct Answer: 4

Explanation:

Data blending combines information from separate data sources within a visualization by using a linking field between the sources. One source acts as the primary source, while another provides related information. Blending differs from joins because the sources remain separate rather than being physically combined into one table. It can be useful when the required datasets come from different connection types or cannot conveniently be joined within a single data model.

Question 25

What is a Tableau set primarily used to represent?

1. A defined subset
2. A calculated measure
3. A data connection
4. A dashboard container

Correct Answer: 1

Explanation:

A set represents a defined subset of data members that can be used for analysis. For example, an analyst could create a set containing selected customers, products, or geographic regions and then compare that group against the remaining members. Sets can be created manually or dynamically using conditions and other criteria. They are especially useful for segmentation and comparing selected members with the broader population.

Question 26

What does grouping primarily allow an analyst to do?

1. Create table calculations
2. Combine related members
3. Change connection types
4. Generate extracts

Correct Answer: 2

Explanation:

Grouping lets an analyst combine individual dimension members into meaningful categories. For example, several product names can be grouped into a broader product category for analysis. The grouping affects how those members are displayed and analyzed without requiring the original source data to be changed. This can simplify visualizations when the existing dimension contains several values that logically belong together.

Question 27

What does a histogram primarily display?

1. Geographic coordinates
2. Category comparisons
3. Distribution of values
4. Hierarchical relationships

Correct Answer: 3

Explanation:

A histogram displays how numerical values are distributed across ranges. Tableau creates these ranges using bins, allowing an analyst to see patterns such as concentration, spread, skewness, or possible outliers. Histograms are different from ordinary bar charts because their primary purpose is to show the distribution of a quantitative variable rather than compare unrelated categorical members. Choosing an appropriate bin size can significantly affect how the distribution appears.

Question 28

Which chart is most appropriate for identifying median and outliers?

1. Area chart
2. Pie chart
3. Gantt chart
4. Box-and-whisker plot

Correct Answer: 4

Explanation:

A box-and-whisker plot summarizes the distribution of numerical values using statistics such as the median and quartiles. Its visual structure also makes unusually distant observations easier to identify. This chart is particularly useful for comparing distributions across multiple categories, such as comparing delivery times among regions. Unlike a simple bar chart, it provides information about spread and distribution rather than only displaying an aggregated value.

Question 29

Which expression type calculates a value at a specified data level?

1. LOD expression
2. String function
3. Date function
4. Number format

Correct Answer: 1

Explanation:

Level of Detail, or LOD, expressions allow Tableau calculations to operate at a specified level of granularity. They can produce results independently of the dimensions currently displayed in the view. LOD expressions are useful when an analyst needs calculations such as customer-level totals, fixed regional averages, or values based on a particular grouping. Common LOD expressions include FIXED, INCLUDE, and EXCLUDE.

Question 30

Which LOD expression fixes calculation granularity explicitly?

1. INCLUDE
2. FIXED
3. EXCLUDE
4. ATTR

Correct Answer: 2

Explanation:

The FIXED LOD expression specifies the dimensions at which Tableau should perform a calculation, regardless of many dimensions present in the visualization. For example, a calculation can determine sales for each customer even when the view is organized differently. This makes FIXED useful when the desired calculation needs a clearly defined level of detail. INCLUDE and EXCLUDE modify the view’s dimensional context differently.

Question 31

What does an INCLUDE LOD expression add to the calculation level?

1. A parameter
2. A data source
3. Specified dimensions
4. A dashboard action

Correct Answer: 3

Explanation:

An INCLUDE LOD expression adds specified dimensions to the level at which Tableau evaluates a calculation. The resulting value can then be aggregated to the level displayed in the view. This is useful when an analyst needs a calculation at a more detailed level before presenting it at a broader level. For example, an INCLUDE expression can calculate customer-level results while the visualization displays information by region.

Question 32

Which LOD expression removes specified dimensions from the view’s detail?

1. FIXED
2. INCLUDE
3. WINDOW
4. EXCLUDE

Correct Answer: 4

Explanation:

EXCLUDE LOD expressions remove specified dimensions from the calculation’s level of detail. This allows an analyst to calculate values as though selected dimensions were not present in the view. A common use is comparing a detailed member with a broader group total. EXCLUDE is different from FIXED because it works by removing named dimensions from the current context rather than defining an entirely independent dimensional level.

Question 33

What does a running total table calculation show?

1. Cumulative values
2. Random samples
3. Static labels
4. Geographic regions

Correct Answer: 1

Explanation:

A running total calculates cumulative values as the view progresses through an ordered sequence. For example, monthly sales can be accumulated from January through December to show how the yearly total builds over time. The calculation depends on the ordering and direction of the table calculation. Running totals are useful for tracking cumulative performance, progress toward goals, and other sequential measures.

Question 34

Which table calculation expresses each value as a share of the total?

1. Difference from
2. Percent of total
3. Moving maximum
4. Rank percentile

Correct Answer: 2

Explanation:

The Percent of Total table calculation converts values into their contribution relative to a specified total. For instance, regional sales can be displayed as percentages of overall sales. This makes proportional comparisons easier than comparing raw values alone. The resulting percentages depend on the table-calculation addressing and partitioning, so the analyst should verify which rows or columns Tableau is using as the relevant total.

Question 35

What does a moving average primarily help reveal?

1. Data-source lineage
2. Geographic boundaries
3. Smoothed trends
4. Field aliases

Correct Answer: 3

Explanation:

A moving average calculates an average across a moving window of values. It helps smooth short-term fluctuations so broader patterns become easier to observe. For example, daily sales may vary substantially, while a seven-day moving average provides a steadier view of recent performance. The selected window size affects the amount of smoothing, so analysts should choose a period appropriate to the business question and data frequency.

Question 36

Which feature can display a constant benchmark across a chart?

1. Trend line
2. Forecast
3. Reference line
4. Cluster

Correct Answer: 3

Explanation:

A reference line adds a visual benchmark to a view, such as an average, constant value, median, or another relevant threshold. It allows viewers to compare individual marks against a meaningful reference. For example, monthly revenue bars can be displayed with an average-revenue line. Reference lines are especially useful for quickly identifying values above or below a target or statistical baseline.

Question 37

What does a trend line help identify in a visualization?

1. Relationship patterns
2. Workbook permissions
3. Extract schedules
4. Field aliases

Correct Answer: 1

Explanation:

A trend line helps illustrate a statistical relationship or general direction within plotted data. It is commonly used with scatter plots to show how one measure changes in relation to another. Depending on the selected model, Tableau can provide information about the fitted relationship. Analysts should remember that a trend line describes an observed statistical relationship and does not by itself establish that one variable causes another.

Question 38

Which visualization is designed to show correlations between two measures?

1. Highlight table
2. Scatter plot
3. Filled map
4. Histogram

Correct Answer: 2

Explanation:

A scatter plot places two quantitative measures on separate axes, allowing individual observations to be compared across both variables. Patterns such as positive association, negative association, clusters, and unusual observations can become visible. Trend lines can also be added to help summarize relationships. Scatter plots are particularly useful when the analytical question concerns whether changes in one measure appear associated with changes in another.

Question 39

Which dashboard action changes a selected parameter value?

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

Correct Answer: 3

Explanation:

A parameter action allows interaction with a visualization to modify a parameter value. This can make dashboards more interactive by letting users control calculations, reference values, or displayed scenarios through selections. For example, selecting a mark could change the parameter used by a calculation. Parameter actions differ from filter actions because they modify a parameter rather than directly restricting the displayed data.

Question 40

What does a highlight action primarily emphasize?

1. Data extracts
2. Selected marks
3. Workbook files
4. Source tables

Correct Answer: 4

Explanation:

A highlight action emphasizes related marks when a user selects a value or category. Instead of removing unrelated data from the view, it visually draws attention to the selected members while retaining the surrounding context. This is useful for comparisons where the analyst wants users to see both the selected group and the rest of the data. Highlighting therefore supports exploration without necessarily filtering marks away.