Tableau Tableau Certified Consultant TCC-C01 Exam Dumps: Updated Questions & Answers (October 2025)

Question # 1

A client currently has a workbook with the table shown below.

Which method will produce the output for the Total Sales Value field for all the categories shown in the table?

Quick Table Calculation

A Window Function

Level of Detail (LOD) Calculation

MAX() Function

Question # 2

A client is working in Tableau Prep and has a field named Orderld that is compiled by country, year, and an order number as shown in the following table.

What should the consultant use to transform the table in the most efficient manner?

A calculated field that uses the TRIM function

A calculated field that uses the LEFT function

The Split option

The Aliases option

Question # 3

A client is searching for ways to curate and document data in order to obtain data lineage. The client has a data source connected to a data lake.

Which tool should the consultant recommend to meet the client's requirements?

Tableau Catalog without Tableau Data Management Add-on

Tableau Catalog with Tableau Data Management Add-on

Tableau Prep Conductor

Tableau Catalog with Tableau Server Management Add-on

Question # 4

A client wants to see data for only the last day in a dataset and the last day is always yesterday. The date is represented with the field Ship Date.

The client is not concerned about the daily refresh results. The volume of data is so large that performance is their priority. In the future, the client will be able

to move the calculation to the underlying database, but not at this time.

The solution should offer the best performance.

Which approach should the consultant use to produce the desired results?

Filter MONTH/DAY/YEAR on [Ship Date] field and use an option to filter to the latest date value when the workbook opens.

Filter on calculation [Ship Date]=TODAY()-1.

Filter on Ship Date field using the Yesterday option.

Filter on calculation [Ship Date]={MAX([Ship Date])}.

Question # 5

A multi-national company wants to have a Tableau dashboard that will provide country-level information for both its forecast summaries and year-on-year

metrics. The company wants to toggle between these two views while leaving main key performance indicators (KPIs) visible on the main dashboard.

Which method is the most efficient in achieving the company's requirements?

Create a dashboard with the sheets containing the main KPIs and the forecast summary worksheet.

. Duplicate this dashboard and replace the forecast view worksheet with the year-on-year metrics worksheet.

. Add navigation buttons to both dashboards.

Create a parameter that accepts values from a list that contains "Forecast View" and "Year-on-Year View."

. Right-click the parameter and select Add to Sheet for both worksheets.

. Navigate back to the dashboard and to the upper corner of the two worksheets.

. Enable the Use as Filter option.

Create a single worksheet with all the measures required for both the forecast summary and the year-on-year views.

. Create a Boolean parameter and a corresponding calculated field with the following calculation: True.

. Add a blank dashboard object and in the Layout tab, check the box for "Control visibility using value" and select the parameter you

created.

Create a Boolean parameter with the two names of the views as aliases and a corresponding calculated field with the following

calculation: True.

. Add the forecast summary sheet to the dashboard and add the year-on-year metrics sheet to the same dashboard as a Floating

dashboard object.

. Add the calculated fields as a Detail under the Marks card of the floating view, create a "Change Parameter" action, and set the

Question # 6

A client wants to flag orders that have sales higher than the regional average.

Which calculated field will produce the required result?

[Sales]

{ FIXED [Order ID] : SUM([Sales]) }

{ FIXED [Region] : SUM([Sales]) }

{ FIXED [Order ID] : SUM([Sales]) }

{ FIXED [Region] : AVG({ FIXED [Order ID] : SUM([Sales]) }) }

{ FIXED [Order ID] : SUM([Sales]) }

{ INCLUDE [Region] : AVG({ FIXED [Order ID] : SUM([Sales]) }) }

Question # 7

Use the following login credentials to sign in

to the virtual machine:

Username: Admin

Password:

The following information is for technical

support purposes only:

Lab Instance: 40201223

To access Tableau Help, you can open the

Help.pdf file on the desktop.

From the desktop, open the CC workbook.

Open the Categorical Sales worksheet.

You need to use table calculations to

compute the following:

. For each category and year, calculate

the average sales by segment.

. Create another calculation to

compute the year-over-year

percentage change of the average

sales by category calculation. Replace

the original measure with the year-

over-year percentage change in the

crosstab.

From the File menu in Tableau Desktop, click

Save.

Question # 8

From the desktop, open the CC workbook.

Open the Manufacturers worksheet.

The Manufacturers worksheet is used to

analyze the quantity of items contributed by

each manufacturer.

You need to modify the Percent

Contribution calculated field to use a Level

of Detail (LOD) expression that calculates

the percentage contribution of each

manufacturer to the total quantity.

Enter the percentage for Newell to the

nearest hundredth of a percent into the

Newell % Contribution parameter.

From the File menu in Tableau Desktop, click

Save.

Explanation:

To modify the Percent Contribution calculated field to use a Level of Detail (LOD) expression and accurately calculate the percentage contribution of each manufacturer to the total quantity, follow these steps:

Open the CC Workbook and Access the Worksheet:

Double-click on the CC workbook from the desktop to open it in Tableau Desktop.

Navigate to the Manufacturers worksheet by selecting its tab at the bottom of the window.

Modify the Percent Contribution Calculated Field:

Navigate to the Data pane and find the "Percent Contribution" calculated field.

Right-click on the "Percent Contribution" field and select 'Edit'.

Modify the formula to incorporate an LOD expression that calculates the total quantity across all manufacturers and the specific quantity per manufacturer:

{FIXED [Manufacturer]: SUM([Quantity])} / {SUM([Quantity])}Quantity])}

This formula uses{FIXED [Manufacturer]: SUM([Quantity])}to compute the total quantity contributed by each manufacturer, regardless of other dimensions in the view. The total quantity{SUM([Quantity])}calculates the grand total across all manufacturers. The division calculates the percentage contribution.

Click 'OK' to save the updated calculated field.

Enter Percentage for Newell:

With the updated "Percent Contribution" field, drag it onto the view to update the chart or table.

Identify the value corresponding to 'Newell' in the updated visualization.

Round this value to the nearest hundredth of a percent as required.

Enter this value into the "Newell % Contribution" parameter. To do this, locate the parameter in the Data pane or on the dashboard, right-click it, and choose 'Edit'. Enter the calculated percentage for Newell.

Save Your Changes:

From the File menu, click 'Save' to store all the modifications you have made to the workbook.

References:

Tableau Help: Offers detailed guidance on using LOD expressions for precise and context-independent aggregations.

Tableau Desktop User Guide: Provides comprehensive instructions on managing calculated fields and parameters, ensuring accurate data analysis.

By following these steps, you will have successfully updated the calculation for percent contribution using LOD expressions, providing a more accurate analysis of each manufacturer's contribution to the total quantity. Moreover, updating the parameter with Newell's specific contribution rounds out the task by reflecting precise data inputs for reporting or further analysis.

Question # 9

From the desktop, open the CC workbook.

Open the Incremental worksheet.

You need to add a line to the chart that

shows the cumulative percentage of sales

contributed by each product to the

incremental sales.

From the File menu in Tableau Desktop, click

Save.

Explanation:

To add a line showing the cumulative percentage of sales contributed by each product to the incremental sales in the Incremental worksheet of your Tableau Desktop, follow these detailed steps:

Open the CC Workbook and Access the Worksheet:

From the desktop, double-click on the CC workbook to open it in Tableau Desktop.

Navigate to the Incremental worksheet by clicking on its tab at the bottom of the window.

Calculate Cumulative Sales Percentage:

Create a new calculated field to compute the cumulative percentage of sales. Right-click in the Data pane and select 'Create Calculated Field'.

Name this field "Cumulative Sales Percentage".

Enter the following formula to calculate the running sum of sales as a percentage of the total sales:

(RUNNING_SUM(SUM([Sales])) / TOTAL(SUM([Sales])) [Sales]))

Click 'OK' to save the calculated field.

Add the Cumulative Sales Percentage Line to the Chart:

Drag the "Cumulative Sales Percentage" field to the Rows shelf, placing it next to the existing Sales measure.

Ensure that the cumulative line appears as a continuous line. Right-click on the "Cumulative Sales Percentage" field on the Rows shelf, select 'Change Chart Type', and choose 'Line'.

Adjust the axis to synchronize or dual-axis if necessary. Right-click on the axis of the "Cumulative Sales Percentage" and select 'Synchronize Axis' if it's on a dual-axis setup.

Format the Cumulative Sales Percentage Line:

Click on the "Cumulative Sales Percentage" line in the visualization.

Navigate to the 'Format' pane to adjust the line style, thickness, and color to make it distinct from other data in the chart.

Save Your Changes:

From the File menu, click 'Save' to ensure all your changes are stored.

References:

Tableau Help: Provides additional details on creating calculated fields and customizing line charts.

Tableau User Guide: Offers extensive instructions on formatting charts, including line types and axis synchronization.

By following these steps, you will successfully add a cumulative sales percentage line to your chart, enhancing the visualization to reflect the incremental contribution of each product to the overall sales in a dynamic and informative manner.

Question # 10

From the desktop, open the NYC

Property Transactions workbook.

You need to record the performance of

the Property Transactions dashboard in

the NYC Property Transactions.twbx

workbook. Ensure that you start the

recording as soon as you open the

workbook. Open the Property

Transactions dashboard, reset the filters

on the dashboard to show all values, and

stop the recording. Save the recording in

C:\CC\Data\.

Create a new worksheet in the

performance recording. In the worksheet,

create a bar chart to show the elapsed

time of each command name by

worksheet, to show how each sheet in

the Property Transactions dashboard

contributes to the overall load time.

From the File menu in Tableau Desktop,

click Save. Save the performance

recording in C:\CC\Data\.

Explanation:

To record the performance of the Property Transactions dashboard in the NYC Property Transactions.twbx workbook and analyze it using a bar chart, follow these detailed steps:

Open the NYC Property Transactions Workbook:

From the desktop, double-click the NYC Property Transactions.twbx workbook to open it in Tableau Desktop.

Start Performance Recording:

Before doing anything else, navigate to the 'Help' menu in Tableau Desktop.

Select 'Settings and Performance', then choose 'Start Performance Recording'.

Open the Property Transactions Dashboard and Reset Filters:

Navigate to the Property Transactions dashboard within the workbook.

Reset all filters to show all values. This usually involves selecting the dropdown on each filter and choosing 'All' or using a 'Reset' button if available.

Stop the Performance Recording:

Go back to the 'Help' menu.

Choose 'Settings and Performance', then select 'Stop Performance Recording'.

Tableau will automatically open a new tab displaying the performance recording results.

Save the Performance Recording:

In the performance recording results tab, go to the 'File' menu.

Click 'Save As' and navigate to the C:\CC\Data\ directory.

Save the file, ensuring it is stored in the desired location.

Create a New Worksheet for Performance Analysis:

Return to the NYC Property Transactions workbook and create a new worksheet by clicking on the 'New Worksheet' icon.

Drag the 'Command Name' field to the Columns shelf.

Drag the 'Elapsed Time' field to the Rows shelf.

Ensure that the 'Worksheet' field is also included in the analysis to break down the time by individual sheets within the dashboard.

Choose 'Bar Chart' from the 'Show Me' options to display the data as a bar chart.

Customize and Finalize the Bar Chart:

Adjust the axes and labels to clearly display the information.

Format the chart to enhance readability, applying color coding or sorting as needed to emphasize sheets with longer load times.

Save Your Work:

Once the new worksheet and the performance recording are complete, ensure all work is saved.

Navigate to the 'File' menu and click 'Save', confirming that changes are stored in the workbook.

References:

Tableau Help Documentation: Provides guidance on how to start and stop performance recordings and analyze them.

Tableau Visualization Techniques: Offers tips on creating effective bar charts for performance data.

By following these steps, you have successfully recorded and analyzed the performance of the Property Transactions dashboard, providing valuable insights into how each component of the dashboard contributes to the overall load time. This analysis is crucial for optimizing dashboard performance and ensuring efficient data visualization.

Summer Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: dcdisc65

Tableau Tableau Certified Consultant TCC-C01 Exam Dumps: Updated Questions & Answers (October 2025)

Answer:

Explanation:

Answer:

Explanation:

Answer:

Explanation:

Answer:

Explanation:

Answer:

Explanation:

Answer:

Explanation:

Answer:

Explanation:

Answer:

Explanation:

Answer:

Explanation:

Answer:

Explanation:

Most Popular Certification Exams

Site Map

Help

Payment

Contact us

Site Secure