Tableau Tableau Certifications TDA-C01 Questions & Answers

• Question 1:

  You need to change the values of a dimension without creating a new field. What should you do?

  A. Rename the fields

  B. Create aliases

  C. Create groups

  D. Transforms the fields

  Correct Answer: B

  Explanation: 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".

  In Tableau, aliases can be used to change the way dimension members appear without altering the underlying data. This is useful for display purposes and does not create a new field within the dataset.

• Question 2:

  You have the following dataset.

  

  When you use the dataset in a worksheet, you want Sales to appear automatically as shown in the following table.

  

  What should you do?

  A. Change the data type of the Sates field to Siring

  B. Create a calculated field that uses a formula of 'S' * str (Round((sales],2)) + 'k'

  C. Change the default number format of the Sales told

  D. Create a calculated field that uses a formula of 'S' + stri < (Sales)/1000)).

  Correct Answer: A

• Question 3:

  You have the following dataset.

  

  You plan to create a dashboard that will be filtered to show only data that is relevant to a specific Tableau user based on the Tableau_User_Name field You need to create a boolean calculated field to place on the data source finer Which formula should you use for the filter?

  A. NAMEUSERNAME()

  B. ISFULLNAMETableu_USER_NAME))=USERNAME()

  C. NAME Tableau-USER-NAME)

  D. USERNAME()=(Tableau_USER_NAME)

  Correct Answer: C

• Question 4:

  You have a dataset that contains people and the awards they have won.

  

  Which formula should you use to get the number of different types of awards that have been won?

  A. COVAR({Award})

  B. COUNTD({Award})

  C. COUNTD {(NAME])

  D. MAX {(Award})

  E. INDEX()

  Correct Answer: C

• Question 5:

  You have the Mowing two tables that contains data about the books in a library.

  

  Both tables are incomplete so there are books missing from the tables.

  You need to combine the tables. The solution must ensure that all the data is retained

  Which type of join should you use?

  A. Full outer join

  B. Right join

  C. left join

  D. Inner join

  Correct Answer: D

• Question 6:

  You have a data source that contains data tor every city in the Unites States. The following is a sample of the data.

  

  You need to use the City dimension to create a dynamic filter that snows the cities that have a population greater than one million Which type of filter should you use?

  A. General filter

  B. Wildcard filter

  C. Top filter

  D. Condition filter

  Correct Answer: C

• Question 7:

  You have the following visualization.

  

  The Last() calculation is set to compute using Table (across)

  Which value will appear in the crosstab for the Consumer segment of the year 2018 if you change compute to use Oder Dale?

  A. 0

  B. 2

  C. 4

  D. 3

  Correct Answer: A

• Question 8:

  From Tableau Desktop you sign in lo a Tableau Server site.

  What appears in the list of available data sources when you search for a published data source?

  A. All the data sources published to the site

  B. All the data sources published to the Tableau Server

  C. All the data sources published to the site within the folders to which you have access

  D. All the data sources published to the Tableau Server within the folders to which you have access

  Correct Answer: D

• Question 9:

  You create a parameter named Choose Region fiat contains values from a field named Region.

  You want users to be able to use the Choose Region parameter to interact with a chart by logging between different regions

  What should you do next?

  A. Add Region to me Fitters card

  B. Add the [Region] = [choose Region) formula to the Filters card

  C. Add the Choose Region parameter to the Pages card

  D. Set the Choose Region parameter to Single Value (list)

  Correct Answer: A

• Question 10:

  You want to add a draft watermark to a dashboard as shown in the following exhibit.

  

  Which type of object should you use?

  A. Image

  B. Sheet

  C. Web page

  D. Horizontal

  Correct Answer: C