QUESTION: 17 Exam Topic: 1, Section 1

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?

Drag the growth rate to Text on the Marks card
Enable captions
Annotate March 2020
Add a tooltip

Answer(s): 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

Reveal Solution Next Question

QUESTION: 18 Exam Topic: 1, Section 1

You want to add a comment to March 2020 as shown in the following visualization.
You have the following sets in a Tableau workbook
- Top N Customers

- Customers of 2020
- Top N Products
- Sellers of 2020
Which two sets can you combine? Choose two

Sellers of 2020
Customers of 2020
Top N Products
Top N Customers

Answer(s): B,D

Explanation:

To combine two sets, they must have at least one dimension in common. In this case, Customers of 2020 and Top N Customers both have Customer Name as a dimension, so they can be combined using set operations such as union, intersection, or difference. Sellers of 2020 and Top N Products have different dimensions (Seller Name and Product Name), so they cannot be combined.

Reference:

https://help.tableau.com/current/pro/desktop/en-us/sets.htm https://help.tableau.com/current/pro/desktop/en-us/sets_create.htm#combine-sets

Reveal Solution Next Question

QUESTION: 19 Exam Topic: 1, Section 1

DRAG DROP (Drag and Drop is not supported)
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)

See Explanation section for answer.

Answer(s): A

Explanation:

The correct order of the four actions is:
Open Tableau Prep
Union the sales data of both divisions
Create a new column to concatenate the name for the Germany division Join the sales data and the population data by using Country as the join field The first action is to open Tableau Prep, which is a tool that allows you to prepare and shape your data for analysis. You can connect to various data sources, clean and transform your data, and output it to Tableau Desktop or Tableau Server.
The second action is to union the sales data of both divisions, which means appending them together. This will create a single table that contains all the rows from both tables, with null values for any missing fields. You can use the Union step in Tableau Prep to drag and drop your tables and create a union.
The third action is to create a new column to concatenate the name for the Germany division, which means combining the first name and last name into one field. This will make it consistent with the name field in the United States division, and allow you to identify each salesperson by their full name. You can use the Clean step in Tableau Prep to create a calculated field that uses the CONCAT function to join the two fields.
The fourth action is to join the sales data and the population data by using Country as the join field, which is a common field between them. This will add the population data for each country to the sales data, which is needed to calculate the sales per capit a. You can use the Join step in Tableau Prep to drag and drop your tables and choose the join type and fields.

Reference:

https://help.tableau.com/current/prep/en-us/prep_get_started.htm https://help.tableau.com/current/prep/en-us/prep_union.htm https://help.tableau.com/current/prep/en-us/prep_clean.htm https://help.tableau.com/current/prep/en-us/prep_join.htm

Reveal Solution Next Question

QUESTION: 20 Exam Topic: 1, Section 1

DRAG DROP (Drag and Drop is not supported)
You have the following dataset.

You need to create the following worksheet.

The table must show either profit or sales based on the selection from the Parameter 1 menu.
Which three actions should you perform in orders
(Place the three correct options in order Use the arrows to move Options lo Answer Area Use Answer Area arrows to reorder the options)