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

Question 1: What is the best practice for monitoring implementation planning systems?

Rely on vendor notifications exclusively
Check systems manually once a month
Monitor only when users report problems
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 2: 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?

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

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 3: What does a hierarchy enable users to do in Tableau visualizations?

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

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 4: Which approach is recommended for implementing compliance standards changes?

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

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 5: Which approach is recommended for implementing troubleshooting methods changes?

Implementing changes only during peak hours
Following a structured change management process with testing (Correct answer)
Skipping documentation to save time
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 6: Which approach is recommended for implementing network configuration changes?

Following a structured change management process with testing (Correct answer)
Skipping documentation to save time
Implementing changes only during peak hours
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 7: What is the primary functional difference between a calculated field and a parameter in Tableau?

Calculated fields support only numeric data while parameters support all data types
Calculated fields can reference parameters, but parameters cannot reference calculated fields
Parameters are stored in the data source while calculated fields exist only in workbooks
Parameters are static, user-controlled input values while calculated fields are dynamic expressions evaluated against data (Correct answer)

Correct answer: Parameters are static, user-controlled input values while calculated fields are dynamic expressions evaluated against data

Parameters hold a single user-selected value that can be fed into calculations, whereas calculated fields define a dynamic formula that is evaluated row-by-row or as an aggregate against the data.

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

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

Correct answer: Worksheets, dashboards, and text

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

Question 9: How should you document implementation planning configurations?

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

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 10: Which approach is recommended for implementing data management changes?

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

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 11: Which Tableau expression correctly calculates the year-over-year sales growth percentage using a table calculation?

(SUM([Sales]) - LOOKUP(SUM([Sales]), -1)) / ABS(LOOKUP(SUM([Sales]), -1)) (Correct answer)
{FIXED YEAR([Order Date]) : SUM([Sales])} / {FIXED : SUM([Sales])}
DATEDIFF('year', [Order Date], TODAY()) * SUM([Sales])
(SUM([Sales]) - SUM([Sales])) / SUM([Sales]) * 100

Correct answer: (SUM([Sales]) - LOOKUP(SUM([Sales]), -1)) / ABS(LOOKUP(SUM([Sales]), -1))

LOOKUP(SUM([Sales]), -1) retrieves the previous period's sales value, and dividing the difference by that prior value yields the year-over-year growth rate.

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

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

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 13: What is the best practice for monitoring performance monitoring systems?

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

Correct answer: Implement automated monitoring with alerting thresholds

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

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

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

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 15: What is the best practice for monitoring data management systems?

Rely on vendor notifications exclusively
Monitor only when users report problems
Implement automated monitoring with alerting thresholds (Correct answer)
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 16: Which Tableau feature simplifies data by creating custom regions or segments?

Sets
Groups (Correct answer)
Filters
Bins

Correct answer: Groups

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

Question 17: What should you do when troubleshooting a network configuration issue?

Make random changes until the problem goes away
Immediately restart all systems
Escalate everything without investigation
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 18: What is the best practice for monitoring troubleshooting methods systems?

Monitor only when users report problems
Implement automated monitoring with alerting thresholds (Correct answer)
Rely on vendor notifications exclusively
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 19: What security consideration is most important in security fundamentals?

Disabling logging to improve performance
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

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 20: What is the best practice for monitoring network configuration systems?

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

Correct answer: Implement automated monitoring with alerting thresholds

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

Question 21: What is the fundamental principle behind troubleshooting methods in the context of Tableau Certified Consultant?

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

Correct answer: Ensuring reliability, security, and optimal performance

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

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

Immediately restart all systems
Follow a systematic approach: identify, research, test, implement, verify (Correct answer)
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 23: What is the output of the Tableau ZN() function when applied to a field that contains a NULL value?

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

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 24: What is the purpose of using a data extract in Tableau?

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

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 25: What security consideration is most important in performance monitoring?

Implementing the principle of least privilege and defense in depth (Correct answer)
Disabling logging to improve performance
Using a single strong password for all systems
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 26: Which of the following is the most appropriate use case for an EXCLUDE LOD expression in Tableau?

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

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 27: How should you document data management configurations?

Keep all configuration details in personal memory
Maintain up-to-date documentation in a centralized, accessible location (Correct answer)
Document only when asked by management
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 28: What is the effect of promoting a dimension filter to a context filter in relation to FIXED LOD expressions?

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

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 29: Which file type is created when data is extracted in Tableau?

.csv
.twb
.hyper (Correct answer)
.tde

Correct answer: .hyper

The .hyper file format is Tableau’s optimized extract file used to store extracted data.

Question 30: Which Tableau chart type is best for comparing proportions within a whole?

Box Plot
Pie Chart (Correct answer)
Tree Map
Histogram

Correct answer: Pie Chart

Pie charts effectively illustrate proportional relationships within a dataset.

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

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

Correct answer: Line Chart

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

Question 32: What is the primary purpose of the TOTAL() function within a Tableau table calculation?

It calculates a running total from the first row through the current row
It returns the sum of values across the entire current partition of a table calculation (Correct answer)
It aggregates all values in the database ignoring the current view entirely
It computes a grand total by querying across all rows in the data source

Correct answer: It returns the sum of values across the entire current partition of a table calculation

TOTAL() returns an aggregate (defaulting to SUM) of the expression across the entire current partition, making it useful for computing percentages of total within each partition.

Question 33: 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 34: 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 35: What security consideration is most important in implementation planning?

Security is not relevant to this area
Implementing the principle of least privilege and defense in depth (Correct answer)
Using a single strong password for all systems
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 36: What security consideration is most important in network configuration?

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 37: What security consideration is most important in system architecture?

Security is not relevant to this area
Implementing the principle of least privilege and defense in depth (Correct answer)
Using a single strong password for all systems
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 38: Which of the following is TRUE about a live connection in Tableau?

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

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 39: Why would you use layout containers in a Tableau dashboard?

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

Correct answer: To organize visualizations neatly

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

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

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

Correct answer: Box Plot

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

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

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

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 42: How should you document compliance standards configurations?

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

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 43: How should you document performance monitoring configurations?

Maintain up-to-date documentation in a centralized, accessible location (Correct answer)
Store documentation on individual workstations
Keep all configuration details in personal memory
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 44: Which approach is recommended for implementing implementation planning changes?

Making all changes at once without testing
Skipping documentation to save time
Following a structured change management process with testing (Correct answer)
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 45: 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 46: Which type of Tableau expression computes a result at a specified dimension level regardless of the filters applied to the current view?

EXCLUDE LOD expression
Running Total table calculation
FIXED LOD expression (Correct answer)
INCLUDE 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 47: What should you do when troubleshooting a performance monitoring issue?

Immediately restart all systems
Follow a systematic approach: identify, research, test, implement, verify (Correct answer)
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 48: What is the fundamental principle behind performance monitoring 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

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

Question 49: Which approach is recommended for implementing system architecture changes?

Making all changes at once without testing
Skipping documentation to save time
Following a structured change management process with testing (Correct answer)
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 50: What is the best practice for monitoring security fundamentals systems?

Rely on vendor notifications exclusively
Check systems manually once a month
Implement automated monitoring with alerting thresholds (Correct answer)
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 51: What Tableau feature would you use to automatically refresh dashboard data at specific intervals?

Tableau Desktop
Tableau Prep
Tableau Reader
Tableau Server (Correct answer)

Correct answer: Tableau Server

Tableau Server allows setting automatic data refreshes for dashboards to keep visualizations up to date.

Question 52: What is a primary advantage of using data blending in Tableau?

It increases the file size of extracts
It supports combining unrelated data from multiple sources (Correct answer)
It merges tables from the same source
It automates dashboard publishing

Correct answer: It supports combining unrelated data from multiple sources

Data blending allows combining data from different sources that don't have a direct join capability, enabling broader analysis.

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

{EXCLUDE [Region] : AVG([Profit])}
{FIXED [Region] : AVG([Profit])} (Correct answer)
{INCLUDE [Region] : AVG([Profit])}
AVG(FIXED [Region] : [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 54: When connecting to multiple tables in Tableau, which option allows you to create relationships between them without merging data?

Joins
Blends
Relationships (Correct answer)
Unions

Correct answer: Relationships

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

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

Scatter Plot
Tree Map (Correct answer)
Line Chart
Histogram

Correct answer: Tree Map

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

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

Implementing the principle of least privilege and defense in depth (Correct answer)
Security is not relevant to this area
Using a single strong password for all systems
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 57: In Tableau, what are 'stories' primarily used for?

Sequential data storytelling (Correct answer)
Real-time data updating
Data cleansing
Interactive calculation

Correct answer: Sequential data storytelling

Stories in Tableau are used for presenting data findings in a sequential, narrative format for effective storytelling.

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

Context Filters
Parameters
Quick Filters
Dashboard Actions (Correct answer)

Correct answer: Dashboard Actions

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

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

Skipping documentation to save time
Implementing changes only during peak hours
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 60: When should a user create a hierarchy in Tableau?

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

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 61: How should you document network configuration configurations?

Store documentation on individual workstations
Document only when asked by management
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 62: What is the main advantage of using dashboards in Tableau?

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

Correct answer: Interactive and simultaneous analysis

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

Question 63: 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?

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

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 64: 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 65: What should you do when troubleshooting a compliance standards 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.

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