Updated Apr 30, 2024 TDA-C01 Exam Dumps - PDF Questions and Testing Engine
New (2024) Tableau TDA-C01 Exam Dumps
NEW QUESTION # 42
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. Central
- B. Cast
- C. West
- D. South
Answer: D
NEW QUESTION # 43
You receive a tab-delimited data file name sales.tsv.
You need to connect to the file.
Which option should you select in Tableau Desktop?
Answer:
Explanation:
NEW QUESTION # 44
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. Add a tooltip
- B. Enable captions
- C. Annotate March 2020
- D. Drag the growth rate to Text on the Marks card
Answer: A
NEW QUESTION # 45
You have the Mowing dashboard.
Which two elements are floating? Choose two.
- A. The state filter
- B. The Rate of Obesity chart
- C. The color legend
- D. The little
- E. The map
Answer: B,C
Explanation:
To identify which elements are floating on a dashboard, you can look for a gray border around them when you select them. Alternatively, you can open the Layout pane and see which elements have a pin icon next to them. The pin icon indicates that the element is floating and can be moved freely on the dashboard. Based on these criteria, the state filter and the color legend are floating elements on the dashboard. 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_create_layouts.htm
NEW QUESTION # 46
You have a dashboard that is configured for desktop browsers.
You want to customize a layout for mobile users.
Which option should you select first? (Click the appropriate Option in the Answer Area.)
Answer:
Explanation:
Explanation:
To customize a layout for mobile users, you should select the Device Preview option first. This option will allow you to see how your dashboard will look on different types of devices, such as phones, tablets, or desktops. You can also choose different models and orientations to preview different screen sizes and resolutions. From the Device Preview mode, you can add, edit, or delete device layouts for each device type.
You can also adjust the size, position, and formatting of the dashboard elements for each device layout. References:
Create Dashboard Layouts for Different Device Types - Tableau
Tableau Certified Data Analyst Study Guide
NEW QUESTION # 47
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%.
Answer:
Explanation:
check the steps below in explanation
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 # 48
You have the following dataset
You need to create the following visualization.
Which quick table calculation should you drag to Text on the Marks card?
- A. Compound Growth Rate
- B. Percent of Total
- C. Percentile
- D. Percent Difference
Answer: B
Explanation:
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:
NEW QUESTION # 49
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:
Explanation:
The correct order of the three actions is:
Add the date to the Columns shelf. Add the segment and the sales to the Rows shelf.
Aggregate the date to month and year.
From the Analytics pane, drag Forecast to the worksheet.
The first action is to add the date to the Columns shelf and the segment and the sales to the Rows shelf. This will create a line chart that shows the daily sales by segment over time. You can use the Show Me menu to choose a line chart if it is not selected by default.
The second action is to aggregate the date to month and year. This will group the daily sales into monthly sales and show the yearly trend. You can right-click on the date field on the Columns shelf and select Month (January 2017) from the menu. You can also drag Year from the Dimensions pane to the Columns shelf before or after Month.
The third action is to drag Forecast from the Analytics pane to the worksheet. This will add a forecast that predicts future sales by segment based on historical trends. You can customize the forecast by clicking on it and using the options on the Marks card.
The other options are not relevant for this scenario. Adding a trend line would show a linear or nonlinear relationship between two measures, but not a prediction of future values. Creating a calculated field that uses the model quantile function would return a value from a statistical model based on a given quantile, but not a forecast.
References: https://help.tableau.com/current/pro/desktop/en-us/analytics.htm
https://help.tableau.com/current/pro/desktop/en-us/buildmanual_shelves.htm
https://help.tableau.com/current/pro/desktop/en-us/dates.htm
https://help.tableau.com/current/pro/desktop/en-us/analytics_forecast.htm
https://help.tableau.com/current/pro/desktop/en-us/functions_functions_statistical.htm#MODEL_QUANTILE
NEW QUESTION # 50
You have the following dataset.
Which grouping option should you use m Tableau Prep to group al five names automatically?
- A. Pronunciation
- B. Manual Selection
- C. Spelling
- D. Common Characters
Answer: B
NEW QUESTION # 51
You connect to a database server by using Tableau Prep. The database server has a data role named Role1.
You have the following field in the data.
You need to apply the Role1 data role to the Material field.
Which two actions should you perform? Choose two.
- A. From the More actions menu of Materials, select Valid in the Show values section.
- B. For the data type of the Material field, select Custom, and then select Role1.
- C. From the More actions menu of Materials, select Group Values, and then select Spelling.
- D. From the More actions menu of Materials, filter the selected values.
Answer: B,C
Explanation:
To apply a custom data role to a field, you need to select the data type of the field and then choose the data role from the list of available roles. This will validate the values in the field against the data role and mark any invalid values with a red exclamation mark. To fix the invalid values, you can use the Group Values option and select the Spelling algorithm, which will group values that are close in spelling and replace them with the most frequent value in the group. This will help you standardize the values in the Material field and match them with the Role1 data role. References: The information is based on the following sources:
Use Data Roles to Validate your Data - Tableau
New in Tableau Prep: Automatically identify data quality issues with Data Roles
NEW QUESTION # 52
You have the following:
Overall Rank and Rank are calculated fields that use the RANK function.
You filter out the sub-category where [Ovorall Rank] - 1.
For which three the sub-categories will the value of Rank change? Choose three.
- A. Machines
G Phones - B. Copiers
- C. Chairs
- D. Accessories
- E. Furnishings
- F. Bookcases
- G. Tables
Answer: A,D,G
Explanation:
In Tableau, the RANK function assigns a rank to each row within a partition of the data, based on the value of the field being ranked. It is important to understand that the rank is recalculated whenever the underlying data or the partitioning changes.
In the given scenario, the Overall Rank is based on the Sales figures, while the Rank (presumably) is based on the Sales within the Category. When filtering on the condition where [Overall Rank] - 1, it means we are excluding the sub-category that has an Overall Rank of 2.
Looking at the data:
Furnishings has an Overall Rank of 8, which does not meet the filter condition ([Overall Rank] - 1).
Therefore, its rank remains the same.
Tables have an Overall Rank of 3. When the sub-category with an Overall Rank of 2 is removed (Chairs in this case), Tables move up in the overall ranking. However, since Tables are the top-ranked within the Furniture category, their Rank within the category would remain unchanged at 1.
Chairs have an Overall Rank of 2, which meets the filter condition and thus will be removed from the view. We cannot determine the change in Rank for Chairs because they are filtered out.
Accessories have an Overall Rank of 5. If any sub-category with a higher Overall Rank (1 to 4) is removed, the rank of Accessories within the Technology category could change because it is currently ranked 3 in its category. With the removal of Phones (Overall Rank 1), the Rank of Accessories could potentially increase.
Copiers have an Overall Rank of 6, which does not meet the filter condition. Therefore, its rank remains the same.
Machines have an Overall Rank of 4. If we remove Phones (Overall Rank 1), Machines will move up in the overall ranking and potentially within the Technology category as well, changing its Rank from 2 to
1.
Phones have an Overall Rank of 1, which does not meet the filter condition of being Overall Rank 2.
Therefore, its rank remains the same.
Bookcases have an Overall Rank of 7, which does not meet the filter condition. Therefore, its rank remains the same.
Based on this analysis, when the sub-category with an Overall Rank of 2 (Chairs) is removed, the Rank value will change for Tables, Accessories, and Machines, as they will move up in the overall ranking within their respective categories. However, it's important to note that while Tables will move up in the overall ranking, their rank within the Furniture category would not change as they are already at the top. The rank changes for Accessories and Machines are due to the removal of Phones, which is ranked higher overall and within the Technology category.
NEW QUESTION # 53
You have the following tiled dashboard that has one sheet.
You want to replace fit sheet with Sheet2.
What should you do?
- A. Drag Sheet2 to the dashboard.
- B. From the context menu of Sheet3. select Deselect
- C. From the context menu of Sheet3. select Remove Dashboard item
- D. Select Sheets and click the Swap Sheet button next to Sheet2.
- E. Right-click Sheet2 and select Add to Dashboard.
Answer: E
NEW QUESTION # 54
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:
Send us your feedback on it
NEW QUESTION # 55
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.
- A. check the steps below in explanation
Answer: A
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 # 56
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. Customers of 2020
- C. Top N Customers
- 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. References:
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 In Tableau, sets can be combined if they are created from the same dimension. From the options provided,
"Customers of 2020" and "Top N Customers" are likely created from the same dimension (Customers).
Therefore, these two sets can be combined to create a new set that includes or excludes members based on the combined criteria. Combining sets like "Top N Products" with "Customers of 2020" would not be feasible unless they are from the same dimension, which is typically not the case.
NEW QUESTION # 57
You are the owner of an alert.
You receive an email notification that the alert was suspended
From where can you resume the suspended alert?
- A. The My Content area of Tableau web pages
- B. The Shared with Ma page
- C. The Data Source page of Tableau Desktop
- D. The Notification area of Tableau Prep
Answer: A
Explanation:
To resume a suspended alert, you need to go to the My Content area of Tableau web pages, where you can see all the alerts that you own or subscribe to. You can click on the alert name and then select Resume from the menu. You can also edit or delete the alert from there. Reference: https://help.tableau.com/current/pro/desktop/en-us/alerts.htm https://help.tableau.com/current/pro/desktop/en-us/alerts_manage.htm
NEW QUESTION # 58
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. INDEX()
- B. COUNTD({Award})
- C. MAX {(Award})
- D. COUNTD {(NAME])
- E. COVAR({Award})
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 # 59
You create the following story that contains two story point.
You want to change the story point format to show the current story point number out of the total number of story points.
Which Layout option should you use?
- A. Numbers
- B. Dots
- C. Arrows only
- D. Caption boxes
Answer: A
Explanation:
To change the story point format to show the current story point number out of the total number of story points, you should use the Numbers option in the Layout tab. This option will display the story points as numbers in a horizontal or vertical sequence, such as 1/2, 2/2. You can also choose to show or hide the next and previous arrows for navigation. The Numbers option will help you indicate the progress and order of your story points more clearly than the other options. Reference:
Creating a Story - Tableau
New in 9.0: Formatting the Story Points Navigator - Tableau
Tableau Certified Data Analyst Study Guide
NEW QUESTION # 60
You have the following dataset that contain null values in the Profits field.
You want the data to appear as shown in the following table.
Which two formulas achieve the goal? Choose two.
- A. 2N ([Profits])
- B. IFNULL [(profits] ,0)
- C. ISNULL ([Profits])
- D. IF [Profits] != null then [Profits] END
Answer: A,B
NEW QUESTION # 61
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. IF ENDSWITH ( [Subject], 'Computer Science') THEN 'Sciences' ELSE 'Humanities' END
- B. CASE [Subject]
WHEN 'Computer Science' THEN 'Sciences'
WHEN 'Science' THEN 'Sciences'
WHEN 'English' THEN 'Humanities'
WHEN 'Social Studies' THEN '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: B,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 # 62
You have the following Map.
You need the map to appear as shown in the following visualization.
What should you do?
- A. Drag Population to Size on the Marks card.
- B. Change the opacity to 75%.
- C. Change the mark type to Map.
- D. Drag Location to Size on the Marks card.
- E. Change the mark type to Density.
Answer: E
Explanation:
To create a map visualization that shows the concentration of data points in different locations, you need to change the mark type to Density. This will create a heatmap that uses color and size to indicate the density of the data points. You can also adjust the intensity and transparency of the density marks to suit your needs. Reference: The information is based on the following sources:
Create Heatmaps that Show Trends or Density in Tableau
Build a Simple Map - Tableau
NEW QUESTION # 63
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 File menu, select Export Packaged Workbook.
- C. From the Server menu, select Publish Data Source.
- D. From the Server menu, select Tableau Public, and then select Save to Tableau Public.
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 # 64
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. Right-click a bar in the chart select Mark Label and then select Always show.
- B. Edit the aliases for City.
- C. Right-click a in the chat, select Annotate and then select Mark.
- D. Drag Region to Tooltip on the Marks card
Answer: D
Explanation:
To show the corresponding region when users hover their mouse over any of the bars, you need to drag Region to Tooltip on the Marks card. This will add Region as a field in the tooltip text that appears when users hover over a mark. You can also customize the tooltip text by editing it in the Tooltip dialog box. Reference: https://help.tableau.com/current/pro/desktop/en-us/buildmanual_shelves.htm https://help.tableau.com/current/pro/desktop/en-us/formatting_tooltips.htm
NEW QUESTION # 65
......
Updated Verified Pass TDA-C01 Exam - Real Questions and Answers: https://www.examcollectionpass.com/Tableau/TDA-C01-practice-exam-dumps.html
Best Way To Study For Tableau TDA-C01 Exam Brilliant TDA-C01 Exam Questions PDF: https://drive.google.com/open?id=102AZArd0LK4kpTalU9oGBWE7mM54kt2R