ExamGecko
Home / Tableau / TCC-C01
Ask Question

TCC-C01: Tableau Certified Consultant

Vendor:
Exam Questions:
55
 Learners
  2.370
Last Updated
April - 2025
Language
English
2 Quizzes
PDF | VPLUS

Exam Number: TCC-C01

Exam Name: Tableau Certified Consultant

Length of test: 120 mins

Exam Format: Multiple-choice questions.

Exam Language: English

Number of questions in the actual exam: 40-45 questions

Passing Score: 750 out of 1000

This study guide should help you understand what to expect on TCC-C01 exam and includes a summary of the topics the exam might cover and links to additional resources. The information and materials in this document should help you focus your studies as you prepare for the exam.

Related questions

A university has data on its undergraduate students and their majors by grade level (Freshman, Sophomore, Junior, Senior). The university is interested in visualizing the path students take as they change majors across grade levels.

Which visualization type should the consultant recommend?

Become a Premium Member for full access
  Unlock Premium Member

From the desktop, open the CC workbook.

Open the City Pareto worksheet.

You need to complete the Pareto chart to show the percentage of sales compared to the percentage of cities. The chart must show references lines to visualize how the data compares to the Pareto principle.

From the File menu in Tableau Desktop, click Save.

Become a Premium Member for full access
  Unlock Premium Member

A client has a dashboard that uses a bar chart to visualize sales by Sub-Category and a detail table that has all the orders for the products within Sub-

Category. The table has more than 10,000 rows of data and is slow to load.

A consultant plans to add an action so when the client interacts with the bar chart, only the relevant data appears in the table.

What will provide the fastest rendering of the dashboard?

Add a filter action, set 'Run action on' to Select, and set 'Clearing the selection will' to Exclude all values.

Add a filter action, set 'Run action on' to Select, and set 'Clearing the selection will' to Exclude all values.

Add a highlight action and set Target Highlighting to Sub-Category.

Add a highlight action and set Target Highlighting to Sub-Category.

Add a highlight action and set Target Highlighting to All Fields.

Add a highlight action and set Target Highlighting to All Fields.

Add a filter action, set 'Run action on' to Menu, and set 'Clearing the selection will' to Show all values.

Add a filter action, set 'Run action on' to Menu, and set 'Clearing the selection will' to Show all values.

Suggested answer: A
Explanation:

To optimize the dashboard rendering, particularly when dealing with a large dataset, a filter action is the most effective tool. Here's why the specified choice is optimal:

Add a filter action: This action creates a direct filter on the detail table based on the selection in the bar chart. It ensures that only data related to the selected sub-category is loaded into the table, significantly reducing load time and improving performance.

Set 'Run action on' to Select: This setting means the filter action will be triggered as soon as the user selects a bar in the bar chart. Immediate activation of the filter ensures that the dashboard is interactive and responsive.

Set 'Clearing the selection will' to Exclude all values: When the selection is cleared, this setting ensures that no data is shown, which avoids loading the entire dataset unnecessarily. This maintains performance when no sub-category is actively selected.

Reference This strategy follows Tableau's performance best practices by using actions to limit the amount of data processed and rendered, as detailed in the Tableau User Guide and training materials on Dashboard Actions for optimizing large datasets.

asked 08/12/2024
javier mungaray
43 questions

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.

Tableau TCC-C01 image Question 55 132026 12082024232714000000

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

Become a Premium Member for full access
  Unlock Premium Member

A client wants to count all the distinct orders placed in 2010. They have written the following calculation, but the result is incorrect.

IF YEAR([Date])=2010 THEN COUNTD ([OrderID]) END

Which calculation will produce the correct result?

Become a Premium Member for full access
  Unlock Premium Member

A client needs to design row-level security (RLS) measures for their reports. The client does not currently have Tableau Data Management Add-on, and it may be an option in the future.

What should the consultant recommend as the safest and easiest way to manage for the long term?

Become a Premium Member for full access
  Unlock Premium Member

A Tableau Cloud client has requested a custom dashboard to help track which data sources are used most frequently in dashboards across their site.

Which two actions should the client use to access the necessary metadata? Choose two.

Become a Premium Member for full access
  Unlock Premium Member

A client wants to see the average number of orders per customer per month, broken down by region. The client has created the following calculated field:

Orders per Customer: {FIXED [Customer ID]: COUNTD([Order ID])}

The client then creates a line chart that plots AVG(Orders per Customer) over MONTH(Order Date) by Region. The numbers shown by this chart are far higher than the customer expects.

The client asks a consultant to rewrite the calculation so the result meets their expectation.

Which calculation should the consultant use?

Become a Premium Member for full access
  Unlock Premium Member

A client wants guidance for Creators to build efficient extracts from large data sources.

What are three Tableau best practices that the Creators should use? Choose three.

Keep only the data required for analysis by using extract filters.

Keep only the data required for analysis by using extract filters.

Use aggregate data for visible dimensions, whenever possible.

Use aggregate data for visible dimensions, whenever possible.

Use only live connections as they are always faster than extracts.

Use only live connections as they are always faster than extracts.

Include all the data from the original data source in the extract.

Include all the data from the original data source in the extract.

Hide all unused fields.

Hide all unused fields.

Suggested answer: A, B, E
Explanation:

To build efficient extracts from large data sources, it is crucial to minimize the load and optimize the performance of the extracts:

A . Keep only the data required for analysis by using extract filters: This best practice involves using filters to reduce the volume of data extracted, thus focusing only on the data necessary for analysis.

B . Use aggregate data for visible dimensions, whenever possible: Aggregating data at the time of extraction reduces the granularity of the data, which can significantly improve performance and reduce the size of the extract.

E . Hide all unused fields: Removing fields that are not needed for analysis from the extract reduces the complexity and size of the data model, which in turn enhances performance and speeds up load times.

These practices are endorsed in Tableau's official documentation and training sessions as effective ways to enhance the performance of Tableau extracts and optimize dashboard responsiveness.

asked 08/12/2024
Sana Mehak
48 questions

A consultant builds a report where profit margin is calculated as SUM([Profit]) / SUM([Sales]). Three groups of users are organized on Tableau Server with the following levels of data access that they can be granted.

. Group 1: Viewers who cannot see any information on profitability

. Group 2: Viewers who can see profit and profit margin

. Group 3: Viewers who can see profit margin but not the value of profit

Which approach should the consultant use to provide the required level of access?

Become a Premium Member for full access
  Unlock Premium Member