Latest Success Metrics For Actual TDA-C01 Exam (Updated 100 Questions)
Genuine TDA-C01 Exam Dumps Free Demo Valid QA's
NEW QUESTION # 21
You want to connect a Tableau workbook to a dataset in a Microsoft Excel spreadsheet.
What should you do from Tableau Desktop?
- A. From the File menu select Import Workbook
- B. From the File menu select New
- C. From the Data menu select New Data Source
- D. From the Data menu select Replace Data Source
Answer: C
Explanation:
To connect a Tableau workbook to a dataset in a Microsoft Excel spreadsheet, you need to select New Data Source from the Data menu. This will open the Connect pane, where you can choose Microsoft Excel as your data source and browse for your spreadsheet file. You can then drag and drop your sheets or tables to join or union them in the data source page. References:
https://help.tableau.com/current/pro/desktop/en-us/connect_basic.htm
https://help.tableau.com/current/pro/desktop/en-us/connect_excel.htm
When connecting to a dataset in Tableau Desktop, you would go to the 'Data' menu and select 'New Data Source'. This allows you to connect to various types of data sources, including Microsoft Excel spreadsheets, where you can then select the specific file you wish to connect to.
NEW QUESTION # 22
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.
- A. check the steps below in explanation
Answer: A
Explanation:
To filter the table to show the members of the Top10 set and the Bottom10 set, 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 Disciplines worksheet.
Click on the Disciplines tab at the bottom of the workbook to open the worksheet. You will see a table that shows the disciplines, sales, and profit for each salesperson.
Click on the drop-down arrow next to Salesperson on the Filters shelf. This will open a menu that allows you to filter by different criteria.
Select Set from the menu. This will show you the sets that are available for the Salesperson field. You will see Top10 and Bottom10 as two sets that have been created based on the sales ranking.
Check the boxes next to Top10 and Bottom10. This will filter the table to show only the members of these two sets. You can also click on All to deselect all other values.
Click OK to apply the filter. You will see that the table now shows 20 rows, 10 for each set.
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 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. Annotate March 2020
- D. Drag the growth rate to Text on the Marks card
Answer: B
NEW QUESTION # 25
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. INDEX()
- C. COUNTD {(NAME])
- D. COUNTD({Award})
- E. COVAR({Award})
Answer: C
NEW QUESTION # 26
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. check the steps below in explanation
Answer: A
Explanation:
To modify the bar chart to show the percentage of sales for each Subcategory within every Category, 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 CategoryPercentage worksheet.
Click on the CategoryPercentage tab at the bottom of the workbook to open the worksheet. You will see a bar chart that shows the total sales for each Subcategory across all Categories.
Right-click on Sales on the Columns shelf and select Add Table Calculation from the menu. This will open a dialog box that allows you to apply a calculation to your measure.
Select Percent of Total from the Calculation Type drop-down list. This will calculate the percentage of sales for each Subcategory out of the total sales for all Subcategories.
Select Category from the Compute Using drop-down list. This will calculate the percentage of sales for each Subcategory within every Category, instead of across all Categories. The total percentage for every Category will be 100%.
Click OK to apply the table calculation. You will see that the bar chart now shows the percentage of sales for each Subcategory within every Category.
NEW QUESTION # 27
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.
Answer:
Explanation:
Send us your feedback on it
NEW QUESTION # 28
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 # 29
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. Publish aw dashboard to Tableau Server
- B. Export the dashboard as a .twbx
- C. Publish the dashboard to Tableau Public
- D. Print the dashboard to PDF
Answer: D
NEW QUESTION # 30
You have a data source that contains data tor every city in the Unites States. The following is a sample of the data.
You need to use the City dimension to create a dynamic filter that snows the cities that have a population greater than one million Which type of filter should you use?
- A. Condition filter
- B. Top filter
- C. Wildcard filter
- D. General filter
Answer: A
Explanation:
To use the City dimension to create a dynamic filter that shows the cities that have a population greater than one million, you should use a condition filter. A condition filter is a type of filter that shows only the values that meet a specified condition based on a measure or a calculation. You can create a condition filter by dragging a dimension to the Filters shelf and selecting Condition from the dialog box. Then you can enter a formula or choose an option that defines your condition.
In this case, you want to create a condition filter based on Population, which is a measure. You can drag City to the Filters shelf and select Condition from the dialog box. Then you can choose By field from the tab and select Population > Sum > Greater than > 1000000 from the drop-down lists. This will create a condition filter that shows only the cities that have a sum of population greater than one million.
The other options are not correct for this scenario. A general filter is not a specific type of filter, but a term that refers to any type of filter in Tableau. A wildcard filter is a type of filter that shows only the values that match a specified pattern or string, such as "New*" or "*ton". A top filter is a type of filter that shows only the top or bottom N values of a measure or dimension based on a ranking or an aggregation. Reference: https://help.tableau.com/current/pro/desktop/en-us/filtering.htm https://help.tableau.com/current/pro/desktop/en-us/filtering_condition.htm https://help.tableau.com/current/pro/desktop/en-us/filtering_wildcard.htm https://help.tableau.com/current/pro/desktop/en-us/filtering_topn.htm
NEW QUESTION # 31
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 # 32
You have a Tableau workbook.
You want to make the workbook available in Tableau Online.
What should you do?
- A. From the Server menu, select Publish Workbook.
- B. From the Server menu, select Tableau Public, and then select Save to Tableau Public.
- C. From the Server menu, select Publish Data Source.
- D. From the File menu, select Export Packaged Workbook.
Answer: A
Explanation:
To make a workbook available in Tableau Online, you need to publish it from Tableau Desktop to Tableau Online. You can do this by selecting Publish Workbook from the Server menu, signing in to your Tableau Online account, choosing a project and a name for your workbook, and clicking Publish. This will upload your workbook and its data sources to Tableau Online, where you can view, edit, and share it with others. References:
Tableau Certified Data Analyst Exam Prep Guide, page 10, section "Publishing and Scheduling Data Refreshes" Tableau Help: Publish a Workbook
NEW QUESTION # 33
You want to connect a Tableau workbook to a dataset in a Microsoft Excel spreadsheet.
What should you do from Tableau Desktop?
- A. From the File menu select Import Workbook
- B. From the File menu select New
- C. From the Data menu select New Data Source
- D. From the Data menu select Replace Data Source
Answer: C
Explanation:
To connect a Tableau workbook to a dataset in a Microsoft Excel spreadsheet, you need to select New Data Source from the Data menu. This will open the Connect pane, where you can choose Microsoft Excel as your data source and browse for your spreadsheet file. You can then drag and drop your sheets or tables to join or union them in the data source page. Reference: https://help.tableau.com/current/pro/desktop/en-us/connect_basic.htm https://help.tableau.com/current/pro/desktop/en-us/connect_excel.htm
NEW QUESTION # 34
You have a dashboard than contains two sheets named Sheet 1 and Sheet 2.
You want to add an object to the dashboard that users can click to switch to a different dashboard in the workbook.
Which object should you add to the dashboard?
Answer:
Explanation:
Explanation:
The object that you should add to the dashboard to allow users to switch to a different dashboard in the workbook is Navigation.
Navigation objects are used to create links between dashboards or sheets in a workbook. You can add a navigation object to a dashboard by dragging it from the list of objects and dropping it on the dashboard. You can then configure the navigation object to specify the destination dashboard or sheet that you want users to navigate to when they click on it.
You can learn more about navigation objects and how to use them in this article:
https://help.tableau.com/current/pro/desktop/en-us/dashboards_navigation.htm
NEW QUESTION # 35
You have the following dataset.
You want to create a new calculated dimension field named Category that meets the following conditions:
. When Subject is Computer Science or Science, Category must be Sciences.
. When Subject is English or Social Studies, Category must be Humanities.
Which two logical functions achieve the goal? Choose two.
- A. CASE [Subject]
WHEN 'Computer Science' THEN 'Sciences'
WHEN 'Science' THEN 'Sciences'
WHEN 'English' THEN 'Humanities'
WHEN 'Social Studies' THEN 'Humanities'
End - B. IF ENDSWITH ( [Subject], 'Computer Science') THEN 'Sciences' ELSE 'Humanities' END
- C. IF [Subject]- 'Science' THEN 'Sciences'
ELSEIF [Subject]='English' THEN 'Humanities'
ELSEIF [Subject]-'Social Studies' THEN 'Humanities'
ELSEIF [Subject]= 'Computer Science' THEN 'Sciences'
END - D. IIF(( CONTAINS ([Subject], 'Science') = TRUE) , 'Humanities', 'Sciences')
Answer: A,C
Explanation:
To create a new calculated dimension field named Category that meets the given conditions, you can use either the IF or the CASE logical function. Both functions allow you to evaluate an expression and return a value based on different scenarios. Option A uses the IF function with multiple ELSEIF clauses to check the value of the Subject field and assign it to either 'Sciences' or 'Humanities'. Option D uses the CASE function with multiple WHEN clauses to do the same thing. Both options will produce the same result, but the CASE function is more concise and easier to read. Option B is incorrect because it will assign 'Humanities' to any subject that contains 'Science' in its name, which is not the desired outcome. Option C is incorrect because it will only check if the subject ends with 'Computer Science' and ignore the other subjects. References:
Logical Functions - Tableau
Tableau Certified Data Analyst Study Guide
NEW QUESTION # 36
......
TDA-C01 Practice Test Give You First Time Success with 100% Money Back Guarantee!: https://www.exam4tests.com/TDA-C01-valid-braindumps.html
Printable & Easy to Use Tableau Certified TDA-C01 Dumps 100% Same Q&A In Your Real Exam: https://drive.google.com/open?id=1l3UrcKk7Q4-v65Aj2WNUygivtm4hgmki