ExamGecko
Home / Tableau / TDA-C01 / List of questions
Ask Question

Tableau TDA-C01 Practice Test - Questions Answers, Page 5

List of questions

Question 41

Report
Export
Collapse

You have a data source that contains data tor every city in the Unites States. The following is a sample of the data.

Tableau TDA-C01 image Question 41 76264 09232024004731000000

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?

General filter
General filter
Wildcard filter
Wildcard filter
Top filter
Top filter
Condition filter
Condition filter
Suggested 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

asked 23/09/2024
DAVID PUNTIN
26 questions

Question 42

Report
Export
Collapse

You have the following chart that shows profits and discounts over time.

Tableau TDA-C01 image Question 42 76265 09232024004731000000

You need to combine the lines to appear as shown in the following chart.

Tableau TDA-C01 image Question 42 76265 09232024004731000000

What should you do?

Drag Discount to Color on the Marks card
Drag Discount to Color on the Marks card
Convert Discount to Discrete
Convert Discount to Discrete
Set Discount to Dual Axis
Set Discount to Dual Axis
Drag Discount to the Columns shelf
Drag Discount to the Columns shelf
Suggested 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/en-us/multiplemeasures.htm https://help.tableau.com/current/pro/desktop/en-us/multiplemeasures_dualaxes.htm

asked 23/09/2024
Reed G Porter
28 questions

Question 43

Report
Export
Collapse

You have a dataset that contains sates data. The following is a sample of the data.

Tableau TDA-C01 image Question 43 76266 09232024004731000000

You need to return a value of true if a month has sales greater than $50 000. otherwise the formula must return a value of false.

Which two formulas achieve the goal Choose two

SUM{[Sales]) IN (50000)
SUM{[Sales]) IN (50000)
IIF(SUM< [Sales] )>50000, TRUE, FALSE)
IIF(SUM< [Sales] )>50000, TRUE, FALSE)
MAX< [Sales], 50000)
MAX< [Sales], 50000)
[Sales] > 50000
[Sales] > 50000
Suggested answer: B, D

Explanation:

The two formulas that will return a value of true if a month has sales greater than $50,000, otherwise the formula must return a value of false, are:

The IIF function is a logical function that returns one value if a condition is true, and another value if the condition is false. In this case, the condition is SUM([Sales]) > 50000, which means that the sum of sales for a month is greater than $50,000. The function will return TRUE if the condition is true, and FALSE if the condition is false. The comparison operator > is a logical operator that returns TRUE if the left operand is greater than the right operand, and FALSE otherwise. In this case, the operands are [Sales] and 50000, which means that the sales for a month are greater than $50,000. The operator will return TRUE if the sales are greater than $50,000, and FALSE otherwise. The other options are not correct for this scenario. The IN function is a logical function that returns TRUE if a value is in a set of values, and FALSE otherwise. In this case, the value is SUM([Sales]), which is not in the set of values (50000). The function will always return FALSE. The MAX function is an aggregation function that returns the maximum value in a field or expression. In this case, the field or expression is [Sales], 50000, which is not valid syntax. The function will return an error.

Reference: https://help.tableau.com/current/pro/desktop/en-us/functions_functions_logical.htm#IIF https://help.tableau.com/current/pro/desktop/en-us/operators.htm https://help.tableau.com/current/pro/desktop/en-us/functions_functions_aggregate.htm#MAX

asked 23/09/2024
Charles Marlin
36 questions

Question 44

Report
Export
Collapse

You have the following dataset that contain null values in the Profits field.

Tableau TDA-C01 image Question 44 76267 09232024004731000000

You want the data to appear as shown in the following table.

Tableau TDA-C01 image Question 44 76267 09232024004731000000

Which two formulas achieve the goal? Choose two.

2N ([Profits])
2N ([Profits])
ISNULL ([Profits])
ISNULL ([Profits])
IFNULL [(profits] ,0)
IFNULL [(profits] ,0)
IF [Profits] != null then [Profits] END
IF [Profits] != null then [Profits] END
IF [Profits] != null then [Profits] END
IF [Profits] != null then [Profits] END
Suggested answer: A, C

Explanation:

The two formulas that will make the data appear as shown in the second table are: The IFNULL function is a logical function that returns the first argument if it is not null, and the second argument if it is null. In this case, the first argument is [Profits], which is the field that contains null values. The second argument is 0, which is the value that you want to replace null values with. The function will return [Profits] if it is not null, and 0 if it is null. The IF statement is a logical statement that returns a value or performs an action if a condition is true, and optionally returns another value or performs another action if the condition is false. In this case, the condition is [Profits] != null, which means that [Profits] is not null. The statement will return [Profits] if the condition is true, and nothing if the condition is false. The END keyword marks the end of the statement. The other options are not correct for this scenario. The ZN function is a logical function that returns zero if a value or expression is null, and returns the value or expression itself if it is not null. However, it only works with numeric values or expressions, and [Profits] may not be numeric in this case. The ISNULL function is a logical function that returns TRUE if a value or expression is null, and FALSE otherwise. It does not replace null values with another value.

Reference: https://help.tableau.com/current/pro/desktop/en-us/functions_functions_logical.htm#IFNULL https://help.tableau.com/current/pro/desktop/en-us/functions_functions_logical.htm#IF https://help.tableau.com/current/pro/desktop/en-us/functions_functions_logical.htm#ZN https://help.tableau.com/current/pro/desktop/en-us/functions_functions_logical.htm#ISNULL

asked 23/09/2024
Juan Carlos Delgado
37 questions

Question 45

Report
Export
Collapse

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

.png
.png
.html
.html
.xlsx
.xlsx
.txt
.txt
.pptx
.pptx
.csv
.csv
Suggested answer: A, C, F

Explanation:

The three formats that you can export a worksheet from the Worksheet menu are: The Worksheet menu is a menu that appears at the top of the Tableau window when you are working on a worksheet. It contains various options and commands that you can use to work with your worksheet, such as formatting, sorting, filtering, and exporting. The Export option is a sub-menu that allows you to export your worksheet to different formats, such as image, data, or cross tab. You can access the Export option by clicking on Worksheet > Export from the menu. The .png format is an image format that you can use to export a worksheet as an image file. An image file is a file that contains a picture of your worksheet, such as a chart or a table. You can use an image file to share your worksheet with others or insert it into other documents or applications. You can export a worksheet as an image file by selecting Worksheet > Export > Image from the menu. This will open a dialog box where you can choose a file name, location, and resolution for your image. The .xlsx format is an Excel format that you can use to export a worksheet as an Excel workbook. An Excel workbook is a file that contains one or more worksheets in a spreadsheet application, such as Microsoft Excel. You can use an Excel workbook to work with your data in Excel or import it into other applications or databases. You can export a worksheet as an Excel workbook by selecting Worksheet > Export > Data from the menu. This will open a dialog box where you can choose a file name and location for your workbook. The .csv format is a comma-separated values format that you can use to export a worksheet as a text file with values separated by commas. A text file is a file that contains plain text without any formatting or graphics. You can use a text file to store or transfer your data in a simple and universal format. You can export a worksheet as a text file by selecting Worksheet > Export > Crosstab to Excel from the menu. This will open a dialog box where you can choose a file name and location for your text file. The other options are not correct for this scenario. The .html format is a web page format that you can use to export a dashboard or a story as a web page file. A web page file is a file that contains HTML code that defines the structure and content of a web page. You can use a web page file to view your dashboard or story in a web browser or embed it into other web pages or applications. However, you cannot export a worksheet as a web page file from the Worksheet menu. You have to use the Dashboard menu or the Story menu instead. The .txt format is another text format that you can use to export data as a text file with values separated by tabs. However, you cannot export data as a .txt file from the Worksheet menu. You have to use the Data Source menu instead. The .pptx format is a PowerPoint format that you can use to export one or more worksheets as PowerPoint slides. A PowerPoint slide is a page that contains graphics and text that are part of a presentation in Microsoft PowerPoint. You can use PowerPoint slides to present your worksheets to others or insert them into other presentations or documents. However, you cannot export worksheets as PowerPoint slides from the Worksheet menu. You have to use the File menu instead.

Reference: https://help.tableau.com/current/pro/desktop/en-us/export.htm https://help.tableau.com/current/pro/desktop/en-us/export_image.htm https://help.tableau.com/current/pro/desktop/en-us/export_data.htm https://help.tableau.com/current/pro/desktop/en-us/export_crosstab.htm https://help.tableau.com/current/pro/desktop/en-us/export_web.htm https://help.tableau.com/current/pro/desktop/en-us/export_datasource.htm https://help.tableau.com/current/pro/desktop/en-us/export_powerpoint.htm

asked 23/09/2024
I Haq
35 questions

Question 46

Report
Export
Collapse

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

Tableau TDA-C01 image Question 46 76269 09232024004731000000

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

Tableau TDA-C01 image Question 46 76269 09232024004731000000

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?

Bring in the secondary data source as a union.
Bring in the secondary data source as a union.
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
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
Bring in the secondary data source by using relationships. From the Data pane, right-click Dorm_Name select Replace Reference, and then select Dorm_Name_New
Bring in the secondary data source by using relationships. From the Data pane, right-click Dorm_Name select Replace Reference, and then select Dorm_Name_New
Create a data blend and select Edit Primary Aliases to replace the primary data source alias values with values from the secondary data source
Create a data blend and select Edit Primary Aliases to replace the primary data source alias values with values from the secondary data source
Suggested answer: C

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

asked 23/09/2024
monet washington
35 questions

Question 47

Report
Export
Collapse

You have the following dataset

Tableau TDA-C01 image Question 47 76270 09232024004731000000

You need to create the following visualization.

Tableau TDA-C01 image Question 47 76270 09232024004731000000

Which quick table calculation should you drag to Text on the Marks card?

Percent of Total
Percent of Total
Percent Difference
Percent Difference
Compound Growth Rate
Compound Growth Rate
Percentile
Percentile
Suggested answer: A

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:

asked 23/09/2024
gregori carmona lorenzo
38 questions

Question 48

Report
Export
Collapse

You create the following worksheet

Tableau TDA-C01 image Question 48 76271 09232024004731000000

The Pick Measure parameter contains the following list of values

Tableau TDA-C01 image Question 48 76271 09232024004731000000

Users can select a value from Pick Measure to change the visualization to show either the Sales measure or the Profit measure.

Which formula is used in the Selected Measure calculated field lo switch between measures?

Case [Pick Measure] WHEN 1 then ([Sales]) WHEN 2 then ([Profit]) END
Case [Pick Measure] WHEN 1 then ([Sales]) WHEN 2 then ([Profit]) END
Case AVG([Pick Measure]) WHEN [Sales] then 1 WHEN [Profit] then 2 END
Case AVG([Pick Measure]) WHEN [Sales] then 1 WHEN [Profit] then 2 END
Case [Pick Measure: WHEN [Sales] then 1 WHEN [Profit] then 2 END
Case [Pick Measure: WHEN [Sales] then 1 WHEN [Profit] then 2 END
Case STFMEPick Measure]) WHEN 'Sales' then ([Sales]) WHEN 'Profit' then ([Profit]) e::i
Case STFMEPick Measure]) WHEN 'Sales' then ([Sales]) WHEN 'Profit' then ([Profit]) e::i
Suggested answer: A

Explanation:

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

asked 23/09/2024
James Davis
41 questions

Question 49

Report
Export
Collapse

You need to change the values of a dimension without creating a new field.

What should you do?

Rename the fields
Rename the fields
Create aliases
Create aliases
Create groups
Create groups
Transforms the fields
Transforms the fields
Suggested answer: B

Explanation:

You can create aliases for the members of a dimension by right-clicking the dimension in the Data pane or in the view and selecting Aliases. This changes how the values are displayed in the view, but not the underlying data. For example, you can create an alias for ''Central'' as ''Midwest''.

asked 23/09/2024
shikeba barakzei
34 questions

Question 50

Report
Export
Collapse

You have the following map.

Tableau TDA-C01 image Question 50 76273 09232024004731000000

You need the map to appear as shown in the following visualization.

Tableau TDA-C01 image Question 50 76273 09232024004731000000

What should you do?

Change the mark type to Density
Change the mark type to Density
Drag Location to Size on the Marks card
Drag Location to Size on the Marks card
Change the mark type to Map
Change the mark type to Map
Drag Population to Size on the Marks card
Drag Population to Size on the Marks card
Change the opacity to 75%
Change the opacity to 75%
Suggested answer: A
asked 23/09/2024
Manish Chaudhary
37 questions
Total 120 questions
Go to page: of 12
Search

Related questions