Study HIGH Quality TDA-C01 Free Study Guides and Exams Tutorials
Download Tableau TDA-C01 Exam Dumps to Pass Exam Easily
NEW QUESTION # 32
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)
Answer:
Explanation:
1 - Open Tableau Desktop
2 - Create a new column to Concatenate the name for the Germany division.
3 - Union the sales data of both divisions.
4 - Join the sales data and the population data by using City as the join field.
NEW QUESTION # 33
You have two data sources that use the same schema One data source contains order data from 2019 and the other data source contains order data from 2020.
You have a worksheet that shows the orders from 2019.
You need to configure the worksheet to show the orders from 2020 without reloading the data.
Which option should you select?
Answer:
Explanation:
NEW QUESTION # 34
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.
Answer:
Explanation:
check the steps below in explanation
Explanation:
To add the Sales by State sheet in a Show/Hide button to the right side of the dashboard, you need to do the following steps:
Open the link to Book1 found on the desktop. This will open the Tableau workbook that contains the sales dashboard.
Click on the sales dashboard tab at the bottom of the workbook to open the dashboard. You will see a dashboard that shows various charts and filters related to sales data.
Drag Sales by State from the Sheets pane to the right side of the dashboard. This will add the sheet as a floating element on the dashboard. You can resize and position it as you like.
Right-click on Sales by State and select Add Show/Hide Button from the menu. This will add a button that allows you to show or hide the sheet on the dashboard. You can customize the appearance and behavior of the button by clicking on it and using the options on the Marks card.
Optionally, you can drag a vertical layout container from the Objects pane to the right side of the dashboard and place Sales by State and its button inside it. This will help you organize your dashboard elements and align them neatly.
NEW QUESTION # 35
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?
- A. From Tableau Server. select Schedules and change the priority of the existing schedule
- B. From Tableau Server. select Schedules find the schedule of the extract, and change the frequency to the Last day of the month
- C. From Tableau Server select the workbook select Refresh Extracts and then add a new extract refresh
- D. From Tableau Desktop, open the Publish Workbook dialog box and configure the schedule.
Answer: C
Explanation:
To refresh an extract on Tableau Server, you need to select the workbook, select Refresh Extracts, and then add a new extract refresh. You can specify the frequency and time of the refresh, as well as any custom options. You can have multiple extract refreshes for the same workbook with different schedules. Reference: https://help.tableau.com/current/server/en-us/refresh_extracts.htm https://help.tableau.com/current/server/en-us/refresh_extracts_add.htm
NEW QUESTION # 36
You have the following visualization.
Answer:
Explanation:
NEW QUESTION # 37
You have a dataset that has four fields named Category. Profit Sates and Customer Name. You need to create the following visualization.
Answer:
Explanation:
NEW QUESTION # 38
You have the following dataset.
Which Level of Detail (LOD) expression should you use to calculate tie grand total of all the regions?
- A. {FIXED: TOTAL (Sales)}
- B. {Fixed: [Region]: TOTAL Sales}
- C. {FIXED: SUM Sales}
- D. {FIXED: [Region] SUM Sales}
Answer: B
NEW QUESTION # 39
You have the following dashboard.
When a user selects a only on the map the data on the bar chart must show only the data for the selected city. The data in the bar chart must change only when the user selects a different city How should you configure the dashboard action? (Use the dropdowns in the Answers Area to select the correct options.)
Answer:
Explanation:
NEW QUESTION # 40
Open the link to Book1 found on the desktop. Open the Movie Durations worksheet.
Replace the existing data source with the Netflix_2019 data source.
Answer:
Explanation:
Send us your feedback on it
NEW QUESTION # 41
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.
Answer:
Explanation:
check the steps below in explanation
Explanation:
To split the Customer Name field into two fields named First Name and Last Name, you need to do the following steps:
Open the link to Book1 found on the desktop. This will open the Tableau workbook that uses the Superstore data source.
Go to the Data Source tab at the bottom of the workbook to see the data source page. You will see a table that shows the fields and values from the Superstore data source.
Right-click on Customer Name in the table and select Split from the menu. This will split the field into two fields based on a separator, which is a space by default. You will see two new fields named Customer Name - Split 1 and Customer Name - Split 2 in the table.
Right-click on Customer Name - Split 1 and select Rename from the menu. Type First Name as the new name and press Enter. This will rename the field as First Name.
Right-click on Customer Name - Split 2 and select Rename from the menu. Type Last Name as the new name and press Enter. This will rename the field as Last Name.
NEW QUESTION # 42
You have the Mowing two tables that contains data about the books in a library.
Both tables are incomplete so there are books missing from the tables.
You need to combine the tables. The solution must ensure that all the data is retained Which type of join should you use?
- A. Full outer join
- B. Right join
- C. left join
- D. Inner join
Answer: D
NEW QUESTION # 43
Open the link to Book1 found on the desktop. Open Disciplines worksheet.
Filter the table to show the members of the Top10 set and the members of the Bottom10 set. There should be a total of 20 rows.
Answer:
Explanation:
Send us your feedback on it
NEW QUESTION # 44
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?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: B
NEW QUESTION # 45
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?
- A. Wildcard filter
- B. General filter
- C. Condition filter
- D. Top filter
Answer: C
Explanation:
To use the City dimension to create a dynamic filter that shows the cities that have a population greater than one million, you should use a condition filter. A condition filter is a type of filter that shows only the values that meet a specified condition based on a measure or a calculation. You can create a condition filter by dragging a dimension to the Filters shelf and selecting Condition from the dialog box. Then you can enter a formula or choose an option that defines your condition.
In this case, you want to create a condition filter based on Population, which is a measure. You can drag City to the Filters shelf and select Condition from the dialog box. Then you can choose By field from the tab and select Population > Sum > Greater than > 1000000 from the drop-down lists. This will create a condition filter that shows only the cities that have a sum of population greater than one million.
The other options are not correct for this scenario. A general filter is not a specific type of filter, but a term that refers to any type of filter in Tableau. A wildcard filter is a type of filter that shows only the values that match a specified pattern or string, such as "New*" or "*ton". A top filter is a type of filter that shows only the top or bottom N values of a measure or dimension based on a ranking or an aggregation. Reference: https://help.tableau.com/current/pro/desktop/en-us/filtering.htm https://help.tableau.com/current/pro/desktop/en-us/filtering_condition.htm https://help.tableau.com/current/pro/desktop/en-us/filtering_wildcard.htm https://help.tableau.com/current/pro/desktop/en-us/filtering_topn.htm
NEW QUESTION # 46
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?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: D
Explanation:
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 is 1.
NEW QUESTION # 47
You create a parameter named Choose Region fiat contains values from a field named Region.
You want users to be able to use the Choose Region parameter to interact with a chart by logging between different regions What should you do next?
- A. Add the [Region] = [choose Region) formula to the Filters card
- B. Set the Choose Region parameter to Single Value (list)
- C. Add Region to me Fitters card
- D. Add the Choose Region parameter to the Pages card
Answer: A
Explanation:
To use the Choose Region parameter to interact with a chart by toggling between different regions, you should add the [Region] = [Choose Region] formula to the Filters card. This formula will create a boolean filter that returns TRUE if the value in the Region field matches the value in the Choose Region parameter, and FALSE otherwise. You can add this formula to the Filters card by right-clicking on it and selecting Add Filter from the menu. Then you can select Condition from the dialog box and enter the formula in the text box. This will filter the chart to show only the data for the selected region.
The other options are not correct for this scenario. Adding Region to the Filters card will create a categorical filter that shows a list of values from the Region field, but it will not use the Choose Region parameter. Adding the Choose Region parameter to the Pages card will create a page control that allows you to cycle through different values of the parameter, but it will not filter the chart. Setting the Choose Region parameter to Single Value (list) will change how the parameter control appears on the worksheet, but it will not affect how it interacts with the chart. Reference: https://help.tableau.com/current/pro/desktop/en-us/parameters.htm https://help.tableau.com/current/pro/desktop/en-us/filtering.htm https://help.tableau.com/current/pro/desktop/en-us/filtering_condition.htm
NEW QUESTION # 48
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.)
Answer:
Explanation:
NEW QUESTION # 49
You have a dataset that contains daily sales by business segment from 2017 to the present You want to use monthly historical trends to predict sales by segment in the future Which three actions should you perform m order?
(Place the three correct options in order Use the arrows to move Options lo Answer Area I In Answer Area arrows to re order the options.)
Answer:
Explanation:
1 - Add the date to the Columns shelf. Add the segment and the sales to the Rows shelf.
2 - Aggregate the date to month and year.
3 - From the Analytics pane, drag Forecast to the worksheet.
NEW QUESTION # 50
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?
- A. November
- B. December
- C. October
- D. August
Answer: C
Explanation:
To find the month that had the biggest increase in average sales compared to the previous month in 2019, you need to compare the slopes of the line segments between each pair of months. The steeper the slope, the greater the increase. Based on the line chart, October had the steepest slope, meaning it had the biggest increase in average sales compared to September in 2019. Reference: https://help.tableau.com/current/pro/desktop/en-us/buildexamples_line.htm https://www.mathsisfun.com/algebra/line-equation-slope.html
NEW QUESTION # 51
......
Get 100% Real Free Tableau Certified TDA-C01 Sample Questions: https://www.exam4pdf.com/TDA-C01-dumps-torrent.html
Accurate TDA-C01 Questions with Free and Fast Updates: https://drive.google.com/open?id=11t9BDFMwy9_ByqvlaRjDr4NdaTvyDIHB
