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

 

Question 81.

What does a Tableau parameter primarily provide?

1. User-controlled input
2. Fixed worksheet filter
3. Automatic extract refresh
4. Dashboard permission

Correct Answer: 1

Explanation:

A Tableau parameter provides a user-controlled value that can influence calculations, filters, reference lines, bins, and other workbook elements. Unlike a standard filter, a parameter is not directly limited to members of a particular field. Analysts can use parameters to let users change assumptions or analytical perspectives dynamically. For example, a parameter can allow users to select a measure for comparison or define a threshold used within a calculation. This flexibility makes parameters valuable when developing interactive dashboards that need to support multiple analytical scenarios without requiring separate worksheets for every possible user selection.

Question 82.

Which Tableau object combines multiple worksheets into one view?

1. Data blend
2. Dashboard
3. Data extract
4. Story point

Correct Answer: 2

Explanation:

A Tableau dashboard combines multiple worksheets into a single interactive view. Each worksheet can contain a different visualization, such as a bar chart, line chart, map, or KPI. Analysts can arrange these views together to present related information in one location. Dashboards can also include filters, parameters, legends, actions, and other interactive controls. For example, a sales dashboard may contain revenue trends, regional performance, product information, and customer metrics. Combining several worksheets allows users to explore connected information without repeatedly switching between separate views, making dashboards useful for monitoring and analytical reporting.

Question 83.

Which calculation counts unique customers?

1. COUNT(Customer Name)
2. SUM(Customer Name)
3. COUNTD(Customer Name)
4. AVG(Customer Name)

Correct Answer: 3

Explanation:

COUNTD is the Tableau function used to count distinct values within a field. When COUNTD is applied to Customer Name, each unique customer is counted once, even if that customer appears in many transaction records. This differs from COUNT, which can count repeated records containing the same customer. Distinct counting is useful when creating metrics for unique customers, accounts, products, or other entities. Analysts frequently use COUNTD when transactional repetition should not increase the reported number of customers. This function is especially important when analyzing customer populations from datasets containing multiple purchases or interactions.

Question 84.

What does a discrete field generally create?

1. Continuous axis
2. Numeric range
3. Trend forecast
4. Headers

Correct Answer: 4

Explanation:

A discrete field divides data into distinct categories and generally creates headers in a Tableau visualization. For example, placing a discrete Region field on the Rows shelf can create separate headers for individual regions. Discrete fields represent separate values rather than a continuous range. Continuous fields behave differently because they typically produce an axis containing a range of values. Understanding this distinction is important because converting a field between discrete and continuous can change the structure and appearance of a visualization. Analysts use this behavior to control how dimensions and measures are presented within worksheets.

Question 85.

Which Tableau area controls mark properties?

1. Marks card
2. Pages shelf
3. Data pane
4. Status bar

Correct Answer: 1

Explanation:

The Marks card controls many visual properties of marks within a Tableau worksheet. Analysts can place fields on options such as Color, Size, Label, Detail, Shape, and Tooltip to determine how information is visually represented. For example, placing a category on Color can distinguish groups, while placing a measure on Size can change mark dimensions according to its values. The Marks card therefore plays an important role in visualization design. By configuring these properties appropriately, analysts can communicate differences, categories, and additional details while keeping the primary worksheet understandable and visually organized.

Question 86.

What is the primary purpose of a dashboard filter?

1. Rename dimensions
2. Restrict displayed data
3. Create database indexes
4. Modify source schemas

Correct Answer: 2

Explanation:

A dashboard filter allows users to restrict the information displayed in one or more dashboard views according to selected criteria. For example, a dashboard may include filters for year, region, product category, or customer segment. When a user changes a filter selection, connected visualizations update to reflect the chosen subset. Filters help users focus on relevant information without modifying the underlying source data. Depending on configuration, a filter can affect one worksheet, several worksheets, or selected dashboard components. This makes filtering an important capability for interactive exploration and focused analytical reporting in Tableau.

Question 87.

Which function is used for conditional logic?

1. DATEADD
2. ROUND
3. IF
4. SPLIT

Correct Answer: 3

Explanation:

The IF function is used to create conditional logic within Tableau calculated fields. It evaluates whether a specified condition is true and returns an appropriate result based on that condition. Analysts can use IF statements to classify records, create business-rule indicators, separate values into categories, or calculate conditional metrics. For example, an analyst could create a field that identifies orders as profitable or unprofitable according to a selected threshold. Conditional calculations allow existing data to be transformed into meaningful analytical categories. These categories can then support filtering, grouping, calculations, and visualization throughout a Tableau workbook.

Question 88.

Which feature displays information when users hover over marks?

1. Pages
2. Filters
3. Parameters
4. Tooltip

Correct Answer: 4

Explanation:

A Tableau tooltip displays additional information when a user moves the pointer over a mark. Tooltips can contain underlying field values, aggregated measures, calculated results, and customized descriptive text. They provide additional context without requiring analysts to place every available detail directly on the visualization. For example, a sales chart might display revenue, profit, customer information, and order details when a user hovers over a specific mark. Well-designed tooltips improve dashboard interactivity while keeping the main visualization clean. They are particularly useful when users need supporting details without increasing visual clutter in the worksheet.

Question 89.

What does a context filter establish?

1. Primary filtering context
2. Dashboard navigation path
3. Calculation formatting rule
4. Workbook access level

Correct Answer: 1

Explanation:

A context filter establishes a primary filtering context that Tableau evaluates before other dimension filters. Subsequent filters can then operate against the reduced dataset created by that context. This can be useful when an analyst needs a specific subset to become the foundation for additional filtering. For example, an analyst may first restrict the data to a particular period and then apply another filter for selected categories. Context filters can also affect performance in certain situations, although the benefit depends on workbook structure and data characteristics. They should therefore be used intentionally when filtering order is analytically important.

Question 90.

Which chart is commonly used to compare categories?

1. Scatter plot
2. Bar chart
3. Gantt chart
4. Area map

Correct Answer: 2

Explanation:

A bar chart is commonly used to compare quantitative values across discrete categories. Each category is represented by a bar, and its length corresponds to the associated measure. This visual structure makes differences between categories relatively easy to identify. Bar charts can be used for comparisons such as sales by region, revenue by product, orders by customer segment, or profit by department. They may be displayed vertically or horizontally depending on the number and length of category labels. Sorting the bars can further improve readability and help users quickly recognize differences among the categories being analyzed.

Question 91.

What does a calculated field allow analysts to create?

1. Server hardware changes
2. Database permissions
3. Derived values
4. Workbook replacements

Correct Answer: 3

Explanation:

A calculated field allows analysts to create new values from existing data by using Tableau expressions. Calculated fields can perform arithmetic, conditional logic, date manipulation, text operations, aggregation, and other analytical tasks. They are especially useful when a required business metric does not already exist in the source data. For example, an analyst can calculate a profit margin using sales and profit fields or classify customers according to spending thresholds. Calculated fields extend Tableau’s analytical capabilities without requiring changes to the original database structure, allowing analysts to build customized metrics directly within the workbook.

Question 92.

Which chart is useful for examining two measures together?

1. Histogram
2. Treemap
3. Text table
4. Scatter plot

Correct Answer: 4

Explanation:

A scatter plot is useful for examining the relationship between two quantitative measures. One measure is generally represented on one axis while the second measure appears on the other axis. Individual marks can represent customers, products, transactions, or other analytical entities. This arrangement helps users identify patterns, clusters, relationships, and potential outliers. For example, analysts can compare sales and profit to investigate whether higher sales values correspond with higher profitability. Scatter plots are especially useful when the analytical goal involves exploring relationships between measures rather than simply comparing totals across discrete categories.

Question 93.

What does a date hierarchy allow users to do?

1. Drill through date levels
2. Remove duplicate records
3. Change credentials
4. Compress extracts

Correct Answer: 1

Explanation:

A date hierarchy allows users to explore information at different levels of temporal detail. Depending on the date field and workbook configuration, users can move from broader levels such as year and quarter to more detailed levels such as month and day. This drill-down capability helps analysts investigate trends progressively. For example, an annual change can be examined by quarter and then by month to determine when the change occurred. Date hierarchies provide both summarized and detailed perspectives within the same analytical view, allowing users to investigate time-based patterns without needing to create completely separate worksheets for every level.

Question 94.

Which feature enables navigation between dashboards?

1. Data relationship
2. Dashboard action
3. Aggregation rule
4. Extract refresh

Correct Answer: 2

Explanation:

Dashboard actions enable interactive behavior between Tableau views and dashboards. A navigation action can allow users to move from one dashboard to another after interacting with a configured button, image, or other dashboard element. This is useful when a workbook contains summary and detailed dashboards that need to work together. Actions can also support filtering and highlighting between views. By configuring navigation appropriately, analysts can create a structured experience in which users begin with high-level information and move into more detailed views when additional investigation is necessary. This creates a connected workflow across multiple dashboard pages.

Question 95.

What does ATTR() show when values are different?

1. Their total
2. Their average
3. An asterisk
4. Their minimum

Correct Answer: 3

Explanation:

The ATTR() function returns a field value when all underlying records associated with a mark contain the same value. When multiple different values exist, Tableau displays an asterisk to indicate that the values are not identical. This behavior is useful when a dimension is displayed alongside aggregated measures and Tableau needs to determine whether one value can represent the underlying records. Analysts may encounter ATTR() automatically in certain views, particularly when dimensions and measures are combined at different levels of detail. Understanding this behavior helps users interpret the asterisk correctly instead of assuming that it represents missing or invalid information.

Question 96.

Which visualization is suitable for one prominent KPI?

1. Packed bubbles
2. Symbol map
3. Highlight table
4. KPI text card

Correct Answer: 4

Explanation:

A KPI text card is suitable for displaying one important metric prominently on a dashboard. Examples include total revenue, profit, customer count, conversion rate, or average order value. KPI cards provide users with a quick summary before they examine more detailed charts and tables. Analysts can supplement the primary value with labels, comparisons, targets, or supporting information when appropriate. Because the visualization focuses attention on one metric, it is especially useful near the top of operational or executive dashboards. A well-designed KPI card helps users understand an important performance measure quickly before exploring more detailed analytical information.

Question 97.

What is the main purpose of aggregation?

1. Summarize underlying records
2. Rename source columns
3. Change ownership
4. Create dashboard buttons

Correct Answer: 1

Explanation:

Aggregation summarizes multiple underlying records into a higher-level analytical value based on the level of detail represented in the visualization. Tableau provides common aggregation functions such as SUM, AVG, MIN, MAX, COUNT, and COUNTD. For example, thousands of individual transaction records can be summarized into total sales by region. Aggregation allows analysts to move from individual records to meaningful summaries that can be compared across categories or time periods. Understanding aggregation is important because adding or removing dimensions can change the level at which measures are calculated, which can consequently change the values displayed within a worksheet.

Question 98.

Which feature can provide a benchmark across a chart?

1. Data interpreter
2. Reference line
3. Alias editor
4. Workbook theme

Correct Answer: 2

Explanation:

A reference line provides a visual benchmark within a Tableau visualization. Analysts can use reference lines to display values such as averages, medians, constants, or other meaningful thresholds. For example, a sales chart can include an average-sales reference line so users can quickly identify categories performing above or below the benchmark. Reference lines make comparisons easier without requiring another worksheet. They are particularly useful when a visualization needs to communicate performance relative to a target, baseline, statistical measure, or predefined threshold. This provides additional context while preserving the structure and purpose of the primary visualization.

Question 99.

What does a Tableau relationship define?

1. Dashboard appearance
2. Parameter behavior
3. Logical data connection
4. Tooltip formatting

Correct Answer: 3

Explanation:

A Tableau relationship defines how logical tables are connected within the data model. It allows Tableau to determine how records from related tables should be combined according to the fields connecting them. Relationships are designed to preserve appropriate levels of detail while allowing multiple tables to participate in analysis. This can be useful when datasets contain different granularities, such as customer-level and transaction-level information. By defining relationships correctly, analysts can build visualizations using fields from multiple logical tables while reducing unnecessary duplication that may occur when tables are combined through inappropriate physical joins.

Question 100.

Which feature can emphasize related marks interactively?

1. Data source filter
2. Extract schedule
3. Workbook theme
4. Highlight action

Correct Answer: 4

Explanation:

A highlight action emphasizes related marks when a user interacts with a selected value. Rather than removing unrelated marks, Tableau keeps them visible while making selected or related marks more visually prominent. This allows users to examine relationships without losing the broader analytical context. For example, selecting a particular product category can highlight corresponding marks across another visualization. Highlight actions are useful in interactive dashboards where users need to compare related information while retaining visibility into the complete dataset. They provide focused visual emphasis without applying a traditional filtering operation that would remove other marks from view.