Tableau Tableau Certifications TDS-C01 Questions & Answers

• Question 181:

  If you see a Blue field, generally it will add _____________ to the view

  A. axis

  B. both

  C. none

  D. headers

  Correct Answer: D

  Important question!

  

  Reference: https://help.tableau.com/current/pro/desktop/en-us/datafields_typesandroles.htm

• Question 182:

  Which of the following are True for Measure Names?

  A. It contains all the measures in your data, collected into a single field with continuous values.

  B. When you add it to a view, all of the measure names appear as row or column headers in the view.

  C. When working with a text table showing Profit for each Category, when you add Sales to the text table (by dragging it and dropping it in the view), the measure names field is automatically dragged to the row and filter shelves.

  D. It contains the names of all measures in your data, collected into a single field with discrete values.

  Correct Answer: BCD

  It contains all the measures in your data, collected into a single field with continuous values -This is the definition for 'Measure Values'.

  All others are True w.r.t. Measure Names!

  The Measure Names field contains the names of all measures in your data, collected into a single field with discrete values.

  

  Documentation : https://help.tableau.com/current/pro/desktop/en-us/datafields_understanddatawindow_meavalues.htm

• Question 183:

  If you use a percent difference Quick Table Calculation, what value will be the first data value?

  A. null

  B. -1

  C. 0000

  D. 0

  Correct Answer: A

  When using a Percent difference, Tableau calculates what the percent change has occured as compared to the last data value. BUT, for the first data value, there is no previous value to compare it to. Hence, it appears as NULL.

  

• Question 184:

  Which of the following are valid options to define the scope of a reference line? Choose 3.

  A. Pane

  B. Table

  C. Section

  D. Window

  E. cell

  F. Axis

  Correct Answer: ABE

  When we create a reference line, we get the following 3 options for the scope:

  

  Reference: https://help.tableau.com/current/pro/desktop/en-us/reference_lines.htm

• Question 185:

  Which of the following shapes does a Heat Map use by default?

  A. Square

  B. Line

  C. Text

  D. Circle

  Correct Answer: A

  By default, the shape that a Heap map uses is a "Square". See below: Reference: https://help.tableau.com/current/pro/desktop/en-us/buildexamples_highlight.htm

  

• Question 186:

  True or False: Trend lines can only be used with numeric or date fields

  A. True

  B. False

  Correct Answer: A

  You can show trend lines in a visualization to highlight trends in your data. To add trend lines to a view, both axes must contain a field that can be interpreted as a number. For example, you cannot add a trend line to a view that has the

  Product Category dimension, which contains strings, on the Columns shelf and the Profit measure on the Rows shelf.

  However, you can add a trend line to a view of sales over time because both sales and time can be interpreted as numeric values.

  Reference: https://help.tableau.com/current/pro/desktop/en-us/trendlines_add.htm

• Question 187:

  Given a map, which of the following fields can be placed in Size,Shape,Detail,Color

  A. Profit, State, Number of Records, Sales

  B. Region, Country, Profit, State

  C. Longitude, Country, State, Sales

  D. Sales, State, Country, Profit

  Correct Answer: D

  Since Sales is a measure, it can easily be depicted via size. To drill down and change the level of detail, Country is the correct choice since it will contain STATE. We can then depict the various states by different shapes such as circle,

  square etc.

  Finally, the Profit can be depicted via a color! Eg-Red for poor and green for excellent profits!

  Reference: https://www.tableau.com/learn/tutorials/on-demand/aggregation-granularity-and-ratio-calculations

• Question 188:

  Which of the following is NOT a valid official data source in Tableau Desktop?

  A. PostgreSQL

  B. SAP HANA

  C. Google Firebase

  D. Amazon Redshift

  Correct Answer: C

  Presently, there is no official way to connect your data in Firebase directly with Tableau Desktop.

  A workaround however can be to export your Firebase data into Google BigQuery, and then connect it to Tableau Desktop.

  But then again, it is a workaround and not an official out-of-the-box solution.

  The following are the available Data sources available as of now:

  1) Server

  

  2) File

  

• Question 189:

  Which of the following are FALSE about Joins?

  A. Joins can be defined at the time of query dynamically

  B. May drop unmatched measure values

  C. They are displayed with Venn diagram icons between physical tables

  D. Joined tables are never merged into a single table.

  E. They are a more dynamic way than relationships to combine data

  Correct Answer: ADE

  According to the official documentation:

  Joins are a more static way to combine data. Joins must be defined between physical tables up front, before analysis, and can't be changed without impacting all sheets using that data source. Joined tables are always merged into a single table. As a result, sometimes joined data is missing unmatched values, or duplicates aggregated values.

  Joins1) Are displayed with Venn diagram icons between physical tables 2) Require you to select join types and join clauses 3) Joined physical tables are merged into a single logical table with a fixed combination of data 4) May drop unmatched measure values 5) May duplicate aggregate values when fields are at different levels of detail 6) Support scenarios that require a single table of data, such as extract filters and aggregation

  Reference: https://help.tableau.com/current/online/en-us/datasource_relationships_learnmorepage.htm

• Question 190:

  What does the following icon do in Tableau? Larger image

  A. Create a Story

  B. Create a Story and Dashboard both

  C. Create a Worksheet

  D. Create a Dashboard

  Correct Answer: D

  The icon shown is used to add a new Dashboard! From the official documentation:

  

  Reference: https://help.tableau.com/current/pro/desktop/en-us/inspectdata_viewdata.htm