Page: 1
/ 14
Total 120 questions
Tableau TDA-C01 Tableau Certified Data Analyst Exam Practice Test
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?
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.
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 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.
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?
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:
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.
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
Question 6
You have the following dataset.
Which formula calculates the percent difference in sales relative to the same quarter the previous year as shown in the Calculation field?
Answer : B
The formula in option B calculates the percent difference in sales relative to the same quarter the previous year. It subtracts the sales of the same quarter from the previous year from the current year's sales, and then divides this by the previous year's sales. This gives a percentage change, which aligns with what is shown in the Calculation field of your dataset. The LOOKUP function returns the value of a specified offset from the current row in the partition. In this case, the offset is -4, which means the value of the same measure four rows above the current row. This corresponds to the same quarter of the previous year, assuming the data is sorted by quarter.Reference:
Tableau Certified Data Analyst Study Guide
Question 7
You are creating an annual report in Microsoft Word.
In Tableau Desktop, you build a chart in a worksheet.
You want to create an image of the chart that you can add to the annual report.
What are two ways to create the image? Choose two.
Answer : A, B
To create an image of the chart that you can add to the annual report, you can use either the Export option or the Copy option from the Worksheet menu. The Export option will allow you to save the image as a file in a specified location, name, and format. The Copy option will allow you to copy the image to the clipboard and paste it into another application, such as Microsoft Word. Both options will let you choose which elements to include in the image, such as title, caption, legend, etc.Reference:
Export Views from Tableau Desktop to Another Application
Copy and Paste Views from Tableau Desktop to Another Application
All Official Question Types