Question 1

You have the following tiled dashboard that has one sheet. https://kxbjsyuhceggsyvxdkof.supabase.co/storage/v1/object/public/file-images/Tableau_TDA-C01/page_7_img_1.jpg You want to replace fit sheet with Sheet2. What should you do?

Accepted Answer

B

Explanation: 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/enus/dashboards_organize_floating_layoutcontainers.htm https://help.tableau.com/current/pro/desktop/en-us/dashboards_replace_datasource.htm

Question 2

You have the following chart that shows profits and discounts over time. https://kxbjsyuhceggsyvxdkof.supabase.co/storage/v1/object/public/file-images/Tableau_TDA-C01/page_50_img_1.jpg You need to combine the lines to appear as shown in the following chart. https://kxbjsyuhceggsyvxdkof.supabase.co/storage/v1/object/public/file-images/Tableau_TDA-C01/page_50_img_2.jpg What should you do?

Accepted Answer

C

Explanation: To combine the lines to appear as shown in the second chart, you should set Discount to Dual Axis. Dual Axis is a feature that allows you to show two measures on two separate axes on one chart. You can create a dual axis by right-clicking on a measure on any shelf and selecting Dual Axis from the menu. This will create two axes on one chart and synchronize their scales. In this case, you want to show Profit and Discount on two separate axes on one chart. You can right- click on Discount on any shelf and select Dual Axis from the menu. This will create a dual axis chart that shows Profit and Discount as two lines with different colors. The other options are not correct for this scenario. Dragging Discount to Color on the Marks card will change the color of Profit based on Discount, but it will not show two lines. Converting Discount to Discrete will change Discount from a green pill to a blue pill, but it will not affect how it appears on the chart. Dragging Discount to Columns shelf will create two separate charts for Profit and Discount, but it will not combine them. Reference: https://help.tableau.com/current/pro/desktop/enus/multiplemeasures.htm https://help.tableau.com/current/pro/desktop/en- us/multiplemeasures_dualaxes.htm

Question 3

You have the following dashboard that contains two visualizations. https://kxbjsyuhceggsyvxdkof.supabase.co/storage/v1/object/public/file-images/Tableau_TDA-C01/page_5_img_1.jpg You want to show only visualization at time. Users must be able to switch between visualizations. What should you me?

Accepted Answer

A

Explanation: Showhide buttons are a feature that allows you to show or hide a layout container on a dashboard. You can use showhide buttons to create a toggle effect that switches between two visualizations. You need to place each visualization in a separate layout container and then add a showhide button for each container. You can customize the appearance and behavior of the buttons to suit your needs. Reference: https://help.tableau.com/current/pro/desktop/enus/dashboards_organize_floating_layoutcontainers.htm https://help.tableau.com/current/pro/desktop/en-us/dashboards_showhide.htm

Question 4

You have two tables named Employeelnfo and DepartmentInfo. Employeelnfo contains four fields
named Full Name, Department ID, Start Date, and Salary.
DepartmentInfo contains four fields named Department Name, Size, Department ID, and VP.
You want to combine the tables to meet the following requirements:
. Each record in Employeelnfo must be retained in the combined table.
. The records must contain the Department Name, Size, and VP fields.
· Every record must have a full name.
Which type of join should you use?

Accepted Answer

B

Explanation: To combine the tables and meet the requirements, you should use a left join. A left join will keep all the records from the left table (Employeelnfo) and match them with the records from the right table (DepartmentInfo) based on the common field (Department ID). If there is no matching record in the right table, the fields from the right table will be null. This way, you will retain all the records from Employeelnfo, and also include the Department Name, Size, and VP fields from DepartmentInfo. Every record will have a full name because it is a field from the left table. A left join will look like this: Reference: Join Your Data - Tableau Join Types in Tableau

Question 5

You want to create the following dashboard. https://kxbjsyuhceggsyvxdkof.supabase.co/storage/v1/object/public/file-images/Tableau_TDA-C01/page_68_img_1.jpg The dashboard will contain two sheets that will connect to the same data source. The top sheet will be configured to filter the bottom sheet. When you click a category on the top sheet, the sheets must resize as shown in the following exhibit. https://kxbjsyuhceggsyvxdkof.supabase.co/storage/v1/object/public/file-images/Tableau_TDA-C01/page_69_img_1.jpg How should you lay out the objects on the dashboard?

Accepted Answer

D

Explanation: To create the dashboard as shown in the image, you need to use a vertical layout container that will adjust the height of the sheets according to the window size. You also need to set the Fit to Entire view option for both sheets so that they will resize proportionally when you click a category on the top sheet. This way, you can achieve the desired effect of having the bottom sheet expand to fill the space left by the top sheet when it filters out some categories. Reference: Size and Lay Out Your Dashboard - Tableau Create a Dashboard - Tableau Format Dashboard Layout in Tableau - GeeksforGeeks

Question 6

You have a data source that contains data tor every city in the Unites States. The following is a
sample of the data.
TDA-C01 practice exam questions

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?

Accepted Answer

D

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

Question 7

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?

Accepted Answer

A

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. Reference: 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

Question 8

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? https://kxbjsyuhceggsyvxdkof.supabase.co/storage/v1/object/public/file-images/Tableau_TDA-C01/page_15_img_1.jpg

Accepted Answer

C

Explanation: To add a comment to March 2020 on a line chart, you need to annotate that mark. You can right-click on the mark and select Annotate > Mark from the menu. This will open a dialog box where you can type your comment and format it as you like. You can also drag and drop the annotation to position it on the worksheet. Dragging the growth rate to Text on the Marks card will add a label to every mark on the line chart, enabling captions will show a description of the worksheet at the bottom, and adding a tooltip will show a text box when users hover over a mark. Reference: https://help.tableau.com/current/pro/desktop/en-us/formatting_annotations.htm https://help.tableau.com/current/pro/desktop/en-us/formatting_annotations_create.htm

Question 9

You have a data source that has two tables named Table1 and Table2. Table1 is the primary table and
Table2 is the secondary table.
You want to combine the tables by using Tableau Prep. The combined table must include only values
from Table1 that do NOT match any values in Table2. The field values from Table2 must appear as null
values.
Which type of join should you use?

Accepted Answer

A

Explanation: To combine the tables by using Tableau Prep and include only values from Table1 that do not match any values in Table2, you should use a left only join. A left only join is a type of join that returns only the rows from the primary table (Table1) that have no matching rows in the secondary table (Table2). The field values from Table2 will appear as null values in the combined table. A left only join is also known as an anti-join or an exclusion join. Reference: Tableau Certified Data Analyst Exam Prep Guide, page 9, section “Preparing Data” Tableau Help: Join Your Data Tableau Help: Left Only Join

Question 10

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. https://kxbjsyuhceggsyvxdkof.supabase.co/storage/v1/object/public/file-images/Tableau_TDA-C01/page_24_img_1.jpg

Accepted Answer

Explanation: . Explanation: To create a histogram on the Quantity field by using bin size of 3, 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 Histogram tab at the bottom of the workbook to open the Histogram worksheet. You will see a blank worksheet with no marks. Right-click on Quantity in the Measures pane and select Create Bins from the menu. This will open a dialog box that allows you to create bins for the Quantity field. Bins are groups of values that are treated as one unit in a histogram. Enter 3 in the Size of bins text box. This will set the bin size to 3, which means that each bin will contain values that are 3 units apart. For example, one bin will contain values from 0 to 2, another bin will contain values from 3 to 5, and so on. Click OK to create the bins. You will see a new field named Quantity (bin) in the Measures pane with a # sign next to it. Drag Quantity (bin) from the Measures pane to Columns on the worksheet. This will create a histogram that shows the distribution of Quantity by bins. You will see bars that represent the frequency or count of values in each bin. Optionally, you can adjust the width, color, and labels of the bars by using the options on the Marks card. You can also add filters, tooltips, or annotations to enhance your histogram. Reference: https://help.tableau.com/current/pro/desktop/en-us/histograms.htm https://help.tableau.com/current/pro/desktop/en-us/calculations_bins.htm https://help.tableau.com/current/pro/desktop/en-us/buildmanual_histograms.htm

Question 11

HOTSPOT You have a blank dashboard. You want to add two sheets to the dashboard. The sheets must support the Show/Hide button. To which two objects can you add the sheets? (Click the two appropriate Options in the Answer Area.) https://kxbjsyuhceggsyvxdkof.supabase.co/storage/v1/object/public/file-images/Tableau_TDA-C01/page_72_img_1.jpg

Accepted Answer

Explanation: https://kxbjsyuhceggsyvxdkof.supabase.co/storage/v1/object/public/file-images/Tableau_TDA-C01/page_72_img_2.jpg To add two sheets to the dashboard that support the Show/Hide button, you can add them to either a horizontal or a vertical container. A container is an object that can hold one or more sheets or other objects and allow you to arrange them in a layout. A Show/Hide button is a feature that lets you hide or show a container and its contents on the dashboard. You can add a Show/Hide button to any container, whether it is tiled or floating, by using the drop-down menu of the container and selecting “Add Show/Hide Button.” You can also customize the appearance and behavior of the button. To add a horizontal or a vertical container to the dashboard, you can drag them from the Objects pane to the dashboard. A horizontal container will arrange the sheets or objects horizontally, while a vertical container will arrange them vertically. You can then drag the sheets you want to add from the Sheets pane to the container. You can resize and reorder the sheets or objects within the container by using the handles and arrows. The other objects in the Answer Area, such as text, image, web page, blank, navigation, download, and extension, do not support the Show/Hide button. They are either static elements that cannot hold other objects, or dynamic elements that require user interaction or external sources. You can add them to the dashboard as well, but they will not have the same functionality as a container with a Show/Hide button. Reference: Add Show/Hide Buttons - Tableau Layout Containers - Tableau

Question 12

HOTSPOT You have the following visualization. https://kxbjsyuhceggsyvxdkof.supabase.co/storage/v1/object/public/file-images/Tableau_TDA-C01/page_61_img_1.jpg You want the count of Returns displayed only for the first year in the table. How should you complete the formula in the calculated field? (Use the dropdowns in the Answer Area to select the correct options to complete the formula.) https://kxbjsyuhceggsyvxdkof.supabase.co/storage/v1/object/public/file-images/Tableau_TDA-C01/page_61_img_2.jpg

Accepted Answer

Explanation: we need to create a calculated field that displays the count of returns only for the first year in the table. To do this, we can use the following formula: IF FIRST () = 0 THEN COUNT (Returns) END This formula uses the FIRST () function, which returns the number of rows from the current row to the first row in the partition. If the current row is the first row, then FIRST () returns 0. The IF statement checks if this condition is true, and if so, it returns the count of returns for that row. Otherwise, it returns NULL. To complete the formula in the calculated field, you should select the following options from the drop-down menus: FIRST () 0 COUNT (Returns) https://help.tableau.com/current/pro/desktop/en-us/functions_functions_date.htm

Question 13

HOTSPOT You have a data set that contains three columns named Sales, Profit, and Quantity. You need to build the following scatter plot. https://kxbjsyuhceggsyvxdkof.supabase.co/storage/v1/object/public/file-images/Tableau_TDA-C01/page_65_img_1.jpg https://kxbjsyuhceggsyvxdkof.supabase.co/storage/v1/object/public/file-images/Tableau_TDA-C01/page_66_img_1.jpg

Accepted Answer

Explanation: https://kxbjsyuhceggsyvxdkof.supabase.co/storage/v1/object/public/file-images/Tableau_TDA-C01/page_66_img_2.jpg To build the scatter plot shown in the image, you need to place the Profit measure on the Rows shelf and the Sales measure on the Columns shelf. This will create a Cartesian chart with Profit as the y- axis and Sales as the x-axis. Then, you need to change the mark type to Circle on the Marks card. This will display the data points as circles that vary in size according to the Quantity measure. You can also add color or shape encoding to the marks to show additional dimensions or measures in the view. Reference: Build a Scatter Plot Understanding and Using Scatter Plots Scatter plot in Tableau

Question 14

HOTSPOT 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? https://kxbjsyuhceggsyvxdkof.supabase.co/storage/v1/object/public/file-images/Tableau_TDA-C01/page_73_img_1.jpg

Accepted Answer

Explanation: To connect to a tab-delimited data file named sales.tsv, you should select the option To a File > Text file in Tableau Desktop. This option will allow you to browse and select the file from your local or network drive and connect to it as a data source. You can then specify the text file properties, such as the delimiter, the text qualifier, and whether the first row contains column names. You can also join, union, or blend the data with other data sources if needed. Reference: Text File - Tableau Tableau Certified Data Analyst Study Guide

Question 15

HOTSPOT You have a data source that contains the following columns. https://kxbjsyuhceggsyvxdkof.supabase.co/storage/v1/object/public/file-images/Tableau_TDA-C01/page_116_img_1.jpg You have the following view that shows the percentage of total sales by category: https://kxbjsyuhceggsyvxdkof.supabase.co/storage/v1/object/public/file-images/Tableau_TDA-C01/page_116_img_2.jpg 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.) https://kxbjsyuhceggsyvxdkof.supabase.co/storage/v1/object/public/file-images/Tableau_TDA-C01/page_117_img_1.jpg

Accepted Answer

Explanation: https://kxbjsyuhceggsyvxdkof.supabase.co/storage/v1/object/public/file-images/Tableau_TDA-C01/page_118_img_1.jpg

Free TABLEAU TDA-C01 Actual Exam Questions