Free Tableau TCC-C01 Exam Dumps Questions & Answers

A client creates a report and publishes it to Tableau Server where each department has its own user group set on the server. The client wants to limit visibility of the report to the sales and marketing groups in the most efficient manner.
Which approach should the consultant recommend?

• A.Add user filters from Tableau Server to each worksheet and select only sales and marketing user groups.
• B.Prepare a row-level security (RLS) entitlement table to define limitations of the access and use it to build user filters in the report's data source.
• C.Grant access to the report on the Tableau Server only to the members of sales and marketing user groups.
• D.Use user groups defined on Tableau Server to build user filters in the report's data source.

A client wants to produce a visualization to show quarterly profit growth and aggregated sales totals across a number of product categories from the data provided below.

Which set of charts should the consultant use to meet the client's requirements?

• A.Waterfall chart and tree map
• B.Line and bubble charts
• C.Scatter plot and pie chart
• D.Gantt and bar charts

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?

• A.IF [ProfitMargin]>0.50 Then 'Highly Profitable'
  ELSEIF [ProfitMargin]>=0 Then 'Profitable'
  ELSEIF [ProfitMargin] <0 Then 'Unprofitable'
  END
• B.IF([ProfitMargin]>=0.50,'Highly Profitable', 'Profitable')
  ELSE 'Unprofitable'
  END
• C.IF [ProfitMargin]>0.50 Then 'Highly Profitable'
  ELSEIF [ProfitMargin]>=0 Then 'Profitable'
  ELSE 'Unprofitable'
  END
• D.IF [ProfitMargin]>=0.50 Then 'Highly Profitable'
  ELSEIF [ProfitMargin]>=0 Then 'Profitable'
  ELSE 'Unprofitable'
  END

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.COUNTD(IF YEAR([Date])=2010 THEN [OrderID] END)
• B.IF YEAR([Date])=2010 THEN {COUNTD ([OrderID])} END
• C.IF MIN(YEAR([Date]))=2010 THEN WINDOW_COUNTD([OrderID]) END
• D.COUNT(IF YEAR([Date])=2010 THEN [OrderID] END)

A client builds a dashboard that presents current and long-term stock measures. Currently, the data is at a daily level. The data presents as a bar chart that presents monthly results over current and previous years. Some measures must present as monthly averages.
What should the consultant recommend to limit the data source for optimal performance?

• A.Move calculating averages to data layer and aggregate dates to monthly level.
• B.Limit data to current and previous years as well as to the last day of each month to eliminate the need to use the averages.
• C.Limit data to current and previous years and leave data at daily level to calculate the averages in the report.
• D.Limit data to current and previous years, move calculating averages to data layer, and aggregate dates to monthly level.