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

 

Question 1

Which Tableau feature is used to combine fields into a hierarchy?

1. Data Blending
2. Hierarchy
3. Grouping
4. Union

Correct Answer: 2

Explanation:

A hierarchy organizes related fields into levels that users can navigate from broader categories to more detailed values. For example, a geographic hierarchy might progress from country to state and then city. Hierarchies make drill-down analysis easier because users can move through related levels without manually adding each field. They are different from groups, which combine selected dimension members, and unions, which append rows from compatible tables.

Question 2

What does a Tableau extract primarily provide?

1. Cached data
2. Dashboard navigation
3. Workbook formatting
4. User permissions

Correct Answer: 1

Explanation:

A Tableau extract is a stored subset or copy of data optimized for analysis. Extracts can improve performance and allow workbooks to operate without querying the original source for every interaction. They can also support scheduled refreshes so analytical data remains current according to the configured refresh process. Extracts are therefore related to data access and performance, not dashboard navigation, formatting, or user authorization.

Question 3

Which chart is most appropriate for showing a trend over time?

1. Pie chart
2. Scatter plot
3. Line chart
4. Treemap

Correct Answer: 3

Explanation:

A line chart is commonly used to display trends across an ordered time dimension. Connecting values with lines makes changes, increases, decreases, and patterns easier to recognize. For example, monthly revenue can be plotted across a year to reveal movement over time. Pie charts emphasize part-to-whole relationships, scatter plots examine relationships between measures, and treemaps display hierarchical proportions.

Question 4

What does a Tableau parameter allow users to control?

1. Data encryption
2. Source credentials
3. Workbook ownership
4. A dynamic value

Correct Answer: 4

Explanation:

A parameter stores a value that can be changed by the user and referenced by calculations, filters, or other supported workbook logic. This allows a dashboard to become more interactive. For example, a parameter could let users select a threshold or switch between analytical measures. Parameters are different from ordinary filters because they are independent values that can influence workbook behavior rather than simply restricting displayed records.

Question 5

Which Tableau function can combine text values?

1. SUM
2. COUNT
3. AVG
4. CONCAT

Correct Answer: 4

Explanation:

The CONCAT function combines two strings into a single text value. It can be useful when creating labels or constructing a combined textual field from separate attributes. Aggregation functions such as SUM and AVG operate on numerical measures, while COUNT determines the number of values or records according to its usage. When analysts need to build a text expression from multiple fields, string functions such as CONCAT are appropriate.

Question 6

What is the primary purpose of a dashboard?

1. Present multiple views together
2. Replace all source systems
3. Store database credentials
4. Create physical database tables

Correct Answer: 1

Explanation:

A Tableau dashboard combines multiple worksheets and visual elements into a single interactive analytical view. This allows users to examine related metrics, charts, filters, and supporting information together. Dashboards can help users explore data from different perspectives without switching between separate worksheets. They do not replace source systems or function as databases. Their primary purpose is to present and interact with multiple analytical views in one place.

Question 7

Which shelf controls the level of detail shown along an axis?

1. Pages
2. Rows
3. Marks
4. Filters

Correct Answer: 2

Explanation:

The Rows shelf places fields along the vertical portion of a Tableau view and can determine how dimensions or measures are displayed there. Similarly, the Columns shelf controls the horizontal structure. The Marks card controls visual properties such as color, size, and shape, while Filters restrict the data displayed. Understanding shelf behavior is fundamental to building Tableau visualizations with the intended structure.

Question 8

What does a discrete field typically create in a Tableau view?

1. Continuous axis
2. Measure aggregation
3. Headers
4. Data extract

Correct Answer: 3

Explanation:

A discrete field generally creates separate headers or panes for its individual values. Tableau displays discrete values as distinct categories rather than as a continuous numerical range. In contrast, continuous fields generally create axes and support a continuous scale. Understanding the distinction between discrete and continuous fields helps analysts control how dimensions and measures appear in visualizations.

Question 9

Which chart is useful for comparing values across categories?

1. Bar chart
2. Line chart
3. Area map
4. Gantt chart

Correct Answer: 1

Explanation:

A bar chart is well suited to comparing quantitative values across distinct categories. The length of each bar provides a straightforward visual comparison between members. For example, an analyst can compare sales across product categories or regions. Line charts are generally better for trends, while Gantt charts are useful for duration and scheduling. Selecting a chart based on the analytical question improves readability.

Question 10

What does a filter primarily do in Tableau?

1. Changes user roles
2. Limits displayed data
3. Encrypts extracts
4. Creates relationships

Correct Answer: 2

Explanation:

A filter limits the data included in a Tableau view according to specified conditions. Analysts can filter by dimensions, measures, dates, or other supported criteria. Filters allow users to focus on relevant records without modifying the underlying source data. They are distinct from relationships, which connect tables or logical data structures, and from user roles or encryption, which belong to security and data-management areas.

Question 11

Which Tableau object contains one or more worksheets?

1. Data source
2. Dashboard
3. Workbook
4. Parameter

Correct Answer: 3

Explanation:

A workbook is the Tableau file that can contain worksheets, dashboards, stories, and associated data-source information. It serves as the primary container for an analytical project. A worksheet is an individual visualization, while a dashboard combines multiple views. A parameter stores a user-controlled value, and a data source provides access to the underlying data. Understanding these object relationships helps analysts organize Tableau projects effectively.

Question 12

Which calculation returns the total of numerical values?

1. SUM
2. LEFT
3. DATEPART
4. CONTAINS

Correct Answer: 1

Explanation:

The SUM function adds numerical values and returns their total according to the level of detail in the view. It is one of Tableau’s commonly used aggregation functions and is frequently applied to measures such as sales, profit, or quantity. LEFT and CONTAINS are string-related functions, while DATEPART extracts a component from a date. Choosing the correct function depends on the type of calculation required.

Question 13

What is a dimension primarily used to represent?

1. Aggregated calculation
2. Categorical information
3. Database password
4. Extract schedule

Correct Answer: 2

Explanation:

Dimensions generally represent categorical or descriptive information used to organize and segment data. Examples include product names, regions, customer types, or departments. Measures, by comparison, usually contain quantitative values that can be aggregated. Dimensions help determine how data is broken into categories in a visualization. They can also be used with filters, labels, color, and other visual properties to provide analytical context.

Question 14

Which visualization shows the relationship between two numerical measures?

1. Histogram
2. Text table
3. Scatter plot
4. Pie chart

Correct Answer: 3

Explanation:

A scatter plot displays individual marks according to values on two numerical axes, making it useful for examining relationships, distributions, and potential correlations between measures. For example, sales and profit can be plotted to identify patterns across products or customers. Histograms focus on distributions of a single measure, while pie charts emphasize part-to-whole composition. Scatter plots are therefore appropriate for two-measure relationship analysis.

Question 15

What does a worksheet contain?

1. A single analytical view
2. Only user permissions
3. Database infrastructure
4. Source-system credentials

Correct Answer: 1

Explanation:

A worksheet contains an individual Tableau analytical view. It can include fields, marks, filters, calculations, and visual structures that together create a specific analysis. Multiple worksheets can then be combined into a dashboard or story. Worksheets do not serve as database infrastructure or credential stores. Understanding worksheets as individual analytical building blocks helps analysts structure larger Tableau workbooks efficiently.

Question 16

Which feature can display different worksheets sequentially?

1. Relationship
2. Story
3. Extract
4. Alias

Correct Answer: 2

Explanation:

A Tableau Story allows analysts to present a sequence of views or story points that communicate an analytical narrative. Each point can contain a worksheet or dashboard and can highlight a different aspect of the analysis. This is useful when users need to move through several related findings in an intentional order. Relationships connect data, extracts store optimized data, and aliases rename displayed values.

Question 17

What does a continuous date field typically create?

1. Discrete headers only
2. A continuous axis
3. A workbook copy
4. A data relationship

Correct Answer: 2

Explanation:

A continuous date field typically creates a continuous axis, allowing values to be displayed along an uninterrupted time scale. This is useful for analyzing trends and changes over time. Discrete dates instead divide the data into distinct headers or categories, such as individual years or months. The choice between continuous and discrete dates depends on whether the analysis requires a continuous timeline or separated date categories.

Question 18

Which feature can combine rows from similar tables?

1. Join
2. Union
3. Parameter
4. Filter

Correct Answer: 3

Explanation:

A union combines rows from two or more tables with compatible structures, effectively appending one dataset beneath another. This is useful when similar data is stored across separate tables or files and should be analyzed as a combined dataset. A join instead combines related tables using matching fields. Parameters provide user-controlled values, while filters restrict the data shown in a visualization.

Question 19

What does a calculated field allow an analyst to create?

1. Derived values
2. User accounts
3. Database servers
4. Extract credentials

Correct Answer: 4

Explanation:

A calculated field allows analysts to create new values from existing data using formulas and Tableau functions. Calculations can support business logic, classifications, ratios, date operations, and other analytical requirements. The resulting field can be used in visualizations similarly to other available fields. Calculated fields do not create user accounts, database infrastructure, or authentication credentials; they extend the analytical model with derived values.

Question 20

Which visual element can encode a measure using color intensity?

1. Marks Color
2. Data Source
3. Parameter Control
4. Worksheet Title

Correct Answer: 1

Explanation:

The Color property on the Marks card can encode a field visually using different colors or levels of color intensity. This allows analysts to highlight differences in measures or categories directly within a visualization. For example, profit values can be represented through varying color intensity to make patterns easier to identify. Data Sources, parameter controls, and worksheet titles serve different purposes and do not directly encode marks.