Tableau TDS-C01 Online Practice Questions and Exam Preparation

Tableau TDS-C01 Online Questions & Answers

• Question 41:

  We can join a maximum of ______ tables in Tableau

  A. 16
  B. 32
  C. 64
  D. 128
  B. 32

  ---

  Explanation/Reference:

  It is possible to join a maximum of 32 tables in Tableau!

  Reference: https://www.mytectra.com/interview-question/tableau-interview-question-and-answers

• Question 42:

  Dragging a ______________ to colour creates distinct colours for each item whereas dragging a ______________ to colour creates a gradient

  A. Discrete value, Continuous Value
  B. Geographic Value, Discrete Value
  C. Continuous Value, Discrete Value
  D. Longitude, Latitude
  A. Discrete value, Continuous Value

  ---

  Explanation/Reference:

  Remember that dragging a discrete value to colour creates distinct colours for each item whereas dragging a continuous value to colour creates a gradient. ( Same for Map ) From the official documentation:

  

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

• Question 43:

  You have a group that contains three members and the Other group. What occurs when you ungroup one of the members?

  A. The group is deleted
  B. The member is added to Other
  C. A new group that contains only the removed member is created
  D. The member remains a member of the dimension but is removed from the group
  B. The member is added to Other

  ---

  Explanation/Reference:

  B - The member is added to the Other group https://help.tableau.com/current/pro/desktop/en-us/sortgroup_groups_creating.htm

• Question 44:

  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
  A. Comparing the actual sales against the target sales

  ---

  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.

  

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

• Question 45:

  Which two options can you use to change the device layout of a dashboard? (Choose two.)

  A. The Layout pane
  B. The Dashboard menu
  C. The Dashboard pane
  D. The Format menu
  B. The Dashboard menu
  C. The Dashboard pane

• Question 46:

  When field names in the Union do not match, then:

  A. An error is raised and both fields are dropped from the resulting Union
  B. Only one field name is present in the Union with null values
  C. Only one field name is present in the Union with correct values since Tableau automatically corrects field name mismatch
  D. Both field names are present in the Union, but contain several null values
  D. Both field names are present in the Union, but contain several null values

  ---

  Explanation/Reference:

  By default, both field names are present in the Union, but contain several null values!

  When field names in the union do not match, fields in the union contain null values. You can merge the non-matching fields into a single field using the merge option to remove the null values. When you use the merge option, the original fields

  are replaced by a new field that displays the first non-null value for each row in the non-matching fields. You can also create your own calculation or, if possible, modify the underlying data to combine the non-matching fields.

  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."

  

  A union of these tables creates the following single table that contains all rows from all tables.

  

  Now suppose a fourth table, "August2016", is added to the underlying data. Instead of the standard "Customer" field name, it contains an abbreviated version called "Cust."

  

  

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

• Question 47:

  A field that shows average home values for the United States in 2016 is most likely :

  A. A discrete date part dimension
  B. A continuous date value dimension
  C. A geographical dimension
  D. An aggregated measure
  D. An aggregated measure

  ---

  Explanation/Reference:

  This question is directly from the Official Tableau Desktop Specialist exam guide. Since we are talking about the AVERAGE home values for the United States in 2016, the question is directly offering us a hint that the answer has something to do with aggregation and that too the values tell us that we're working with MEASURES. Date part and Date values don't really make much sense given the question, and neither does geography.

  Therefore, the answer naturally is "An aggregated measure".

• Question 48:

  If you have a dashboard and are displaying its filter, how can you rearrange it?

  A. By clicking on the 2 lines on top and dragging the filter.
  B. By clicking on the dropdown and dragging the filter
  C. By clicking on the filter title and dragging it.
  D. By clicking anywhere inside the filter and dragging it.
  A. By clicking on the 2 lines on top and dragging the filter.

  ---

  Explanation/Reference:

  You can drag the filter by clicking on the 2 lines on top, and then dragging the filter as shown:

  

• Question 49:

  True or False: It is not possible to blend axes for multiple measures into a single axis

  A. False
  B. True
  A. False

  ---

  Explanation/Reference:

  We can very much blend multiple measures into a single axis. Such charts are called Combined-Axis / Blended-Axis charts. Follow along:

  Measures can share a single axis so that all the marks are shown in a single pane. To blend multiple measures, drag one measure or axis and drop it onto an existing axis.

  Instead of adding rows and columns to the view, when you blend measures there is a single row or column and all of the values for each measure is shown along one continuous axis. For example, the view below shows quarterly sales and

  profit on a shared axis.

  

  Note: If you drag a measure on to the canvas and only see a single ruler indicator instead of the double ruler indicator shown below, Tableau creates dual axes instead of a blended axis. For more information about how to create dual axes, see Compare two measures using dual axes.

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

• Question 50:

  If you decide you want to see all of the marks in the view at the most detailed level of granularity, you can __________________ the view.

  A. sort the measures
  B. disaggregate the measures
  C. break-down the measures
  D. aggregate the measures
  E. split the measures
  B. disaggregate the measures

  ---

  Explanation/Reference:

  

  The different aggregations available for a measure determine how the individual values are collected: they can be added (SUM), averaged (AVG), or set to the maximum (MAX) or minimum (MIN) value from the individual row values. For a

  complete list of the available aggregations, check out-List of Predefined Aggregations in Tableau.

  The level of detail is determined by the dimensions in your view--for information about the concept of level of detail, see How dimensions affect the level of detail in the view. Disaggregating your data can be useful for analyzing measures that

  you may want to use both independently and dependently in the view. For example, you may be analyzing the results from a product satisfaction survey with the Age of participants along one axis. You can aggregate the Age field to determine

  the average age of participants or disaggregate the data to determine at what age participants were most satisfied with the product. Disaggregating data can be useful when you are viewing data as a scatter plot. See Example: Scatter Plots,

  Aggregation, and Granularity.

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