This page was exported from Exam for engine [ http://blog.test4engine.com ] Export date:Sun Nov 17 22:18:30 2024 / +0000 GMT ___________________________________________________ Title: Latest Tableau TDA-C01 Free Certification Exam Material with 92 Q&As [Q47-Q66] --------------------------------------------------- Latest Tableau TDA-C01 Free Certification Exam Material with 92 Q&As  UPDATED TDA-C01 Exam Questions Certification Test Engine to PDF Tableau TDA-C01 certification exam tests candidates on various topics, including data visualization, data analysis, and data management. Candidates are required to demonstrate their ability to use Tableau to create dashboards, analyze data, and create insights that can be used for making business decisions. TDA-C01 exam is designed to test candidates' practical skills in using Tableau, and it is structured to ensure that candidates have a good understanding of Tableau's features and functionalities.   Q47. 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. Send us your feedback on itQ48. 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?  South  Cast  Central  West The central region has the smallest distribution of profits because it has the smallest interquartile range (IQR), which is the distance between the first and third quartiles of the box plot. The IQR measures the spread of the middle 50% of the data. The smaller the IQR, the less variation in the data. Reference: https://help.tableau.com/current/pro/desktop/en-us/buildexamples_boxplot.htm https://www.statisticshowto.com/probability-and-statistics/interquartile-range/Q49. 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. Send us your feedback on itQ50. You are subscribed to several views.You need to unsubscribe from the views.What should you use?  The My Content area of Tableau web pages  The Notifications area of Tableau Prep  The Data Source page of Tableau Desktop  The Shared with Me page To unsubscribe from the views, you should use the My Content area of Tableau web pages. This area allows you to manage your subscriptions, as well as your workbooks, views, and data sources. You can select the views you want to unsubscribe from, click Actions, and then click Unsubscribe. You can also change the subscription options, such as the schedule, the format, or the message. Reference:Create a Subscription to a View or Workbook – TableauTableau Certified Data Analyst Study GuideQ51. You have the following dataset.Which grouping option should you use m Tableau Prep to group al five names automatically?  Pronunciation  Spelling  Common Characters  Manual Selection To group all five names automatically, you should use Manual Selection as a grouping option in Tableau Prep. Manual Selection is a feature that allows you to select values from your data and group them together based on your criteria. You can use Manual Selection by clicking on Group Values in Profile pane > Manual Selection from the menu. This will open a dialog box where you can select values from your data and assign them to a group.In this case, you want to group all five names together based on their spelling variations. You can use Manual Selection by selecting all five values from your data and assigning them to a group named “Harry Potter”. This will create a new field named Grouped Field that contains “Harry Potter” as one value.The other options are not correct for this scenario. Pronunciation is a feature that groups values based on how they sound, but it may not work well with names or uncommon words. Spelling is a feature that groups values based on common spelling errors or typos, but it may not recognize all variations or synonyms. Common Characters is a feature that groups values based on the number of characters they share, but it may not capture the meaning or context of the values. Reference: https://help.tableau.com/current/prep/en-us/prep_group.htm https://help.tableau.com/current/prep/en-us/prep_group_manual.htmQ52. You have a dataset that has four fields named Category. Profit Sates and Customer Name. You need to create the following visualization. Q53. 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. Send us your feedback on itQ54. 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?  Add Region to me Fitters card  Add the [Region] = [choose Region) formula to the Filters card  Add the Choose Region parameter to the Pages card  Set the Choose Region parameter to Single Value (list) To use the Choose Region parameter to interact with a chart by toggling between different regions, you should add the [Region] = [Choose Region] formula to the Filters card. This formula will create a boolean filter that returns TRUE if the value in the Region field matches the value in the Choose Region parameter, and FALSE otherwise. You can add this formula to the Filters card by right-clicking on it and selecting Add Filter from the menu. Then you can select Condition from the dialog box and enter the formula in the text box. This will filter the chart to show only the data for the selected region.The other options are not correct for this scenario. Adding Region to the Filters card will create a categorical filter that shows a list of values from the Region field, but it will not use the Choose Region parameter. Adding the Choose Region parameter to the Pages card will create a page control that allows you to cycle through different values of the parameter, but it will not filter the chart. Setting the Choose Region parameter to Single Value (list) will change how the parameter control appears on the worksheet, but it will not affect how it interacts with the chart. Reference: https://help.tableau.com/current/pro/desktop/en-us/parameters.htm https://help.tableau.com/current/pro/desktop/en-us/filtering.htm https://help.tableau.com/current/pro/desktop/en-us/filtering_condition.htmQ55. 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?  General filter  Wildcard filter  Top filter  Condition filter Q56. You have the following datasetYou need to create the following visualization.Which quick table calculation should you drag to Text on the Marks card?  Percent of Total  Percent Difference  Compound Growth Rate  Percentile we need to create a quick table calculation that shows the percent of total sales for each category and sub-category. To do this, we can follow these steps:Drag Category to Columns and Sub-Category to Rows.Drag Sales to Text on the Marks card.Right-click Sales on the Marks card and select Quick Table Calculation > Percent of Total.Right-click Sales on the Marks card again and select Compute Using > Category.This will create a quick table calculation that shows the percent of total sales for each sub-category within each category. The visualization will look like this:Q57. You have the following tiled dashboard that has one sheet.You want to replace fit sheet with Sheet2.What should you do?  Right-click Sheet2 and select Add to Dashboard.  Select Sheets and click the Swap Sheet button next to Sheet2.  From the context menu of Sheet3. select Remove Dashboard item  Drag Sheet2 to the dashboard.  From the context menu of Sheet3. select Deselect 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.htmQ58. 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%. check the steps below in explanationExplanation: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.Q59. 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. check the steps below in explanationExplanation: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.Q60. 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?  Add Region to me Fitters card  Add the [Region] = [choose Region) formula to the Filters card  Add the Choose Region parameter to the Pages card  Set the Choose Region parameter to Single Value (list) Q61. in which three formats can you export a worksheet from the Worksheet menu? Choose three  .pptx  .csv  .xlsx  .png  .txt  .html Q62. 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.  check the steps below in explanation To filter the table to show the Top 10 NOC based on the number of medals won, 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 NOC, discipline, and medals for each country.Drag Medals from the Measures pane to the Filters shelf. This will open a dialog box that allows you to filter by different criteria.Select Top from the dialog box. This will show you options to filter by the top or bottom values of a field.Enter 10 in the text box next to By field. This will filter by the top 10 values of Medals.Select NOC from the drop-down list next to By field. This will filter by the top 10 values of NOC based on Medals.Click OK to apply the filter. You will see that the table now shows only 10 rows, one for each NOC with the highest number of medals.Q63. 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?  Change the data type of the Sates field to Siring  Create a calculated field that uses a formula of ‘S’ * str (Round((sales],2)) + ‘k’  Change the default number format of the Sales told  Create a calculated field that uses a formula of ‘S’ + stri < (Sales)/1000)). 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.htmQ64. A colleague provides you with access to a folder that contains the following files:* Sates.csv* Bookl.twb* Sates.hyper* Export.mdbWhich He contains an extract?  Export mdb  Book1.twb  Sales.hyper  Sales.csv Q65. 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? Q66. 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.  Send us your feedback on it.  Send us your  Loading … Get The Important Preparation Guide With TDA-C01 Dumps: https://www.test4engine.com/TDA-C01_exam-latest-braindumps.html --------------------------------------------------- Images: https://blog.test4engine.com/wp-content/plugins/watu/loading.gif https://blog.test4engine.com/wp-content/plugins/watu/loading.gif --------------------------------------------------- --------------------------------------------------- Post date: 2024-02-06 11:08:45 Post date GMT: 2024-02-06 11:08:45 Post modified date: 2024-02-06 11:08:45 Post modified date GMT: 2024-02-06 11:08:45