Tableau TDA-C01 Practice Test - Questions Answers, Page 10

HOTSPOT

You have a table that contains four columns named Order Date, Country, Sales, and Profit.

You need to add a column that shows the day of the week for each row. For example, orders placed on August 31, 2022, will show a day of

Wednesday.

How should you complete the formula? (Use the dropdowns in the Answer Area to select the correct options to complete the formula.)

You publish a dashboard that uses an extract. 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 do?

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.

DRAG DROP

You have a data source that contains the following columns.

You want to filter regions based on the highest sales. Users must be able to specify the number of regions shown.

Which three actions should you perform in order? (Place the three correct options in order. Use the arrows to move Options to Answer Area.

Use Answer Area arrows to re-order the options.)

Create an integer data type parameter named Param1

Drag Region to the Filters shelf.

Configure a Top filter by field. Use Param1 and filter by the sum of Sales.

Tableau Certified Data Analyst Exam Prep Guide, page 10, section ''Filtering Data''

Tableau Help: Parameters

Tableau Help: Top Filters

You have a workbook that connects to a database. The database requires authentication.

You plan to publish the workbook and schedule a daily refresh of the data.

Which two conditions must be met to schedule the refresh? Choose two.

DRAG DROP

You are developing a data source in Tableau Prep.

You have two tables named Orders and Employees.

The Orders table was created in 2019 and contains the following columns.

The Employees table contains all the employee information for the various sales teams in the sales department and contains the following columns

You want to prepare the data so that you can analyze sales trends over time for every sales team.

Which three actions should you perform in order? (Place the three correct options in order. Use the arrows to move Options to Answer Are a. Use Answer Area arrows to re-order the options.)

HOTSPOT

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

You want to create the following table in a view.

Which function should you use to create the Position column?

You have a data source that has two tables named Table1 and Table2. Table1 is the primary table and Table2 is the secondary table.

You want to combine the tables by using Tableau Prep. The combined table must include only values from Table1 that do NOT match any values in Table2. The field values from Table2 must appear as null values.

Which type of join should you use?