Tableau Tableau Certifications TDS-C01 Questions & Answers

• Question 191:

  _____________ contains the visualisations, info needed to build the visualisations, and a copy of the data source.

  A. Tableau Data Extract (.tde)

  B. Tableau Packaged Workbook (.twbx)

  C. Tableau Bookmark (.tbm)

  D. Tableau Workbook (.twb)

  Correct Answer: B

  TWBX is all in one. It contains viz, info needed to build the viz, and a copy of the data source. It doesn't contain extracts of the data but can contain both live and data extracts. Best if want to eliminate the barrier of data access.

  Create a .twbx with file-based data sources

  1) Select File > Save As.

  2) Specify a file name for the packaged workbook in the Save As dialog box.

  

  3)Select Tableau Packaged Workbooks on the Save as type drop-down list. 4) Click Save. 5) The default location is the Workbooks folder of the Tableau repository. However, you can save packaged workbooks to any directory you choose. The following files are included in packaged workbooks: --> Background images --> Custom geocoding --> Custom shapes --> Local cube files --> Microsoft Access files --> Microsoft Excel files --> Tableau extract files (.hyper or .tde) --> Text files (.csv, .txt, etc.)

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

• Question 192:

  A ________________ is a single zip file that contains a workbook along with any supporting local file data and background images. This format is the best way to package your work for sharing with others who don't have access to the original data.

  A. .twbx file

  B. .tbm file

  C. .twb file

  D. .tde file

  Correct Answer: A

  According to the official Tableau documentation:

  Tableau packaged workbooks have the .twbx file extension. A packaged workbook is a single zip file that contains a workbook along with any supporting local file data and background images. This format is the best way to package your work for sharing with others who don't have access to the original data. For more information, see Packaged Workbooks. Reference: https://help.tableau.com/current/pro/desktop/en-us/environ_filesandfolders.htm

• Question 193:

  For which of the following charts, does the Size option on the Marks card not work?

  A. Gantt Chart

  B. Bar Chart

  C. Tree Map

  D. Pie Chart

  Correct Answer: C

  You can adjust the size for all charts except the Tree Map. You use dimensions to define the structure of the treemap, and measures to define the size or color of the individual rectangles. Treemaps are a relatively simple data visualization

  that can provide insight in a visually attractive format.

  In a Tree Map, the measure itself defines the size and colour! The greater the sum of Measure for each category, the darker and larger its box.

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

• Question 194:

  Which of the following are valid reasons to use a Tableau Data Extract (.tde) over Live Connections?

  A. To support additional functionality such as count distinct

  B. Fast to create

  C. Help improve performance

  D. To have access to the freshest possible data at all times

  Correct Answer: ABC

  From the official documentation, the following are the major advantages of using Tableau Data Extracts:

  

  From Tableau 2020.2 onwards, .hyper is the recommended way since it is faster than .tde! Reference: https://help.tableau.com/current/pro/desktop/en-us/extracting_data.htm

• Question 195:

  Suppose you have a bar chart. When we group by labels in a view, which of the following happens?

  A. Nothing changes in the view, but a group is created in the Dimensions shelf.

  B. The colours of the members selected are now the same, and different for the rest of the members.

  C. Trick question! It is not possible to group by labels.

  D. A new mark (bar) is created, which consolidates all members of the group.

  Correct Answer: D

  *Very important question*

  If we select the labels in the view and then group, a new consolidated mark is created -in our case bar since we are talking about a bar chart in the question. See below:

  

  Then on grouping, a new bar is created, and the colour of all bars remain the same.

  

  Had we grouped by choosing the marks instead of the labels, the following would be the result:

  

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

• Question 196:

  Which of the following are true about dimensions?

  A. They contain contain numeric, quantitative values

  B. They contain qualitative values (such as names, dates, or geographical data)

  C. They affect the level of detail in the view

  D. Dates are mostly placed in dimensions by default for relational data sources

  Correct Answer: BCD

  

  

  Measures contain numeric quantitative values hence that option is incorrect.

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

• Question 197:

  __________ is a technique in Tableau which will identify marks with similar characteristics

  A. Clustering

  B. Grouping

  C. Sets

  D. Union

  Correct Answer: A

  Cluster analysis partitions marks in the view into clusters, where the marks within each cluster are more similar to one another than they are to marks in other clusters.

  

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

• Question 198:

  Which of these is NOT a type of Quick Filter available in Tableau?

  A. Wildcard Match

  B. Multiple Values (dropdown)

  C. Regex Match

  D. Single Value (slider)

  Correct Answer: C

  Upon clicking on a filter, we see the following options: Clearly, Regex Match is not one of these options!

  

• Question 199:

  Which of the following are required to create a trend line?

  A. 2 measures on opposing axes, or a date and a measure on opposing axes.

  B. 1 measure, or a date and a dimension on opposing axes.

  C. 1 measure only

  D. 2 dimensions, or a date and a dimension on opposing axes.

  Correct Answer: A

  To create a trend line, we need:

  

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

• Question 200:

  Using the atheletes table:

  i) Create a sheet with a crosstab showing the Average weight for each sport (Sheet 1)

  ii) Create a sheet with a Map showing the Total number of gold medals per Country. Use size as a Mark. (Sheet 2)

  Now, Create a Dashboard containing both these sheets, and Use Sheet 2 as a Filter for Sheet 1. What was the average weight for Badminton in Russia?

  (Ignore any nulls / unknowns)

  A. 76.25

  B. 65.67

  C. 68.77

  D. 4.87

  Correct Answer: A

  Pretty common question on the Tableau Desktop Specialist exam.

  1) First, lets create Sheet 1. For this, drag sport to the Row shelf, and Weight to the Text mark in the Marks shelf. Change its aggregation to Average:

  

  2) Now, for sheet 2-Drag nationality to the view, and gold to the size mark in the Marks shelf.

  NOTE: Depending on your version of Tableau , you may need to assign a Geographical role to the nationality column first as follows:

  

  3) Now, let's create a dashboard, and use both these sheets in it:

  

  4) Now, for the most Important step, use SHEET 2 AS A FILTER FOR SHEET 1 as follows:

  

  Now simply click on Russia in Sheet 2, and Sheet 1 will automatically update as follows: