Tableau TDS-C01 Online Practice Questions and Exam Preparation

Tableau TDS-C01 Online Questions & Answers

• Question 231:

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

  A. Square
  B. Line
  C. Text
  D. Circle
  A. Square

  ---

  Explanation/Reference:

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

  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
  D. None of these

  ---

  Explanation/Reference:

  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

• Question 233:

  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.
  D. A new mark (bar) is created, which consolidates all members of the group.

  ---

  Explanation/Reference:

  *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 234:

  True or False: We can disaggregate the data, to see all of the marks in the view at the most detailed level of granularity

  A. True
  B. False
  A. True

  ---

  Explanation/Reference:

  Whenever you add a measure to your view, an aggregation is applied to that measure by default. This default is controlled by the Aggregate Measures setting in the Analysis menu. If you decide you want to see all of the marks in the view at

  the most detailed level of granularity, you can disaggregate the view. Disaggregating your data means that Tableau will display a separate mark for every data value in every row of your data source.

  To disaggregate all measures in the view:

  Clear the Analysis >Aggregate Measures option. If it is already selected, click Aggregate Measures once to deselect it.

  

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

• Question 235:

  You want to provide additional information when hovering over a field in the Data pane as shown in the following exhibit.

  

  What should you configure for the field?

  A. An alias
  B. A header label
  C. A default comment
  D. A hierarchy
  C. A default comment

  ---

  Explanation/Reference:

  https://shantikanhai.medium.com/learn-tableau-how-to-change-the-default-properties-for-a-data-field-e3a0bb8d98a4 Right-click on the data field in the Data pane and choose Default properties. Select comment and add the comment.

• Question 236:

  Which of the following are true about Dashboards in Tableau?

  A. Floating items can be layered over other objects
  B. Tiled items don't overlap
  C. A bar chart can be used a floating item
  D. None of these
  A. Floating items can be layered over other objects
  B. Tiled items don't overlap
  C. A bar chart can be used a floating item

  ---

  Explanation/Reference:

  From the official Tableau documentation:

  

  As we can see below, Bar charts can be used as a floating object.

  

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

• Question 237:

  

  You clicked Sheet 1 from the data source page, and now you have opened the Tableau Desktop workspace as shown above. What is the main thing that you do here?

  A. Clean the data
  B. Preview the data
  C. Create visualisations to analyze your data
  D. Rename the fields and change data types
  C. Create visualisations to analyze your data

  ---

  Explanation/Reference:

  The Tableau workspace consists of menus, a toolbar, the Data pane, cards and shelves, and one or more sheets. Sheets can be worksheets, dashboards, or stories. For details on dashboard or story workspaces, see Create a Dashboard or The Story Workspace.

  

  The main thing you do in the workspace is to create visualisations to analyze your data.

  Renaming data fields, cleaning the data, previewing the data can all be done in the Data source window.

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

• Question 238:

  How can you format numbers in Tableau as currency?

  A. Right-click a measure or axis in the view and select Format. Then in the Format pane, click the Numbers drop-down menu.
  B. Right-click on the data source used in the view and select Format. Then in the Format pane, click the Numbers drop-down menu.
  C. Right-click a dimension in the view and select Format. Then in the Format pane, click the Numbers drop-down menu.
  D. Right-click on the Sheet name and select Format. Then in the Format pane, click the Numbers drop-down menu.
  A. Right-click a measure or axis in the view and select Format. Then in the Format pane, click the Numbers drop-down menu.

  ---

  Explanation/Reference:

  According to the official Tableau documentation: Reference: https://help.tableau.com/current/pro/desktop/en-us/formatting_specific_numbers.htm

  

• Question 239:

  Using the Geo Data Table, create a Map showing Sales made per State. For the State of New York (NY), what was the amount in Sales ($) made for Phone Assortments with White color?

  A. $16,581
  B. (Correct)
  C. $147,950
  D. $48,115
  E. $33,768
  A. $16,581

  ---

  Explanation/Reference:

  Phew! Tricky one! You needed to use filters in this one. Follow along:

  

  2) Next, as the question mentions, we need to focus on the Assortment PHONE, the color WHITE, and the state of NEW YORK.-> so we use filters for this! i) First drag Assortment to Filters, and select only Phones :

  

  ii) Next, drag Color to Filters and Choose only White:

  

  iii) Next, drag State ID to Filters, and choose New York (NY):

  

  And Voila! We have our answer as follows:

  

  iv) Last, drag Sales to Label

• Question 240:

  In order to avoid any confusions, what should you do after creating a Dual-axis chart?

  A. Hide the axis
  B. Change the colours
  C. Synchronise the axis
  D. Edit the labels
  C. Synchronise the axis

  ---

  Explanation/Reference:

  After creating a dual axis chart, make sure to synchronise their axis since they both might not be having the same y-axis.

  

  , chart, line chart

  To align the two axes in a dual axes chart to use the same scale, right-click (control-click on Mac) the secondary axis, and select Synchronize Axis. This aligns the scale of the secondary axis to the scale of the primary axis. In this example,

  the Sales axis is the secondary axis and the Profit axis is the primary axis. If you would like to change which axis is the primary, and which axis is the secondary, select the field on the Columns or Rows shelf that is the secondary, and drag it

  in front of the primary field on the shelf until you see an orange triangle appear.

  In this example, you can select the SUM(Sales) field on the Rows shelf, and drag it in front of the SUM(Profit) field. The Sales axis is now the primary and the Profit axis is the secondary.

  

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