Tableau TDA-C01 Exam

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

Free Tableau TDA-C01 Exam Actual Questions

The questions for TDA-C01 were last updated On Nov. 23, 2023

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.

A2N ([Profits])

BISNULL ([Profits])

CIFNULL [(profits] ,0)

DIF [Profits] != null then [Profits] END

EIFNULL([Profits],0) D. IF [Profits] != null then [Profits] END
The IFNULL function is a logical function that returns the first argument if it is not null, and the second argument if it is null. In this case, the first argument is [Profits], which is the field that contains null values. The second argument is 0, which is the value that you want to replace null values with. The function will return [Profits] if it is not null, and 0 if it is null.
The IF statement is a logical statement that returns a value or performs an action if a condition is true, and optionally returns another value or performs another action if the condition is false. In this case, the condition is [Profits] != null, which means that [Profits] is not null. The statement will return [Profits] if the condition is true, and nothing if the condition is false. The END keyword marks the end of the statement.
The other options are not correct for this scenario. The ZN function is a logical function that returns zero if a value or expression is null, and returns the value or expression itself if it is not null. However, it only works with numeric values or expressions, and [Profits] may not be numeric in this case. The ISNULL function is a logical function that returns TRUE if a value or expression is null, and FALSE otherwise. It does not replace null values with another value. Reference: https://help.tableau.com/current/pro/desktop/en-us/functions_functions_logical.htm#IFNULL https://help.tableau.com/current/pro/desktop/en-us/functions_functions_logical.htm#IF https://help.tableau.com/current/pro/desktop/en-us/functions_functions_logical.htm#ZN https://help.tableau.com/current/pro/desktop/en-us/functions_functions_logical.htm#ISNULL

Reveal Solution

Correct Answer: C, D

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?

Reveal Solution

Correct Answer: A

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

A.png

B.html

C.xlsx

D.txt

E.pptx

F.csv
A) .png C) .xlsx F) .csv
The Worksheet menu is a menu that appears at the top of the Tableau window when you are working on a worksheet. It contains various options and commands that you can use to work with your worksheet, such as formatting, sorting, filtering, and exporting.
The Export option is a sub-menu that allows you to export your worksheet to different formats, such as image, data, or cross tab. You can access the Export option by clicking on Worksheet > Export from the menu.
The .png format is an image format that you can use to export a worksheet as an image file. An image file is a file that contains a picture of your worksheet, such as a chart or a table. You can use an image file to share your worksheet with others or insert it into other documents or applications. You can export a worksheet as an image file by selecting Worksheet > Export > Image from the menu. This will open a dialog box where you can choose a file name, location, and resolution for your image.
The .xlsx format is an Excel format that you can use to export a worksheet as an Excel workbook. An Excel workbook is a file that contains one or more worksheets in a spreadsheet application, such as Microsoft Excel. You can use an Excel workbook to work with your data in Excel or import it into other applications or databases. You can export a worksheet as an Excel workbook by selecting Worksheet > Export > Data from the menu. This will open a dialog box where you can choose a file name and location for your workbook.
The .csv format is a comma-separated values format that you can use to export a worksheet as a text file with values separated by commas. A text file is a file that contains plain text without any formatting or graphics. You can use a text file to store or transfer your data in a simple and universal format. You can export a worksheet as a text file by selecting Worksheet > Export > Crosstab to Excel from the menu. This will open a dialog box where you can choose a file name and location for your text file.
The other options are not correct for this scenario. The .html format is a web page format that you can use to export a dashboard or a story as a web page file. A web page file is a file that contains HTML code that defines the structure and content of a web page. You can use a web page file to view your dashboard or story in a web browser or embed it into other web pages or applications. However, you cannot export a worksheet as a web page file from the Worksheet menu. You have to use the Dashboard menu or the Story menu instead.
The .txt format is another text format that you can use to export data as a text file with values separated by tabs. However, you cannot export data as a .txt file from the Worksheet menu. You have to use the Data Source menu instead.
The .pptx format is a PowerPoint format that you can use to export one or more worksheets as PowerPoint slides. A PowerPoint slide is a page that contains graphics and text that are part of a presentation in Microsoft PowerPoint. You can use PowerPoint slides to present your worksheets to others or insert them into other presentations or documents. However, you cannot export worksheets as PowerPoint slides from the Worksheet menu. You have to use the File menu instead. Reference: https://help.tableau.com/current/pro/desktop/en-us/export.htm https://help.tableau.com/current/pro/desktop/en-us/export_image.htm https://help.tableau.com/current/pro/desktop/en-us/export_data.htm https://help.tableau.com/current/pro/desktop/en-us/export_crosstab.htm https://help.tableau.com/current/pro/desktop/en-us/export_web.htm https://help.tableau.com/current/pro/desktop/en-us/export_datasource.htm https://help.tableau.com/current/pro/desktop/en-us/export_powerpoint.htm

Reveal Solution

Correct Answer: A, C, F

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?

Reveal Solution

Correct Answer: A

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.

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?

Reveal Solution

Correct Answer: A

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.

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

Get Full Access Now

Disscuss Tableau TDA-C01 Topics, Questions or Ask Anything Related

Submit Cancel