Salesforce Tableau Certified Consultant (TCC-C01) — Questions and Answers

Question 1: What field type in Tableau would you assign to numerical data that supports mathematical operations?

Measure (Correct answer)
Discrete
Dimension
Attribute

Correct answer: Measure

Measures represent numerical data that can undergo mathematical operations like sums and averages.

Question 2: What is the fundamental principle behind performance monitoring in the context of Tableau Certified Consultant?

Maximizing system complexity
Avoiding all system changes
Ensuring reliability, security, and optimal performance (Correct answer)
Using the most expensive solutions available

Correct answer: Ensuring reliability, security, and optimal performance

Performance Monitoring in Tableau Certified Consultant fundamentally aims to ensure system reliability, security, and optimal performance.

Question 3: What is the best practice for monitoring data management systems?

Implement automated monitoring with alerting thresholds (Correct answer)
Check systems manually once a month
Rely on vendor notifications exclusively
Monitor only when users report problems

Correct answer: Implement automated monitoring with alerting thresholds

Automated monitoring with properly configured alerting thresholds enables proactive identification and resolution of issues.

Question 4: What is the fundamental principle behind data management in the context of Tableau Certified Consultant?

Avoiding all system changes
Using the most expensive solutions available
Ensuring reliability, security, and optimal performance (Correct answer)
Maximizing system complexity

Correct answer: Ensuring reliability, security, and optimal performance

Data Management in Tableau Certified Consultant fundamentally aims to ensure system reliability, security, and optimal performance.

Question 5: Why would you use layout containers in a Tableau dashboard?

To improve dashboard speed
To organize visualizations neatly (Correct answer)
To calculate data fields
To automate data refresh

Correct answer: To organize visualizations neatly

Layout containers are used to organize visualizations neatly, maintaining consistent alignment and spacing in dashboards.

Question 6: What should you do when troubleshooting a data management issue?

Immediately restart all systems
Make random changes until the problem goes away
Follow a systematic approach: identify, research, test, implement, verify (Correct answer)
Escalate everything without investigation

Correct answer: Follow a systematic approach: identify, research, test, implement, verify

A systematic troubleshooting approach ensures the root cause is identified and the fix is verified without creating new issues.

Question 7: How does a FIXED LOD expression interact with a standard dimension filter in Tableau's order of operations?

FIXED LOD and dimension filters execute simultaneously
FIXED LOD respects dimension filters by default without any configuration
FIXED LOD runs after dimension filters are applied
FIXED LOD runs before dimension filters are applied (Correct answer)

Correct answer: FIXED LOD runs before dimension filters are applied

In Tableau's order of operations, FIXED LOD expressions are evaluated before dimension filters, so they compute on unfiltered data unless the filtered dimension is promoted to a context filter.

Question 8: What security consideration is most important in troubleshooting methods?

Implementing the principle of least privilege and defense in depth (Correct answer)
Security is not relevant to this area
Disabling logging to improve performance
Using a single strong password for all systems

Correct answer: Implementing the principle of least privilege and defense in depth

The principle of least privilege combined with defense in depth provides layered security that protects against various attack vectors.

Question 9: Which of the following is the most appropriate use case for an EXCLUDE LOD expression in Tableau?

Adding a more granular dimension to the current calculation scope
Replicating the behavior of a running total across partitions
Computing sales totals independent of all dashboard filters
Calculating a percent of total that removes a specific dimension from the computation (Correct answer)

Correct answer: Calculating a percent of total that removes a specific dimension from the computation

EXCLUDE LOD expressions remove a specified dimension from the view's level of detail, which is ideal for computing aggregates like percent of total that should ignore one dimension.

Question 10: Which Tableau calculation construct is best suited for evaluating a single dimension field against multiple specific discrete values and returning a corresponding result for each?

CASE / WHEN / THEN / END (Correct answer)
IIF() with nested conditions
SWITCH() function
IF / THEN / ELSEIF / END

Correct answer: CASE / WHEN / THEN / END

CASE/WHEN is optimized for matching a single expression against a list of specific values, producing cleaner and more readable syntax than nested IF/ELSEIF chains for this pattern.

Question 11: When connecting to multiple tables in Tableau, which option allows you to create relationships between them without merging data?

Relationships (Correct answer)
Blends
Unions
Joins

Correct answer: Relationships

Relationships in Tableau are a flexible way to define logical connections between tables while maintaining separate data sources.

Question 12: In Tableau, what chart type is recommended to visualize the distribution of data points and potential outliers?

Line Chart
Bar Chart
Box Plot (Correct answer)
Pie Chart

Correct answer: Box Plot

Box plots are ideal for displaying data distribution and identifying outliers.

Question 13: What type of content can you add to a Tableau story point?

Text descriptions only
Worksheets, dashboards, and text (Correct answer)
Worksheets only
Dashboards only

Correct answer: Worksheets, dashboards, and text

Story points in Tableau can include individual worksheets, dashboards, or text descriptions.

Question 14: What is the purpose of using a data extract in Tableau?

To store a static snapshot of data for faster performance (Correct answer)
To apply security rules to dashboards
To connect to web-based APIs
To update the live data source regularly

Correct answer: To store a static snapshot of data for faster performance

Data extracts improve performance by storing a snapshot of data in Tableau’s fast data engine, allowing offline analysis.

Question 15: What is the fundamental principle behind compliance standards in the context of Tableau Certified Consultant?

Avoiding all system changes
Ensuring reliability, security, and optimal performance (Correct answer)
Using the most expensive solutions available
Maximizing system complexity

Correct answer: Ensuring reliability, security, and optimal performance

Compliance Standards in Tableau Certified Consultant fundamentally aims to ensure system reliability, security, and optimal performance.

Question 16: What does the Tableau LOOKUP() table calculation function return?

A value from a data source record located by primary key
A string match found within another string field
A VLOOKUP-style result across blended data sources
The value of an expression in a target row offset relative to the current row (Correct answer)

Correct answer: The value of an expression in a target row offset relative to the current row

LOOKUP() returns the value of a given expression at a row that is a specified number of positions before or after the current row in the table calculation's addressing direction.

Question 17: What security consideration is most important in system architecture?

Implementing the principle of least privilege and defense in depth (Correct answer)
Using a single strong password for all systems
Security is not relevant to this area
Disabling logging to improve performance

Correct answer: Implementing the principle of least privilege and defense in depth

The principle of least privilege combined with defense in depth provides layered security that protects against various attack vectors.

Question 18: What happens when a Tableau LOD expression is nested inside another LOD expression?

Tableau throws a calculation error because nested LODs are unsupported
The inner LOD is resolved first, and its result is available as input to the outer LOD (Correct answer)
Only FIXED LODs support nesting; INCLUDE and EXCLUDE cannot be nested
Both LOD expressions execute in parallel and their results are merged

Correct answer: The inner LOD is resolved first, and its result is available as input to the outer LOD

Tableau supports nested LOD expressions; the inner expression is evaluated at its declared granularity first, and the resulting value is then used within the outer LOD expression's computation.

Question 19: Which of the following is TRUE about a live connection in Tableau?

They are stored as .hyper files locally
They provide real-time data access by querying the source directly (Correct answer)
They require manual data refreshes
They always improve performance over extracts

Correct answer: They provide real-time data access by querying the source directly

Live connections reflect the most recent data from the source and are suitable for real-time or frequently updated datasets.

Question 20: Which element in a Tableau dashboard allows users to filter all views simultaneously?

Parameters
Quick Filters
Dashboard Actions (Correct answer)
Context Filters

Correct answer: Dashboard Actions

Dashboard actions enable interactive filtering across multiple visualizations within a single dashboard.

Question 21: What is the role of Tableau’s Data Interpreter?

It cleans Excel files by recognizing structure and formatting (Correct answer)
It filters duplicate values in a worksheet
It enhances calculated field performance
It converts data into .hyper format

Correct answer: It cleans Excel files by recognizing structure and formatting

The Data Interpreter helps clean messy Excel spreadsheets by identifying headers, footers, and irregular formatting.

Question 22: What does the Tableau ATTR() aggregation function return when the underlying data contains multiple different values for the field within the current view's level of detail?

NULL, suppressing the field from display entirely
The most frequently occurring (mode) value among all rows
The first alphabetical value found in the dataset
An asterisk (*) indicating that the field is not uniquely defined at this granularity (Correct answer)

Correct answer: An asterisk (*) indicating that the field is not uniquely defined at this granularity

ATTR() returns the field's value only when every row in the partition shares the same value; if there are multiple distinct values, it returns '*' to signal the ambiguity.

Question 23: Which type of Tableau expression computes a result at a specified dimension level regardless of the filters applied to the current view?

Running Total table calculation
INCLUDE LOD expression
FIXED LOD expression (Correct answer)
EXCLUDE LOD expression

Correct answer: FIXED LOD expression

FIXED LOD expressions compute at the declared dimension level and are evaluated before dimension filters, making them independent of view-level filter context.

Question 24: What security consideration is most important in compliance standards?

Security is not relevant to this area
Using a single strong password for all systems
Disabling logging to improve performance
Implementing the principle of least privilege and defense in depth (Correct answer)

Correct answer: Implementing the principle of least privilege and defense in depth

The principle of least privilege combined with defense in depth provides layered security that protects against various attack vectors.

Question 25: How does Tableau use Bins?

To drill down through hierarchies
To break continuous measures into fixed-size intervals (Correct answer)
To create custom groups of dimension values
To aggregate data by time

Correct answer: To break continuous measures into fixed-size intervals

Bins convert continuous measures into discrete ranges, which helps in histogram creation or simplified analysis of numerical values.

Question 26: Which approach is recommended for implementing implementation planning changes?

Skipping documentation to save time
Implementing changes only during peak hours
Making all changes at once without testing
Following a structured change management process with testing (Correct answer)

Correct answer: Following a structured change management process with testing

A structured change management process with proper testing minimizes risk and ensures successful implementation.

Question 27: What should you do when troubleshooting a compliance standards issue?

Make random changes until the problem goes away
Escalate everything without investigation
Immediately restart all systems
Follow a systematic approach: identify, research, test, implement, verify (Correct answer)

Correct answer: Follow a systematic approach: identify, research, test, implement, verify

A systematic troubleshooting approach ensures the root cause is identified and the fix is verified without creating new issues.

Question 28: When should a Tableau developer use a FIXED LOD expression instead of a standard aggregate measure in the view?

When the calculation needs to span across blended data sources
When a filter needs to be applied after the aggregation completes
When the required aggregation granularity is coarser than the current view's level of detail (Correct answer)
When working with non-additive measures like distinct counts across a blend

Correct answer: When the required aggregation granularity is coarser than the current view's level of detail

FIXED LOD expressions are the right tool when you need to aggregate at a higher (coarser) granularity than what the view displays, such as computing a per-customer average while the view shows individual orders.

Question 29: What is the fundamental principle behind system architecture in the context of Tableau Certified Consultant?

Using the most expensive solutions available
Ensuring reliability, security, and optimal performance (Correct answer)
Avoiding all system changes
Maximizing system complexity

Correct answer: Ensuring reliability, security, and optimal performance

System Architecture in Tableau Certified Consultant fundamentally aims to ensure system reliability, security, and optimal performance.

Question 30: How should you document data management configurations?

Document only when asked by management
Keep all configuration details in personal memory
Maintain up-to-date documentation in a centralized, accessible location (Correct answer)
Store documentation on individual workstations

Correct answer: Maintain up-to-date documentation in a centralized, accessible location

Centralized, accessible, and current documentation is essential for troubleshooting, disaster recovery, and knowledge sharing.

Question 31: What is the purpose of grouping in Tableau?

To aggregate measures across sheets
To change data source filters
To blend data from multiple sources
To combine dimension values into categories (Correct answer)

Correct answer: To combine dimension values into categories

Grouping in Tableau allows users to combine dimension members into higher-level categories to simplify analysis and improve visualization clarity.

Question 32: How should you document compliance standards configurations?

Maintain up-to-date documentation in a centralized, accessible location (Correct answer)
Keep all configuration details in personal memory
Store documentation on individual workstations
Document only when asked by management

Correct answer: Maintain up-to-date documentation in a centralized, accessible location

Centralized, accessible, and current documentation is essential for troubleshooting, disaster recovery, and knowledge sharing.

Question 33: Which approach is recommended for implementing troubleshooting methods changes?

Implementing changes only during peak hours
Skipping documentation to save time
Following a structured change management process with testing (Correct answer)
Making all changes at once without testing

Correct answer: Following a structured change management process with testing

A structured change management process with proper testing minimizes risk and ensures successful implementation.

Question 34: Which Tableau visualization type is best for showing hierarchical data and relative proportions across different categories?

Scatter Plot
Histogram
Tree Map (Correct answer)
Line Chart

Correct answer: Tree Map

Tree maps effectively show hierarchical structures and proportional comparisons between categories.

Question 35: What should you do when troubleshooting a security fundamentals issue?

Follow a systematic approach: identify, research, test, implement, verify (Correct answer)
Immediately restart all systems
Make random changes until the problem goes away
Escalate everything without investigation

Correct answer: Follow a systematic approach: identify, research, test, implement, verify

A systematic troubleshooting approach ensures the root cause is identified and the fix is verified without creating new issues.

Question 36: When should a user create a hierarchy in Tableau?

To enable drill-down functionality in visualizations (Correct answer)
To create calculated fields
To import additional datasets
To filter data at the worksheet level

Correct answer: To enable drill-down functionality in visualizations

Hierarchies are helpful when users want to drill down into multiple levels of a dimension, such as Year > Quarter > Month.

Question 37: What does a hierarchy enable users to do in Tableau visualizations?

Control dashboard layout
Drill down or roll up data across levels (Correct answer)
Remove unwanted data from view
Switch data sources automatically

Correct answer: Drill down or roll up data across levels

Hierarchies allow users to expand or collapse levels of detail, making it easier to explore and analyze data at different granularities.

Question 38: How should you document performance monitoring configurations?

Maintain up-to-date documentation in a centralized, accessible location (Correct answer)
Store documentation on individual workstations
Document only when asked by management
Keep all configuration details in personal memory

Correct answer: Maintain up-to-date documentation in a centralized, accessible location

Centralized, accessible, and current documentation is essential for troubleshooting, disaster recovery, and knowledge sharing.

Question 39: What is the correct Tableau syntax for a FIXED Level of Detail expression that calculates average profit per region?

AVG(FIXED [Region] : [Profit])
{EXCLUDE [Region] : AVG([Profit])}
{FIXED [Region] : AVG([Profit])} (Correct answer)
{INCLUDE [Region] : AVG([Profit])}

Correct answer: {FIXED [Region] : AVG([Profit])}

FIXED LOD expressions use curly braces with the keyword FIXED, followed by the dimension declaration, a colon, and the aggregate expression.

Question 40: What is the best practice for monitoring network configuration systems?

Monitor only when users report problems
Rely on vendor notifications exclusively
Check systems manually once a month
Implement automated monitoring with alerting thresholds (Correct answer)

Correct answer: Implement automated monitoring with alerting thresholds

Automated monitoring with properly configured alerting thresholds enables proactive identification and resolution of issues.

Question 41: Which LOD expression type adds a dimension to the view's level of detail for the purpose of a finer-grained computation?

FIXED
EXCLUDE
CONTEXT
INCLUDE (Correct answer)

Correct answer: INCLUDE

INCLUDE LOD expressions add the specified dimension to whatever granularity is in the view, resulting in a finer aggregation that is then re-aggregated at the view level.

Question 42: What is the output of the Tableau ZN() function when applied to a field that contains a NULL value?

It excludes the NULL from subsequent aggregations
It replaces the NULL with zero (0) (Correct answer)
It converts the NULL to an empty string
It normalizes the value between 0 and 1

Correct answer: It replaces the NULL with zero (0)

ZN() (Zero for Null) replaces NULL values with 0, preventing NULLs from propagating through calculations where a zero would be semantically correct.

Question 43: How should you document security fundamentals configurations?

Document only when asked by management
Store documentation on individual workstations
Maintain up-to-date documentation in a centralized, accessible location (Correct answer)
Keep all configuration details in personal memory

Correct answer: Maintain up-to-date documentation in a centralized, accessible location

Centralized, accessible, and current documentation is essential for troubleshooting, disaster recovery, and knowledge sharing.

Question 44: What security consideration is most important in network configuration?

Security is not relevant to this area
Using a single strong password for all systems
Implementing the principle of least privilege and defense in depth (Correct answer)
Disabling logging to improve performance

Correct answer: Implementing the principle of least privilege and defense in depth

The principle of least privilege combined with defense in depth provides layered security that protects against various attack vectors.

Question 45: What should you do when troubleshooting a implementation planning issue?

Immediately restart all systems
Escalate everything without investigation
Make random changes until the problem goes away
Follow a systematic approach: identify, research, test, implement, verify (Correct answer)

Correct answer: Follow a systematic approach: identify, research, test, implement, verify

A systematic troubleshooting approach ensures the root cause is identified and the fix is verified without creating new issues.

Question 46: What is the main advantage of using dashboards in Tableau?

Generating new data sources
Improving data storage
Creating complex calculations
Interactive and simultaneous analysis (Correct answer)

Correct answer: Interactive and simultaneous analysis

Dashboards provide interactive visualizations allowing users to analyze multiple views and data insights simultaneously.

Question 47: What is the effect of promoting a dimension filter to a context filter in relation to FIXED LOD expressions?

Context filters have no effect on FIXED LOD expressions
The context filter removes the need for LOD expressions in that view
The FIXED LOD expression is now evaluated after the context filter, causing it to respect the filter (Correct answer)
The context filter converts FIXED LOD expressions into INCLUDE LOD behavior

Correct answer: The FIXED LOD expression is now evaluated after the context filter, causing it to respect the filter

Context filters are applied before FIXED LOD expressions in Tableau's order of operations, so promoting a dimension filter to context causes FIXED LOD calculations to be scoped to the filtered data.

Question 48: What security consideration is most important in performance monitoring?

Security is not relevant to this area
Using a single strong password for all systems
Implementing the principle of least privilege and defense in depth (Correct answer)
Disabling logging to improve performance

Correct answer: Implementing the principle of least privilege and defense in depth

The principle of least privilege combined with defense in depth provides layered security that protects against various attack vectors.

Question 49: What should you do when troubleshooting a troubleshooting methods issue?

Make random changes until the problem goes away
Follow a systematic approach: identify, research, test, implement, verify (Correct answer)
Immediately restart all systems
Escalate everything without investigation

Correct answer: Follow a systematic approach: identify, research, test, implement, verify

A systematic troubleshooting approach ensures the root cause is identified and the fix is verified without creating new issues.

Question 50: Which Tableau field type would you use to represent discrete categorical data such as product names?

Dimension (Correct answer)
Measure
Continuous
Aggregate

Correct answer: Dimension

Dimensions represent discrete categorical data like product names, locations, or categories.

Question 51: What should you do when troubleshooting a performance monitoring issue?

Escalate everything without investigation
Make random changes until the problem goes away
Follow a systematic approach: identify, research, test, implement, verify (Correct answer)
Immediately restart all systems

Correct answer: Follow a systematic approach: identify, research, test, implement, verify

A systematic troubleshooting approach ensures the root cause is identified and the fix is verified without creating new issues.

Question 52: What is the fundamental principle behind security fundamentals in the context of Tableau Certified Consultant?

Avoiding all system changes
Ensuring reliability, security, and optimal performance (Correct answer)
Maximizing system complexity
Using the most expensive solutions available

Correct answer: Ensuring reliability, security, and optimal performance

Security Fundamentals in Tableau Certified Consultant fundamentally aims to ensure system reliability, security, and optimal performance.

Question 53: In a Tableau table calculation configured with 'Compute Using: Specific Dimensions,' what role does the partitioning configuration play?

It defines the group of cells within which the calculation resets and restarts (Correct answer)
It determines the traversal order of rows for the calculation
It sets the filter applied to data before the table calculation executes
It specifies which dimensions are included in the aggregate before the calculation

Correct answer: It defines the group of cells within which the calculation resets and restarts

Partitioning defines the boundaries of each independent group; when the table calculation moves from one partition to another, it restarts from the beginning.

Question 54: Which Tableau feature simplifies data by creating custom regions or segments?

Groups (Correct answer)
Bins
Sets
Filters

Correct answer: Groups

Groups are used in Tableau to create custom segments from existing data, helping simplify complex data into meaningful categories.

Question 55: Which type of Tableau calculation is executed by the Tableau engine after data has been retrieved from the data source, rather than being pushed to the database?

Table calculations (Correct answer)
Data source calculations
Extract calculations
Row-level calculations

Correct answer: Table calculations

Table calculations are computed by Tableau's query engine on the aggregated result set already returned from the data source, not at the database level.

Question 56: What is the best practice for monitoring system architecture systems?

Rely on vendor notifications exclusively
Monitor only when users report problems
Check systems manually once a month
Implement automated monitoring with alerting thresholds (Correct answer)

Correct answer: Implement automated monitoring with alerting thresholds

Automated monitoring with properly configured alerting thresholds enables proactive identification and resolution of issues.

Question 57: What is a key benefit of using Sets in Tableau?

They simplify dashboards visually
They blend datasets across worksheets
They allow changing data types
They create dynamic groups based on logic or user input (Correct answer)

Correct answer: They create dynamic groups based on logic or user input

Sets allow for dynamic comparison and flexible filtering based on conditions or specific selections, enabling more advanced analyses.

Question 58: What is the fundamental principle behind network configuration in the context of Tableau Certified Consultant?

Avoiding all system changes
Using the most expensive solutions available
Maximizing system complexity
Ensuring reliability, security, and optimal performance (Correct answer)

Correct answer: Ensuring reliability, security, and optimal performance

Network Configuration in Tableau Certified Consultant fundamentally aims to ensure system reliability, security, and optimal performance.

Question 59: A consultant needs to assign each customer to a cohort based on the month of their very first purchase, regardless of what filters are applied to the view. Which approach is most appropriate?

DATEDIFF('month', [Order Date], TODAY())
DATETRUNC('month', [Order Date])
WINDOW_MIN(MIN([Order Date]))
{FIXED [Customer ID] : MIN([Order Date])} (Correct answer)

Correct answer: {FIXED [Customer ID] : MIN([Order Date])}

A FIXED LOD expression using MIN([Order Date]) anchored to [Customer ID] computes the first purchase date per customer independent of view filters, enabling accurate cohort assignment.

Question 60: What type of chart in Tableau is most suitable for showing changes over time?

Line Chart (Correct answer)
Bar Chart
Pie Chart
Scatter Plot

Correct answer: Line Chart

Line charts are optimal for visualizing trends and changes over time.

Question 61: What is the best practice for monitoring performance monitoring systems?

Implement automated monitoring with alerting thresholds (Correct answer)
Rely on vendor notifications exclusively
Monitor only when users report problems
Check systems manually once a month

Correct answer: Implement automated monitoring with alerting thresholds

Automated monitoring with properly configured alerting thresholds enables proactive identification and resolution of issues.

Question 62: Which approach is recommended for implementing performance monitoring changes?

Making all changes at once without testing
Implementing changes only during peak hours
Skipping documentation to save time
Following a structured change management process with testing (Correct answer)

Correct answer: Following a structured change management process with testing

A structured change management process with proper testing minimizes risk and ensures successful implementation.

Question 63: Which approach is recommended for implementing data management changes?

Following a structured change management process with testing (Correct answer)
Skipping documentation to save time
Making all changes at once without testing
Implementing changes only during peak hours

Correct answer: Following a structured change management process with testing

A structured change management process with proper testing minimizes risk and ensures successful implementation.

Question 64: What security consideration is most important in data management?

Using a single strong password for all systems
Implementing the principle of least privilege and defense in depth (Correct answer)
Disabling logging to improve performance
Security is not relevant to this area

Correct answer: Implementing the principle of least privilege and defense in depth

The principle of least privilege combined with defense in depth provides layered security that protects against various attack vectors.

Question 65: Which approach is recommended for implementing network configuration changes?

Following a structured change management process with testing (Correct answer)
Making all changes at once without testing
Skipping documentation to save time
Implementing changes only during peak hours

Correct answer: Following a structured change management process with testing

A structured change management process with proper testing minimizes risk and ensures successful implementation.

Salesforce Tableau Certified Consultant (TCC-C01)

The Tableau Certified Consultant exam validates expertise in designing and implementing enterprise Tableau solutions, including data connections, advanced calculations, workbook design, and governance on Tableau Server or Cloud.

Questions

105 min

Time Limit

63%

To Pass

Checking for saved progress...

Exam Rules

You can skip questions and return to them later
Flag questions for review before submitting
No feedback shown until you submit the entire exam
Unanswered questions count as wrong — answer everything
10 pretest questions are mixed in and don't affect your score
Timer auto-submits when time runs out
Your progress is auto-saved every 30 seconds