Tableau Tableau Certifications TDA-C01 Questions & Answers

• Question 11:

  You have the following dataset.

  

  Which grouping option should you use m Tableau Prep to group al five names automatically?

  A. Pronunciation

  B. Spelling

  C. Common Characters

  D. Manual Selection

  Correct Answer: D

• Question 12:

  You have the following chart that shows the cumulative of sales from various dates.

  

  You want the months to appear as shown in the following chart.

  

  What should you do?

  A. Convert the date to Exact Date

  B. Convert the date to Continuous

  C. Select Show Misting Values for the dale

  D. Convert the date to Attribute

  Correct Answer: B

• Question 13:

  You have the following bar chart.

  

  You want the chart to appear as shown in the Mowing exhibit.

  

  What should you add?

  A. A reference band

  B. A reference line

  C. An average line

  D. A distribution band

  Correct Answer: A

• Question 14:

  You have the following chart that shows profits and discounts over time.

  

  You need to combine the lines to appear as shown in the following chart.

  

  What should you do?

  A. Drag Discount to Color on the Marks card

  B. Convert Discount to Discrete C. Set Discount to Dual Axis

  D. Drag Discount to the Columns shelf

  Correct Answer: A

• Question 15:

  You have a dataset that contains sates data. The following is a sample of the data.

  

  You need to return a value of true if a month has sales greater than $50 000. otherwise the formula must return a value of false. Which two formulas achieve the goal Choose two

  A. SUM{[Sales]) IN (50000)

  B. IIF(SUM< [Sales] )>50000, TRUE, FALSE)

  C. MAX< [Sales], 50000)

  D. [Sales] > 50000

  Correct Answer: BD

• Question 16:

  You have the following dataset that contain null values in the Profits field.

  

  You want the data to appear as shown in the following table.

  

  Which two formulas achieve the goal? Choose two.

  A. ZN ([Profits])

  B. ISNULL ([Profits])

  C. IFNULL [(profits] ,0)

  D. IF [Profits] != null then [Profits] END

  Correct Answer: AC

• Question 17:

  You publish a dashboard tut uses an attract. The extract refreshes every Monday at 10:00. You need to ensure that the extract also refreshes on the last day of the month at 18:00. What should you do?

  A. From Tableau Desktop, open the Publish Workbook dialog box and configure the schedule.

  B. From Tableau Server select the workbook select Refresh Extracts and then add a new extract refresh

  C. From Tableau Server. select Schedules find the schedule of the extract, and change the frequency to the Last day of the month

  D. From Tableau Server. select Schedules and change the priority of the existing schedule

  Correct Answer: C

• Question 18:

  You have the following dataset in Microsoft Excel.

  

  You are using interpreter to cleans the dataset. Data interpreter provides the following results.

  

  How many rows of data will be ingested into Tableau as values?

  A. 10

  B. 20

  C. 17

  D. 15

  Correct Answer: C

• Question 19:

  You have a Tableau workbook that contain three worksheets named Sheet1 Sheet2 and Sheet3.

  You create several filters.

  From the Data Source page you plan to add data source fillers When type of filter will appear in the Edit Data Source Filters dialog box?

  A. A table calculation filter used on Sheet

  B. A top N condition filer on a dimension in Sheet 1 and Sheet2

  C. A context filler on a dimension m Sheet3

  D. A dimension Maw on all the sheets

  Correct Answer: B

• Question 20:

  In which throe formats can you export a worksheet from the Worksheet menu? Choose three

  A. .png

  B. .html

  C. .xlsx

  D. .txt

  E. .pptx

  F. .csv

  Correct Answer: BDF