2022 TDA-C01 exam torrent TDA-C01 Study Guide [Q21-Q45]

NEW QUESTION 21
You have the following line chart that shows the average sales by month.

Which month had the biggest increase in swage sales compared to me previous month in 2019?

NEW QUESTION 22
You have a database that includes field named sales, City and Region.
You have the following chart that shows the number of sales made in different cities.

You want to dynamically show the corresponding region when users hover their mouse over any of the bars.
What should you do?

NEW QUESTION 23
From Tableau Desktop you sign in lo a Tableau Server site.
What appears in the list of available data sources when you search for a published data source?

NEW QUESTION 24
You have the following dataset.

Which grouping option should you use m Tableau Prep to group al five names automatically?

NEW QUESTION 25
Open the link to Book1 found on the desktop. Use the Superstore data source.
Split the Customer Name field into two fields named First Name and Last Name.

NEW QUESTION 26
You have the following chart that shows the cumulative of sales from various dates.

You want the months to appear as shown in the following chart.

What should you do?

NEW QUESTION 27
You have the following dataset.

You need to create the following worksheet.

The table must show either profit or sales based on the selection from the Parameter 1 menu.
Which three actions should you perform in orders
(Place the three correct options in order Use the arrows to move Options lo Answer Area Use Answer Area arrows to reorder the options)

NEW QUESTION 28
You have the following dataset.

Which Level of Detail (LOD) expression should you use to calculate tie grand total of all the regions?

NEW QUESTION 29
You company has two divisions located in the United States and Germany Bach division has a separate database. The following is a sample of the sales data for the division in the United States.

The following is a sample of the sales data for me division in Germany.

You have population data in a file named Populatio.csv. the following is a sample of the data.

You plan to create a visualization that ml show tie sales per capita for each salesperson Each salesperson must be identified by identified by their full name.
You need to prepare the data to support the planned visualization. The data source must support being published .
Which four actions should you perform in order?
(Place the four correct options n order Use the arrows to move Options to Answer Area arrows to re-order the options.
Use Answer Area arrows to re-order the options)

NEW QUESTION 30
You have a line chart on a worksheet.
You want to add a comment to March 2020 as shown in the following visualization.
What should you do?

NEW QUESTION 31
You have the Mowing dashboard.

Which two elements are floating? Choose two.

NEW QUESTION 32
You have the following visualization.

The Last() calculation is set to compute using Table (across)
Which value will appear in the crosstab for the Consumer segment of the year 2018 if you change compute to use Oder Dale?

NEW QUESTION 33
Open the link to Book1 found on the desktop. Open the Line worksheet.
Modify the chart to show only main and max values of both measures in each region.

NEW QUESTION 34
You have a Tableau workbook that contain three worksheets named Sheet1 Sheet2 and Sheet3.
You create several filters.
From the Data Source page you plan to add data source fillers
When type of filter will appear in the Edit Data Source Filters dialog box?

NEW QUESTION 35
You have a dataset that contains sates dat
a. The following is a sample of the data.

You need to return a value of true if a month has sales greater than $50 000. otherwise the formula must return a value of false.
Which two formulas achieve the goal Choose two

NEW QUESTION 36
You have the following data source in tableau Server.

You need to ensure that the data is updated every hour.
What should you select?

NEW QUESTION 37
You have the following two datasets:
* A Microsoft Excel worksheet that has two columns named Employee Name and Department
* A Microsoft SQL Server table that has three columns named Employee Name. Pay Grade and Team Size.
You want to use Tableau Prep to join the two datasets.
Which three actions should you perform m order? (Place the three correct options in order.)

NEW QUESTION 38
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.

NEW QUESTION 39
You conned to a Microsoft SQL Server database
You need to create a custom SQL query that retrieves rows from a table named Students Only students m the city of Berlin must be returned How should you complete the query? (Drag the appropriate Options to the Answer Area and drop into the correct locations.)

NEW QUESTION 40
Open the link to Book1 found on the desktop. Open the sales dashboard.
Add the Sales by State sheet in a Show/Hide button to the right side of the dashboard.

NEW QUESTION 41
You have a data source that contains data tor every city in the Unites States. The following is a sample of the data.

You need to use the City dimension to create a dynamic filter that snows the cities that have a population greater than one million Which type of filter should you use?

NEW QUESTION 42
You publish a dashboard tut uses an attract. 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?