[UPDATED Dec-2024] Best Value Available Preparation Guide for TDA-C01 Exam [Q72-Q88]

Rate this post

[UPDATED Dec-2024] Best Value Available Preparation Guide for TDA-C01 Exam

1 Full TDA-C01 Practice Test and 122 Unique Questions, Get it Now!

Q72. You have the following worksheet.

You want to create a table calculation that shows sales growth over each year.
How should you complete the formula? (Use the dropdowns in the Answer Area to select the correct options to complete the formula.)

Q73. You have the following dataset.

Yon need to calculate the ranking shown in the Rank field.
How should you complete the formula? (Use the dropdowns in the Answer Area to select the correct options to complete the formula ?

Q74. You want to create the following dashboard that will contain two sheets.

What should you do?

Drag both sheets to the dashboard and add a border to each sheet.

Drag both sheets to the dashboard and add a background lo each sheet.

Add both sheets lo a horizontal container and add a border to the container.

Add a border to both sheets and add both sheets to a horizontal object.

Q75. You want to add a draft watermark to a dashboard as shown in the following exhibit.

Which type of object should you use?

Image

Sheet

Web page

Horizontal

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

From the Data menu select New Data Source

From the Data menu select Replace Data Source

From the File menu select New

From the File menu select Import Workbook

Q77. You have the following chart that sorts states by the number of products each state has purchased.

Which formula should you use to include a number with the position of each state within each region?

FIRST ()

INDEX ()

WINDOW_SUM(SUM ([Quantity]))

LOOKUP (SUM ([Quantity]))

Q78. You create the following story that contains two story point.

You want to change the story point format to show the current story point number out of the total number of story points.
Which Layout option should you use?

Dots

Arrows only

Caption boxes

Numbers

Q79. You want to add a comment to March 2020 as shown in the following visualization.
You have the following sets in a Tableau workbook
* Top N Customers
* Customers of 2020
* Top N Products
* Sellers of 2020
Which two sets can you combine? Choose two

Sellers of 2020

Customers of 2020

Top N Products

Top N Customers

Q80. You create a worksheet named Sales by Region and hide the tide of the worksheet. You print the worksheet as a PDF and notice that the worksheet title appears. You need to prevent the title from appearing when you print the worksheet as a PDF. Which settings should configure from the File menu in Tableau Desktop?

Page Setup

Export As PowerPoint

Export As Version

Q81. Open the link to Book1 found on the desktop. Open SalesVSProfit worksheet.
Add a distribution band on Profit to show the standard deviation from- 1 to 1.

Q82. You have the Mowing dashboard.

Which two elements are floating? Choose two.

The state filter

The color legend

The map

The Rate of Obesity chart

The little

Q83. You have the following visualization.

You Create a table calculation named Rank_Score that has a formula of RANK(AVG([Score]), and you drag Rank_Score to Text on the Marks cards.
What is the Rank Score value for Student ID 4220?

Q84. You have a dataset that has four fields named Category. Profit Sates and Customer Name. You need to create the following visualization.

Q85. You have the Mowing two tables that contains data about the books in a library.

Both tables are incomplete so there are books missing from the tables.
You need to combine the tables. The solution must ensure that all the data is retained Which type of join should you use?

Full outer join

Right join

left join

Inner join

Q86. Open the link to Book1 found on the desktop. Open Disciplines worksheet.
Filter the table to show the members of the Top10 set and the members of the Bottom10 set. There should be a total of 20 rows.

Q87. 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

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.

Q88. You want to add a comment to March 2020 as shown in the following visualization.
You have the following sets in a Tableau workbook
* Top N Customers
* Customers of 2020
* Top N Products
* Sellers of 2020
Which two sets can you combine? Choose two

Sellers of 2020

Customers of 2020

Top N Products

Top N Customers

Tableau TDA-C01 certification exam covers a wide range of topics related to data analytics, including data visualization, business intelligence, data analysis, and data reporting. Participants in this certification program will learn how to use different Tableau tools and features to create effective visualizations and dashboards. They will also develop skills in interpreting data and identifying trends and patterns that can be used to make data-driven decisions. In addition, participants will learn how to create effective data reports and communicate data insights to stakeholders.

Achieving the Tableau TDA-C01 certification demonstrates a candidate’s ability to use Tableau software to solve complex data problems and effectively communicate insights from data. Tableau Certified Data Analyst certification is recognized by top companies and organizations worldwide, making it a valuable asset for professionals looking to advance their careers in the field of data analysis. With the increasing demand for skilled data analysts, the Tableau TDA-C01 certification can give candidates a competitive edge in the job market and open up new career opportunities.

Get Instant Access to TDA-C01 Practice Exam Questions: https://www.braindumpsit.com/TDA-C01_real-exam.html