Ace TDA-C01 Certification with 122 Actual Questions
PASS Tableau TDA-C01 EXAM WITH UPDATED DUMPS
NEW QUESTION # 64
You have the Mowing dashboard.
Which two elements are floating? Choose two.
- A. The color legend
- B. The Rate of Obesity chart
- C. The state filter
- D. The little
- E. The map
Answer: B,C
Explanation:
In Tableau dashboards, floating elements are those that can be freely moved over the dashboard canvas without being snapped into the tiled layout. The floating elements are often indicated by their standalone frames and the ability to overlap with other dashboard items. From the provided image, the state filter and the Rate of Obesity chart can be identified as floating if they can be moved independently of the tiled grid layout that constrains other elements.
NEW QUESTION # 65
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.)
Answer:
Explanation:
Reference:
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.
Tableau Help: DATENAME Function
Tableau Help: Date Functions
NEW QUESTION # 66
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
- A. [Sales] > 50000
- B. IIF(SUM< [Sales] )>50000, TRUE, FALSE)
- C. MAX< [Sales], 50000)
- D. SUM{[Sales]) IN (50000)
Answer: A,B
NEW QUESTION # 67
You plan to create a Tableau subscription for several users.
Which two formats can you use? Choose two.
- A. Microsoft PowerPoint
- B. PDF
- C. Image
- D. Microsoft Excel
Answer: B,C
NEW QUESTION # 68
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 # 69
You want to create the following dashboard.
The dashboard will contain two sheets that will connect to the same data source. The top sheet will be configured to filter the bottom sheet.
When you click a category on the top sheet, the sheets must resize as shown in the following exhibit.
How should you lay out the objects on the dashboard?
- A. Add both sheets to the dashboard. Set Fit to Fix width.
- B. Drag a blank object to the dashboard and add both sheets to the dashboard. Set Fit to Entire view.
- C. Drag a vertical container to the dashboard and add both sheets to the container. Set Fit to Entire view.
- D. Drag a horizontal container to the dashboard and add both sheets to the container. Set the Fit to Standard.
Answer: C
Explanation:
To create the dashboard as shown in the image, you need to use a vertical layout container that will adjust the height of the sheets according to the window size. You also need to set the Fit to Entire view option for both sheets so that they will resize proportionally when you click a category on the top sheet. This way, you can achieve the desired effect of having the bottom sheet expand to fill the space left by the top sheet when it filters out some categories. Reference:
Size and Lay Out Your Dashboard - Tableau
Create a Dashboard - Tableau
Format Dashboard Layout in Tableau - GeeksforGeeks
NEW QUESTION # 70
You have the following dataset.
Which grouping option should you use m Tableau Prep to group al five names automatically?
- A. Manual Selection
- B. Spelling
- C. Pronunciation
- D. Common Characters
Answer: B
Explanation:
Tableau Prep's Grouping feature includes various methods to group similar data. The Spelling option is used when the data has small variations in spelling, such as capitalization differences or common typos. Given that the names in the dataset vary in capitalization and punctuation but are spelled correctly, the Spelling grouping option would be the most appropriate choice to automatically group all five names.
NEW QUESTION # 71
Open the link to Book1 found on the desktop. Open SalesVSProfit worksheet.
Add a distribution band on Profit to show the standard deviation from- 1 to 1.
Answer:
Explanation:
check the steps below in explanation.
Explanation:
To add a distribution band on Profit to show the standard deviation from -1 to 1, 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 SalesVSProfit worksheet.
Click on the SalesVSProfit tab at the bottom of the workbook to open the worksheet. You will see a scatter plot that shows the relationship between Sales and Profit for each Sub-Category.
Click on the Analytics tab on the left side of the workbook to open the Analytics pane. You will see a list of analytical objects that you can drag and drop onto your worksheet.
Drag Distribution Band from the Analytics pane to Profit on the Rows shelf. This will add a distribution band on Profit that shows the average and confidence interval for each Sub-Category.
Click on the Edit button on the distribution band to open the Edit Distribution Band dialog box. You will see options to customize your distribution band.
Change the Band From value to -1 and the Band To value to 1. This will change the distribution band to show the standard deviation from -1 to 1, which means one standard deviation below and above the average.
Click OK to apply the changes. You will see that the distribution band now shows a narrower range of values for Profit.
References: https://help.tableau.com/current/pro/desktop/en-us/analytics.htm
https://help.tableau.com/current/pro/desktop/en-us/analytics_distributionband.htm
https://help.tableau.com/current/pro/desktop/en-us/analytics_distributionband_edit.htm
NEW QUESTION # 72
You want to create the following table in a view.
Which function should you use to create the Position column?
- A. RANK
- B. LAST
- C. FIRST
- D. INDKX
Answer: C
Explanation:
To create the Position column, you should use the FIRST () function. The FIRST () function returns the number of rows from the current row to the first row in the partition. For example, the first row in a partition will return 0, the second row will return -1, and so on. In this question, the partition is defined by the Segment field, and the table is sorted by the Sales field in descending order. Therefore, the Position column shows the offset of each row from the first row in each segment, based on the sales ranking. References:
Tableau Certified Data Analyst Exam Prep Guide, page 11, section "Creating Calculated Fields" Tableau Help: FIRST Function
NEW QUESTION # 73
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.
- A. Send us your feedback on it.
- B. Send us your
Answer: A
NEW QUESTION # 74
You have the following tiled dashboard that has one sheet.
You want to replace fit sheet with Sheet2.
What should you do?
- A. Right-click Sheet2 and select Add to Dashboard.
- B. Select Sheets and click the Swap Sheet button next to Sheet2.
- C. Drag Sheet2 to the dashboard.
- D. From the context menu of Sheet3. select Remove Dashboard item
- E. From the context menu of Sheet3. select Deselect
Answer: B
Explanation:
To replace a sheet on a tiled dashboard, you can simply drag the new sheet from the Sheets pane to the dashboard and drop it over the existing sheet. This will replace the old sheet with the new one and keep the same size and position. Alternatively, you can right-click on the old sheet and select Replace Data Source, then choose the new sheet from the list. Reference: https://help.tableau.com/current/pro/desktop/en-us/dashboards_organize_floating_layoutcontainers.htm https://help.tableau.com/current/pro/desktop/en-us/dashboards_replace_datasource.htm
NEW QUESTION # 75
You have a data set that contains three columns named Sales, Profit, and Quantity.
You need to build the following scatter plot.
Answer:
Explanation:
Explanation:
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
NEW QUESTION # 76
You have the following dataset.
When you use the dataset in a worksheet, you want Sales to appear automatically as shown in the following table.
What should you do?
- A. Change the data type of the Sates field to Siring
- B. Create a calculated field that uses a formula of 'S' * str (Round((sales],2)) + 'k'
- C. Change the default number format of the Sales told
- D. Create a calculated field that uses a formula of 'S' + stri < (Sales)/1000)).
Answer: A
NEW QUESTION # 77
You have the following dataset
You need to create the following visualization.
Which quick table calculation should you drag to Text on the Marks card?
- A. Percent of Total
- B. Percentile
- C. Percent Difference
- D. Compound Growth Rate
Answer: A
Explanation:
we need to create a quick table calculation that shows the percent of total sales for each category and sub-category. To do this, we can follow these steps:
Drag Category to Columns and Sub-Category to Rows.
Drag Sales to Text on the Marks card.
Right-click Sales on the Marks card and select Quick Table Calculation > Percent of Total.
Right-click Sales on the Marks card again and select Compute Using > Category.
This will create a quick table calculation that shows the percent of total sales for each sub-category within each category. The visualization will look like this:
NEW QUESTION # 78
You have the following visualization.
Answer:
Explanation:
Explanation:
NEW QUESTION # 79
You have the following primary data source that contains a dimension named Dorm_Code.
You receive the following secondary data source that contains updated dorm codes.
You need to bring the updated dorm codes into Tableau and use the codes in existing visualizations. The new dorm codes must use the existing field name of Dorm_Code.
What should you do?
- A. Bring in the secondary data source as a union.
- B. Bring in the secondary table as a left join to the primary data source. From the Data Source page, select Create Calculated Field in the Dorm_Name field and enter [Dcrm_Name_New] in the calculation window
- C. Create a data blend and select Edit Primary Aliases to replace the primary data source alias values with values from the secondary data source
- D. Bring in the secondary data source by using relationships. From the Data pane, right-click Dorm_Name select Replace References, and then select Dorm_Name_New
Answer: D
Explanation:
Using relationships: You can use relationships to link the secondary data source with the primary data source based on a common field. This will allow you to use fields from both data sources in your visualization without creating new fields or duplicating data. You can then replace references to update the dimension values. For example, you can use relationships to link the updated dorm codes with the primary data source and then replace Dorm_Code with Dorm_Code_New in your visualization.
https://community.tableau.com/s/question/0D54T00000C5ldZSAR/update-data-view-based-on-dimension To update existing visualizations with new codes without changing the field name, using relationships to bring in the secondary data source is appropriate. Then using Replace References allows you to update the references from the old dorm codes to the new ones while maintaining the existing field name.
NEW QUESTION # 80
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:
check the steps below in explanation.
Explanation:
To filter the table to show the members of the Top10 set and the Bottom10 set, 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 Disciplines worksheet.
Click on the Disciplines tab at the bottom of the workbook to open the worksheet. You will see a table that shows the disciplines, sales, and profit for each salesperson.
Click on the drop-down arrow next to Salesperson on the Filters shelf. This will open a menu that allows you to filter by different criteria.
Select Set from the menu. This will show you the sets that are available for the Salesperson field. You will see Top10 and Bottom10 as two sets that have been created based on the sales ranking.
Check the boxes next to Top10 and Bottom10. This will filter the table to show only the members of these two sets. You can also click on All to deselect all other values.
Click OK to apply the filter. You will see that the table now shows 20 rows, 10 for each set.
References: https://help.tableau.com/current/pro/desktop/en-us/sets.htm
https://help.tableau.com/current/pro/desktop/en-us/filtering.htm
NEW QUESTION # 81
You have a Tableau workbook that has a live data source. The data source connects to a Microsoft SQL Server database. Only the users in your department can access the database.
You plan to publish the workbook to a Tableau Server site named Public. All the users in your company can access Public.
What are two ways to ensure that all the users can view the worksheets in the workbook? Choose two.
- A. Embed the credentials when you publish the workbook.
- B. Remove all the data source filters before you publish.
- C. Export the data to a .csv before you publish.
- D. Configure the local file permissions to the workbook file, and then publish the workbook.
- E. Change the data source to an extract before you publish.
Answer: A,E
NEW QUESTION # 82
You want to add a draft watermark to a dashboard as shown in the following exhibit.
Which type of object should you use?
- A. Sheet
- B. Image
- C. Web page
- D. Horizontal
Answer: A
Explanation:
To add a draft watermark to a dashboard, you should use a sheet as a type of object. A sheet is a worksheet that contains a chart or a table that you can add to your dashboard. You can create a sheet that shows the word "Draft" as a text mark and format it with transparency, size, and color. Then you can drag the sheet to your dashboard and position it behind your other sheets as a floating element. You can also adjust the opacity and layering of the sheet to make it look like a watermark. Reference: https://help.tableau.com/current/pro/desktop/en-us/dashboards.htm https://help.tableau.com/current/pro/desktop/en-us/dashboards_create_layouts.htm https://help.tableau.com/current/pro/desktop/en-us/dashboards_create_watermarks.htm
NEW QUESTION # 83
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 Choose Region parameter to the Pages card
- B. Add Region to me Fitters card
- C. Add the [Region] = [choose Region) formula to the Filters card
- D. Set the Choose Region parameter to Single Value (list)
Answer: B
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 # 84
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.
- A. check the steps below in explanation
Answer: A
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 # 85
Open the link to Book1 found on the desktop. Open the CategoryPercentage worksheet.
Modify the bar chart show the percentage of sales for each Subcategory within every Category. The total percentage for every Category must be 100%.
- A. Send us your feedback on it.
- B. Send us your
Answer: A
NEW QUESTION # 86
You plan to publish a workbook to Tableau Server.
You want to ensure that users can see other published dashboards from their current dashboard.
Which setting should you configure? (Click the appropriate Option in the Answer Area.)
Answer:
Explanation:
NEW QUESTION # 87
You have the following bar chart.
You want the chart to appear as shown in the Mowing exhibit.
What should you add?
- A. A distribution band
- B. A reference band
- C. A reference line
- D. An average line
Answer: A
Explanation:
A reference band is a shaded area that shows a range of values on an axis. You can use a reference band to highlight a target range, a confidence interval, or a standard deviation. In this case, you want to add a reference band that shows the range of values from 0 to 100 on the y-axis. This will create a shaded area behind the bars that indicates the percentage of sales.
To add a reference band, you need to do the following steps:
Click on the Analytics tab on the left side of the workbook to open the Analytics pane. You will see a list of analytical objects that you can drag and drop onto your worksheet.
Drag Reference Band from the Analytics pane to Y-Axis on the worksheet. This will add a reference band on the y-axis that shows the average and confidence interval for all values.
Click on the Edit button on the reference band to open the Edit Reference Band dialog box. You will see options to customize your reference band.
Change the Band From value to 0 and the Band To value to 100. This will change the reference band to show the range of values from 0 to 100 on the y-axis.
Click OK to apply the changes. You will see that the reference band now shows a shaded area behind the bars.
NEW QUESTION # 88
......
TDA-C01 Questions PDF [2025] Use Valid New dump to Clear Exam: https://whizlabs.actual4dump.com/Tableau/TDA-C01-actualtests-dumps.html