Tableau Tableau Certifications TDS-C01 Questions & Answers

• Question 1:

  What does the box in a box plot represent?

  A. Maximum value of the data

  B. Minimum value of the data

  C. The interquartile range

  D. The median of the middle half of the data points

  Correct Answer: C

  In a box and whisker plot:

  1) The ends of the box are the upper and lower quartiles, so the box spans the interquartile range

  2) The median is marked by a vertical line inside the box

  3) The whiskers are the two lines outside the box that extend to the highest and lowest observations.

  

• Question 2:

  Which of the following are stored in a .tds file? Choose 3.

  A. Data Connection information

  B. Visualizations

  C. Calculated Fields

  D. Data Extracts

  E. Metadata edits

  Correct Answer: ACE

  If you've created a data connection that you might want to use with other workbooks or share with colleagues, you can export (save) the data source to a file. You might want to do this also if you've added joined tables, default properties, or custom fields--such as groups, sets, calculated fields, and binned fields--to the Data pane.

  

  Visualisations and Data extracts are NOT saved in a .tds file!

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

• Question 3:

  When there are both negative and positive values for a field, the default range of values will use two color ranges. This is known as a ______________ palette.

  A. reversed

  B. stepped

  C. diverging

  D. converging

  Correct Answer: C

  

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

• Question 4:

  Which of the following are valid ways to add Totals to a view?

  A. Using the Data Pane

  B. Using the Analytics Pane

  C. From the Analysis Tab in the Menu bar on top

  D. Using the Marks shelf

  Correct Answer: BC

  To add totals to a view using the Analytics pane

  Also, you can add totals from the Analytics tab in the Menu above:

  

• Question 5:

  ______________ refers to the level of detail for a piece of data, wherever you are looking.

  A. Data Cleanliness

  B. Data granularity

  C. Data connectivity

  D. Data LOD

  Correct Answer: B

  Data is generated and analyzed at many different levels of granularity. Granularity is the level of detail of the data. For example, when looking at graduation data, granularity would describe whether a row in the data set represents a single person or the graduating class of a university.

  Reference: https://www.tableau.com/about/blog/2018/6/data-prep-101-what-aggregate-function-and-how-do-you-combine-aggregated-data-89244

• Question 6:

  ________________ files are shortcuts for quickly connecting to the original data that you use often. Data source files do not contain the actual data but rather the information necessary to connect to the actual data as well as any modifications you've made on top of the actual data such as changing default properties, creating calculated fields, adding groups, and so on.

  A. .tbm

  B. .tds

  C. .tde

  D. .twb

  Correct Answer: B

  According to the official Tableau documentation:

  Tableau data source files have the .tds file extension. Data source files are shortcuts for quickly connecting to the original data that you use often. Data source files do not contain the actual data but rather the information necessary to connect to the actual data as well as any modifications you've made on top of the actual data such as changing default properties, creating calculated fields, adding groups, and so on. For more information, see Save Data Sources. Reference: https://help.tableau.com/current/pro/desktop/en-us/environ_filesandfolders.htm

• Question 7:

  True or False: When you drag additional tables to the logical layer canvas, Tableau automatically attempts to create the relationship based on existing key constraints and matching fields to define the relationship. If it can't determine the matching fields, then relating these tables is not possible.

  A. True

  B. False

  Correct Answer: B

  Tables that you drag to the logical layer of the Data Source page canvas must be related to each other. When you drag additional tables to the logical layer canvas, Tableau automatically attempts to create the relationship based on existing key constraints and matching fields to define the relationship. If it can't determine the matching fields, you will need to select them. If no constraints are detected, a Many-to-many relationship is created and referential integrity is set to Some records match. These default settings are a safe choice and provide the most a lot of flexibility for your data source.

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

• Question 8:

  Which of the following are valid ways to Bold the Tooltip content in Tableau?

  A. Click on Analysis, Tooltip options, and select bold.

  B. Click on Tooltip in the Marks card, and select bold.

  C. Click on Worksheet in the Menu bar, followed by Tooltip and select the bold option

  D. Right click, click format and then under the default worksheet formatting, choose Tooltip and make it bold.

  Correct Answer: BCD

  Lot of students have been seeing this question in the exam lately, and wanted me to include this question so here it is. Follow along1) Click on Worksheet in the Menu bar, followed by Tooltip and select the bold option

  

  

  2) Click on Tooltip in the Marks card, and select bold.

  

  

  3) Right click, click format and then under the default worksheet formatting, choose Tooltip and make it bold.

  

  A picture containing line chart

  

  There exists no option to Bold the tooltip contents by clicking Analysis. Hence, it is an incorrect choice.

• Question 9:

  Beginning in version 10.5, when you create a new extract, it uses the _________ format instead of the .tde format.

  A. .tds

  B. .tdex

  C. .hyper

  D. .twbx

  Correct Answer: C

  Beginning in version 10.5, when you create a new extract, it uses the .hyper format instead of the .tde format.

  Extracts in the .hyper format take advantage of the improved data engine, which supports the same fast analytical and query performance as the data engine before it, but for even larger extracts.

  Although there are many benefits of using .hyper extracts, the primary benefits include the following:

  1) Create larger extracts: You can create extracts with billions of rows of data. Because .hyper extracts can support more data, you can consolidate .tde extracts that you previously had to create separately into a single .hyper extract.

  2) Create and refresh extracts faster: While Tableau has always optimized performance for creating and refreshing extracts, version 2020.3 supports faster extract creation and refreshes for even larger data sets.

  3) Experience better performance when interacting with views that use extract data sources: Although smaller extracts continue to perform efficiently, larger extracts perform more efficiently.

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

• Question 10:

  To use a quick table calculation, which of the following programming languages do you need to know?

  A. ython

  B. Java

  C. Javascript

  D. None of these

  Correct Answer: D

  You don't need to know ANY programming language to use quick table calculations!

  Follow along with the steps below to learn how to apply a quick table calculation to a visualization:

  1) Open Tableau Desktop and connect to the Sample-Superstore data source, which comes with Tableau.

  2) Navigate to a new worksheet.

  3) From the Data pane, under Dimensions, drag Order Date to the Columns shelf.

  4) From the Data pane, under Dimensions, drag State to the Rows shelf.

  5) From the Data pane, under Measures, drag Sales to Text on the Marks Card.

  6) From the Data pane, under Measures, drag Profit to Color on the Marks Card.

  7) On the Marks card, click the Mark Type drop-down and select Square.

  

  The visualization updates to look like this:

  

  Apply the quick table calculation

  1) On the Marks card, right-click SUM(Profit) and select Quick Table Calculation > Moving Average.

  Note: You can only perform quick table calculations on measures in the view. A delta symbol appears on the field to indicate that a quick table calculation is being applied to the field. The colors in the visualization update to show the moving

  average of profit across the years.

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