Tableau TDS-C01 Online Practice Questions and Exam Preparation

Tableau TDS-C01 Online Questions & Answers

• Question 221:

  Our use case states that we need to create a set showing the Bottom 10 products by Profit in each Region. Which of the following filter types should you apply on Region?

  A. Measure Filters
  B. Context Filters
  C. Extract Filters
  D. Dimension Filters
  B. Context Filters

  ---

  Explanation/Reference:

  The beauty of context filters is that according to Tableau's Order of Operations, they are executed before Sets.

  

  Diagram

  This means that based on what Region's you've selected-Tableau will first only preserve the rows for those Regions. THEN, after this it will compute the Set , i.e , Bottom 10 products in each Region.

  1) First let's create a set to compute the Bottom 10 Products by Profit.

  

  2) Next, take region on the Rows Shelf followed by the Set we just created. Drag Region and the Set to the Filters Shelf as well.

  

  3) Now, try to only visualize the data for the South Region:

  

  4) The problem right now is that Tableau is computing the Set first (Bottom 10 Products), and then applying the Dimension Filter-South Region and hence these values are incorrect. Note how these aren't even 10 products, but rather just 8. To fix this, simply add Region to Context:

  

  Upon doing this, we get the correct answer as :

  

  References: https://help.tableau.com/current/pro/desktop/en-us/order_of_operations.htm https://help.tableau.com/current/pro/desktop/en-us/filtering_context.htm

• Question 222:

  The calculation [Ship Date]-[Order Date] will return _______________

  A. Number of orders placed in that duration
  B. Number of days between these dates
  C. Number of unique orders placed between these dates
  D. Number of orders shipped between these dates
  B. Number of days between these dates

  ---

  Explanation/Reference:

  As the names suggest, if we subtract the order date from the shipping date, we simply get the number of days between these 2 dates. We can these use this calculated field in our charts, and can use COUNT, SUM, AVG etc with them according to our need.

• Question 223:

  Which of the following are valid ways to show Mark Labels in the visualisation?

  A. Click on the Show mark labels icon in the Toolbar
  B. Drag the measure to the Text label in the Marks Card
  C. Click on Data in the Menu bar and Choose Show Mark Labels
  D. Click on Analysis in the Menu bar and choose Show Mark Labels
  A. Click on the Show mark labels icon in the Toolbar
  B. Drag the measure to the Text label in the Marks Card
  D. Click on Analysis in the Menu bar and choose Show Mark Labels

  ---

  Explanation/Reference:

  The following showcase how you can show mark labels. Using the Sample Superstore dataset: 1) Let's create a Bar chart showing the sales for each sub-category:

  

  2) Now you can show labels by:

  2.1) Click on Show Mark Labels Icon in the Toolbar ( easiest )

  

  2.2) Drag Sales to the Text icon in the Marks Card 2.3) Click on Analysis-> Show mark labels from the Tableau menu bar

• Question 224:

  Which of the following 2 fields CANNOT be deleted in Tableau?

  A. Number of Records
  B. Measure Names
  C. Measure Values
  D. Calculated Fields
  B. Measure Names
  C. Measure Values

  ---

  Explanation/Reference:

  Measure names and values CANNOT be deleted in Tableau like other columns can. These are auto-generated. Calculated Fields, and Number of records can both be deleted.

• Question 225:

  Join the Geo Data and Time Series Table on the Item Number ID column, and display the Store count for every State on a Map. What was the Store count in 2017 for Texas (TX)?

  A. 592,593
  B. 293,202
  C. 416,702
  D. 336,908
  C. 416,702

  ---

  Explanation/Reference:

  Since you need BOTH State and the YEAR, we need to use an Inner Join.

• Question 226:

  You need to invert the color intensity of a quantitative range. Which option should you use?

  A. Border
  B. Reversed
  C. Opacity
  D. Stepped Color
  B. Reversed

  ---

  Explanation/Reference:

  Select Reversed to invert the order of colors in the range. For example, if you want lower values to have a darker intensity in a sequential palette, reverse the palette. For a diverging palette, reversing the color palette means swapping the two colors in the palette, in addition to inverting the shades within each color range.

• Question 227:

  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
  A. Yes

  ---

  

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

• Question 228:

  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
  C. The interquartile range

  ---

  Explanation/Reference:

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

  How does Tableau know at which level to aggregate values?

  A. Values are always aggregated at the level of granularity of the worksheet.
  B. Tableau doesn't aggregate values, we do!
  C. Values are always aggregated at the level of the Date Part
  D. Aggregation is always done by using Tableau special formulas
  A. Values are always aggregated at the level of granularity of the worksheet.

  ---

  Explanation/Reference:

  In Tableau, you can aggregate measures or dimensions, though it is more common to aggregate measures. Whenever you add a measure to your view, an aggregation is applied to that measure by default. The type of aggregation applied varies depending on the context of the view.

  When you add a measure to the view, Tableau automatically aggregates its values. Sum, average, and median are common aggregations; for a complete list, see List of Predefined Aggregations in Tableau. The current aggregation appears as part of the measure's name in the view. For example, Sales becomes SUM(Sales). Every measure has a default aggregation which is set by Tableau when you connect to a data source. You can view or change the default aggregation for a measure--see Set the Default Aggregation for a Measure.

  You can change the aggregation for a measure in the view from its context menu:

  

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

• Question 230:

  Is it possible to make a Measure discrete?

  A. No
  B. Yes
  B. Yes

  ---

  Explanation/Reference:

  Right click on any measure, and choose Discrete as shown:

  

  Once you do this, the green pill becomes blue in colour, indicating that it is now Discrete!

  

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