Free Access to Tableau.TCC-C01.v2025-10-01.q20 with Valid Practice Test (Page 2)

Question 1

A consultant wants to improve the performance of reports by moving calculations to the data layer and materializing them in the extract.
Which calculation should the consultant use?

A.ZN([Sales])*(1 - ZN([Discount]))
B.CASE [Sector Parameter]
WHEN 1 THEN "green"
WHEN 2 THEN "yellow"
C.SUM([Profit])/SUM([Sales])
D.POWER(ZN(SUM([Sales]))/
LOOKUP(ZN(SUM([Sales])), FIRST()),ZN(1/(INDEX()-1)))
- 1
END

Question 2

A consultant creates a histogram that presents the distribution of profits across a client's customers. The labels on the bars show percent shares. The consultant used a quick table calculation to create the labels.
Now, the client wants to limit the view to the bins that have at least a 15% share. The consultant creates a profit filter but it changes the percent labels.
Which approach should the consultant use to produce the desired result?

A.Use a calculation with TOTAL() function instead of a quick table calculation.
B.Add the [Profit] filter to the context.
C.Filter with a table calculation WINDOW_AVG(MIN([Profit]), first(), last())
D.Filter with the table calculation used to create labels.

Correct Answer: B

When a filter is applied directly to the view, it can affect the calculation of percentages in a histogram because it changes the underlying data that the quick table calculation is based on. To avoid this, adding the [Profit] filter to the context will maintain the original calculation of percent shares while filtering out bins with less than a 15% share. This is because context filters are applied before any other calculations, so the percent shares calculated will be based on the context-filtered data, thus preserving the integrity of the original percent labels.
References:The solution is based on the principles of context filters and their order of operations in Tableau, which are documented in Tableau's official resources and community discussions123.
When a histogram is created showing the distribution of profits with labels indicating percent shares using a quick table calculation, and a need arises to limit the view to bins with at least a 15% share, applying a standard profit filter directly may undesirably alter how the percent labels calculate because they depend on the overall distribution of data. Placing the [Profit] filter into the context makes it a "context filter," which effectively changes how data is filtered in calculations:
* Create a Context Filter: Right-click on the profit filter and select "Add to Context". This action changes the order of operations in filtering, meaning the context filter is applied first.
* Adjust the Percent Calculation: With the profit filter set in the context, it first reduces the data set to only those profits that meet the filter criteria. Subsequently, any table calculations (like the percent share labels) are computed based on this reduced data set.
* View Update: The view now updates to display only those bins where the profits are at least 15%, and the percent share labels recalculated to reflect the distribution of only the filtered (contextual) data.
References:
* Context Filters in Tableau: Context filters are used to filter the data passed down to other filters, calculations, the marks card, and the view. By setting the profit filter as a context filter, it ensures that calculations such as the percentage shares are based only on the filtered subset of the data.

Question 3

A client is using the Tableau Content Migration Tool to move content from an old Tableau Server to a new Tableau Server.
Which content will need to be moved using a different tool or process?

A.Published data sources that use live connections
B.Tableau Prep flows
C.Published data sources that use extracts
D.Workbooks

Question 4

A client has many published data sources in Tableau Server. The data sources use the same databases and tables. The client notices different departments give different answers to the same business questions, and the departments cannot trust the data. The client wants to know what causes data sources to return different data.
Which tool should the client use to identify this issue?

A.Tableau Prep Conductor
B.Ask Data
C.Tableau Catalog
D.Tableau Resource Monitoring Tool

Question 5

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?

A.Divide the quick filters into three groups: General, for shops. Place the general filters on the left of dashboard for warehouses. Place other filters next to the sections to which they apply.
B.Use Dynamic Zone Visibility to inform viewers which quick filters apply to warehouses or shops.
C.Hide container with all quick filters with a Show/Hide Button.
D.Use Dynamic Zone Visibility to show only the quick filters that apply with the chosen parameter value and a Show/Hide Button to hide container with all the filters.

Question 1

Question 2

Question 3

Question 4

Question 5

Download PDF File