Tableau TDS-C01 Online Practice Questions and Exam Preparation

Tableau TDS-C01 Online Questions & Answers

• Question 21:

  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
  A. Joins can be defined at the time of query dynamically
  D. Joined tables are never merged into a single table.
  E. They are a more dynamic way than relationships to combine data

  ---

  Explanation/Reference:

  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 22:

  When should you use a relationship instead of a join for two data sets?

  A. To use both data sets across multiple sheets in a visualization.
  B. The data sets are in two separate tables within a single spreadsheet.
  C. The data sets include similar data aggregated at different levels of detail.
  D. The data sets include similar data aggregated up to the highest level.
  C. The data sets include similar data aggregated at different levels of detail.

  ---

  Explanation/Reference:

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

• Question 23:

  True or False: All rows from both tables are returned in an INNER JOIN

  A. True
  B. False
  B. False

  ---

  Explanation/Reference:

  The INNER JOIN keyword selects all rows from both tables as long as there is a match between the columns. Consider 2 tables "Orders" and "Customers". If there are records in the "Orders" table that do not have matches in "Customers", these orders will not be shown!

  

  Reference: https://www.w3schools.com/sql/sql_join_inner.asp

• Question 24:

  What is the minimum amount of RAM recommended for any production use of Tableau Server?

  A. 8GB
  B. 16GB
  C. 32GB
  D. 64GB
  B. 16GB

  ---

  Explanation/Reference:

  The computer on which you are installing or upgrading Tableau Server must meet the minimum hardware requirements. If the Setup program determines that your computer does not meet the following requirements, you will not be able to install Tableau Server. These minimum requirements are appropriate for a computer that you use for prototyping and testing of Tableau Server. They apply to single-node installations and to each computer in a distributed installation.

  

  Reference: https://help.tableau.com/current/server/en-us/server_hardware_min.htm

• Question 25:

  True or False: The Highlighting action can be disabled for the entire workbook.

  A. True
  B. False
  A. True

  ---

  Explanation/Reference:

  Yes, it is possible to disable highlighting for the entire workbook.

  

  For more information : https://help.tableau.com/current/pro/desktop/en-gb/actions_highlight.htm

• Question 26:

  Which of the following represent a valid method to create a Bullet Graph with the LEAST number of fields possible?

  A. using 2 measures
  B. using 2 dimensions
  C. using 2 dimensions and 3 measures
  D. using 1 measure
  A. using 2 measures

  ---

  Explanation/Reference:

  A bullet graph is a variation of a bar graph developed to replace dashboard gauges and meters. A bullet graph is useful for comparing the performance of a primary measure to one or more other measures. Below is a single bullet graph showing how actual sales compared to estimated sales.

  We can create a Bullet graph with just 2 measures! This method requires the LEAST number of fields possible to create this type of chart. The best way to tackle such questions in the exam is to click the "SHOW ME" button on top right, and hover over the chart we want to create.

  In our case, it is a Bullet graph.

  

  

  Therefore, we need 2 measures at least to create this chart, and 0 or more dimensions.

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

• Question 27:

  What are two use cases for creating hierarchies from the Data pane? (Choose two.)

  A. To organize related fields together
  B. To add drilldown functionality for fields
  C. To create faster-performing queries
  D. To concatenate all fields into a single field
  A. To organize related fields together
  B. To add drilldown functionality for fields

• Question 28:

  ______________ is a method for appending values (rows) to tables. You can use this method if both tables have the same columns. The result is a virtual table that has the same columns but extends vertically by adding rows of data.

  A. Joining
  B. Blending
  C. Combining
  D. Unioning
  D. Unioning

  ---

  Explanation/Reference:

  Unioning is the correct answer! From the official documentation:

  

  For example, suppose you have the following customer purchase information stored in three tables, separated by month. The table names are "May2016" , "June2016" and "July2016."

  

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

• Question 29:

  You have the following legend.

  

  What occurs when you click the icon to the right of Air Ticketing Cabin Type Name?

  A. The legend toggles on or off
  B. The highlighter toggles on or off
  C. The filter options open
  D. The Edit Colors dialog box opens
  B. The highlighter toggles on or off

  ---

  Explanation/Reference:

• Question 30:

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

  A. axis
  B. both
  C. none
  D. headers
  D. headers

  ---

  Explanation/Reference:

  Important question!

  

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