Page: 1
/ 14
Total 55 questions
Tableau TCC-C01 Tableau Certified Consultant Exam Practice Test
Question 1
A client's dashboard has two sections dedicated to their shops and warehouses shown when a viewer chooses either shops or warehouses with a parameter.
There are a few quick filters that apply to both, while others apply to only shops or only warehouses.
Currently, the quick filters are all shown at the left side of the dashboard. The client wants to hide all filters, but when shown, make it easy for the viewer to
find the quick filters that work for only shops or only warehouses.
Which solution should the consultant recommend that meets the client's needs and is most user-friendly?
Question 2
A client has a database that stores widget inventory by day and it is updated on a nonstandard schedule as shown below.
They want a data visualization that shows widget inventory daily, however their business unit does not have the ability to modify the data warehouse
structure.
What should the client do to achieve the desired result?
Answer : D
For a client who needs a daily visualization of widget inventory but cannot modify the data warehouse structure, the best approach is to use Tableau Prep to add new rows. Tableau Prep can be used to manipulate the existing dataset by adding missing date entries and appropriately adjusting inventory counts based on available data. This allows the creation of a complete daily snapshot for visualization without needing changes to the underlying database structure.
Question 3
A client has a published dashboard. They change the dashboard and then republish it. Now, users report that their web browser bookmarks to the dashboard
are broken.
What are two possible causes for this issue? Choose two.
Answer : B, D
When a client republishes a dashboard after making changes and users report broken bookmarks, the likely causes include:
The dashboard was published to a different project: Changing the project location alters the URL path, causing bookmarks to point to a now non-existent dashboard location.
The dashboard was published with a new name: Altering the dashboard's name changes its URL, resulting in broken bookmarks as the previous URL no longer leads to the intended dashboard.
Question 4
A consultant migrated a data source to improve performance. The consultant wants to identify which workbooks need to be updated to point to the new data
source.
Which Tableau tool should the consultant use?
Answer : D
To identify which workbooks need to be updated to point to a new data source after a migration, a consultant should use Tableau Advanced Management. This component of Tableau provides comprehensive management capabilities including the ability to track workbook dependencies and data source usage across your entire Tableau environment. Using Tableau Advanced Management allows consultants to assess the impact of changes in the data source on connected workbooks and efficiently manage updates.
Question 5
Refer to the exhibit.
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\.
Answer : A
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.
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.
Topic 3, Knowledge-Based Section B
Question 6
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.
Answer : A
To complete the Pareto chart in the 'City Pareto' worksheet of your Tableau Desktop and add reference lines to illustrate how the data compares to the Pareto principle, follow these 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 City Pareto worksheet by selecting its tab at the bottom of the window.
Construct the Pareto Chart:
Ensure that sales data is aggregated by city. If not, drag the 'City' dimension to the Columns shelf and the 'Sales' measure to the Rows shelf.
Sort the sales data in descending order to properly align the cities according to their sales contribution.
To create a running total of sales, right-click on the 'Sales' measure on the Rows shelf, select 'Quick Table Calculation', and choose 'Running Total'.
Drag the 'Number of Records' field to the Rows shelf next to the Sales running total. Right-click on it, select 'Quick Table Calculation', and choose 'Running Total'. Set its calculation to 'Percent of Total' from the 'Edit Table Calculation' option to represent the percentage of cities.
Add Reference Lines for the Pareto Principle:
Click on the Analytics tab in the sidebar.
Drag a 'Reference Line' element and drop it onto the chart area.
Set the Reference Line for the Sales axis at 80% to represent the typical Pareto cutoff where 80% of effects come from 20% of causes.
Add another Reference Line on the axis representing the percentage of cities, set at 20%, to visually assess the Pareto principle.
Adjust the Appearance of the Chart:
Format the reference lines by right-clicking on them, selecting 'Edit', and choosing a distinct style or color to make them stand out.
Ensure the chart is clear and labels are appropriately adjusted for easy understanding of the data visualization.
Save Your Changes:
From the File menu, click 'Save' to ensure all your changes are stored.
Tableau Help: Offers detailed guidance on creating Pareto charts and adding reference lines.
Tableau Visualization Best Practices: Provides tips on effectively displaying cumulative data and principles such as Pareto.
By following these steps, you will have successfully enhanced the City Pareto worksheet to include a complete Pareto chart with reference lines that illustrate how the sales data compares to the Pareto principle, making it easier to analyze and communicate the distribution of sales across cities.
Question 7
From the desktop, open the CC workbook. Use the US Population Estimates data source.
You need to shape the data in US Population Estimates by using Tableau Desktop. The data must be formatted as shown in the following table.
Open the Population worksheet. Enter the total number of records contained in the data set into the Total Records parameter.
From the File menu in Tableau Desktop, click Save.
Answer : A
To shape the data in the 'US Population Estimates' data source and enter the total number of records into the 'Total Records' parameter in Tableau Desktop, follow these 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 Population worksheet by selecting its tab at the bottom of the window.
Format and Shape the Data:
Ensure the data types match those specified in the requirements: Sex, Origin, Race as strings; Year, Age, Population as whole numbers.
To verify or change the data type, click on the dropdown arrow next to each field name in the Data pane and select 'Change Data Type' if necessary.
Calculate Total Number of Records:
Create a new calculated field named 'Total Records'. To do this, right-click in the Data pane and select 'Create Calculated Field'.
Enter the formula COUNT([Record ID]) or SUM([Number of Records]) depending on how the data source identifies each row uniquely.
Drag this new calculated field onto the worksheet to display the total number of records.
Enter the Value into the Total Records Parameter:
Locate the 'Total Records' parameter in the Data pane. Right-click on the parameter and select 'Edit'.
Manually enter the number displayed from the calculated field into the parameter, ensuring accuracy to meet the data shaping requirement.
Save Your Changes:
From the File menu, click 'Save' to ensure all your changes are stored.
Tableau Desktop Guide: Provides detailed instructions on managing data types, creating calculated fields, and updating parameters.
Tableau Data Shaping Techniques: Outlines effective methods for manipulating and structuring data for analysis.
This process will ensure the data in the 'US Population Estimates' is accurately shaped according to the specified format and that the total number of records is correctly calculated and entered into the designated parameter. This thorough approach ensures data integrity and accuracy in reporting.
All Official Question Types