TDA-C01 Practice Test Questions Updated 66 Questions
Tableau TDA-C01 Dumps - Secret To Pass in First Attempt
Tableau TDA-C01 certification exam covers a wide range of topics, including data preparation, data analysis and visualization, and dashboard creation. It is a comprehensive exam that requires candidates to have a deep understanding of Tableau's functionality, features, and best practices. TDA-C01 exam is designed to test a candidate's ability to use Tableau to create effective visualizations, perform complex data analysis, and communicate insights to stakeholders.
Tableau TDA-C01 Exam consists of 36 multiple-choice questions that must be completed within 120 minutes. TDA-C01 exam is available in English, Japanese, Simplified Chinese, and Spanish. To pass the exam, candidates must score at least 70%. Tableau Certified Data Analyst certification is valid for two years, after which candidates must recertify. The Tableau TDA-C01 Exam is a valuable credential for data analysts who want to demonstrate their proficiency in using Tableau for data analysis and visualization.
Tableau TDA-C01 (Tableau Certified Data Analyst) Exam is an industry-recognized certification that validates the skills and knowledge of individuals in the field of data analysis. Tableau Certified Data Analyst certification is designed for professionals who are seeking to enhance their skills in data visualization, data analysis, and data manipulation using Tableau software. The TDA-C01 exam is a rigorous test that requires candidates to demonstrate their proficiency in various Tableau topics.
NEW QUESTION # 20
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. IIF(SUM< [Sales] )>50000, TRUE, FALSE)
- B. [Sales] > 50000
- C. MAX< [Sales], 50000)
- D. SUM{[Sales]) IN (50000)
Answer: A,B
NEW QUESTION # 21
You have the following dashboard.
When a user selects a only on the map the data on the bar chart must show only the data for the selected city. The data in the bar chart must change only when the user selects a different city How should you configure the dashboard action? (Use the dropdowns in the Answers Area to select the correct options.)
Answer:
Explanation:
NEW QUESTION # 22
You need to change the values of a dimension without creating a new field.
What should you do?
- A. Create aliases
- B. Transforms the fields
- C. Create groups
- D. Rename the fields
Answer: A
Explanation:
You can create aliases for the members of a dimension by right-clicking the dimension in the Data pane or in the view and selecting Aliases. This changes how the values are displayed in the view, but not the underlying data. For example, you can create an alias for "Central" as "Midwest".
NEW QUESTION # 23
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 # 24
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 # 25
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.
- A. Send us your
- B. Send us your feedback on it.
Answer: B
NEW QUESTION # 26
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. Customers of 2020
- C. Top N Products
- D. Top N Customers
Answer: A,C
NEW QUESTION # 27
You have the following dataset in Microsoft Excel.
You are using interpreter to cleans the dataset. Data interpreter provides the following results.
How many rows of data will be ingested into Tableau as values?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: D
Explanation:
Data interpreter is a feature that helps you clean and structure your data in Excel before importing it into Tableau. It detects and removes any headers, footers, subtotals, or other elements that are not part of the actual data. It also splits any merged cells and fills in any missing values. In this case, data interpreter provides the following results:
It removes the first three rows and the last two rows that contain headers and footers.
It splits the merged cells in column A and fills in the missing values with "Fiction" or "Non-Fiction".
It does not remove or change any other rows or cells.
Therefore, the number of rows of data that will be ingested into Tableau as values is 17, which is the number of rows left after removing the headers and footers. Reference: https://help.tableau.com/current/pro/desktop/en-us/importing_cleaning_up_data.htm https://help.tableau.com/current/pro/desktop/en-us/importing_data_interpreter.htm
NEW QUESTION # 28
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.
- A. Send us your
- B. Send us your feedback on it.
Answer: B
NEW QUESTION # 29
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 # 30
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
- B. Send us your feedback on it.
Answer: B
NEW QUESTION # 31
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 # 32
You have the following box plot that shows the distribution of average profits made in every state by region.
Which region has the smallest distribution of profits?
- A. Cast
- B. Central
- C. West
- D. South
Answer: D
NEW QUESTION # 33
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 Sales over time select Ignore Actions
- 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 Profits by Stale deselect Use as Filter
Answer: B
NEW QUESTION # 34
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. Change the default number format of the Sales told
- C. Create a calculated field that uses a formula of 'S' * str (Round((sales],2)) + 'k'
- D. Create a calculated field that uses a formula of 'S' + stri < (Sales)/1000)).
Answer: A
NEW QUESTION # 35
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. IIF(SUM< [Sales] )>50000, TRUE, FALSE)
- B. [Sales] > 50000
- C. MAX< [Sales], 50000)
- D. SUM{[Sales]) IN (50000)
Answer: A,B
Explanation:
B) IIF(SUM([Sales]) > 50000, TRUE, FALSE) D. [Sales] > 50000
The IIF function is a logical function that returns one value if a condition is true, and another value if the condition is false. In this case, the condition is SUM([Sales]) > 50000, which means that the sum of sales for a month is greater than $50,000. The function will return TRUE if the condition is true, and FALSE if the condition is false.
The comparison operator > is a logical operator that returns TRUE if the left operand is greater than the right operand, and FALSE otherwise. In this case, the operands are [Sales] and 50000, which means that the sales for a month are greater than $50,000. The operator will return TRUE if the sales are greater than $50,000, and FALSE otherwise.
The other options are not correct for this scenario. The IN function is a logical function that returns TRUE if a value is in a set of values, and FALSE otherwise. In this case, the value is SUM([Sales]), which is not in the set of values (50000). The function will always return FALSE. The MAX function is an aggregation function that returns the maximum value in a field or expression. In this case, the field or expression is [Sales], 50000, which is not valid syntax. The function will return an error. Reference: https://help.tableau.com/current/pro/desktop/en-us/functions_functions_logical.htm#IIF https://help.tableau.com/current/pro/desktop/en-us/operators.htm https://help.tableau.com/current/pro/desktop/en-us/functions_functions_aggregate.htm#MAX Explanation:
The two formulas that will return a value of true if a month has sales greater than $50,000, otherwise the formula must return a value of false, are:
NEW QUESTION # 36
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 # 37
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
- B. Send us your feedback on it.
Answer: B
NEW QUESTION # 38
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 Products
- B. Top N Customers
- C. Customers of 2020
- D. Sellers of 2020
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. 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 # 39
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.
- A. Send us your
- B. Send us your feedback on it.
Answer: B
NEW QUESTION # 40
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 default number format of the Sales told
- B. Create a calculated field that uses a formula of 'S' * str (Round((sales],2)) + 'k'
- C. Change the data type of the Sates field to Siring
- D. Create a calculated field that uses a formula of 'S' + stri < (Sales)/1000)).
Answer: A
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 # 41
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 # 42
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 # 43
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. Change the mark type to Density
- C. Drag Location to Size on the Marks card
- D. Drag Population to Size on the Marks card
- E. Change the mark type to Map
Answer: D
NEW QUESTION # 44
......
Tableau TDA-C01 Exam Dumps [2023] Practice Valid Exam Dumps Question: https://actual4test.practicetorrent.com/TDA-C01-practice-exam-torrent.html