Desktop-Certified-Associate Tableau Practice Questions

Question #1 (Topic: demo questions)

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 (Topic: demo questions)

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 (Topic: demo questions)

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.

Question #4 (Topic: demo questions)

In which of the following scenarios you should use the blend?

A.

The data to combine has the same structure but consists of data of different years.

B.

The combined data will be used in many worksheets in the current workbook.

C.

The data to combine is at a different level of detail.

D.

All of the above.

Correct Answer: C

Explanation:

Union - The data to combine has the same structure but consists of data of different years.
Blend - The data to combine is at a different level of detail.

Tableau Desktop-Certified-Associate - Tableau Desktop Certified Associate Certification Exam

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

In which of the following scenarios you should use the blend?

The data to combine has the same structure but consists of data of different years.

The combined data will be used in many worksheets in the current workbook.

The data to combine is at a different level of detail.

All of the above.

Correct Answer: C

Union - The data to combine has the same structure but consists of data of different years.Blend - The data to combine is at a different level of detail.

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

Union - The data to combine has the same structure but consists of data of different years.
Blend - The data to combine is at a different level of detail.