Page: 1
/ 14
Total 100 questions
Tableau TDA-C01 Tableau Certified Data Analyst Exam Practice Test
Question 1
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 2
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 3
You have the following dataset:
Which grouping option should you use in Tableau Prep to group all five names automatically?
Answer : D
Common Characters: Find and group values that have letters or numbers in common. This option uses the ngram fingerprint algorithm that indexes words by their unique characters after removing punctuation, duplicates, and whitespace. This algorithm works for any supported language. This option isn't available for data roles. For example, this algorithm would match names that are represented as 'John Smith' and 'Smith, John' because they both generate the key 'hijmnost'. Since this algorithm doesn't consider pronunciation, the value 'Tom Jhinois' would have the same key 'hijmnost' and would also be included in the group.
Question 4
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?
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 5
You are subscribed to several views.
You need to unsubscribe from the views.
What should you use?
Answer : A
To unsubscribe from the views, you should use the My Content area of Tableau web pages. This area allows you to manage your subscriptions, as well as your workbooks, views, and data sources. You can select the views you want to unsubscribe from, click Actions, and then click Unsubscribe. You can also change the subscription options, such as the schedule, the format, or the message.Reference:
Create a Subscription to a View or Workbook - Tableau
Tableau Certified Data Analyst Study Guide
Question 6
You have the following visualization.
You Create a table calculation named Rank_Score that has a formula of RANK(AVG([Score]), and you drag Rank_Score to Text on the Marks cards.
What is the Rank Score value for Student ID 4220?
Answer : D
the rank function returns the rank of each row within the partition of a result set. The rank of a row is one plus the number of ranks that come before the row in question.
To answer your question, we need to apply the rank function to the Avg Score column and sort it in descending order. Then we can find the rank score value for Student ID 4220 by looking at the corresponding row.
Here is how the table would look like after applying the rank function and sorting:
As you can see, the rank score value for Student ID 4220 is1.
Question 7
You need to change the values of a dimension without creating a new field.
What should you do?
Answer : B
You can create aliases for the members of a dimension by right-clicking the dimension in the Data pane or in the view and selecting Aliases. This changes how the values are displayed in the view, but not the underlying data. For example, you can create an alias for ''Central'' as ''Midwest''.
All Official Question Types