Salesforce Certified Tableau Data Analyst (Analytics-DA-201) Free Practice Test

Question 1

You have the following table.

You need each record to alternate between grey and white.
What should you change in the Format Shading pane?

A. the row banding size to 3

B. the column banding size to 1

C. the row banding size to 1

D. the column banding size to 3

Correct Answer: C

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 2

A Data Analyst has the following primary data source that contairis a dimension named Dorm_Code.

The analyst receives the following secondary data source that contains updated dorm codes.

The analyst needs to bring the updated dorm codes into Tableau and use the codes in existing visualizations.
The new dorm codes must use the existing field name of Dorm_Code.
What should the analyst do?

A. Bring in the secondary data source by using relationships. From the Data pane, right-click Dorm_Name, select Replace References, and then select Dorm Name New.

B. Bring in the secondary table as a left join to the primary data source. From the Data Source page, select Create Calculated Field in the Dorm_Name field and enter [Dorm_Name_New] in the calculation window.

C. Bring in the secondary data source as a union.

D. Create a data blend and select Edit Primary Aliases to replace the primary data source alias values with values from the secondary data source.

Correct Answer: A

Question 3

A Data Analyst has the following bar chart.

The analyst wants the chart to appear as shown in the following exhibit.

What should the analyst add?

A. A reference line

B. A distribution band

C. A reference band

D. An average line

Correct Answer: B

Question 4

Which syntax should a Data Analyst use to find the first purchase date per customer when Customer is not in the view?

A. [Customer ID] : MIN([Purchase Date])

B. [Customer ID] : { [Purchase Date] }

C. MIN([Purchase Date])

D. { FIXED [Customer ID] : MIN([Purchase Date]) }

Correct Answer: D

Question 5

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

A. Customers of 2020

B. Top N Products

C. Top N Customers

D. Sellers of 2020

Correct Answer: A,C

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 6

You have the following visualization.

Correct Answer:

Explanation:

Question 7

Which function should a Data Analyst use to average sales at a less-granular level of detail than is in the view?

A. AVG

B. INCLUDE

C. RUNNING_AVG

D. EXCLUDE

Correct Answer: D

Question 8

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

A. The object disappears from the item hierarchy.

B. The object gets deleted from the dashboard.

C. The hidden object remains in the same position but is grayed out.

D. The layout automatically adjusts to fill the space.

Correct Answer: D

Question 9

A Data Analyst creates a parameter named Choose Region that contains values from a field named Region.
The analyst wants users to be able to use the Choose Region parameter to interact with a chart by toggling between different regions.
What should the analyst do next?

A. Add the [Region] = [Choose Region] formula to the Filters card.

B. Set the Choose Region parameter to Single Value (list).

C. Add Region to the Filters card.

D. Add the Choose Region parameter to the Pages card.

Correct Answer: A

Question 10

You want to create the following table in a view.

Which function should you use to create the Position column?

A. LAST

B. INDKX

C. RANK

D. FIRST

Correct Answer: D

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 11

You have the following map.

You need the map to appear as shown in the following visualization.

What should you do?

A. Change the mark type to Density

B. Change the opacity to 75%

C. Drag Location to Size on the Marks card

D. Drag Population to Size on the Marks card

E. Change the mark type to Map

Correct Answer: A

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Welcome to TestSimulate

Salesforce Certified Tableau Data Analyst (Analytics-DA-201) Free Practice Test