Tableau TDS-C01 Online Practice Questions and Exam Preparation

Tableau TDS-C01 Online Questions & Answers

• Question 261:

  For creating variable sized bins we use __________________

  A. Calculated Fields
  B. Table Calculations
  C. Sets
  D. Groups
  A. Calculated Fields

  ---

  Explanation/Reference:

  One way to view a measure in Tableau Desktop is to split it into bins. You can think of bins as buckets based on a range of values. For example, say you have a measure that represents age. Instead of aggregating the measure to calculate the average age, you can bin the measure to define age groups: 0?, 6?0, 11?5, and so on. Then you can count the number of people in each age group.

  Create a calculated field for variable bin size Step 1 Select Analysis > Create Calculated Field. Step 2 In the Calculated Field dialog box, complete the following steps: Reference: https://riti-ritesh.blogspot.com/2016/07/creating-variable-sized-bins_8.html

  

• Question 262:

  True or False : Bins can be created on dimensions

  A. False
  B. True
  B. True

  ---

  Explanation/Reference:

  Bin are a user-defined grouping of numerical data in the data source. According to the official Tableau documentation: It's sometimes useful to convert a continuous measure (or a numeric dimension) into bins. Have a look at the following image. When we right click a measure, we get the following options:

  

  However, for a dimension (this is because the DATA TYPE of this dimension is a string:

  

  But what if we have a dimension of type NUMBER (NUMERIC DIMENSION)? See below:

  

  We can clearly create bins from dimensions too-they just have to be numeric :)

  For more information, please refer to : https://help.tableau.com/current/pro/desktop/en-us/calculations_bins.htm

• Question 263:

  You want to update the font of an entire workbook.

  What should you use to configure the default fonts?

  A. The Format Font pane
  B. The Format Workbook pane
  C. Field labels
  D. Titles and captions
  B. The Format Workbook pane

• Question 264:

  Which mark type is used in a highlight table?

  A. Area
  B. Square
  C. Polygon
  D. Text
  B. Square

  ---

  Explanation/Reference:

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

• Question 265:

  Are animations enabled by default in Tableau?

  A. No
  B. Yes
  A. No

  ---

  Explanation/Reference:

  No, by default, animations are not enabled in Tableau. We can animate visualizations to better highlight changing patterns in your data, reveal spikes and outliers, and see how data points cluster and separate. Animations visually transition

  between filter, sort, and zoom settings, different pages, and changes to filter, parameter, and set actions. As visualizations animate in response to these changes, viewers can more clearly see how data differs, helping them make better

  informed decisions.

  When you author animations, you can choose between two different styles: simultaneous or sequential. Here are examples of each type.

  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.

  To Animate visualizations in a workbook:

  1) Choose Format > Animations.

  2) If you want to animate every sheet, under Workbook Default, click On. Then do the following:

  For Duration, choose a preset, or specify a custom duration of up to 10 seconds. For Style, choose Simultaneous to play all animations at once or Sequential to fade out marks, move and sort them, and then fade them in.

  3) To override workbook defaults for a particular sheet, change the settings under Selected Sheet.

  

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

• Question 266:

  What is the one most important thing you should do after creating a Dual-axis chart?

  A. Synchronise the axis
  B. Change the colours
  C. Edit the labels
  D. Hide the axis
  A. 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.

  

  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

• Question 267:

  You have a workbook that contains one data source and you need to combine data from another database. What should you do first?

  A. Create an extract
  B. Edit the existing connection
  C. Add a new data source from the data source canvas
  D. Add a new connection
  C. Add a new data source from the data source canvas

• Question 268:

  How can you create a packaged data source?

  A. From the Worksheet menu, select Export, and then select Data.
  B. From the File menu, select Save As.
  C. From the File menu, select Share.
  D. From the Data pane, right-click the data connection, and then select Add to Saved Data Sources.
  D. From the Data pane, right-click the data connection, and then select Add to Saved Data Sources.

• Question 269:

  You may create a context filter to:

  A. To create a dependent filter
  B. Improve performance
  C. To replace a data source filter
  D. Create a dependent numerical or top N filter
  B. Improve performance
  D. Create a dependent numerical or top N filter

  ---

  Explanation/Reference:

  Important question! You cannot use a context filter to replace a data source filter since each filter type has its own use case. Also, a content filter is an Independent filter and all other filters are called dependent since they only process the data that passes through a context filter.

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

  

  

• Question 270:

  Which of the following would you use to connect to multiple tables in a single data source at once?

  A. A Blend
  B. A Hierarchy
  C. A Set
  D. A Join
  D. A Join

  ---

  Explanation/Reference:

  The data that you analyze in Tableau is often made up of a collection of tables that are related by specific fields (that is, columns). Joining is a method for combining data on based on those common fields. The result of combining data using a join is a virtual table that is typically extended horizontally by adding columns of data. For example, consider the following two tables originating from a single data source:

  

  We can combine these 2 tables, simply by joining the tables on ID to answer questions like, "How much was paid in royalties for authors from a given publisher?". By combining tables using a join, you can view and use related data from different tables in your analysis.

  

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