Tableau TDA-C01 Online Practice Questions and Exam Preparation

Tableau TDA-C01 Online Questions & Answers

• Question 71:

  You have the following dataset.

  

  Which grouping option should you use m Tableau Prep to group al five names automatically?

  A. Pronunciation
  B. Spelling
  C. Common Characters
  D. Manual Selection
  B. Spelling

  ---

  Explanation

  Tableau Prep's Grouping feature includes various methods to group similar data. The Spelling option is used when the data has small variations in spelling, such as capitalization differences or common typos. Given that the names in the dataset vary in capitalization and punctuation but are spelled correctly, the Spelling grouping option would be the most appropriate choice to automatically group all five names.

• Question 72:

  You plan to create a visualization that has a dual axis chart. The dual axis chart will contain a shape chart and a line chart will use the same measure named Population on the axis.

  You need to configure be shapes to be much larger than the line.

  What should you do?

  A. Duplicate Population Drag the duplicate to the second Marks card and configure the see of the marks independently
  B. Create a custom shape that is larger than the default shape and add the shape to the Shapes folder in My Repository
  C. For the second axis select Shape on the Marks card From Select Shape Palette select Custom and then select Reset
  D. Change Population to a discrete dimension
  A. Duplicate Population Drag the duplicate to the second Marks card and configure the see of the marks independently

  ---

  Explanation

  To configure the shapes to be much larger than the line, you need to duplicate Population and drag it to the second Marks card. This will create a dual axis chart with two measures on one axis. You can then select Shape on one Marks card and Line on another Marks card, and adjust the size of each mark independently using the Size slider or menu.

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

  In a dual-axis chart in Tableau, if you want to have two different visual mark types (like a shape and a line) and configure them differently (such as making one larger than the other), you would need to duplicate the measure. You then drag this duplicate to the second Marks card (which represents the second axis). There, you can adjust the size of the marks (shapes, in this case) independently of the line marks on the first Marks card.

• Question 73:

  In which throe formats can you export a worksheet from the Worksheet menu? Choose three

  A. .png
  B. .html
  C. .xlsx
  D. .txt
  E. .pptx
  F. .csv
  B. .html
  D. .txt
  F. .csv

  ---

  Explanation

• Question 74:

  You have the following primary data source that contains a dimension named Dorm_Code.

  

  You receive the following secondary data source that contains updated dorm codes.

  

  You need to bring the updated dorm codes into Tableau and use the codes in existing visualizations. The new dorm codes must use the existing field name of Dorm_Code.

  What should you do?

  A. Bring in the secondary data source as a union.
  B. Bring in the secondary table as a left join to the primary data source. From the Data Source page, select Create Calculated Field in the Dorm_Name field and enter [Dcrm_Name_New] in the calculation window
  C. Bring in the secondary data source by using relationships. From the Data pane, right- click Dorm_Name select Replace References, and then select Dorm_Name_New
  D. Create a data blend and select Edit Primary Aliases to replace the primary data source alias values with values from the secondary data source
  C. Bring in the secondary data source by using relationships. From the Data pane, right- click Dorm_Name select Replace References, and then select Dorm_Name_New

  ---

  Explanation

  Using relationships: You can use relationships to link the secondary data source with the primary data source based on a common field. This will allow you to use fields from both data sources in your visualization without creating new fields or duplicating data. You can then replace references to update the dimension values. For example, you can use relationships to link the updated dorm codes with the primary data source and then replace Dorm_Code with Dorm_Code_New in your visualization. https://community.tableau.com/s/question/0D54T00000C5ldZSAR/update-data-view- based-on-dimension To update existing visualizations with new codes without changing the field name, using relationships to bring in the secondary data source is appropriate. Then using Replace References allows you to update the references from the old dorm codes to the new ones while maintaining the existing field name.

• Question 75:

  CORRECT TEXT

  Open the link to Book1 found on the desktop. Open the Movie Durations worksheet.

  Replace the existing data source with the Netflix_2019 data source.

  

  A. Check the steps below in explanation.
  B. PlaceHoder
  A. Check the steps below in explanation.

  ---

  Explanation

  To replace the existing data source with the Netflix_2019 data source, 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 Movie Durations worksheet.

  Click on the Movie Durations tab at the bottom of the workbook to open the worksheet. You will see a bar chart that shows the number of movies by duration for the existing data source.

  Go to the Data Source tab at the bottom of the workbook to see the data source page. You will see a table that shows the fields and values from the existing data source.

  Click on the drop-down arrow next to the data source name at the top of the page and select Replace Data Source from the menu. This will open a dialog box that allows you to replace your data source with another one.

  Select Netflix_2019 from the list of available data sources and click OK. This will replace your existing data source with the Netflix_2019 data source and update your worksheet accordingly. You may need to fix any broken fields or

  calculations that result from the replacement.

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

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

• Question 76:

  HOTSPOT

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

  

  

  Explanation

• Question 77:

  HOTSPOT

  You have a Tableau Prep flow that joins a dataset named Global Indicators to a dataset named Price Indices.

  In which step can you transform rows of monthly data into rows of yearly data''

  

  

  Explanation

• Question 78:

  You subscribe to a view that delivers a daily email to your inbox. You want to make the subscription available to other stakeholders. What should you do?

  A. From the worksheet, modify the subscription.
  B. From the My Content overview page, modify the subscription.
  C. From the dashboard overview page, modify the subscription.
  D. From the My Content overview page, modify the alert.
  B. From the My Content overview page, modify the subscription.

  ---

  Explanation

• Question 79:

  DRAG DROP

  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)

  Select and Place:

  

  

  Explanation

• Question 80:

  You publish a dashboard tut uses an attract. The extract refreshes every Monday at 10:00.

  You need to ensure that the extract also refreshes on the last day of the month at 18:00.

  What should you do?

  A. From Tableau Desktop, open the Publish Workbook dialog box and configure the schedule.
  B. From Tableau Server select the workbook select Refresh Extracts and then add a new extract refresh
  C. From Tableau Server. select Schedules find the schedule of the extract, and change the frequency to the Last day of the month
  D. From Tableau Server. select Schedules and change the priority of the existing schedule
  C. From Tableau Server. select Schedules find the schedule of the extract, and change the frequency to the Last day of the month

  ---

  Explanation

  To ensure that the extract also refreshes on the last day of the month at 18:00, you need to add a new extract refresh task to the workbook on Tableau Server. You can do this by selecting the workbook, selecting Refresh Extracts, and then

  choosing Schedule a Refresh. You can then select an existing schedule that matches your desired frequency and time, or create a new schedule with a custom frequency and time. This will add a new extract refresh task to the workbook, in

  addition to the existing one that refreshes every Monday at 10:00. You can also modify or delete the extract refresh tasks as needed.

  References:

  Tableau Certified Data Analyst Exam Prep Guide, page 10, section "Publishing and Scheduling Data Refreshes"

  Tableau Help: Refresh Data on a Schedule

  Tableau Help: Manage Refresh Tasks