# Tableau TDS-C01 Tableau Desktop Specialist Exam Practice Test

Page: 1 / 14
Total 314 questions
Question 1

You have a data set that builds a union between two tables. You need to extract the data set. What should you use to extract the data set?

When dealing with a union of two tables in Tableau, using logical tables with a single table extract is the most appropriate approach. Logical tables allow for the integration of data from multiple tables in a way that is seamless and efficient for analysis. By using a single table extract, Tableau consolidates the data from the union into one extract, optimizing performance and enabling faster data processing. This approach is particularly beneficial when working with large datasets or complex unions.

Question 2

What are two examples of a date value?

Choose two.

Date values in Tableau represent specific points in time and are typically formatted in a standard date format.

Option A, '2020-05-01', is a standard date format representing the 1st of May, 2020.

Option D, 'January 1, 1995', is another example of a date value, representing the 1st of January, 1995. Options B ('December') and C ('Wednesday') represent a month and a day of the week, respectively, but do not specify a particular date.

Question 3

You need to invert the color intensity of a quantitative range. Which option should you use?

To invert the color intensity of a quantitative range in Tableau, you should use the 'Reversed' option. This option inverts the color scheme so that the colors representing the higher values are swapped with those representing the lower values. For example, if a color scale initially shows dark colors for high values and light colors for low values, using 'Reversed' will switch this so that dark colors represent low values and light colors represent high values. This option is particularly useful for better visual distinction and interpretation in certain data scenarios.

Question 4

Which two types of aggregations can be applied to string fields? Choose two.

The two types of aggregations that can be applied to string fields in Tableau are Count Distinct and Minimum. Count Distinct counts the unique values of a field, and Minimum finds the smallest value in a field based on the alphanumeric order. String fields do not support numeric aggregations like Sum or Average.

Question 5

You have the following string value: Sales Data.

Which calculated field produces an output of Sales?

The calculated field formula LEFT('Sales Data', 5) will correctly produce the output 'Sales' from the string value 'Sales Data'. The LEFT function in Tableau returns the specified number of characters from the start of the string. Here, the first 5 characters of 'Sales Data' are 'Sales'.

Question 6

Which action describes the process for changing a measure so that it automatically aggregates an average instead of a sum?

To change a measure so that it automatically aggregates as an average instead of a sum, you should right-click the field in the Data pane and select Default Properties. In the Default Properties menu, you can set the default aggregation for the measure, such as setting it to calculate an average by default when added to a view.

Question 7

What statement correctly describes a requirement to create a reference line in Tableau?