TCC-C01: Tableau Certified Consultant
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?
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.
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 highlight action and set Target Highlighting to Sub-Category.
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.
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.
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 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?
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?
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.
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?
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.
Use aggregate data for visible dimensions, whenever possible.
Use only live connections as they are always faster than extracts.
Include all the data from the original data source in the extract.
Hide all unused fields.
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.
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?
Question