Question 1

A Tableau consultant notices that a client’s dashboard filter for ‘Region’ is not affecting a calculated field that computes total sales, despite the calculation being correctly set up.

What could be causing this issue based on Tableau’s order of operations?

Options :

A : The 'Region' filter is set as a context filter, and it is being applied after the calculation

B : The 'Region' filter is not set as a context filter, so it-s being applied after the calculation

C : The calculated field for total sales is not correctly referencing the 'Region' filter

D : The dashboard is using an extract instead of a live connection, which is causing the filter to be applied incorrectly

Answer: B

Question 2

A stakeholder has multiple files saved (CSV/Tables) in a single location. A few files from the location are

required for analysis. Data transformation (calculations)

is required for the files before designing the visuals. The files have the following attributes:

. All files have the same schema.

. Multiple files have something in common among their file names.

. Each file has a unique key column.

Which data transformation strategy should the consultant use to deliver the best optimized result?

Options :

A :

Use join option to combine/merge all the files together before doing the data transformation (calculations).

B :

Use wildcard Union option to combine/merge all the files together before doing the data transformation (calculations).

C :

Apply the data transformation (calculations) in each require file and do the wildcard union to combine/merge before designing the visuals.

D :

Apply the data transformation (calculations) in each require file and do the join to combine/merge before designing the visuals.

Answer: B

Question 3

In a Tableau workbook, you need to find the average sales amount for each product category, but only considering those customers who have made purchases above a certain threshold.

How should you structure the LOD expression?

Options :

A : Use a FIXED LOD expression to calculate the average sales per category for all customers, then filter out customers below the purchase threshold

B : Apply a FIXED LOD expression to first identify customers above the purchase threshold, then another FIXED LOD to calculate the average sales per category for these customers

C : Implement an EXCLUDE LOD expression to exclude customers below the purchase threshold and then calculate the average sales per category

D : Utilize an INCLUDE LOD expression to include only those customers above the purchase threshold in the average sales calculation per category

Answer: B

Question 4

A consultant is designing a Tableau dashboard for a retail client to analyze daily sales data. The client wants the dashboard to reflect sales changes as they occur throughout the day.

Which type of calculation should the consultant primarily use in the Tableau workbook for this purpose?

Options :

A : Static calculations that are predefined in Tableau Prep

B : Responsive calculations in the Tableau workbook that update in real-time with data changes

C : Calculations based solely on historical sales data, updated monthly

D : Manual calculations updated by the client at the end of each day

Answer: B

Question 5

In a situation where a Tableau consultant needs to present a comparison of sales performance metrics across multiple years for different product categories, which advanced chart type would facilitate an effective and comprehensive comparison?

Options :

A : Chord diagram

B : Radar chart

C : Data densification

D : Small multiples

Answer: D

Confidently Practice Online with Free TCC-C01 Exam Cram

Buying Options: