Free TDA-C01 Exam Braindumps certification guide Q&A
TDA-C01 Certification Overview Latest TDA-C01 PDF Dumps
Tableau TDA-C01 exam covers a wide range of topics related to data analysis, including data preparation, data analysis, and data visualization. It also includes questions on Tableau’s features and functionality, as well as best practices for using the software effectively. TDA-C01 exam consists of multiple-choice questions and is timed at 120 minutes. A passing score of 75% or higher is required to obtain the Tableau Certified Data Analyst certification.
NEW QUESTION # 21
You have the following map.
You need the map to appear as shown in the following visualization.
What should you do?
- A. Drag Location to Size on the Marks card
- B. Drag Population to Size on the Marks card
- C. Change the mark type to Map
- D. Change the opacity to 75%
- E. Change the mark type to Density
Answer: E
NEW QUESTION # 22
You subscribe to a view that delivers a daily email to your inbox.
You want to make the subscription available to other stakeholders.
What should you do?
- A. From the worksheet, modify the subscription.
- B. From the My Content overview page, modify the alert.
- C. From the dashboard overview page, modify the subscription.
- D. From the My Content overview page, modify the subscription.
Answer: D
NEW QUESTION # 23
You have the following dashboard.
Currently the map is used as a filter that affects the data on the otter sheets of the dashboard You need to configure the dashboard to ensure that selecting a data point on the map only tillers the Detail table What should you do?
- A. From the context menu of Profits by Stale deselect Use as Filter
- B. From the context menu of Sales over time select Ignore Actions
- C. From the context menu of Sales over time select Deselect
- D. From the context menu of Sales over lime select Remove Dashboard Item
Answer: B
Explanation:
To configure the dashboard to ensure that selecting a data point on the map only filters the Detail table, you should select Ignore Actions from the context menu of Sales over time. Ignore Actions is a feature that allows you to exclude a sheet from being affected by any actions on the dashboard, such as filters or highlights. You can select Ignore Actions by right-clicking on a sheet on the dashboard and selecting Ignore Actions from the menu.
In this case, you want to exclude Sales over time from being filtered by the map, so you should select Ignore Actions from its context menu. This will make Sales over time ignore any selections on the map and show all values. The Detail table will still be filtered by the map as usual.
The other options are not correct for this scenario. Removing Dashboard Item will delete Sales over time from the dashboard, which is not what you want. Deselecting Use as Filter will disable the map as a filter for any sheet on the dashboard, which is not what you want. Selecting Deselect will clear any selections on the map, but it will not prevent Sales over time from being filtered by future selections. Reference: https://help.tableau.com/current/pro/desktop/en-us/actions.htm https://help.tableau.com/current/pro/desktop/en-us/actions_ignore.htm
NEW QUESTION # 24
Open the Link to Book1 found on the desktop. Open Map worksheet and use Superstore data source.
Create a filed map to show the distribution of total Sales by State across the United States.
Answer:
Explanation:
check the steps below in explanation.
Explanation:
To create a filled map to show the distribution of total Sales by State across the United States, 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.
Click on the Map tab at the bottom of the workbook to open the Map worksheet. You will see a blank worksheet with no marks.
Drag State from the Dimensions pane to Detail on the Marks card. This will create a map that shows each state as a mark. You may need to zoom in or out to see the whole map.
Drag Sales from the Measures pane to Color on the Marks card. This will create a filled map that shows the distribution of total Sales by State across the United States. The color legend will show you the range of values and colors for Sales.
Optionally, you can adjust the color scheme, transparency, size, and borders of the marks by clicking on the Color menu on the Marks card. You can also add labels, tooltips, or filters to enhance your map.
References: https://help.tableau.com/current/pro/desktop/en-us/maps.htm
https://help.tableau.com/current/pro/desktop/en-us/maps_howto_filled.htm
https://help.tableau.com/current/pro/desktop/en-us/marks_markproperties_color.htm
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.
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.
References: https://help.tableau.com/current/pro/desktop/en-us/datasource_prepare.htm
https://help.tableau.com/current/pro/desktop/en-us/split.htm
https://help.tableau.com/current/pro/desktop/en-us/renamefield.htm
NEW QUESTION # 26
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 # 27
You have a dataset that contains people and the awards they have won.
Which formula should you use to get the number of different types of awards that have been won?
- A. MAX {(Award})
- B. COVAR({Award})
- C. COUNTD {(NAME])
- D. COUNTD({Award})
- E. INDEX()
Answer: C
NEW QUESTION # 28
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.
- A. IFNULL [(profits] ,0)
- B. IFNULL([Profits],0)
- C. IF [Profits] != null then [Profits] END
- D. 2N ([Profits])
- E. ISNULL ([Profits])
Answer: A,D
Explanation:
The IFNULL function is a logical function that returns the first argument if it is not null, and the second argument if it is null. In this case, the first argument is [Profits], which is the field that contains null values. The second argument is 0, which is the value that you want to replace null values with. The function will return [Profits] if it is not null, and 0 if it is null.
The IF statement is a logical statement that returns a value or performs an action if a condition is true, and optionally returns another value or performs another action if the condition is false. In this case, the condition is [Profits] != null, which means that [Profits] is not null. The statement will return [Profits] if the condition is true, and nothing if the condition is false. The END keyword marks the end of the statement.
The other options are not correct for this scenario. The ZN function is a logical function that returns zero if a value or expression is null, and returns the value or expression itself if it is not null. However, it only works with numeric values or expressions, and [Profits] may not be numeric in this case. The ISNULL function is a logical function that returns TRUE if a value or expression is null, and FALSE otherwise. It does not replace null values with another value. Reference: https://help.tableau.com/current/pro/desktop/en-us/functions_functions_logical.htm#IFNULL https://help.tableau.com/current/pro/desktop/en-us/functions_functions_logical.htm#IF https://help.tableau.com/current/pro/desktop/en-us/functions_functions_logical.htm#ZN https://help.tableau.com/current/pro/desktop/en-us/functions_functions_logical.htm#ISNULL Explanation:
The two formulas that will make the data appear as shown in the second table are:
NEW QUESTION # 29
Open the link to Book1 found on the desktop. Open Disciplines worksheet.
Filter the table to show the Top 10 NOC based on the number of medals won.
- A. check the steps below in explanation
Answer: A
Explanation:
To filter the table to show the Top 10 NOC based on the number of medals won, 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 NOC, discipline, and medals for each country.
Drag Medals from the Measures pane to the Filters shelf. This will open a dialog box that allows you to filter by different criteria.
Select Top from the dialog box. This will show you options to filter by the top or bottom values of a field.
Enter 10 in the text box next to By field. This will filter by the top 10 values of Medals.
Select NOC from the drop-down list next to By field. This will filter by the top 10 values of NOC based on Medals.
Click OK to apply the filter. You will see that the table now shows only 10 rows, one for each NOC with the highest number of medals.
NEW QUESTION # 30
You want to connect a Tableau workbook to a dataset in a Microsoft Excel spreadsheet.
What should you do from Tableau Desktop?
- A. From the Data menu select New Data Source
- B. From the File menu select Import Workbook
- C. From the File menu select New
- D. From the Data menu select Replace Data Source
Answer: A
NEW QUESTION # 31
in which three formats can you export a worksheet from the Worksheet menu? Choose three
- A. .png
- B. .html
- C. .xlsx
- D. .txt
- E. .pptx
- F. .csv
Answer: A,B,F
NEW QUESTION # 32
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 # 33
Open the Link to Book1 found on the desktop. Open Map worksheet and use Superstore data source.
Create a filed map to show the distribution of total Sales by State across the United States.
Answer:
Explanation:
Send us your feedback on it
NEW QUESTION # 34
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:
check the steps below in explanation
Explanation:
To replace the existing data source with the Netflix_2019 data source, 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 Movie Durations worksheet.
Click on the Movie Durations tab at the bottom of the workbook to open the worksheet. You will see a bar chart that shows the number of movies by duration for the existing 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 existing data source.
Click on the drop-down arrow next to the data source name at the top of the page and select Replace Data Source from the menu. This will open a dialog box that allows you to replace your data source with another one.
Select Netflix_2019 from the list of available data sources and click OK. This will replace your existing data source with the Netflix_2019 data source and update your worksheet accordingly. You may need to fix any broken fields or calculations that result from the replacement.
NEW QUESTION # 35
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.)
Answer:
Explanation:
1 - Join the tables.
2 - Aggregate the data by Sales Team.
3 - Add the following filter to the Employees table: Sale Team - Team Alpha.
Reference:
[Tableau Certified Data Analyst Exam Prep Guide], page 9, section "Preparing Data"
[Tableau Help: Join Your Data]
[Tableau Help: Aggregate Your Data]
[Tableau Help: Filter Your Data]
NEW QUESTION # 36
You create the following worksheet
The Pick Measure parameter contains the following list of values
Users can select a value from Pick Measure to change the visualization to show either the Sales measure or the Profit measure.
Which formula is used in the Selected Measure calculated field lo switch between measures?
- A. Case STFMEPick Measure])
WHEN "Sales" then ([Sales])
WHEN "Profit" then ([Profit]) e::i - B. Case [Pick Measure]
WHEN 1 then ([Sales])
WHEN 2 then ([Profit]) END - C. Case AVG([Pick Measure])
WHEN [Sales] then 1
WHEN [Profit] then 2
END - D. Case [Pick Measure:
WHEN [Sales] then 1
WHEN [Profit] then 2 END
Answer: B
Explanation:
https://help.tableau.com/current/pro/desktop/en-us/parameters_swap.htm
NEW QUESTION # 37
Open the link to Book1 found on the desktop. Open the Histogram worksheet and use the Superstone data source.
Create a histogram on the Quantity field by using bin size of 3.
Answer:
Explanation:
check the steps below in explanation.
Explanation:
To create a histogram on the Quantity field by using bin size of 3, 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.
Click on the Histogram tab at the bottom of the workbook to open the Histogram worksheet. You will see a blank worksheet with no marks.
Right-click on Quantity in the Measures pane and select Create Bins from the menu. This will open a dialog box that allows you to create bins for the Quantity field. Bins are groups of values that are treated as one unit in a histogram.
Enter 3 in the Size of bins text box. This will set the bin size to 3, which means that each bin will contain values that are 3 units apart. For example, one bin will contain values from 0 to 2, another bin will contain values from 3 to 5, and so on.
Click OK to create the bins. You will see a new field named Quantity (bin) in the Measures pane with a
# sign next to it.
Drag Quantity (bin) from the Measures pane to Columns on the worksheet. This will create a histogram that shows the distribution of Quantity by bins. You will see bars that represent the frequency or count of values in each bin.
Optionally, you can adjust the width, color, and labels of the bars by using the options on the Marks card. You can also add filters, tooltips, or annotations to enhance your histogram.
References: https://help.tableau.com/current/pro/desktop/en-us/histograms.htm
https://help.tableau.com/current/pro/desktop/en-us/calculations_bins.htm
https://help.tableau.com/current/pro/desktop/en-us/buildmanual_histograms.htm
NEW QUESTION # 38
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?
- A. A table calculation filter used on Sheet
- B. A top N condition filer on a dimension in Sheet 1 and Sheet2
- C. A dimension Maw on all the sheets
- D. A context filler on a dimension m Sheet3
Answer: B
NEW QUESTION # 39
......
Tableau TDA-C01 certification is a valuable credential for individuals who want to enhance their skills and knowledge in data analytics. Tableau Certified Data Analyst certification is globally recognized and provides individuals with a competitive edge in the job market. Preparing for the exam requires a combination of practical experience and theoretical knowledge, and Tableau provides various resources to help individuals prepare for the exam. Passing the TDA-C01 exam demonstrates an individual's ability to use Tableau to connect to various data sources, perform data analysis, create and share visualizations, and design dashboards.
The Best Tableau TDA-C01 Study Guides and Dumps of 2024: https://www.vceprep.com/TDA-C01-latest-vce-prep.html
Top Tableau TDA-C01 Exam Audio Study Guide! Practice Questions Edition: https://drive.google.com/open?id=1yhTNtLu_FqX7Gk5y2D4cqBHKkHa-dsJS