Tableau TDA-C01 Exam Practice Test Instant Access

Question 1

Refer to the exhibit.

You need the top 10 values to appear in a different color. The lop 10 values must be colored dynamically.

What should you do?

ASelect the lop 10 bars, create a set. and then drag the set to Color on the Marks card.

BCreate a group field that groups the top 10 values into one group and the rest of the values into another group. Drag the group field to Color on the Marks card.

CSelect the top 10 bars, and then change the color by selecting Color on the Marks card.

DCreate a set that has a top 10 condition, and then drag the set to Color on the Marks card.

Answer : D

Question 2

You have a large data source that contains more than 10 million rows. Users can filter the rows by a field named Animal.

The following is a sample of the data.

You want to improve the performance of the views by including only animals of a particular type.

To which filter should you add the Type field on the worksheet?

ADimension filler

BTable calculation filter

CContext filter

DMeasure filter

Answer : C

Question 3

You have the following dashboard.

From the context menu of Sales over time, select Ignore Actions.

Several Lays later, you decide that you want to filter both Sales over time and Detail table by selecting a data point on the map.

What should you do?

AFrom the context menu of Sales over lime, select Filters and then select Enable Auto Update.

BFrom the context menu of Profits by state, deselect Use as Filter and then select Use as Filter.

CFrom the context menu of Detail table, select Ignore Actions.

DFrom the context menu of Sales over time, select Use as Filter and then deselect Use as Filter

Answer : B

Question 4

You have the following view.

You want to filter the view lo show only records that have a movie name starting with the word. "The". You must achieve the goal without writing any formulas.

Which type of filter should you use?

AWildcard

BCondition

CGeneral

DTop

Answer : A

Question 5

You have the following: Overall Rank and Rank are calculated fields that use the RANK function.

You filter out the sub-category where [Ovorall Rank] - 1.

For which three the sub-categories will the value of Rank change? Choose three.

AFurnishings

BTables

CChairs

DAccessories

ECopiers

FMachines
G Phones

HBookcases

Answer : B, D, F

In Tableau, the RANK function assigns a rank to each row within a partition of the data, based on the value of the field being ranked. It is important to understand that the rank is recalculated whenever the underlying data or the partitioning changes.

In the given scenario, the Overall Rank is based on the Sales figures, while the Rank (presumably) is based on the Sales within the Category. When filtering on the condition where [Overall Rank] - 1, it means we are excluding the sub-category that has an Overall Rank of 2.

Looking at the data:

Furnishings has an Overall Rank of 8, which does not meet the filter condition ([Overall Rank] - 1). Therefore, its rank remains the same.

Tables have an Overall Rank of 3. When the sub-category with an Overall Rank of 2 is removed (Chairs in this case), Tables move up in the overall ranking. However, since Tables are the top-ranked within the Furniture category, their Rank within the category would remain unchanged at 1.

Chairs have an Overall Rank of 2, which meets the filter condition and thus will be removed from the view. We cannot determine the change in Rank for Chairs because they are filtered out.

Accessories have an Overall Rank of 5. If any sub-category with a higher Overall Rank (1 to 4) is removed, the rank of Accessories within the Technology category could change because it is currently ranked 3 in its category. With the removal of Phones (Overall Rank 1), the Rank of Accessories could potentially increase.

Copiers have an Overall Rank of 6, which does not meet the filter condition. Therefore, its rank remains the same.

Machines have an Overall Rank of 4. If we remove Phones (Overall Rank 1), Machines will move up in the overall ranking and potentially within the Technology category as well, changing its Rank from 2 to 1.

Phones have an Overall Rank of 1, which does not meet the filter condition of being Overall Rank 2. Therefore, its rank remains the same.

Bookcases have an Overall Rank of 7, which does not meet the filter condition. Therefore, its rank remains the same.

Based on this analysis, when the sub-category with an Overall Rank of 2 (Chairs) is removed, the Rank value will change for Tables, Accessories, and Machines, as they will move up in the overall ranking within their respective categories. However, it's important to note that while Tables will move up in the overall ranking, their rank within the Furniture category would not change as they are already at the top. The rank changes for Accessories and Machines are due to the removal of Phones, which is ranked higher overall and within the Technology category.

Question 6

You create the following worksheet

The Pick Measure parameter contains the following list of values

Users can select a value from Pick Measure to change the visualization to show either the Sales measure or the Profit measure.

Which formula is used in the Selected Measure calculated field lo switch between measures?

ACase [Pick Measure]
WHEN 1 then ([Sales])
WHEN 2 then ([Profit]) END

BCase AVG([Pick Measure])
WHEN [Sales] then 1
WHEN [Profit] then 2
END

CCase [Pick Measure:
WHEN [Sales] then 1
WHEN [Profit] then 2 END

DCase STFMEPick Measure])
WHEN 'Sales' then ([Sales])
WHEN 'Profit' then ([Profit]) e::i

Answer : A

https://help.tableau.com/current/pro/desktop/en-us/parameters_swap.htm

Question 7

You have the following dataset

You need to create the following visualization.

Which quick table calculation should you drag to Text on the Marks card?

APercent of Total

BPercent Difference

CCompound Growth Rate

DPercentile

Answer : A

we need to create a quick table calculation that shows the percent of total sales for each category and sub-category. To do this, we can follow these steps:

Drag Category to Columns and Sub-Category to Rows.

Drag Sales to Text on the Marks card.

Right-click Sales on the Marks card and select Quick Table Calculation > Percent of Total.

Right-click Sales on the Marks card again and select Compute Using > Category.

This will create a quick table calculation that shows the percent of total sales for each sub-category within each category. The visualization will look like this:

Tableau TDA-C01 Tableau Certified Data Analyst Exam Practice Test