Desktop-Certified-Associate Tableau Desktop Certified Associate Free Demo Questions – Try Before You Buy

Question 1

How to add reference lines in a view? (Select correct two answers)

A

Using Analytics pane

B

Using Data Pane

C

Using Analysis Menu

D

Right Click on Axis and Add Reference Line

Correct Answer: A, D

Explanation:

Using Analytics pane:

Question 2

To create a choropleth map, your data source should include the following types of
information?

A

Quantitative or qualitative values

B

Location names or custom polygons

C

Background image

D

Custom Territories

Correct Answer: A, B

Explanation:

To create a choropleth map, the data source must contain quantitative or qualitative values (A) and location names or custom polygons (B). The values represent the data that will be visualized, such as population, sales, crime rates, or categories, while the location information identifies the geographic areas (countries, states, regions, districts, or custom-defined boundaries) that will be shaded or colored based on those values. A background image (C) is not required because choropleth maps use geographic boundaries rather than images, and custom territories (D) are optional and only needed when using user-defined regions. Therefore, the essential requirements for a choropleth map are data values and geographic location information, making A and B the correct answers.

Question 3

How the ATTR() is defined in Tableau?

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

Correct Answer: A

Explanation:

In Tableau, the ATTR() (Attribute) function is used to return a value when all records in the current level of detail have the same value for a dimension. If there are multiple different values, Tableau displays an asterisk (*) to indicate that the value is not unique. Internally, ATTR() is defined as:
**`IF MIN([dimension]) = MAX([dimension]) THEN MIN([dimension]) ELSE "*" END`**This logic works because if the minimum and maximum values of a dimension are the same, then all values must be identical, so Tableau returns that value. If the minimum and maximum values differ, it means multiple values exist, and Tableau returns an asterisk (*) instead. Therefore, Option A is correct.

Demo Tableau Desktop-Certified-Associate Exam Questions

How to add reference lines in a view? (Select correct two answers)

Using Analytics pane

Using Data Pane

Using Analysis Menu

Right Click on Axis and Add Reference Line

Correct Answer: A, D

Using Analytics pane:

To create a choropleth map, your data source should include the following types of
information?

Quantitative or qualitative values

Location names or custom polygons

Background image

Custom Territories

Correct Answer: A, B

How the ATTR() is defined in Tableau?

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

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

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

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

Correct Answer: A

Demo Practice Mode

Demo Tableau Desktop-Certified-Associate Exam Questions

How to add reference lines in a view? (Select correct two answers)

Using Analytics pane

Using Data Pane

Using Analysis Menu

Right Click on Axis and Add Reference Line

Correct Answer: A, D

Using Analytics pane:

To create a choropleth map, your data source should include the following types ofinformation?

Quantitative or qualitative values

Location names or custom polygons

Background image

Custom Territories

Correct Answer: A, B

How the ATTR() is defined in Tableau?

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

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

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

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

Correct Answer: A

Demo Practice Mode

To create a choropleth map, your data source should include the following types of
information?