Question 1

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

Question 2

Using the Profit Analysis Dashboard twbx file, find out the profit recorded in October 2016 by California State in the West region? You can add the functionality to the dashboard.

Options :

A : $3,251

B : $3,448

C : $517

D : $987

Answer: C

Question 3

You've created a bar chart displaying the top 10 products based on sales, and you want it to automatically update when a new product enters the top 10. Which Tableau feature or functionality would help you accomplish this?

Options :

A : Groups

B : Hierarchy

C : Bins

D : Sets

Answer: D

Question 4

Connect to the "Covid data" source. Create a line chart using continuous months and new deaths. Find the Excess Kurtosis for the sum of new deaths.

Options :

A : -0.56

B : -0.67

C : -0.69

D : -0.58

Answer: B

Question 5

Why might this LOD expression for percent of total sales give different results than a table calculation for percent of total sales?

2021-04-07-07-32-07-1fac52b52fac6fcdda6020e2c6c8c94e

Options :

A : The market filter is not correctly set up

B : The LOD expression is not correctly set up

C : The table calculation is not correctly set up

D : The filter is applied before the Table calculation is performed

Answer: D