Tableau Tableau Certifications TDS-C01 Questions & Answers

• Question 31:

  Which of the following can you use to create a Histogram?

  A. 2 measures

  B. 1 measure

  C. 2 dimensions

  D. 1 dimension

  Correct Answer: B

  A histogram is a chart that displays the shape of a distribution. A histogram looks like a bar chart but groups values for a continuous measure into ranges, or bins. The basic building blocks for a histogram are as follows:

  

  Demo :

  

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

• Question 32:

  Most viewers scan content starting at the _____________ of a page.

  A. top left

  B. center

  C. bottom left

  D. bottom right

  E. top right

  Correct Answer: A

  According to Tableau's official documentation:

  

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

• Question 33:

  How can you format an axis as Bold in Tableau?

  A. By choosing the axis and selecting Command/Control + B on your keyboard

  B. By right clicking on the axis, choosing Edit Axis, and then setting its font to bold.

  C. By right clicking on the axis, choosing format, and then setting its font to bold.

  D. By clicking on Format on the main menu bar, choosing field labels, and setting it to bold.

  Correct Answer: C

  To make an axis bold, simply right click it, select format, and then click on Font to choose Bold:

  

  None of the other options are valid ways to make the axis bold. Read more about editing axis: https://help.tableau.com/current/pro/desktop/en-us/formatting_editaxes.htm

• Question 34:

  Using the dataset, plot a Map showing all the countries, filtered by Market to only include LATAM. Which country in the LATAM Market has the highest shipping delay (sum of total number of days between the order date and the ship date)?

  A. Brazil

  B. Peru

  C. Argentina

  D. Mexico

  Correct Answer: D

  VERY IMPORTANT

• Question 35:

  Which of the following would you use to edit the Shape, colour, and Text of your visualisations?

  A. Marks Card

  B. Data Pane

  C. Filter Shelf

  D. Analytics Pane

  Correct Answer: A

  The Marks Card allows us not only to edit the Shape, Text and Colour, but also to modify the Tooltip and the level of detail of the visualisation!

  

  The Marks card is a key element for visual analysis in Tableau. As you drag fields to different properties in the Marks card, you add context and detail to the marks in the view.

  

  You use the Marks card to set the mark type (see Change the Type of Mark in the View), and to encode your data with color, size, shape, text, and detail. To change the mark settings, see Control the Appearance of Marks in the View.

  

  In this example, three different fields have been dragged to different properties in the Marks card. Segment is on Color, Region is on Shape, and Quantity is on Size. After you add a field to the Marks card, you can click the icon next to the

  field to change the property it is using. You can also click the property buttons in the Marks card to change those settings.

  Many properties can have multiple fields. For example, you can add multiple fields to Label, Detail, Tooltip, and Color. Size and Shape can only have one field at a time. For more details, see Control the Appearance of Marks in the View.

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

• Question 36:

  Using the dataset provided, create a crosstab showing the Profit of each Region per Year, then add grand totals to the view. What was the total Profit for Canada in 2012 and the total Profit for Canada for 2011 through 2014, respectively?

  A. 5,129 and 88,872

  B. 52,678 and 311,404

  C. 1,807 and 34,571

  D. 4,888 and 17,817

  Correct Answer: D

  To reach the correct answer, follow these steps:

  1) Drag Order Date (Discrete Year) to the Column shelf, and Region to the Row Shelf as shown:

  

  2) Drag Profit to Text in the Marks Shelf as shown:

  

  3) Click on Analysis as shown-> Totals-> SELECT ROW GRAND TOTALS The following will be the final view:

  

  You could also Filter by Region to only Focus on Canada, but that's your choice:

  

  THEREFORE,

  2012 = 4,888 2011-> 2014 = 17,817

• Question 37:

  Using the Time-series table, create a cross tab showing the Sales for each Item Number-ID, broken down by Assortments, then add Grand totals to the view. Which Item Number ID made the maximum sales across all assortments?

  A. 584

  B. 901

  C. Correct)

  D. 205

  E. 660

  Correct Answer: B

  Drag Assortment and Year ID to the column shelf, and Item Number ID to the row shelf. Next, drag Sales to the Text label to create a cross-tab

• Question 38:

  A Tableau Data Source File (.tds) contains which of the following?

  A. Default Field Properties

  B. Copy of any local file-based data

  C. Calculated Fields

  D. Data Source Type

  Correct Answer: ACD

  All are correct, except-Copy of any local file-based data. This is contained in a .tdsx file (Tableau Packaged Data Source)! According to the official documentation-

  

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

• Question 39:

  Which of the following is a valid way to create Sets in Tableau?

  A. In the Data pane, right-click a dimension and select Create > Set.

  B. In the Tableau Main Menu, Choose Worksheet and select Create > Set

  C. In the Tableau Main Menu, choose Dashboard and select Create > Set

  D. In the Data pane, right-click a measure and select Create > Set.

  Correct Answer: A

  There are two types of sets: dynamic sets and fixed sets. The members of a dynamic set change when the underlying data changes. Dynamic sets can only be based on a single dimension.

  To create a dynamic set:

  1) In the Data pane, right-click a dimension and select Create > Set.

  2) In the Create Set dialog box, configure your set. You can configure your set using the following tabs:

  General: Use the General tab to select one or more values that will be considered when computing the set.

  You can alternatively select the Use all option to always consider all members even when new members are added or removed.

  None of the other options exist, and therefore are incorrect answers.

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

• Question 40:

  For creating variable sized bins we use __________________

  A. Calculated Fields

  B. Table Calculations

  C. Sets

  D. Groups

  Correct Answer: A

  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