Go to TDA-C01 Questions - Try TDA-C01 dumps pdf
Dumps Practice Exam Questions Study Guide for the TDA-C01 Exam
Tableau TDA-C01 certification is a valuable credential for data analysts who wish to demonstrate their expertise in using Tableau for data analysis and visualization. It provides a standardized way for employers to assess a candidate's skills and knowledge in this area. By passing TDA-C01 exam, individuals can enhance their career prospects and showcase their ability to analyze and communicate insights from complex data sets.
NEW QUESTION # 43
You have the following chart that shows the cumulative of sales from various dates.
You want the months to appear as shown in the following chart.
What should you do?
- A. Convert the date to Continuous
- B. Convert the date to Attribute
- C. Select Show Misting Values for the dale
- D. Convert the date to Exact Date
Answer: A
NEW QUESTION # 44
A Data Analyst creates a parameter named Choose Region that contains values from a field named Region.
The analyst wants users to be able to use the Choose Region parameter to interact with a chart by toggling between different regions.
What should the analyst do next?
- A. Add Region to the Filters card.
- B. Add the Choose Region parameter to the Pages card.
- C. Add the [Region] = [Choose Region] formula to the Filters card.
- D. Set the Choose Region parameter to Single Value (list).
Answer: C
NEW QUESTION # 45
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: A
NEW QUESTION # 46
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 # 47
You are the owner of an alert.
You receive an email notification that the alert was suspended From where can you resume the suspended alert?
- A. The Shared with Ma page
- B. The My Content area of Tableau web pages
- C. The Data Source page of Tableau Desktop
- D. The Notification area of Tableau Prep
Answer: A
NEW QUESTION # 48
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 lime select Remove Dashboard Item
- C. From the context menu of Sales over time select Deselect
- D. From the context menu of Sales over time select Ignore Actions
Answer: D
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 # 49
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. Sellers of 2020
- B. Top N Customers
- C. Customers of 2020
- D. Top N Products
Answer: B,C
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. References:
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 In Tableau, sets can be combined if they are created from the same dimension. From the options provided,
"Customers of 2020" and "Top N Customers" are likely created from the same dimension (Customers).
Therefore, these two sets can be combined to create a new set that includes or excludes members based on the combined criteria. Combining sets like "Top N Products" with "Customers of 2020" would not be feasible unless they are from the same dimension, which is typically not the case.
NEW QUESTION # 50
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. Export mdb
- B. Book1.twb
- C. Sales.csv
- D. Sales.hyper
Answer: A
NEW QUESTION # 51
A Data Analyst has the following chart that shows the cumulative volume of sales from various dates.
The analyst wants the months to appear as shown in the following chart.
What should the analyst do?
- A. Convert the date to Continuous
- B. Change the Sort Order
- C. Convert the date to Attribute
- D. Convert the date to Exact Date
Answer: A
NEW QUESTION # 52
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 # 53
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 # 54
You have the Mowing dashboard.
Which two elements are floating? Choose two.
- A. The little
- B. The state filter
- C. The color legend
- D. The Rate of Obesity chart
- E. The map
Answer: C,D
Explanation:
To identify which elements are floating on a dashboard, you can look for a gray border around them when you select them. Alternatively, you can open the Layout pane and see which elements have a pin icon next to them. The pin icon indicates that the element is floating and can be moved freely on the dashboard. Based on these criteria, the state filter and the color legend are floating elements on the dashboard. 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_create_layouts.htm
NEW QUESTION # 55
You have a Tableau Prep flow that joins a dataset named Global Indicators to a dataset named Price Indices.
In which step can you transform rows of monthly data into rows of yearly data''
Answer:
Explanation:
NEW QUESTION # 56
A colleague provides a Data Analyst with access to a folder that contains the following files:
Sales.csv
Book1.twb
Sales.hyper
Export.mdb
Which file is a Tableau extract?
- A. Export.mdb
- B. Sales.hyper
- C. Book1.twb
- D. Sales.csv
Answer: B
NEW QUESTION # 57
You have the following dataset.
You need to create the following worksheet.
The table must show either profit or sales based on the selection from the Parameter 1 menu.
Which three actions should you perform in orders
(Place the three correct options in order Use the arrows to move Options lo Answer Area Use Answer Area arrows to reorder the options)
Answer:
Explanation:
A screenshot of a computer Description automatically generated
NEW QUESTION # 58
You have the following visualization.
Answer:
Explanation:
NEW QUESTION # 59
You have the following tiled dashboard that has one sheet.
You want to replace fit sheet with Sheet2.
What should you do?
- A. From the context menu of Sheet3. select Deselect
- B. From the context menu of Sheet3. select Remove Dashboard item
- C. Right-click Sheet2 and select Add to Dashboard.
- D. Drag Sheet2 to the dashboard.
- E. Select Sheets and click the Swap Sheet button next to Sheet2.
Answer: E
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 # 60
You have two tables named Employeelnfo and DepartmentInfo. Employeelnfo contains four fields named Full Name, Department ID, Start Date, and Salary.
DepartmentInfo contains four fields named Department Name, Size, Department ID, and VP.
You want to combine the tables to meet the following requirements:
. Each record in Employeelnfo must be retained in the combined table.
. The records must contain the Department Name, Size, and VP fields.
* Every record must have a full name.
Which type of join should you use?
- A. Union
- B. Inner
- C. Full outer
- D. Left
Answer: D
Explanation:
To combine the tables and meet the requirements, you should use a left join. A left join will keep all the records from the left table (Employeelnfo) and match them with the records from the right table (DepartmentInfo) based on the common field (Department ID). If there is no matching record in the right table, the fields from the right table will be null. This way, you will retain all the records from Employeelnfo, and also include the Department Name, Size, and VP fields from DepartmentInfo. Every record will have a full name because it is a field from the left table. A left join will look like this:
Reference:
Join Your Data - Tableau
Join Types in Tableau
NEW QUESTION # 61
You have a workbook that connects to a database. The database requires authentication.
You plan to publish the workbook and schedule a daily refresh of the data.
Which two conditions must be met to schedule the refresh? Choose two.
- A. The data source must use a live connection.
- B. The data must be extracted.
- C. The data source must be stored as a hyper file.
- D. The credentials must be embedded.
Answer: B,D
Explanation:
To schedule a refresh of the data, you need to ensure that Tableau Server or Tableau Online can access the database without prompting for credentials. This can be done by embedding the credentials in the workbook or the published data source. You also need to extract the data from the database and publish it as a separate data source or as part of the workbook. A live connection would not allow you to refresh the data on a schedule, as it would always query the database directly. A hyper file is a format for storing extracted data, but it is not a requirement for scheduling a refresh. Reference:
Tableau Certified Data Analyst Exam Prep Guide, page 10, section "Publishing and Scheduling Data Refreshes" Tableau Help: Embedding Database Credentials Tableau Help: Extract Your Data
NEW QUESTION # 62
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. Common Characters
- D. Pronunciation
Answer: A
NEW QUESTION # 63
What should a Data Analyst use to visualize the distribution and variability of measure values along an axis?
- A. Scatter Plot
- B. Bullet Graph
- C. Histogram
- D. Box Plot
Answer: D
NEW QUESTION # 64
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 # 65
You have a data source that contains the following columns.
You want to sort customers based on the most expensive orders.
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 # 66
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. IF [Profits] != null then [Profits] END
- B. ISNULL ([Profits])
- C. IFNULL [(profits] ,0)
- D. ZN ([Profits])
Answer: C,D
Explanation:
Both the ZN and IFNULL functions in Tableau can be used to replace NULL values with zeros. The ZN function converts NULL to zero directly, while the IFNULL function allows you to specify that NULL should be replaced with zero. Both will result in showing zero for any NULL values in the Profits field.
References: 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
NEW QUESTION # 67
......
Free Tableau Certified TDA-C01 Exam Question: https://www.lead2passed.com/Tableau/TDA-C01-practice-exam-dumps.html
TDA-C01 Dumps with Practice Exam Questions Answers: https://drive.google.com/open?id=1zZXQ9_5r1p5e-vf2fffK52Mn_b-c2Hl1
