Analytics-DA-201 Free Practice Test

- (Topic 3)
You have a dataset that contains sates data. The following is a sample of the data.

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

1. A. SUM{[Sales]) IN (50000)
2. B. IIF(SUM< [Sales] )>50000, TRUE, FALSE)
3. C. MAX< [Sales], 50000)
4. D. [Sales] > 50000

Correct Answer: BD

- (Topic 3)
A Data Analyst has the following dataset:

The analyst wants to create a new calculated dimension field named Category that meets the following conditions:
When Subject is Computer Science or Science, the Category must be Sciences. When Subject is English or Social Studies, the Category must be Humanities. Which two logical functions achieve this goal? (Choose two.)

1. A. IF [Subject] = 'Science' THEN 'Sciences' ELSEIF [Subject] = 'English' THEN 'Humanities'ELSEIF [Subject] = 'Social Studies' THEN 'Humanities' ELSEIF [Subject] = 'Computer Science' THEN 'Sciences' END
2. B. IIF((CONTAINS([Subject], 'Science') = TRUE), 'Humanities', 'Sciences')
3. C. IF ENDSWITH([Subject], 'Computer Science') THEN 'Sciences' ELSE 'Humanities' END
4. D. CASE [Subject]WHEN 'Computer Science' THEN 'Sciences' WHEN 'English' THEN 'Humanities'WHEN 'Social Studies' THEN 'Humanities' END

Correct Answer: AD

FILL IN THE BLANK - (Topic 2)
Open the link to Book1 found on the desktop. Use the Superstore data source. Split the Customer Name field into two fields named First Name and Last Name.

Solution:
To split the Customer Name field into two fields named First Name and Last Name, you need to do the following steps: Open the link to Book1 found on the desktop. This will open the Tableau workbook that uses the Superstore data source. Go to the Data Source tab at the bottom of the workbook to see the data source page. You will see a table that shows the fields and values from the Superstore data source. Right-click on Customer Name in the table and select Split from the menu. This will split the field into two fields based on a separator, which is a space by default. You will see two new fields named Customer Name - Split 1 and Customer Name - Split 2 in the table. Right-click on Customer Name - Split 1 and select Rename from the menu. Type First Name as the new name and press Enter. This will rename the field as First Name. Right-click on Customer Name - Split 2 and select Rename from the menu. Type Last Name as the new name and press Enter. This will rename the field as Last Name.

Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A

- (Topic 3)

You need the top 10 values to appear in a different color. The lop 10 values must be colored dynamically.
What should you do?

1. A. Select the lop 10 bars, create a se
2. B. and then drag the set to Color on the Marks card.
3. C. Create a group field that groups the top 10 values into one group and the rest of the values into another grou
4. D. Drag the group field to Color on the Marks card.
5. E. Select the top 10 bars, and then change the color by selecting Color on the Marks card.
6. F. Create a set that has a top 10 condition, and then drag the set to Color on the Marks card.

Correct Answer: D

- (Topic 3)

How are the colors configured for the map?

1. A. A sequential color gradient
2. B. A diverging color palette that has five stepped colors
3. C. A diverging color palette that has six stepped colors
4. D. A single color gradient

Correct Answer: B