Weekend Sale Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: pass65

TCC-C01 Tableau Certified Consultant Questions and Answers

Questions 4

A client has a large data set that contains more than 10 million rows.

A consultant wants to calculate a profitability threshold as efficiently as possible. The calculation must classify the profits by using the following specifications:

. Classify profit margins above 50% as Highly Profitable.

. Classify profit margins between 0% and 50% as Profitable.

. Classify profit margins below 0% as Unprofitable.

Which calculation meets these requirements?

Options:

A.

IF [ProfitMargin]>0.50 Then 'Highly Profitable'

ELSEIF [ProfitMargin]>=0 Then 'Profitable'

ELSE 'Unprofitable'

END

B.

IF [ProfitMargin]>=0.50 Then 'Highly Profitable'

ELSEIF [ProfitMargin]>=0 Then 'Profitable'

ELSE 'Unprofitable'

END

C.

IF [ProfitMargin]>0.50 Then 'Highly Profitable'

ELSEIF [ProfitMargin]>=0 Then 'Profitable'

ELSEIF [ProfitMargin] <0 Then 'Unprofitable'

END

D.

IF([ProfitMargin]>=0.50,'Highly Profitable', 'Profitable')

ELSE 'Unprofitable'

END

Buy Now
Questions 5

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

Which calculated field will produce the required result?

Options:

A.

[Sales]

>

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

B.

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

>

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

C.

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

>

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

D.

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

>

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

Buy Now
Questions 6

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?

Options:

A.

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

B.

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

C.

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

D.

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

Buy Now
Questions 7

A client requests a published Tableau data source that is connected to SQL Server. The client needs to leverage the multiple tables option to create an

extract. The extract will include partial data from the SQL Server data source.

Which action will reduce the amount of data in the extract?

Options:

A.

Use an extract filter.

B.

Aggregate the extract to the visible dimensions.

C.

Define the filters by using custom SQL.

D.

Set up the extract as an incremental refresh.

Buy Now
Questions 8

A client calculates the percent of total sales for a particular region compared to all regions.

TCC-C01 Question 8

Which calculation will fix the automatic recalculation on the % of total field?

Options:

A.

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

B.

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

C.

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

D.

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

Buy Now
Questions 9

A client has several long-term shipping contracts with different vendors that set rates based on shipping volume and speed. The client requests a dashboard

that allows them to model shipping costs for the next week based on the selected shipping vendor. Speed for the end user is critical.

Which dashboard building strategy will deliver the desired result?

Options:

A.

Recommend that the client model for only profitability for the next 24 hours instead of a full week.

B.

Calculate the potential shipping cost for each order with each vendor, display the aggregate costs in a large table, and use quick filters to

limit the options visible to the user.

C.

Aggregate the orders then use a calculated field that refers to a user-selected parameter to calculate the shipping costs.

D.

Use a calculated field that refers to a user-selected parameter to calculate shipping costs for each order and then display the aggregate

values.

Buy Now
Questions 10

TCC-C01 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\.

Options:

Buy Now
Questions 11

From the desktop, open the CC workbook.

Open the City Pareto worksheet.

You need to complete the Pareto chart toshow the percentage of sales compared tothe percentage of cities. The chart mustshow references lines to visualize how thedata compares to the Pareto principle.

From the File menu in Tableau Desktop, clickSave.

Options:

Buy Now
Questions 12

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.

TCC-C01 Question 12

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.

Options:

Buy Now
Questions 13

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.

Options:

Buy Now
Questions 14

From the desktop, open the CCworkbook. Use the US PopulationEstimates data source.

You need to shape the data in USPopulation Estimates by using TableauDesktop. The data must be formatted asshown in the following table.

TCC-C01 Question 14

Open the Population worksheet. Enterthe total number of records contained inthe data set into the Total Recordsparameter.

From the File menu in Tableau Desktop,click Save.

Options:

Buy Now
Questions 15

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.

Options:

Buy Now
Exam Code: TCC-C01
Exam Name: Tableau Certified Consultant
Last Update: Dec 13, 2024
Questions: 55

PDF + Testing Engine

$57.75  $164.99

Testing Engine

$43.75  $124.99
buy now TCC-C01 testing engine

PDF (Q&A)

$36.75  $104.99
buy now TCC-C01 pdf