Tableau TDA-C01 Exam Practice Test Instant Access

Question 1

You have the following view.

You want to filter the view lo show only records that have a movie name starting with the word. "The". You must achieve the goal without writing any formulas.

Which type of filter should you use?

AWildcard

BCondition

CGeneral

DTop

Answer : A

Question 2

You have a Tableau workbook that has a live data source. The data source connects to a Microsoft SQL Server database. Only the users in your department can access the database.

You plan to publish the workbook to a Tableau Server site named Public. All the users in your company can access Public.

What are two ways to ensure that all the users can view the worksheets in the workbook? Choose two.

AChange the data source to an extract before you publish.

BEmbed the credentials when you publish the workbook.

CRemove all the data source filters before you publish.

DExport the data to a .csv before you publish.

EConfigure the local file permissions to the workbook file, and then publish the workbook.

Answer : A, B

Question 3

You have a dashboard that contains a parameter named Start Date.

You need to create an extract from a Microsoft Excel file. The extract must be filtered based on Start Date.

What should you do?

ACreate a data source based on the Excel worksheet and create a calculated field based on Start Date. Add the calculated field to the extract filter.

BCreate a custom SOL query to define the data source and create a calculated field based on Start Date. Add the calculated field to the extract filter.

CCreate a custom SOL query that references Stan Date in the WHERE clause.

DCreate a data source based on the Excel worksheet and create a calculated field based on Start Date. From the Data pane, add the calculated field to the data source filter

Answer : A

Question 4

You have the following two tables.

Table A is the primary table.

Which type of join is established when a blend is created by using the join key of Category?

ALeft join

BRight join

CInner join

DOuter join

Answer : A

Question 5

You have the following Map.

You need the map to appear as shown in the following visualization.

What should you do?

ADrag Location to Size on the Marks card.

BChange the opacity to 75%.

CDrag Population to Size on the Marks card.

DChange the mark type to Density.

EChange the mark type to Map.

Answer : D

To create a map visualization that shows the concentration of data points in different locations, you need to change the mark type to Density. This will create a heatmap that uses color and size to indicate the density of the data points. You can also adjust the intensity and transparency of the density marks to suit your needs.Reference:The information is based on the following sources:

Create Heatmaps that Show Trends or Density in Tableau

Build a Simple Map - Tableau

Question 6

You have the following chart that sorts states by the number of products each state has purchased.

Which formula should you use to include a number with the position of each state within each region?

AFIRST ()

BINDEX ()

CWINDOW_SUM(SUM ([Quantity]))

DLOOKUP (SUM ([Quantity]))

Answer : D

The LOOKUP function is used to return the value of a specified field in a different row, which can be defined relative to the current row. In this context, it can be used to include a number with the position of each state within each region by looking up the SUM([Quantity]) in each respective position.Reference:The information is inferred from general Tableau knowledge as well as the following sources:

Tableau Functions (Alphabetical)

LOOKUP

Tableau Certified Data Analyst Exam Guide

Question 7

You have the following dataset.

You want to create a new calculated dimension field named Category that meets the following conditions:

. When Subject is Computer Science or Science, Category must be Sciences.

. When Subject is English or Social Studies, Category must be Humanities.

Which two logical functions achieve the goal? Choose two.

AIF [Subject]- 'Science' THEN 'Sciences'
ELSEIF [Subject]='English' THEN 'Humanities'
ELSEIF [Subject]-'Social Studies' THEN 'Humanities'
ELSEIF [Subject]= 'Computer Science' THEN 'Sciences'
END

BIIF(( CONTAINS ([Subject], 'Science') = TRUE) , 'Humanities', 'Sciences')

CIF ENDSWITH ( [Subject], 'Computer Science') THEN 'Sciences' ELSE 'Humanities' END

DCASE [Subject]
WHEN 'Computer Science' THEN 'Sciences'
WHEN 'Science' THEN 'Sciences'
WHEN 'English' THEN 'Humanities'
WHEN 'Social Studies' THEN 'Humanities'
End

Answer : A, D

To create a new calculated dimension field named Category that meets the given conditions, you can use either the IF or the CASE logical function. Both functions allow you to evaluate an expression and return a value based on different scenarios. Option A uses the IF function with multiple ELSEIF clauses to check the value of the Subject field and assign it to either 'Sciences' or 'Humanities'. Option D uses the CASE function with multiple WHEN clauses to do the same thing. Both options will produce the same result, but the CASE function is more concise and easier to read. Option B is incorrect because it will assign 'Humanities' to any subject that contains 'Science' in its name, which is not the desired outcome. Option C is incorrect because it will only check if the subject ends with 'Computer Science' and ignore the other subjects.Reference:

Logical Functions - Tableau

Tableau Certified Data Analyst Study Guide

Tableau TDA-C01 Tableau Certified Data Analyst Exam Practice Test