Tableau Certified Consultant - TCC-C01 Exam Practice Test

Question 1

A client wants to flag orders that have sales higher than the regional average.
Which calculated field will produce the required result?

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

B. { FIXED [Order ID] : SUM([Sales]) }
>
{ FIXED [Region] : SUM([Sales]) }

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

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

Correct Answer: A

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 2

An online sales company has a table data source that contains Order Date. Products ship on the first day of each month for all orders from the previous month.
The consultant needs to know the average number of days that a customer must wait before a product is shipped.
Which calculation should the consultant use?

A. Calc1: DATETRUNC ('day', DATEADD ('day', 31, [Order Date]))
Calc2: AVG ([Order Date] - [Calc1])

B. Calc1: DATETRUNC ('day', DATEADD('week', 4, [Order Date]))
Calc2: AVG([Order Date] - [Calc1])

C. Calc1: DATETRUNC ('month', DATEADD('month', 1, [Order Date]))
Calc2: AVG(DATEDIFF ('week', [Order Date], [Calc1]))

D. Calc1: DATETRUNC ('month', DATEADD ('month', 1, [Order Date]))
Calc2: AVG(DATEDIFF ('day', [Order Date], [Calc1]))

Correct Answer: D

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 3

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?

A. Define the filters by using custom SQL.

B. Use an extract filter.

C. Set up the extract as an incremental refresh.

D. Aggregate the extract to the visible dimensions.

Correct Answer: B

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 4

For a new report, a consultant needs to build a data model with three different tables, including two that contain hierarchies of locations and products. The third table contains detailed warehousing data from all locations across six countries. The consultant uses Tableau Cloud and the size of the third table excludes using an extract.
What is the most performant approach to model the data for a live connection?

A. Joining the tables in Tableau Prep

B. Blending the first two tables with the third

C. Relating the tables in Tableau Desktop

D. Joining the tables in Tableau Desktop

Correct Answer: C

Question 5

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. IF YEAR([Date])=2010 THEN {COUNTD ([OrderID])} END

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

C. IF MIN(YEAR([Date]))=2010 THEN WINDOW_COUNTD([OrderID]) END

D. COUNT(IF YEAR([Date])=2010 THEN [OrderID] END)

Correct Answer: B

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 6

A multi-national company wants to have a Tableau dashboard that will provide country-level information for both its forecast summaries and year-on-year metrics. The company wants to toggle between these two views while leaving main key performance indicators (KPIs) visible on the main dashboard.
Which method is the most efficient in achieving the company's requirements?

A. Create a single worksheet with all the measures required for both the forecast summary and the year-on-year views.
. Create a Boolean parameter and a corresponding calculated field with the following calculation: True.
. Add a blank dashboard object and in the Layout tab, check the box for "Control visibility using value" and select the parameter you created.

B. Create a parameter that accepts values from a list that contains "Forecast View" and "Year-on-Year View."
. Right-click the parameter and select Add to Sheet for both worksheets.
. Navigate back to the dashboard and to the upper corner of the two worksheets.
. Enable the Use as Filter option.

C. Create a Boolean parameter with the two names of the views as aliases and a corresponding calculated field with the following calculation: True.
. Add the forecast summary sheet to the dashboard and add the year-on-year metrics sheet to the same dashboard as a Floating dashboard object.
. Add the calculated fields as a Detail under the Marks card of the floating view, create a "Change Parameter" action, and set the
"Target Parameter" and "Source Fields" to the parameter and calculated field you created.
. Check the box for "Control visibility using value" in the Layout tab of the floating view and select the parameter you created.

D. Create a dashboard with the sheets containing the main KPIs and the forecast summary worksheet.
. Duplicate this dashboard and replace the forecast view worksheet with the year-on-year metrics worksheet.
. Add navigation buttons to both dashboards.

Correct Answer: C

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Tableau Certified Consultant - TCC-C01 Exam Practice Test

Latest Update

Useful Links

Contact Us