Tableau TDA-C01 Cert Guide PDF 100% Cover Real Exam Questions
Pass TDA-C01 Exam - Real Questions and Answers
NEW QUESTION # 12
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. Customers of 2020
- B. Sellers of 2020
- C. Top N Customers
- D. Top N Products
Answer: A,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 # 13
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 # 14
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. Sales.csv
- C. Book1.twb
- D. Export mdb
Answer: A
Explanation:
A .hyper file is an extract file that contains a snapshot of data from a data source. It is a compressed and optimized file format that can be used to improve the performance and portability of dashboards and workbooks. A .twb file is a workbook file that contains the visualization and connection information, but not the data itself. A .csv file is a comma-separated values file that contains plain text data. A .mdb file is a Microsoft Access database file that contains tables, queries, forms, and other objects. Reference: https://help.tableau.com/current/pro/desktop/en-us/save_savework_packagedworkbooks.htm https://help.tableau.com/current/pro/desktop/en-us/extracting_data.htm https://help.tableau.com/current/pro/desktop/en-us/examples_csv.htm https://support.microsoft.com/en-us/office/introduction-to-access-database-files-9f9a0f8c-9a3c-4a0b-8e6c-6d1f1f7c2b7e
NEW QUESTION # 15
You have the following visualization.
Answer:
Explanation:
NEW QUESTION # 16
You have the following visualization.
Answer:
Explanation:
NEW QUESTION # 17
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: C
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 # 18
You have the following dataset.
You plan to create a dashboard that will be filtered to show only data that is relevant to a specific Tableau user based on the Tableau_User_Name field You need to create a boolean calculated field to place on the data source finer Which formula should you use for the filter?
- A. ISFULLNAMETableu_USER_NAME))=USERNAME()
- B. NAME Tableau-USER-NAME)
- C. NAMEUSERNAME()
- D. USERNAME()=(Tableau_USER_NAME)
Answer: D
Explanation:
To create a boolean calculated field to place on the data source filter, you should use the formula USERNAME() = [Tableau_user]. This formula will return TRUE if the current Tableau user name matches the value in the Tableau_user field, and FALSE otherwise. You can use this formula as a data source filter by dragging it to the Filters shelf and selecting TRUE from the menu. This will filter the data to show only the rows that are relevant to the specific Tableau user.
The other options are not correct for this scenario. NAME([Tableau_user]) is not a valid function in Tableau. ISFULLNAME([Tableau_user]) = USERNAME() is not a valid expression in Tableau. 'S' + STR([Sales]/1000) is not a boolean expression, but a string expression that converts sales to thousands with a prefix of "S". Reference: https://help.tableau.com/current/pro/desktop/en-us/filtering_datasource.htm https://help.tableau.com/current/pro/desktop/en-us/functions_functions_logical.htm#USERNAME https://help.tableau.com/current/pro/desktop/en-us/calculations_calculatedfields.htm
NEW QUESTION # 19
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 # 20
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 # 21
You have the following bar chart.
You want the chart to appear as shown in the Mowing exhibit.
What should you add?
- A. A reference line
- B. A distribution band
- C. A reference band
- D. An average line
Answer: C
Explanation:
A reference band is a shaded area that shows a range of values on an axis. You can use a reference band to highlight a target range, a confidence interval, or a standard deviation. In this case, you want to add a reference band that shows the range of values from 0 to 100 on the y-axis. This will create a shaded area behind the bars that indicates the percentage of sales.
To add a reference band, you need to do the following steps:
Click on the Analytics tab on the left side of the workbook to open the Analytics pane. You will see a list of analytical objects that you can drag and drop onto your worksheet.
Drag Reference Band from the Analytics pane to Y-Axis on the worksheet. This will add a reference band on the y-axis that shows the average and confidence interval for all values.
Click on the Edit button on the reference band to open the Edit Reference Band dialog box. You will see options to customize your reference band.
Change the Band From value to 0 and the Band To value to 100. This will change the reference band to show the range of values from 0 to 100 on the y-axis.
Click OK to apply the changes. You will see that the reference band now shows a shaded area behind the bars.
NEW QUESTION # 22
You have the Mowing dashboard.
Which two elements are floating? Choose two.
- A. The map
- B. The state filter
- C. The color legend
- D. The Rate of Obesity chart
- E. The little
Answer: A,D
NEW QUESTION # 23
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:
1 - Create a parameter that has list string values of profit and sales. Select Show Parameter
2 - Create a calculated field that uses the following formula:....
3 - Drag the calculated field to Detail on the Marks card and add tRegion to the Columns sheif.
NEW QUESTION # 24
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 # 25
You create a parameter named Choose Region fiat contains values from a field named Region.
You want users to be able to use the Choose Region parameter to interact with a chart by logging between different regions What should you do next?
- A. Set the Choose Region parameter to Single Value (list)
- B. Add the [Region] = [choose Region) formula to the Filters card
- C. Add Region to me Fitters card
- D. Add the Choose Region parameter to the Pages card
Answer: C
NEW QUESTION # 26
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. Dashboard actions
- B. Worksheet actions
- C. A parameter and a calculated filed
- D. Showhide buttons
Answer: A
NEW QUESTION # 27
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 AVG([Pick Measure])
WHEN [Sales] then 1
WHEN [Profit] then 2
END - B. Case [Pick Measure:
WHEN [Sales] then 1
WHEN [Profit] then 2 END - C. Case [Pick Measure]
WHEN 1 then ([Sales])
WHEN 2 then ([Profit]) END - D. Case STFMEPick Measure])
WHEN "Sales" then ([Sales])
WHEN "Profit" then ([Profit]) e::i
Answer: D
Explanation:
https://help.tableau.com/current/pro/desktop/en-us/parameters_swap.htm
NEW QUESTION # 28
You have the following dataset.
Which grouping option should you use m Tableau Prep to group al five names automatically?
- A. Pronunciation
- B. Common Characters
- C. Manual Selection
- D. Spelling
Answer: C
NEW QUESTION # 29
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. Create a calculated field that uses a formula of 'S' * str (Round((sales],2)) + 'k'
- B. Create a calculated field that uses a formula of 'S' + stri < (Sales)/1000)).
- C. Change the default number format of the Sales told
- D. Change the data type of the Sates field to Siring
Answer: D
NEW QUESTION # 30
......
Tableau TDA-C01 exam covers a wide range of topics such as data connections, data preparation, data analysis, and visualization. TDA-C01 exam is designed to test an individual's understanding of Tableau Desktop and Tableau Prep Builder. TDA-C01 exam consists of multiple-choice and multiple-response questions, and it is proctored to ensure that the integrity of the certification is maintained.
100% Free TDA-C01 Daily Practice Exam With 66 Questions: https://examtorrent.actualtests4sure.com/TDA-C01-practice-quiz.html
