Tableau TDS-C01 Online Practice Questions and Exam Preparation

Tableau TDS-C01 Online Questions & Answers

• Question 81:

  When using a Blend, what is the color of tick-mark on the primary and secondary data sources respectively?

  A. Red, Blue
  B. Orange, Blue
  C. Blue, Red
  D. Blue, Orange
  D. Blue, Orange

  ---

  Explanation/Reference:

  When using a Blend, the primary data source appears with a BLUE tick-mark and the secondary data source appears with a ORANGE tick-mark. See below:

  

  Reference: https://www.tutorialspoint.com/tableau/tableau_data_blending.htm

• Question 82:

  What is the one critical difference between normal calculated fields, and the calculated fields created after Data blending?

  A. No difference, calculated fields cannot be created in Blends
  B. Fields used in Blends must first be aggregated
  C. The calculated fields created in Blends cannot be edited once created
  D. The calculated fields created in Blends cannot use more than 2 fields
  B. Fields used in Blends must first be aggregated

  ---

  Explanation/Reference:

  Yes, due to the nature of blends, there are some conditions as follows from the official documentation that must be kept in mind while working with blends: In addition to handling calculations slightly differently, there are some limitations on secondary data sources. You may not be able to sort by a field from a secondary data source, and action filters may not work as expected with blended data. For more information, see Other data blending issues.

  

  

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

• Question 83:

  Which of the following is a benefit of using a Tableau Data Source (.tds)?

  A. To hold one or more worksheets, plus zero or more dashboards and stories.
  B. To not contain the actual data but rather the information necessary to connect to the actual data as well as any modifications you've made on top of the actual data such as changing default properties, creating calculated fields etc
  C. To create a single zip file that contains a workbook along with any supporting local file data and background images. This is great for sharing your work with others who don't have access to the original data.
  D. To create a local copy of a subset or entire data set that you can use to share data with others, when you need to work offline, and improve performance.
  B. To not contain the actual data but rather the information necessary to connect to the actual data as well as any modifications you've made on top of the actual data such as changing default properties, creating calculated fields etc

  ---

  Explanation/Reference:

  The following are the official definitions from the Tableau documentation for the various file types:

  1) .tds (Tableau Data Source)-To not contain the actual data but rather the information necessary to connect to the actual data as well as any modifications you've made on top of the actual data such as changing default properties, creating

  calculated fields etc.

  (CORRECT ANSWER)

  2) .twbx ( Tableau packaged workbook)-To create a single zip file that contains a workbook along with any supporting local file data and background images. This is great for sharing your work with others who don't have access to the original

  data.

  3) Extract (.hyper or .tde) ?To create a local copy of a subset or entire data set that you can use to share data with others, when you need to work offline, and improve performance.

  3) (.twb) Workbooks ?To hold one or more worksheets, plus zero or more dashboards and stories.

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

• Question 84:

  What will the following function return? LEFT("Tableau", 3)

  A. An error
  B. Tab
  C. eau
  D. ble
  B. Tab

  ---

  Explanation/Reference:

  The following is the official documentation for the String function LEFT:

  

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

• Question 85:

  What are two correct methods for creating a visual group? (Choose two.)

  A. Right-click a dimension in the Data pane
  B. Click the drop-down arrow from the top of the Data pane
  C. Select marks in the view
  D. Drag a dimension onto another dimension in the Data pane
  A. Right-click a dimension in the Data pane
  C. Select marks in the view

• Question 86:

  Which of the following are stored in a .tds file? Choose 3.

  A. Data Connection information
  B. Visualizations
  C. Calculated Fields
  D. Data Extracts
  E. Metadata edits
  A. Data Connection information
  C. Calculated Fields
  E. Metadata edits

  ---

  Explanation/Reference:

  If you've created a data connection that you might want to use with other workbooks or share with colleagues, you can export (save) the data source to a file. You might want to do this also if you've added joined tables, default properties, or custom fields--such as groups, sets, calculated fields, and binned fields--to the Data pane.

  

  Visualisations and Data extracts are NOT saved in a .tds file!

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

• Question 87:

  Create a Set containing Customer Names whose Sales are GREATER than 30,000. Which customer had the LEAST sales in this set?

  A. Tom Ashbrook B. Sanjit Engle
  C. Penelope Sewall
  D. Tamara Chand
  C. Penelope Sewall

  ---

  Explanation/Reference:

  As the question mentions, we need to create a SET with the following conditions-> Choose only those customers whose Sales > 30,000 1) Right click on customer name--> Create--> Set

  

  2) Let's Name the Set-Customer>30k ( you can name it anything you want :) ) Select USE ALL, and then move to the CONDITION TAB:

  

  3) In the Condition Tab, Choose BY FIELD-> Select Sales-> Sum-> Greater than 30000 , and click OK

  

  4) You should now have a new Set in the Data Pane as follows:

  

  5) Drag this set to the rows shelf, and click on SHOW MEMBERS IN SET. Now drag Sales to the Column Shelf.

  

  6) Click on the Show Mark Labels, and Sort ascending icons as shown:

  

  7) Voila! We have our answer:

  

• Question 88:

  For which of the following charts, does the Size option on the Marks card not work?

  A. Gantt Chart
  B. Bar Chart
  C. Tree Map
  D. Pie Chart
  C. Tree Map

  ---

  Explanation/Reference:

  You can adjust the size for all charts except the Tree Map. You use dimensions to define the structure of the treemap, and measures to define the size or color of the individual rectangles. Treemaps are a relatively simple data visualization

  that can provide insight in a visually attractive format.

  In a Tree Map, the measure itself defines the size and colour! The greater the sum of Measure for each category, the darker and larger its box.

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

• Question 89:

  True or False: We get different colour pallete options if we drop a discrete field on "Color" in the marks card compared to if we drop a continous field on Color.

  A. False
  B. True
  B. True

  ---

  Explanation/Reference:

  Yes! We get different color palettes. They are: *From the official Tableau documentation*

  

  To change the color for a value

  1) Click on an item on the left, under Select Data Item.

  2) Click a new color in the palette on the right. In Tableau Desktop you can hover over a swatch to identify the color.

  3) Repeat for as many values that you want to change.

  4) In Tableau Desktop, click OK to exit the Edit Colors dialog box. In Tableau Server or Tableau Online, simply close the dialog box.

  AND

  

  

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

• Question 90:

  Which of the following fields would be best used as Dimensions?

  A. Profit
  B. Names
  C. Categories
  D. Sales
  B. Names
  C. Categories

  ---

  Explanation/Reference:

  Names and Categories would be mostly used as dimensions (categorical data).

  Profit and measures contain quantitative data and would be more suitable for Measures!

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