Analytics-DA-201 Free Practice Test

- (Topic 1)
You have the following line chart that shows the average sales by month.

Which month had the biggest increase in swage sales compared to me previous month in 2019?

1. A. August
2. B. October
3. C. December
4. D. November

Correct Answer: D

HOTSPOT - (Topic 3)
You have a table that contains four columns named Order Date, Country, Sales, and Profit.
You need to add a column that shows the day of the week for each row. For example, orders placed on August 31, 2022, will show a day of
Wednesday.
How should you complete the formula? (Use the dropdowns in the Answer Area to select the correct options to complete the formula.)

Solution:


Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A

- (Topic 3)
A Data Analyst has the following two tables named Orders and Returns.

The analyst needs to get the Customer ID and Customer Name for only the orders that were returned. Orders will be the leading table.
Which type of join should the analyst perform in Tableau Prep?

1. A. Left join
2. B. Unmatched only join
3. C. Inner join
4. D. Full join

Correct Answer: C

- (Topic 3)
A Data Analyst has a data source that contains the following columns:

he analyst has the following FIXED Level of Detail (LOD) expression called Region Sales:
{ FIXED [Region] : SUM([Sales]) }
The analyst has a view that has a dimension filter on the State column to exclude five states.
What should the analyst do to ensure the five states are also excluded from the LOD expression?

1. A. Drag the LOD expression to the Filters shelf.
2. B. Change the LOD expression to { FIXED [Region], [State] : SUM([Sales]) }.
3. C. Right-click the State dimension filter, and then click Attribute.
4. D. Right-click the State dimension filter, and then click Add to Context.

Correct Answer: D

- (Topic 3)
You have a large data source that contains more than 10 million rows. Users can filter the rows by a field named Animal.
The following is a sample of the data.

You want to improve the performance of the views by including only animals of a particular type.
To which filter should you add the Type field on the worksheet?

1. A. Dimension filler
2. B. Table calculation filter
3. C. Context filter
4. D. Measure filter

Correct Answer: C