Question 1

Using Tableau Prep Builder, can we save the output to the Database table?

Options :

A : True

B : False

Answer: A

Question 2

Blend the Significant Volcano Eruption dataset with the Country population dataset using year and country. Find out which country is having 4 volcano eruptions in the year 1963 and what was the population of this country in the same year?

Options :

A : Indonesia and 95,055,669

B : Japan and 96,812,000

C : Indonesia and 9,103,406,453

D : Japan and 9,103,406,453

Answer: A

Question 3

How the ATTR() is defined in Tableau?

Options :

A : IF MIN ([dimension]) = MAX ([dimension]) THEN MIN ([dimension]) ELSE "*" END

B : IF MIN ([dimension]) < MAX ([dimension]) THEN MAX ([dimension]) ELSE "*" END

C : IF MIN ([dimension]) = MAX ([dimension]) THEN MIN ([dimension]) ELSE MAX ([dimension]) END

D : IF MIN ([dimension]) = MAX ([dimension]) THEN MIN ([dimension]) ELSE NULL END

Answer: A

Question 4

Connect to the "Education" data source. Analyze the Math score and create 3 categories. If the score is less than 500 then consider the student as 'Low Performer'. If the score is greater than or equal to 500 but less than 600 then call it 'Average Performer'. If the score is greater than or equal to 600 then 'High Performer'. Find out the percentage of Average Performers in males?

Options :

A : 32.38%

B : 42.84%

C : 32.25%

D : 44.33%

Answer: D

Question 5

You connect to a database server by using Tableau Prep. The database server has a data role named Role1. You have the following field in the data.You need to apply the Role1 data role to the Material field. Which two actions should you perform? Choose two.

Options :

A : From the More actions menu of Materials, select Valid in the Show values section.

B : For the data type of the Material field, select Custom, and then select Role1.

C : From the More actions menu of Materials, select Group Values, and then select Spelling.

D : From the More actions menu of Materials, filter the selected values.

Answer: B,C

Free Analytics-DA-201 Mock Exam – Practice Online Confidently

Buying Options: