Analytics-DA-201 Free Practice Test

- (Topic 3)
You have the following dataset that contain null values in the Profits field.

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

Which two formulas achieve the goal? Choose two.

1. A. ZN ([Profits])
2. B. ISNULL ([Profits])
3. C. IFNULL [(profits] ,0)
4. D. IF [Profits] != null then [Profits] END

Correct Answer: AC

- (Topic 3)
When using a Show/Hide button in Tableau, what happens if the object is in a Tiled layout container?

1. A. The layout automatically adjusts to fill the space.
2. B. The object disappears from the item hierarchy.
3. C. The hidden object remains in the same position but is grayed out.
4. D. The object gets deleted from the dashboard.

Correct Answer: A

- (Topic 3)
You have the following chart that shows the cumulative of sales from various dates.

You want the months to appear as shown in the following chart.

What should you do?

1. A. Convert the date to Exact Date
2. B. Convert the date to Continuous
3. C. Select Show Misting Values for the dale
4. D. Convert the date to Attribute

Correct Answer: B

- (Topic 3)
A Data Analyst has a data source that has two tables named Table1 and Table2. Table1 is the primary table and Table2 is the secondary table.
The analyst wants to combine the tables by using Tableau Prep. The combined table must include only values from Table1 that do not match any values in Table2. The field values from Table2 must appear as null values.
Which type of join should the analyst use?

1. A. Inner
2. B. Left only
3. C. Left
4. D. Full outer
5. E. Union

Correct Answer: B

HOTSPOT - (Topic 3)
You have a blank dashboard.
You want to add two sheets to the dashboard. The sheets must support the Show/Hide button.
To which two objects can you add the sheets? (Click the two appropriate Options in the Answer Area.)

Solution:


Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A