100% Free TDA-C01 Exam Dumps Use Real Tableau Certified Dumps With 178 Questions!
Pass Your TDA-C01 Exam Easily With 100% Exam Passing Guarantee [2025]
NEW QUESTION # 102
You have the following dataset.
Yon need to calculate the ranking shown in the Rank field.
How should you complete the formula? (Use the dropdowns in the Answer Area to select the correct options to complete the formula ?
Answer:
Explanation:
NEW QUESTION # 103
You have the following map.
You need the map to appear as shown in the following visualization.
What should you do?
- A. Change the mark type to Density
- B. Drag Location to Size on the Marks card
- C. Drag Population to Size on the Marks card
- D. Change the opacity to 75%
- E. Change the mark type to Map
Answer: A
Explanation:
The question presents a scenario where a geographic map visualization in Tableau needs to be transformed from a series of discrete circles representing data points to a density map visualization. The density map shows concentrations of data points with a gradient of color, where denser areas are indicated by a darker color.
Here's the explanation for each option:
A). Change the mark type to Density: This is the correct answer because changing the mark type to 'Density' in Tableau creates a density map, which displays the concentration of data points with a color gradient. This is exactly what is needed to achieve the visual effect shown in the second image, where regions with a higher concentration of data points are represented by darker shades.
B). Drag Location to Size on the Marks card: This option would adjust the size of the marks based on the number of locations, which is not relevant to creating a density map. It would result in varying sizes of circles, not a continuous gradient.
C). Change the mark type to Map: The visualization is already using a map. This option would not change the visualization to the desired density map.
D). Drag Population to Size on the Marks card: This would change the size of the circles based on the population values, making some circles larger and others smaller. This is not how a density map is created, which uses color intensity rather than size to show concentration.
E). Change the opacity to 75%: Changing the opacity would affect the transparency of the marks on the map but would not transform the visualization into a density map.
To achieve the visualization shown in the second image, the mark type must be changed to 'Density,' which will produce a heat map-like effect where the color intensity represents the concentration of data points.
Therefore, the correct answer is A. Change the mark type to Density.
To create a density map from a scatter plot of data points, you would change the mark type to Density. This mark type allows you to visualize the concentration of data points in an area, which can be useful for identifying clusters or patterns in geospatial data.
NEW QUESTION # 104
You connect to a database server by using Tableau Prep. The database server has a data role named Role1.
You have the following field in the data.
You need to apply the Role1 data role to the Material field.
Which two actions should you perform? Choose two.
- A. For the data type of the Material field, select Custom, and then select Role1.
- B. From the More actions menu of Materials, select Group Values, and then select Spelling.
- C. From the More actions menu of Materials, filter the selected values.
- D. From the More actions menu of Materials, select Valid in the Show values section.
Answer: A,B
Explanation:
To apply a custom data role to a field, you need to select the data type of the field and then choose the data role from the list of available roles. This will validate the values in the field against the data role and mark any invalid values with a red exclamation mark. To fix the invalid values, you can use the Group Values option and select the Spelling algorithm, which will group values that are close in spelling and replace them with the most frequent value in the group. This will help you standardize the values in the Material field and match them with the Role1 data role. References: The information is based on the following sources:
Use Data Roles to Validate your Data - Tableau
New in Tableau Prep: Automatically identify data quality issues with Data Roles
NEW QUESTION # 105
You have the following chart that shows profits and discounts over time.
You need to combine the lines to appear as shown in the following chart.
What should you do?
- A. Drag Discount to the Columns shelf
- B. Set Discount to Dual Axis
- C. Drag Discount to Color on the Marks card
- D. Convert Discount to Discrete
Answer: C
NEW QUESTION # 106
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:
Send us your feedback on it
NEW QUESTION # 107
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:
Explanation:
Select
Where
The correct way to complete the query is:
SELECT * FROM [dbo] . [Students]
WHERE [Students].[City] = 'Berlin'
The SELECT statement is used to retrieve data from a table or a view. The * symbol means that all columns will be returned. The FROM clause specifies the table or view name and the schema name.
The WHERE clause is used to filter the data based on a condition. The condition is [Students].[City] =
'Berlin', which means that only rows where the City column of the Students table is equal to 'Berlin' will be returned.
The other options are not relevant for this query. CAST is a function that converts a value from one data type to another. JOIN is a clause that combines data from two or more tables based on a common field. ON is a keyword that specifies the join condition. UNION is a set operation that combines the results of two or more queries into one result set.
References: https://docs.microsoft.com/en-us/sql/t-sql/queries/select-transact-sql?view=sql-server-ver15
https://docs.microsoft.com/en-us/sql/t-sql/queries/where-transact-sql?view=sql-server-ver15
https://docs.microsoft.com/en-us/sql/t-sql/functions/cast-and-convert-transact-sql?view=sql-server-ver15
https://docs.microsoft.com/en-us/sql/t-sql/queries/from-transact-sql?view=sql-server-ver15#join
https://docs.microsoft.com/en-us/sql/t-sql/language-elements/set-operators-union-transact-sql?view=sql-server-v
NEW QUESTION # 108
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.
References: https://help.tableau.com/current/pro/desktop/en-us/dashboards.htm https://help.tableau.com
/current/pro/desktop/en-us/dashboards_showhide.htm https://help.tableau.com/current/pro/desktop/en-us
/dashboards_create_layouts.htm
NEW QUESTION # 109
You have a dashboard that contains confidential information about patients health. The data needs to always be up to date tor a team of healthcare workers How should you share me dashboard with the healthcare workers?
- A. Print the dashboard to PDF
- B. Publish the dashboard to Tableau Public
- C. Publish the dashboard to Tableau Server
- D. Export the dashboard as a .twbx
Answer: C
Explanation:
To share a dashboard that contains confidential information about patients health and needs to always be up to date for a team of healthcare workers, you should publish it to Tableau Server. This will allow you to control who can access and interact with your dashboard, as well as schedule automatic refreshes of your data source or extract. Publishing to Tableau Public would expose your data to anyone on the internet, printing to PDF would not update your data, and exporting as a .twbx would require sending a large file that might not be compatible with other versions of Tableau. References: https://help.tableau.com/current/pro/desktop/en-us
/publish_workbooks_share.htm https://help.tableau.com/current/pro/desktop/en-us
/publish_workbooks_tableauserver.htm
When sharing sensitive and confidential information that needs to be kept up-to-date, such as patient health data for a team of healthcare workers, the best practice is to publish the dashboard to Tableau Server. Tableau Server is designed for secure, controlled access and can be configured to ensure that data is refreshed as needed. Publishing to Tableau Public is not secure for confidential data, printing to PDF or exporting as a .
twbx does not allow for live data updates.
NEW QUESTION # 110
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. August
- B. October
- C. December
- D. November
Answer: D
Explanation:
Based on the line chart provided, each point on the line chart represents the average sales for a given month, and the percentage values indicate the change in average sales compared to the previous month. The month of November shows a significant increase from the month of October, indicated by a large upward spike on the chart and a high percentage increase.
NEW QUESTION # 111
You have a blank dashboard.
You want to add two sheets to the dashboard. The sheets must support the Show/Hide button.
To which two objects can you add the sheets? (Click the two appropriate Options in the Answer Area.)
Answer:
Explanation:
To add two sheets to the dashboard that support the Show/Hide button, you can add them to either a horizontal or a vertical container. A container is an object that can hold one or more sheets or other objects and allow you to arrange them in a layout. A Show/Hide button is a feature that lets you hide or show a container and its contents on the dashboard. You can add a Show/Hide button to any container, whether it is tiled or floating, by using the drop-down menu of the container and selecting "Add Show/Hide Button." You can also customize the appearance and behavior of the button.
To add a horizontal or a vertical container to the dashboard, you can drag them from the Objects pane to the dashboard. A horizontal container will arrange the sheets or objects horizontally, while a vertical container will arrange them vertically. You can then drag the sheets you want to add from the Sheets pane to the container. You can resize and reorder the sheets or objects within the container by using the handles and arrows.
The other objects in the Answer Area, such as text, image, web page, blank, navigation, download, and extension, do not support the Show/Hide button. They are either static elements that cannot hold other objects, or dynamic elements that require user interaction or external sources. You can add them to the dashboard as well, but they will not have the same functionality as a container with a Show/Hide button.
References:
Add Show/Hide Buttons - Tableau
Layout Containers - Tableau
NEW QUESTION # 112
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 in order? (Place the three correct options in order.)
Answer:
Explanation:
Explanation:
The correct order of the three actions is:
From the connections pane, connect to both data sources
Join both datasets and select the join type
Specify Employee Name as the join key
The first action is to connect to both data sources from the connections pane in Tableau Prep. The connections pane is where you can access and add data sources to your flow. You can connect to various types of data sources, such as Excel, SQL Server, or Tableau Server. In this case, you want to connect to an Excel worksheet and a SQL Server table.
The second action is to join both datasets and select the join type. A join is a way of combining data from two or more tables based on a common field. You can join datasets by dragging one table to the canvas and dropping it on top of another table. This will create a join step in your flow. You can select the join type from the drop-down list on the join step. The join type determines which rows are returned from the tables.
The third action is to specify Employee Name as the join key. A join key is a field that is used to match rows from different tables. You can specify the join key by clicking on the field name in each table and dragging it to the center of the join step. This will create a join clause that shows the field name and the operator. In this case, you want to use Employee Name as the join key, because it is a common field between the two datasets.
The other options are not relevant for this scenario. Specifying Department and Team Size as a join condition will not work, because they are not common fields between the two datasets. Opening both data sources in Tableau Desktop will not help you join them in Tableau Prep. Adding a step to aggregate the data in the SQL Server table will not affect the join, but it may change the level of detail of your data. References:
https://help.tableau.com/current/prep/en-us/prep_connect.htm
https://help.tableau.com/current/prep/en-us/prep_join.htm
https://help.tableau.com/current/prep/en-us/prep_join_types.htm
NEW QUESTION # 113
In a dataset, you have a string field named Name that contains unnecessary semicolons.
Which function should you use to remove the semicolons from the Name field?
- A. TRIM
- B. SPLIT
- C. CONTAINS
- D. REPLACE
Answer: C
Explanation:
The REPLACE function is used to replace all occurrences of a substring within a string with another substring. In this case, it can be used to remove the semicolons from the Name field by replacing them with an empty string. For example, REPLACE ("John;Doe", ";", "") = "JohnDoe". References: The information is based on the following sources:
* String Functions - Tableau
* Remove special characters and add a semi colon in a word - Tableau
NEW QUESTION # 114
You want to create the following table in a view.
Which function should you use to create the Position column?
- A. LAST
- B. INDKX
- C. RANK
- D. FIRST
Answer: D
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 # 115
You have the following tiled dashboard that has one sheet.
You want to replace the sheet with Sheet2.
What should you do?
- A. From the context menu of Sheet3, select Deselect.
- B. Select Sheet3 and click the Swap Sheet button next to Sheet2.
- C. From the context menu of Sheet3, select Remove Dashboard Item.
- D. Drag Sheet2 to the dashboard.
- E. Right-click Sheet2 and select Add to Dashboard.
Answer: D
Explanation:
In Tableau, to replace a sheet on a dashboard, you can simply drag the desired sheet (Sheet2 in this case) from the sheets list onto the dashboard where the current sheet (Sheet3) is. This will replace the existing visualization with the new one.
NEW QUESTION # 116
in which three formats can you export a worksheet from the Worksheet menu? Choose three
- A. .xlsx
- B. .txt
- C. .csv
- D. .pptx
- E. .html
- F. .png
Answer: A,D,F
Explanation:
Tableau provides various options to export data from a worksheet. The formats available are typically those that are best suited for visualization or further data analysis. The options include:
.png for exporting images of the visualizations
.xlsx for exporting data in a format that can be opened with Microsoft Excel
.pptx for creating PowerPoint presentations with the visualization embedded These formats are designed to facilitate sharing and presenting the insights derived from Tableau visualizations, or for conducting further analysis in tools like Excel.
NEW QUESTION # 117
You plan to create a visualization that has a dual axis chart. The dual axis chart will contain a shape chart and a line chart will use the same measure named Population on the axis.
You need to configure be shapes to be much larger than the line.
What should you do?
- A. Create a custom shape that is larger than the default shape and add the shape to the Shapes folder in My Repository
- B. Duplicate Population Drag the duplicate to the second Marks card and configure the see of the marks independently
- C. For the second axis select Shape on the Marks card From Select Shape Palette select Custom and then select Reset
- D. Change Population to a discrete dimension
Answer: B
Explanation:
To configure the shapes to be much larger than the line, you need to duplicate Population and drag it to the second Marks card. This will create a dual axis chart with two measures on one axis. You can then select Shape on one Marks card and Line on another Marks card, and adjust the size of each mark independently using the Size slider or menu. Reference: https://help.tableau.com/current/pro/desktop/en-us/multiplemeasures_dualaxes.htm https://help.tableau.com/current/pro/desktop/en-us/marks_markproperties_size.htm
NEW QUESTION # 118
......
Study resources for the Valid TDA-C01 Braindumps: https://freepdf.passtorrent.com/TDA-C01-latest-torrent.html