Tableau Tableau Certifications TDS-C01 Questions & Answers

• Question 121:

  Which of the following points are True about Viz Animations?

  A. Sequential animations take more time but make complex changes clearer by presenting them step-by-step

  B. They can be turned on for certain worksheets only

  C. Animations work well with maps, polygons, and density marks in web browsers

  D. It is possible to turn them on for the entire workbook at once

  Correct Answer: ABD

  All of the given options are true except-Animations work well with maps, polygons, and density marks in web browsers. From the official documentation:

  

  As seen above, we can either turn the animations for the entire workbook (upper red box), or only for the current sheet ( lower red box )

  1) Simultaneous animations

  The default simultaneous animations are faster and work well when showing value changes in simpler charts and dashboards.

  2) Sequential animations

  Sequential animations take more time but make complex changes clearer by presenting them step-by-step.

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

• Question 122:

  The default path for all supporting files, data sources, icons, logs etc is in ______________________

  A. Documents-> Tableau Files

  B. Documents-> Tableau

  C. Documents-> My Tableau Repository

  D. Downloads-> Tableau Support Files

  Correct Answer: C

  By default, all of the above mentioned are stored in Documents-> My Tableau Repository Reference: https://help.tableau.com/current/pro/desktop/en-us/environ_filesandfolders.htm

• Question 123:

  Is it possible to use measures in the same view multiple times (e.g. SUM of the measure and AVG of the measure)?

  A. Yes

  B. No

  Correct Answer: A

  Yes, it is very much possible to use measures in the same view multiple times. For example, refer to the image below:

  

  We are using BOTH the Sum of the revenue and the AVG of the revenue in the same view!

• Question 124:

  By default, measures placed in a view are aggregated. The type of aggregation applied ______________

  A. is always sum

  B. depends on the context of the view

  C. is always COUNT

  D. is always AVERAGE

  Correct Answer: B

  By default, measures placed in a view are aggregated. Mostly you'll notice that the aggregation is SUM, but not ALWAYS.

  The type of aggregation applied varies depending on the context of the view.

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

• Question 125:

  When using a Blend, what is the color of tick-mark on the primary and secondary data sources respectively?

  A. Red, Blue

  B. Orange, Blue

  C. Blue, Red

  D. Blue, Orange

  Correct Answer: D

  When using a Blend, the primary data source appears with a BLUE tick-mark and the secondary data source appears with a ORANGE tick-mark. See below:

  

  Reference: https://www.tutorialspoint.com/tableau/tableau_data_blending.htm

• Question 126:

  What will the following function return? LEFT("Tableau", 3)

  A. An error

  B. Tab

  C. eau

  D. ble

  Correct Answer: B

  The following is the official documentation for the String function LEFT:

  

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

• Question 127:

  What does the following marker/icon do in Tableau?

  

  A. Format the Legends

  B. Edit the Colors

  C. Toggle the highlighting on/off.

  D. Highlight the largest value

  Correct Answer: C

  The correct answer is Toggle the highlighting ON/OFF. If selected, whichever value you choose from this legend will be highlighted in the view. However, if it is deselected, then even if you choose a value in the Legend, it will NOT be highlighted.

  See below:

  

  

• Question 128:

  True or False: LEFT JOIN returns all rows from the left table, with the matching rows in the right table

  A. True

  B. False

  Correct Answer: A

  This is true, indeed!

  The LEFT JOIN keyword returns all records from the left table (table1), and the matched records from the right table (table2). The result is NULL from the right side, if there is no match.

  

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

• Question 129:

  The row and column shelves contain ___________________

  A. Pills

  B. Grand Totals

  C. Filters

  D. Parameters

  Correct Answer: A

  We can drag fields from the Data pane to create the structure for your visualizations. The Columns shelf creates the columns of a table, while the Rows shelf creates the rows of a table. You can place any number of fields on these shelves. These FIELDS are also referred to as PILLS. See below:

  

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

• Question 130:

  Which of the following is a good reason for using a bullet graph?

  A. Comparing the actual sales against the target sales

  B. Analysing the trend over a given time period

  C. Forecasting future sales

  D. Displaying the year-on-year growth in sales

  Correct Answer: A

  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.

  

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