Tableau TDA-C01 Online Practice Questions and Exam Preparation

Tableau TDA-C01 Online Questions & Answers

• Question 81:

  HOTSPOT

  You have a dataset that has four fields named Category. Profit Sates and Customer Name. You need to create the following visualization.

  

  

  

  Explanation

  Sales:

  B. Columns Profit:

  D. Rows Customer Name:

  C. Detail on the Marks card Category: A. Color on the Marks card

  To create the visualization, you need to drag Sales to Columns, Profit to Rows, Customer Name to Detail on the Marks card, and Category to Color on the Marks card. This will create a scatter plot that shows the relationship between Sales and Profit for each Customer Name, with different colors for each Category.

  References: https://help.tableau.com/current/pro/desktop/en-us/buildmanual_shelves.htm

  https://help.tableau.com/current/pro/desktop/en-us/buildexamples_scatter.htm

• Question 82:

  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 [Subject]- 'Science' THEN 'Sciences' ELSEIF [Subject]='English' THEN 'Humanities' ELSEIF [Subject]-'Social Studies' THEN 'Humanities' ELSEIF [Subject]= 'Computer Science' THEN 'Sciences' END
  B. IIF(( CONTAINS ([Subject], 'Science') = TRUE) , 'Humanities', 'Sciences')
  C. IF ENDSWITH ( [Subject], 'Computer Science') THEN 'Sciences' ELSE 'Humanities' END
  D. CASE [Subject] WHEN 'Computer Science' THEN 'Sciences' WHEN 'Science' THEN 'Sciences' WHEN 'English' THEN 'Humanities' WHEN 'Social Studies' THEN 'Humanities' End
  A. IF [Subject]- 'Science' THEN 'Sciences' ELSEIF [Subject]='English' THEN 'Humanities' ELSEIF [Subject]-'Social Studies' THEN 'Humanities' ELSEIF [Subject]= 'Computer Science' THEN 'Sciences' END
  D. CASE [Subject] WHEN 'Computer Science' THEN 'Sciences' WHEN 'Science' THEN 'Sciences' WHEN 'English' THEN 'Humanities' WHEN 'Social Studies' THEN 'Humanities' End

  ---

  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

• Question 83:

  HOTSPOT

  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.)

  

  

  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

• Question 84:

  Refer to the exhibit.

  You need the top 10 values to appear in a different color. The lop 10 values must be colored dynamically.

  

  What should you do?

  A. Select the lop 10 bars, create a set. and then drag the set to Color on the Marks card.
  B. Create a group field that groups the top 10 values into one group and the rest of the values into another group. Drag the group field to Color on the Marks card.
  C. Select the top 10 bars, and then change the color by selecting Color on the Marks card.
  D. Create a set that has a top 10 condition, and then drag the set to Color on the Marks card.
  D. Create a set that has a top 10 condition, and then drag the set to Color on the Marks card.

  ---

  Explanation

• Question 85:

  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 Data Source page of Tableau Desktop
  B. The Notification area of Tableau Prep
  C. The My Content area of Tableau web pages
  D. The Shared with Ma page
  C. The My Content area of Tableau web pages

  ---

  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.

  References: https://help.tableau.com/current/pro/desktop/en-us/alerts.htm https://help.tableau.com/current/pro/desktop/en-us/alerts_manage.htm

  In Tableau, the "My Content" area on the web interface is the place where a user can manage their content, including workbooks, data sources, and alerts. If an alert is suspended, the owner of the alert can go to the "My Content" area to resume it.

• Question 86:

  HOTSPOT

  You have the following visualization.

  

  

  

  Explanation

• Question 87:

  You have a Tableau workbook that contain three worksheets named Sheet1 Sheet2 and Sheet3. You create several filters.

  From the Data Source page you plan to add data source fillers When type of filter will appear in the Edit Data Source Filters dialog box?

  A. A table calculation filter used on Sheet
  B. A top N condition filer on a dimension in Sheet 1 and Sheet2
  C. A context filler on a dimension m Sheet3
  D. A dimension Maw on all the sheets
  D. A dimension Maw on all the sheets

  ---

  Explanation

  A data source filter is a filter that applies to all the worksheets that use the same data source. It filters the data before any other filters or calculations are applied. You can add a data source filter from the Data Source page by clicking on the Add button next to Filters.

  The type of filter that will appear in the Edit Data Source Filters dialog box is a dimension filter on all the sheets. This means that you can choose a dimension from your data source and filter it by values, range, condition, or top/bottom. The filter will affect all the worksheets that use that dimension.

  The other types of filters are not data source filters and will not appear in the Edit Data Source Filters dialog box. A table calculation filter is a filter that applies to a table calculation, such as percent of total or running total. A top N condition filter is a filter that shows only the top or bottom N values of a measure or dimension based on a condition. A context filter is a filter that creates a subset of data that other filters can use.

  References: https://help.tableau.com/current/pro/desktop/en-us/filtering_datasource.htm https://help.tableau.com/current/pro/desktop/en-us/filtering.htm https://help.tableau.com/current/pro/desktop/en-us/filtering_tablecalculations.htm https://help.tableau.com/current/pro/desktop/en-us/filtering_topn.htm https://help.tableau.com/current/pro/desktop/en-us/filtering_context.htm

  Data source filters in Tableau apply to the entire data source, affecting all sheets that use that data source. The Edit Data Source Filters dialog box allows you to add filters that operate at the data source level, which is different from context filters, top N filters, or table calculation filters that are applied at the worksheet level.

• Question 88:

  You are subscribed to several views.

  You need to unsubscribe from the views. What should you use?

  A. The My Content area of Tableau web pages
  B. The Notifications area of Tableau Prep
  C. The Data Source page of Tableau Desktop
  D. The Shared with Me page
  A. The My Content area of Tableau web pages

  ---

  Explanation

  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.

  References: Create a Subscription to a View or Workbook - Tableau Tableau Certified Data Analyst Study Guide

• Question 89:

  You have the following tiled dashboard that has one sheet.

  

  You want to replace fit sheet with Sheet2. What should you do?

  A. Right-click Sheet2 and select Add to Dashboard.
  B. Select Sheets and click the Swap Sheet button next to Sheet2.
  C. From the context menu of Sheet3. select Remove Dashboard item
  D. Drag Sheet2 to the dashboard.
  E. From the context menu of Sheet3. select Deselect
  D. Drag Sheet2 to the dashboard.

  ---

  Explanation

  In Tableau, to replace a sheet on a dashboard, you can simply drag the desired sheet (Sheet2 in this case) from the sheets list onto the dashboard area where the current sheet (Sheet3) resides. This action will replace the existing sheet with the new one. Right-clicking and adding to the dashboard adds an additional sheet rather than replacing, and the context menu options mentioned in the other choices are not the standard methods for replacing sheets within a dashboard.

• Question 90:

  HOTSPOT

  You have a data source that contains the following columns.

  

  You have the following view that shows the percentage of total sales by category:

  

  You want to change the calculation to show the percentage of total sales within the categories of every region annually. Which Compute Using option should you use? (Click the appropriate Option in the Answer Area.)

  

  

  Explanation