Prepare Top Tableau TDA-C01 Exam Study Guide Practice Questions Edition
Go to TDA-C01 Questions - Try TDA-C01 dumps pdf
Tableau TDA-C01 is a certification exam offered by Tableau for individuals who want to establish their expertise in data analysis using Tableau. Tableau Certified Data Analyst certification is designed for professionals who want to demonstrate their advanced knowledge and skills in data analysis and visualization. The Tableau TDA-C01 certification exam validates an individual's ability to use Tableau to connect to various data sources, create visualizations, and analyze data to make informed business decisions.
NEW QUESTION # 36
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: C
Explanation:
To make Sales appear automatically as shown in the second table, you should change the default number format of the Sales field. The default number format is how Tableau displays a field when you drag it to a worksheet. You can change the default number format by right-clicking on the field and selecting Default Properties > Number Format from the menu. This will open a dialog box where you can choose a category, such as Currency or Percentage, and customize the options, such as decimal places or prefixes.
In this case, you want to change the default number format of Sales to Currency with zero decimal places and a custom prefix of "S". This will make Sales appear as "S" followed by the rounded value in thousands.
The other options are not correct for this scenario. Changing the data type of Sales to String will not affect how it appears on a worksheet. Creating a calculated field that uses a formula will not change the default number format of Sales, but create a new field that you have to drag to a worksheet. Converting Sales to Attribute will return only one value for each partition of data, which will not show any variation over time. Reference: https://help.tableau.com/current/pro/desktop/en-us/formatting.htm https://help.tableau.com/current/pro/desktop/en-us/formatting_change_default.htm
NEW QUESTION # 37
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. Send us your feedback on it.
- B. Send us your
Answer: A
NEW QUESTION # 38
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 # 39
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. Export the dashboard as a .twbx
- C. Publish the dashboard to Tableau Public
- D. Publish aw dashboard to Tableau Server
Answer: D
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. Reference: 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
NEW QUESTION # 40
You have the following map.
You need the map to appear as shown in the following visualization.
What should you do?
- A. Change the opacity to 75%
- B. Drag Population to Size on the Marks card
- C. Change the mark type to Density
- D. Drag Location to Size on the Marks card
- E. Change the mark type to Map
Answer: B
NEW QUESTION # 41
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?
- A. Enable captions
- B. Add a tooltip
- C. Drag the growth rate to Text on the Marks card
- D. Annotate March 2020
Answer: B
NEW QUESTION # 42
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. COUNTD({Award})
- C. COVAR({Award})
- D. COUNTD {(NAME])
- E. INDEX()
Answer: D
NEW QUESTION # 43
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: D
NEW QUESTION # 44
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:
1 - From the connections pane, connect to both data sources
2 - Join both datasets and select the join type
3 - Specify Employee Name as the join key
Reference:
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 # 45
A colleague provides you with access to a folder that contains the following files:
* Sates.csv
* Bookl.twb
* Sates.hyper
* Export.mdb
Which He contains an extract?
- A. Sales.hyper
- B. Book1.twb
- C. Sales.csv
- D. Export mdb
Answer: D
NEW QUESTION # 46
You want to add a draft watermark to a dashboard as shown in the following exhibit.
Which type of object should you use?
- A. Horizontal
- B. Sheet
- C. Web page
- D. Image
Answer: B
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 # 47
You want to add a comment to March 2020 as shown in the following visualization.
You have the following sets in a Tableau workbook
* Top N Customers
* Customers of 2020
* Top N Products
* Sellers of 2020
Which two sets can you combine? Choose two
- A. Top N Customers
- B. Customers of 2020
- C. Top N Products
- D. Sellers of 2020
Answer: A,B
Explanation:
To combine two sets, they must have at least one dimension in common. In this case, Customers of 2020 and Top N Customers both have Customer Name as a dimension, so they can be combined using set operations such as union, intersection, or difference. Sellers of 2020 and Top N Products have different dimensions (Seller Name and Product Name), so they cannot be combined. Reference: https://help.tableau.com/current/pro/desktop/en-us/sets.htm https://help.tableau.com/current/pro/desktop/en-us/sets_create.htm#combine-sets
NEW QUESTION # 48
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.
Answer:
Explanation:
check the steps below in explanation
Explanation:
To modify the chart to show only min and max values of both measures in each region, 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 Line worksheet.
Click on the Line tab at the bottom of the workbook to open the worksheet. You will see a line chart that shows the sales and profit for each month by region.
Drag Month from the Columns shelf to Filters shelf. This will open a dialog box that allows you to filter by different criteria.
Select Range of Dates from the dialog box. This will show you options to filter by a range of dates or values.
Select Minimum and Maximum from the drop-down list next to Month. This will filter by the minimum and maximum values of Month for each region. You can also enter specific values or use the sliders to adjust the range.
Click OK to apply the filter. You will see that the line chart now shows only min and max values of both measures in each region.
NEW QUESTION # 49
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.)
Answer:
Explanation:
1 - Specify Employee Name as the join key
2 - Open both data sources in Tableau Desktop
3 - Join both datasets and select the join type
NEW QUESTION # 50
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. ISNULL ([Profits])
- C. IFNULL [(profits] ,0)
- D. IF [Profits] != null then [Profits] END
- E. 2N ([Profits])
- F. IF [Profits] != null then [Profits] END
Answer: C,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 # 51
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 # 52
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 # 53
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. Inner join
- B. Right join
- C. Full outer join
- D. left join
Answer: C
Explanation:
To combine the two tables that contain data about books in a library and ensure that all the data is retained, you should use a full outer join. A full outer join is a type of join that returns all rows from both tables, regardless of whether there is a match or not. If there is no match, null values are filled in for the missing fields.
To perform a full outer join, you need to do the following steps:
Connect to both tables as your data sources in Tableau. You can use either live or extract connections.
Drag one table to the canvas and drop it on top of another table. This will create a join between them based on a common field.
Click on the join icon between the tables and select Full Outer Join from the drop-down list. This will change the join type to full outer join and show all rows from both tables.
Optionally, you can add or remove join clauses by clicking on Add or Remove buttons next to each clause. You can also change or rename fields by clicking on them.
The other types of joins are not correct for this scenario. An inner join returns only the rows that have a match in both tables, which will exclude any books that are missing from either table. A left join returns all rows from the left table and only the matching rows from the right table, which will exclude any books that are only in the right table. A right join returns all rows from the right table and only the matching rows from the left table, which will exclude any books that are only in the left table. Reference: https://help.tableau.com/current/pro/desktop/en-us/joining_tables.htm https://help.tableau.com/current/pro/desktop/en-us/join_types.htm
NEW QUESTION # 54
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] SUM Sales}
- C. {Fixed: [Region]: TOTAL Sales}
- D. {FIXED: SUM Sales}
Answer: A
Explanation:
To calculate the grand total of all the regions, you need to use a Level of Detail (LOD) expression that ignores any dimensions in the view and returns the total sum of sales. The FIXED keyword allows you to specify the level of detail for the calculation, and the TOTAL function returns the sum of all values in the expression. Therefore, the correct LOD expression is {FIXED: TOTAL (Sales)}. Reference: https://help.tableau.com/current/pro/desktop/en-us/calculations_calculatedfields_lod.htm https://help.tableau.com/current/pro/desktop/en-us/functions_functions_tablecalculation.htm#TOTAL
NEW QUESTION # 55
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 # 56
You have the following dashboard that contains two visualizations.
You want to show only visualization at time. Users must be able to switch between visualizations.
What should you me?
- A. Showhide buttons
- B. A parameter and a calculated filed
- C. Dashboard actions
- D. Worksheet actions
Answer: A
Explanation:
Showhide buttons are a feature that allows you to show or hide a layout container on a dashboard. You can use showhide buttons to create a toggle effect that switches between two visualizations. You need to place each visualization in a separate layout container and then add a showhide button for each container. You can customize the appearance and behavior of the buttons to suit your needs. 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_showhide.htm
NEW QUESTION # 57
......
Free Tableau Certified TDA-C01 Exam Question: https://www.exam4docs.com/TDA-C01-study-questions.html
Dumps Practice Exam Questions Study Guide for the TDA-C01 Exam: https://drive.google.com/open?id=1qgQouz_61ghG-AAhUIKLafzjybmP3vAb
