Oct-2023 FREE Tableau TDA-C01 PRACTICE QUESTIONS AND ANSWERS UPDATES
DEMO FREE BEFORE YOU BUY TDA-C01 DUMPS
Tableau TDA-C01 exam consists of multiple choice questions that test candidates on their knowledge of Tableau software and data analysis concepts. TDA-C01 exam is timed and candidates have a limited amount of time to answer each question. TDA-C01 exam is scored on a pass/fail basis and candidates who pass the exam are awarded the Tableau Certified Data Analyst certification.
Tableau TDA-C01 certification exam is a vendor-neutral certification that is recognized globally. It is designed to help data analysts and business intelligence professionals demonstrate their proficiency in the use of Tableau Desktop. TDA-C01 exam covers a range of topics, including data preparation, data analysis, visualization, and dashboard development. Tableau Certified Data Analyst certification also includes a practical component that requires candidates to demonstrate their ability to create interactive dashboards and data models using Tableau.
NEW QUESTION # 18
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 # 19
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.
NEW QUESTION # 20
You have a database that includes field named sales, City and Region.
You have the following chart that shows the number of sales made in different cities.
You want to dynamically show the corresponding region when users hover their mouse over any of the bars.
What should you do?
- A. Drag Region to Tooltip on the Marks card
- B. Edit the aliases for City.
- C. Right-click a in the chat, select Annotate and then select Mark.
- D. Right-click a bar in the chart select Mark Label and then select Always show.
Answer: C
NEW QUESTION # 21
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 Attribute
- B. Convert the date to Exact Date
- C. Convert the date to Continuous
- D. Select Show Misting Values for the dale
Answer: C
NEW QUESTION # 22
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: SUM Sales}
- B. {FIXED: [Region] SUM Sales}
- C. {FIXED: TOTAL (Sales)}
- D. {Fixed: [Region]: TOTAL Sales}
Answer: C
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 # 23
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. Export mdb
- C. Book1.twb
- D. Sales.csv
Answer: B
NEW QUESTION # 24
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 Deselect
- B. From the context menu of Profits by Stale deselect Use as Filter
- C. From the context menu of Sales over lime select Remove Dashboard Item
- D. From the context menu of Sales over time select Ignore Actions
Answer: C
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.
- A. Send us your
- B. Send us your feedback on it.
Answer: B
NEW QUESTION # 26
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 # 27
You have the following tiled dashboard that has one sheet.
You want to replace fit sheet with Sheet2.
What should you do?
- A. Select Sheets and click the Swap Sheet button next to Sheet2.
- B. Drag Sheet2 to the dashboard.
- C. From the context menu of Sheet3. select Deselect
- D. From the context menu of Sheet3. select Remove Dashboard item
- E. Right-click Sheet2 and select Add to Dashboard.
Answer: E
NEW QUESTION # 28
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 # 29
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. NAME Tableau-USER-NAME)
- B. USERNAME()=(Tableau_USER_NAME)
- C. ISFULLNAMETableu_USER_NAME))=USERNAME()
- D. NAMEUSERNAME()
Answer: B
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 # 30
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.
Answer:
Explanation:
Send us your feedback on it
NEW QUESTION # 31
From Tableau Desktop you sign in lo a Tableau Server site.
What appears in the list of available data sources when you search for a published data source?
- A. All the data sources published to the site within the folders to which you have access
- B. All the data sources published to the site
- C. All the data sources published to the Tableau Server
- D. All the data sources published to the Tableau Server within the folders to which you have access
Answer: D
NEW QUESTION # 32
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: B
Explanation:
To get the number of different types of awards that have been won, you should use the formula COUNTD({Award}). This formula will return the count of distinct values in the Award field, which are the different types of awards that have been won.
The other options are not correct for this scenario. COVAR({Award}) is not a valid function in Tableau. MAX({Award}) will return the maximum value in the Award field, which may not be a type of award. INDEX() will return the index or rank of each row in a partition, which is not related to the types of awards. Reference: https://help.tableau.com/current/pro/desktop/en-us/functions_functions_aggregate.htm#COUNTD https://help.tableau.com/current/pro/desktop/en-us/functions_functions_tablecalculation.htm#INDEX
NEW QUESTION # 33
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 # 34
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 - Aggregate the date to month and year.
2 - Create a calculated field that uses the MODEL_QUANTILE function.
3 - Add the date to the Columns sfelf. Add the segment and the sales to the Rows shelf.
NEW QUESTION # 35
You have the following visualization.
You Create a table calculation named Rank_Score that has a formula of RANK(AVG([Score]), and you drag Rank_Score to Text on the Marks cards.
What is the Rank Score value for Student ID 4220?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: D
Explanation:
the rank function returns the rank of each row within the partition of a result set. The rank of a row is one plus the number of ranks that come before the row in question.
To answer your question, we need to apply the rank function to the Avg Score column and sort it in descending order. Then we can find the rank score value for Student ID 4220 by looking at the corresponding row.
Here is how the table would look like after applying the rank function and sorting:
As you can see, the rank score value for Student ID 4220 is 1.
NEW QUESTION # 36
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.
NEW QUESTION # 37
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 # 38
......
Latest Tableau TDA-C01 Dumps with Test Engine and PDF: https://www.passexamdumps.com/TDA-C01-valid-exam-dumps.html
Tableau TDA-C01 Exam Dumps Are Essential To Get Good Marks: https://drive.google.com/open?id=1A1g4vqL6YQ7zpboG7_i2FQsTKPWkpA_1
