Tableau TDS-C01 Online Practice Questions and Exam Preparation

Tableau TDS-C01 Online Questions & Answers

• Question 161:

  Suppose I have the following view. What will be the total number of marks if I drag a new measure to the row shelf vs the column shelf?

  

  A. If dragged to row shelf : 14 marks ; If dragged to column shelf : 7 marks
  B. If dragged to row shelf : 7 marks ; If dragged to column shelf : 14 marks
  C. If dragged to row shelf : 14 marks ; If dragged to column shelf : 14 marks
  D. If dragged to row shelf : 7 marks ; If dragged to column shelf : 7 marks
  A. If dragged to row shelf : 14 marks ; If dragged to column shelf : 7 marks

  ---

  Explanation/Reference:

  This is a tricky question often asked in the exam.

  If we drag a new measure to the row shelf, the following happens:

  We now have 2 rows, and the same 7 columns for both these rows. Therefore, 2x7 = 14 marks!

  

  , chart, bar chart Description automatically generated with medium confidence But if we drag the same measure to the column shelf, we have just 1 row and a chart created for each of the columns. So (1x7) = 7 marks!

  

  Reference and notes: https://medium.com/@justindixon91/tableau-specialist-exam-notes-part-4-understanding-tableau-concepts-f78de83fdd35

• Question 162:

  True or False: When relating tables, the fields that define the relationships must have the same data type.

  A. True
  B. False
  A. True

  ---

  Explanation/Reference:

  According to the official documentation, the following are the requirements for using relationships:

  1) When relating tables, the fields that define the relationships must have the same data type. Changing the data type in the Data Source page does not change this requirement. Tableau will still use the data type in the underlying database

  for queries.

  2) You can't define relationships based on geographic fields.

  3) Circular relationships aren't supported in the data model.

  4) You can't edit relationships in a published data source.

  5) You can't define relationships between published data sources.

  6) Your workbook must use an embedded data source for you to be able to edit relationships and performance options in the Data Source page in Tableau Online or Tableau Server.

  Reference: https://help.tableau.com/current/online/en-us/datasource_relationships_learnmorepage.htm

• Question 163:

  Which of the following are valid ways to copy a worksheet visualisation as an image?

  A. By simply clicking Control + V on the keyboard
  B. By clicking on Worksheet in the Tableau Main Menu above, and choosing Copy->Image
  C. Using the Marks shelf and choosing Copy->Image
  D. By right clicking on the worksheet visualisation and selecting Copy->Image
  B. By clicking on Worksheet in the Tableau Main Menu above, and choosing Copy->Image
  D. By right clicking on the worksheet visualisation and selecting Copy->Image

  ---

  Explanation/Reference:

  The following are 2 correct ways to copy the worksheet visualisation as an image:

  

  AND

  

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

• Question 164:

  DOWNLOAD THE DATASET FROM-https://drive.google.com/file/d/1F8L_Rl5B9LAz8RDi-DdjWx3Iv-SgzaBq/view?usp=sharing ( if you haven't already from the test instructions page! ) How many different countries are present in the dataset?

  A. 150
  B. 147
  C. 140
  D. 156
  B. 147

  ---

  Explanation/Reference:

  To reach the correct answer, follow these steps:

  1) You can simply drag Country to the view, and look at the marks in the bottom left of Tableau Desktop-147 marks!

  

  2) Or, you can simply go to Data Source-> Country Tab-> Describe

  

  

  As you can see, 147 members exist in this Country column!

• Question 165:

  What are three benefits of using an extract as compared to a live connection to a data source? (Choose three.)

  A. A live connection to a data source provides the best performance for data connections.
  B. Calculated fields perform better in workbooks connected to extracts than in workbooks with live connections to a data source.
  C. Extracts are stored in memory (RAM), resulting in faster query performance as compared with live data connections.
  D. An extract reduces the amount of data stored on a client computer as compared to a live data connection.
  E. A live connection to a data source can be slow due to network and user traffic, whereas a connection to an extract improves performance.
  B. Calculated fields perform better in workbooks connected to extracts than in workbooks with live connections to a data source.
  C. Extracts are stored in memory (RAM), resulting in faster query performance as compared with live data connections.
  D. An extract reduces the amount of data stored on a client computer as compared to a live data connection.

• Question 166:

  What are three ways to access bolding options for the text in a tooltip? (Choose three.)

  A. Hover over a mark and press CTRL+B.
  B. Hover over a mark and press ALT+F.
  C. Right-click on the Field and select Format.
  D. Select Worksheet on the menu, and then select Tooltip.
  E. Select Tooltip on the Marks card.
  F. Select Format on the menu, and then select Font.
  D. Select Worksheet on the menu, and then select Tooltip.
  E. Select Tooltip on the Marks card.
  F. Select Format on the menu, and then select Font.

• Question 167:

  Is it possible to add both a Dashboard and a Worksheet at the same time to a Story Point in Tableau?

  A. Yes
  B. No
  B. No

  ---

  Explanation/Reference:

  This is a tricky question. We are talking about story POINTS, and not entire stories in the question.

  To create a story, lets say I have a blank story with 1 dashboard and 1 worksheet.

  I can simply drag the dashboard into the view to create a new story point.

  

  Now, if I try to adjust the worksheet beside it in this same view, I cannot. See below:

  

  The only option available is to replace the existing view. Therefore, the answer is NO since they both cannot be added. Read more about stories in Tableau: https://help.tableau.com/current/pro/desktop/en-us/story_create.htm

• Question 168:

  You can use the __________________ in Tableau to clean / organise your data.

  A. Data cleaner
  B. Data manager
  C. Data interpreter
  D. Data organiser
  C. Data interpreter

  ---

  Explanation/Reference:

  When you track data in Excel spreadsheets, you create them with the human interface in mind. To make your spreadsheets easy to read, you might include things like titles, stacked headers, notes, maybe empty rows and columns to add

  white space, and you probably have multiple tabs of data too.

  When you want to analyze this data in Tableau, these aesthetically pleasing attributes make it very difficult for Tableau to interpret your data. That's where Data Interpreter can help.

  

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

• Question 169:

  True or False: When you drag additional tables to the logical layer canvas, Tableau automatically attempts to create the relationship based on existing key constraints and matching fields to define the relationship. If it can't determine the matching fields, then relating these tables is not possible.

  A. True
  B. False
  B. False

  ---

  Explanation/Reference:

  Tables that you drag to the logical layer of the Data Source page canvas must be related to each other. When you drag additional tables to the logical layer canvas, Tableau automatically attempts to create the relationship based on existing key constraints and matching fields to define the relationship. If it can't determine the matching fields, you will need to select them. If no constraints are detected, a Many-to-many relationship is created and referential integrity is set to Some records match. These default settings are a safe choice and provide the most a lot of flexibility for your data source.

  Reference: https://help.tableau.com/current/server/en-us/datasource_datamodel.htm

• Question 170:

  ________________ files are shortcuts for quickly connecting to the original data that you use often. Data source files do 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, adding groups, and so on.

  A. .tbm
  B. .tds
  C. .tde
  D. .twb
  B. .tds

  ---

  Explanation/Reference:

  According to the official Tableau documentation:

  Tableau data source files have the .tds file extension. Data source files are shortcuts for quickly connecting to the original data that you use often. Data source files do 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, adding groups, and so on. For more information, see Save Data Sources. Reference: https://help.tableau.com/current/pro/desktop/en-us/environ_filesandfolders.htm