Tableau TDA-C01 Exam Practice Test Instant Access

Question 1

You subscribe to a view that delivers a daily email to your inbox.

You want to make the subscription available to other stakeholders.

What should you do?

AFrom the worksheet, modify the subscription.

BFrom the My Content overview page, modify the subscription.

CFrom the dashboard overview page, modify the subscription.

DFrom the My Content overview page, modify the alert.

Answer : B

Question 2

You have a workbook that connects to a database. The database requires authentication.

You plan to publish the workbook and schedule a daily refresh of the data.

Which two conditions must be met to schedule the refresh? Choose two.

AThe credentials must be embedded.

BThe data source must be stored as a hyper file.

CThe data source must use a live connection.

DThe data must be extracted.

Answer : A, D

To schedule a refresh of the data, you need to ensure that Tableau Server or Tableau Online can access the database without prompting for credentials. This can be done by embedding the credentials in the workbook or the published data source. You also need to extract the data from the database and publish it as a separate data source or as part of the workbook. A live connection would not allow you to refresh the data on a schedule, as it would always query the database directly. A hyper file is a format for storing extracted data, but it is not a requirement for scheduling a refresh.Reference:

Tableau Certified Data Analyst Exam Prep Guide, page 10, section ''Publishing and Scheduling Data Refreshes''

Tableau Help: Embedding Database Credentials

Tableau Help: Extract Your Data

Question 3

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.

AFrom the More actions menu of Materials, select Valid in the Show values section.

BFor the data type of the Material field, select Custom, and then select Role1.

CFrom the More actions menu of Materials, select Group Values, and then select Spelling.

DFrom the More actions menu of Materials, filter the selected values.

Answer : B, C

To apply a custom data role to a field, you need to select the data type of the field and then choose the data role from the list of available roles. This will validate the values in the field against the data role and mark any invalid values with a red exclamation mark. To fix the invalid values, you can use the Group Values option and select the Spelling algorithm, which will group values that are close in spelling and replace them with the most frequent value in the group. This will help you standardize the values in the Material field and match them with the Role1 data role.Reference:The information is based on the following sources:

Use Data Roles to Validate your Data - Tableau

New in Tableau Prep: Automatically identify data quality issues with Data Roles

Question 4

In a dataset, you have a string field named Name that contains unnecessary semicolons.

Which function should you use to remove the semicolons from the Name field?

ATRIM

BCONTAINS

CREPLACE

DSPLIT

Answer : C

The REPLACE function is used to replace all occurrences of a substring within a string with another substring. In this case, it can be used to remove the semicolons from the Name field by replacing them with an empty string. For example, REPLACE (''John;Doe'', '';'', '''') = ''JohnDoe''.Reference:The information is based on the following sources:

String Functions - Tableau

Remove special characters and add a semi colon in a word - Tableau

Question 5

You have the following dataset:

You want to create a parameter to dynamically filter the data to produce the following results.

Which two types of parameters can you use to produce the results? Choose two.

AFloat

BBoolean

CDate

DDatetime

EString

FInteger

Answer : E, F

In the context of filtering data in Tableau, both string and integer parameters can be used to dynamically filter data. A string parameter can be used to filter text-based values, while an integer parameter is suitable for numerical values. In the provided dataset and result URLs, it appears that a unique identifier or key (which could be a string or integer) is being used to filter specific data entries.Reference:The information is based on the following sources:

An Introduction to Parameters in Tableau

Create Parameters - Tableau

Question 6

You want to create the following dashboard.

The dashboard will contain two sheets that will connect to the same data source. The top sheet will be configured to filter the bottom sheet.

When you click a category on the top sheet, the sheets must resize as shown in the following exhibit.

How should you lay out the objects on the dashboard?

ADrag a horizontal container to the dashboard and add both sheets to the container. Set the Fit to Standard.

BAdd both sheets to the dashboard. Set Fit to Fix width.

CDrag a blank object to the dashboard and add both sheets to the dashboard. Set Fit to Entire view.

DDrag a vertical container to the dashboard and add both sheets to the container. Set Fit to Entire view.

Answer : D

To create the dashboard as shown in the image, you need to use a vertical layout container that will adjust the height of the sheets according to the window size. You also need to set the Fit to Entire view option for both sheets so that they will resize proportionally when you click a category on the top sheet. This way, you can achieve the desired effect of having the bottom sheet expand to fill the space left by the top sheet when it filters out some categories.Reference:

Size and Lay Out Your Dashboard - Tableau

Create a Dashboard - Tableau

Format Dashboard Layout in Tableau - GeeksforGeeks

Question 7

You have two tables named Employeelnfo and DepartmentInfo. Employeelnfo contains four fields named Full Name, Department ID, Start Date, and Salary.

DepartmentInfo contains four fields named Department Name, Size, Department ID, and VP.

You want to combine the tables to meet the following requirements:

. Each record in Employeelnfo must be retained in the combined table.

. The records must contain the Department Name, Size, and VP fields.

* Every record must have a full name.

Which type of join should you use?

AInner

BLeft

CFull outer

DUnion

Answer : B

To combine the tables and meet the requirements, you should use a left join. A left join will keep all the records from the left table (Employeelnfo) and match them with the records from the right table (DepartmentInfo) based on the common field (Department ID). If there is no matching record in the right table, the fields from the right table will be null. This way, you will retain all the records from Employeelnfo, and also include the Department Name, Size, and VP fields from DepartmentInfo. Every record will have a full name because it is a field from the left table. A left join will look like this:

Join Your Data - Tableau

Join Types in Tableau

Tableau TDA-C01 Tableau Certified Data Analyst Exam Practice Test