Analytics-DA-201 Free Practice Test

- (Topic 3)
In a dataset, a Data Analyst has a string field named Category that contains unnecessary trailing spaces.
Which function should the analyst use to remove the trailing spaces from the Category field?

1. A. RTRIM
2. B. SPLIT
3. C. LTRIM
4. D. REPLACE

Correct Answer: A

- (Topic 3)
You want to create the following dashboard.

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.

How should you lay out the objects on the dashboard?

1. A. Drag a horizontal container to the dashboard and add both sheets to the containe
2. B. Set the Fit to Standard.
3. C. Add both sheets to the dashboar
4. D. Set Fit to Fix width.
5. E. Drag a blank object to the dashboard and add both sheets to the dashboar
6. F. Set Fit to Entire view.
7. G. Drag a vertical container to the dashboard and add both sheets to the containe
8. H. Set Fit to Entire view.

Correct Answer: D

HOTSPOT - (Topic 3)
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?

Solution:


Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A

- (Topic 1)
You have the following box plot that shows the distribution of average profits made in every
state by region.
Which region has the smallest distribution of profits?

1. A. South
2. B. Cast
3. C. Central
4. D. West

Correct Answer: A

- (Topic 3)
A Data Analyst needs to analyze the financial performance of the sales team. In order to make the dashboards easier to understand, the analyst needs to format the financial values to show the dollar symbol ($) in front of the value.
How should the analyst enable this formatting across the workbook?

1. A. Right-click on the measure in the data pane, then click on Create and Calculated Field to convert to a string and add the $ symbol.
2. B. Right-click on the measure in the data pane, then click on Default Properties and Number Format.
3. C. Click on the Format tab and select Workbook Theme.
4. D. Click on the Analysis tab and select Forecast.

Correct Answer: B