TDA-C01 Online Practice Questions and Answers

Correct Answer: C

Correct Answer: D

Correct Answer: A

To combine the tables by using Tableau Prep and include only values from Table1 that do not match any values in Table2, you should use a left only join. A left only join is a type of join that returns only the rows from the primary table (Table1) that have no matching rows in the secondary table (Table2). The field values from Table2 will appear as null values in the combined table. A left only join is also known as an anti-join or an exclusion join. References: Tableau Certified Data Analyst Exam Prep Guide, page 9, section "Preparing Data" Tableau Help: Join Your Data Tableau Help: Left Only Join

Correct Answer: A

Explanation: To organize the tables in the Data pane based on the type of data contained within the tables, you should use folders. Folders are a way to manually group fields, parameters, sets, or tables in the Data pane according to your preference. You can create folders by right-clicking on the fields or tables you want to group and selecting Folders > Create Folder. You can also drag and drop fields or tables into existing folders. You can name the folders according to the type of data they contain, such as sales, customer, product, etc. Folders can help you find and access the fields or tables you need more easily and efficiently. References: Organize and Customize Fields in the Data Pane - Tableau Tableau Certified Data Analyst Study Guide

Correct Answer: AD

To schedule a refresh of the data, you need to ensure that Tableau Server or Tableau Online can access the database without prompting for credentials. This can be done by embedding the credentials in the workbook or the published data source. You also need to extract the data from the database and publish it as a separate data source or as part of the workbook. A live connection would not allow you to refresh the data on a schedule, as it would always query the database directly. A hyper file is a format for storing extracted data, but it is not a requirement for scheduling a refresh. References: Tableau Certified Data Analyst Exam Prep Guide, page 10, section "Publishing and Scheduling Data Refreshes" Tableau Help: Embedding Database Credentials Tableau Help: Extract Your Data

Correct Answer:

Correct Answer:

Correct Answer:

To build the scatter plot shown in the image, you need to place the Profit measure on the Rows shelf and the Sales measure on the Columns shelf. This will create a Cartesian chart with Profit as the y-axis and Sales as the x-axis. Then, you need to change the mark type to Circle on the Marks card. This will display the data points as circles that vary in size according to the Quantity measure. You can also add color or shape encoding to the marks to show additional dimensions or measures in the view. References: Build a Scatter Plot Understanding and Using Scatter Plots Scatter plot in Tableau

Correct Answer:

Explanation: we need to create a calculated field that displays the count of returns only for the first year in the table. To do this, we can use the following formula:

IF FIRST () = 0 THEN COUNT (Returns) END

This formula uses the FIRST () function, which returns the number of rows from the current row to the first row in the partition. If the current row is the first row, then FIRST () returns 0. The IF statement checks if this condition is true, and if so,

it returns the count of returns for that row. Otherwise, it returns NULL.

To complete the formula in the calculated field, you should select the following options from the drop-down menus:

FIRST ()

COUNT (Returns)

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

Correct Answer:

To add a column that shows the day of the week for each row, you should complete the formula as follows: DATENAME ( `weekday' , [Order Date]) The DATENAME function in Tableau returns the name of a specified part of a date or datetime value, such as the year, month, or day. It takes two arguments: the date part and the date. In this question, you want to return the name of the weekday, such as Monday, Tuesday, or Wednesday, for each order date. Therefore, you need to use `weekday' as the date part and [Order Date] as the date. The formula will return a string value that represents the name of the weekday for each order date. References: Tableau Help: DATENAME Function Tableau Help: Date Functions

To add a column that shows the day of the week for each row, you should complete the formula as follows: DATENAME ( `weekday' , [Order Date]) The DATENAME function in Tableau returns the name of a specified part of a date or datetime value, such as the year, month, or day. It takes two arguments: the date part and the date. In this question, you want to return the name of the weekday, such as Monday, Tuesday, or Wednesday, for each order date. Therefore, you need to use `weekday' as the date part and [Order Date] as the date. The formula will return a string value that represents the name of the weekday for each order date. References: Tableau Help: DATENAME Function Tableau Help: Date Functions