Home / Tableau / TDA-C01

Question list

List of questions

Question 1

(0)

You have the following box plot that shows the distribution of average profits made in every state by region. Which region has the smallest distribution of profits?

Question 2

(0)

You have the following dashboard that contains two visualizations. You want to show only visualization at time. Users must be able to switch between visualizations. What should you me?

Question 3

(0)

You publish a dashboard tut uses an attract. The extract refreshes every Monday at 10:00. You need to ensure that the extract also refreshes on the last day of the month at 18:00. What should you

Question 4

(0)

A colleague provides you with access to a folder that contains the following files: * Sates.csv * Bookl.twb * Sates.hyper * Export.mdb Which He contains an extract?

Question 5

(0)

You have the following tiled dashboard that has one sheet. You want to replace fit sheet with Sheet2. What should you do?

Question 6

(0)

You have the following line chart that shows the average sales by month. Which month had the biggest increase in swage sales compared to me previous month in 2019?

Question 7

(0)

You are the owner of an alert. You receive an email notification that the alert was suspended From where can you resume the suspended alert?

Question 8

(0)

You have the Mowing dashboard. Which two elements are floating? Choose two.

Question 9

(0)

You have a database that includes field named sales, City and Region. You have the following chart that shows the number of sales made in different cities. You want to dynamically show the corre

Question 10

(0)

You want to connect a Tableau workbook to a dataset in a Microsoft Excel spreadsheet. What should you do from Tableau Desktop?

Related questions

You want to create the following dashboard that will contain two sheets. What should you do?

HOTSPOT You have a data set that contains three columns named Sales, Profit, and Quantity. You need to build the following scatter plot.

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?

DRAG DROP In a worksheet, you have a calculated column named YTD Sales that uses the following formula. [Order Date] <= TODAY () AND DATETBUNC {''year'', [Order Dace]) = DATETPUNC)'year', TODAY(J) You want to create a calculated column named Exclude Current Month that will be dragged to the Filters shell. Exclude Current Month will exclude the current month values from YTD Sales. How should you complete the formula for Exclude Current Month? (Drag the appropriate Options to the Answer Area and drop into the correct locations.)

You want to create the following table in a view. Which function should you use to create the Position column?

DRAG DROP You conned to a Microsoft SQL Server database You need to create a custom SQL query that retrieves rows from a table named Students Only students m the city of Berlin must be returned How should you complete the query? (Drag the appropriate Options to the Answer Area and drop into the correct locations.)

In a dataset, you have a string field named Name that contains unnecessary semicolons. Which function should you use to remove the semicolons from the Name field?

You have a Tableau workbook. You want to make the workbook available in Tableau Online. What should you do?

You want to create the following dashboard. The dashboard will contain two sheets that will connect to the same data source. The top sheet will be configured to filter the bottom sheet. When you click a category on the top sheet, the sheets must resize as shown in the following exhibit. How should you lay out the objects on the dashboard?

You have a workbook that uses an extracted data source. You publish the workbook to Tableau Server. Which three actions can you perform from the Extract Refresh page in Tableau Server? Choose three.

Question 94 - TDA-C01 discussion

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.

Furnishings

Tables

Chairs

Accessories

Copiers

Machines G Phones

Bookcases

Suggested answer: B, D, F

Explanation:

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.

Show Answer

asked 23/09/2024

J Von

49 questions

Your answer: A B C D E F G

0 comments

Sorted by