Cyber Monday 2023! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: CM25OFF

Certification Provider: Tableau

Exam Name: Tableau Certified Data Analyst

Number of questions in our database: 64

Exam Version: Nov. 23, 2023

TDA-C01 Exam Official Topics:

**Topic 1:**Choose which data transformation to perform based on a business scenario/ Choose between live connection or extract**Topic 2:**Summarize, model, and customize data by using the Analytics feature/ Prepare data by using Data Interpreter, pivot, and split**Topic 3:**Publish and Manage Content on Tableau Server and Tableau Online/ Connect to a data source on Tableau Server**Topic 4:**Remove gridlines, row-level and column-level bands, and shading/ Pull data from relational databases by using custom SQL queries**Topic 5:**Apply responsive design for specific device layouts/ Configure filter settings including Top N, Bottom N, include, exclude, wildcard, and conditional**Topic 6:**Replace the connected data source with another data source for an existing chart or sheet/ Choose when to convert between discrete and continuous**Topic 7:**Apply filters to multiple sheets and data sources/ Combine sheets into a dashboard by using containers and layout options**Topic 8:**Use multiple data sources (establish relationships, create joins, union tables, blend data)/ Choose an appropriate data source**Topic 9:**Create parameters to enable interactivity/ Perform data transformation in Tableau Prep**Topic 10:**Swap sheets by using parameters or sheet selector/ Schedule data extract refreshes/ Shape data by using aggregations

Question #1

You have the following dataset that contain null values in the Profits field.

You want the data to appear as shown in the following table.

Which two formulas achieve the goal? Choose two.

The two formulas that will make the data appear as shown in the second table are:

Question #2

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?

the rank function returns the rank of each row within the partition of a result set. The rank of a row is one plus the number of ranks that come before the row in question.

To answer your question, we need to apply the rank function to the Avg Score column and sort it in descending order. Then we can find the rank score value for Student ID 4220 by looking at the corresponding row.

Here is how the table would look like after applying the rank function and sorting:

As you can see, the rank score value for Student ID 4220 is1.

Question #3

in which three formats can you export a worksheet from the Worksheet menu? Choose three

The three formats that you can export a worksheet from the Worksheet menu are:

Question #4

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?

the rank function returns the rank of each row within the partition of a result set. The rank of a row is one plus the number of ranks that come before the row in question.

To answer your question, we need to apply the rank function to the Avg Score column and sort it in descending order. Then we can find the rank score value for Student ID 4220 by looking at the corresponding row.

Here is how the table would look like after applying the rank function and sorting:

As you can see, the rank score value for Student ID 4220 is1.

Question #5

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?

the rank function returns the rank of each row within the partition of a result set. The rank of a row is one plus the number of ranks that come before the row in question.

To answer your question, we need to apply the rank function to the Avg Score column and sort it in descending order. Then we can find the rank score value for Student ID 4220 by looking at the corresponding row.

Here is how the table would look like after applying the rank function and sorting:

As you can see, the rank score value for Student ID 4220 is1.

Unlock all TDA-C01 Exam Questions with Advanced Practice Test Features:

- Select Question Types you want
- Set your Desired Pass Percentage
- Allocate Time (Hours : Minutes)
- Create Multiple Practice tests with Limited Questions
- Customer Support

Submit Cancel