TDA-C01 Online Practice Questions and Answers

Correct Answer: D

Correct Answer: C

Correct Answer: A

Correct Answer: AD

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

Correct Answer: A

Explanation: The question presents a scenario where a geographic map visualization in Tableau needs to be transformed from a series of discrete circles representing data points to a density map visualization. The density map shows

concentrations of data points with a gradient of color, where denser areas are indicated by a darker color.

Here's the explanation for each option:

A. Change the mark type to Density: This is the correct answer because changing the mark type to 'Density' in Tableau creates a density map, which displays the concentration of data points with a color gradient. This is exactly what is needed to achieve the visual effect shown in the second image, where regions with a higher concentration of data points are represented by darker shades. B. Drag Location to Size on the Marks card: This option would adjust the size of the marks based on the number of locations, which is not relevant to creating a density map. It would result in varying sizes of circles, not a continuous gradient. C. Change the mark type to Map: The visualization is already using a map. This option would not change the visualization to the desired density map. D. Drag Population to Size on the Marks card: This would change the size of the circles based on the population values, making some circles larger and others smaller. This is not how a density map is created, which uses color intensity rather than size to show concentration. E. Change the opacity to 75%: Changing the opacity would affect the transparency of the marks on the map but would not transform the visualization into a density map. To achieve the visualization shown in the second image, the mark type must be changed to 'Density,' which will produce a heat map-like effect where the color intensity represents the concentration of data points. Therefore, the correct answer is A. Change the mark type to Density.

To create a density map from a scatter plot of data points, you would change the mark type to Density. This mark type allows you to visualize the concentration of data points in an area, which can be useful for identifying clusters or patterns in geospatial data.

Correct Answer: C

Explanation: Extensions in Tableau are web-based programs that can interact with dashboards. To add a button that allows users to export the dashboard as an image, you would use an Extension object. This could be a custom extension designed to trigger the download of the dashboard view as an image.

Correct 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. References: Size and Lay Out Your Dashboard - Tableau Create a Dashboard - Tableau Format Dashboard Layout in Tableau - GeeksforGeeks

Correct Answer: A

To add the Sales by State sheet in a Show/Hide button to the right side of the dashboard, 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 sales dashboard.

Click on the sales dashboard tab at the bottom of the workbook to open the dashboard. You will see a dashboard that shows various charts and filters related to sales data.

Drag Sales by State from the Sheets pane to the right side of the dashboard. This will add the sheet as a floating element on the dashboard. You can resize and position it as you like.

Right-click on Sales by State and select Add Show/Hide Button from the menu.

This will add a button that allows you to show or hide the sheet on the dashboard.

You can customize the appearance and behavior of the button by clicking on it and using the options on the Marks card.

Optionally, you can drag a vertical layout container from the Objects pane to the right side of the dashboard and place Sales by State and its button inside it. This will help you organize your dashboard elements and align them neatly.

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

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

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

Correct Answer: A

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.

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

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

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

Correct Answer: A

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.

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

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

Correct Answer:

Explanation: To filter regions based on the highest sales and allow users to specify the number of regions shown, you should perform these actions in order:

Answer area:

Create an integer data type parameter named Param1.

Drag Region to the Filters shelf.

Configure a Top filter by field. Use Param1 and filter by the sum of Sales. To create a dynamic filter that lets users choose the number of regions to display, you need to use a parameter and a top filter. A parameter is a user-defined variable

that can be used in calculations, filters, and reference lines. A top filter is a type of filter that shows only the top or bottom N values based on a specified field or expression. In this question, you want to filter regions based on the highest sales.

You also want users to be able to specify the number of regions shown. To achieve this, you need to follow these steps:

First, you need to create an integer data type parameter named Param1. This parameter will allow users to enter a number that will determine how many regions to show. You can create a parameter by right-clicking on the Data pane and

selecting Create Parameter. Then, you need to specify the name, data type, current value, and allowable values for the parameter. In this case, you can choose Integer as the data type, 10 as the current value, and All as the allowable values.

You also need to show the parameter control by right-clicking on the parameter and selecting Show Parameter Control. This will display a slider or a text box where users can enter or adjust the parameter value. Next, you need to drag Region

to the Filters shelf. This will open the Filter dialog box, where you can choose how to filter the Region field. You can filter by general, wildcard, condition, or top. In this case, you want to filter by top, so you need to select the Top tab.

Finally, you need to configure a top filter by field. Use Param1 and filter by the sum of Sales. This will filter the Region field by showing only the top N regions based on the sum of Sales, where N is the value of the parameter Param1. You can

configure a top filter by field by selecting By field in the Top tab, then choosing the parameter Param1 from the drop-down list, and selecting the aggregation function Sum and the field Sales from the other drop-down lists. This will create a

filter expression that looks like this: Top Param1 by SUM(Sales). By following these steps, you will create a filter that shows only the regions with the highest sales, and allows users to change the number of regions shown by adjusting the

parameter value.

References:

Tableau Certified Data Analyst Exam Prep Guide, page 10, section "Filtering Data" Tableau Help: Parameters

Tableau Help: Top Filters

Correct Answer:

Correct Answer:

Correct Answer:

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. References: Build a Scatter Plot Understanding and Using Scatter Plots Scatter plot in Tableau

Correct Answer:

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. References: Add Show/Hide Buttons - Tableau Layout Containers - Tableau