Tableau Tableau Certifications TDS-C01 Questions & Answers

• Question 141:

  True or False: A sheet cannot be used within a story directly. Either sheets should be used within a dashboard, or a dashboard should be used within a story.

  A. rue

  B. False

  Correct Answer: B

  It is possible in Tableau to use a sheet within a story directly. Moreover, in Tableau, a story is a sequence of visualizations that work together to convey information. You can create stories to tell a data narrative, provide context, demonstrate how decisions relate to outcomes, or to simply make a compelling case. At the same time, a story is also a collection of sheets, arranged in a sequence. Each individual sheet in a story is called a story point.

  

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

• Question 142:

  When you connect to a new data source, all worksheets that previously referred to the original data source now refer to the new data source. If the new data source does not have the same field names as the original workbook, the fields are marked with an exclamation point

  

  Which feature helps us fix this issue?

  A. Replace References

  B. Fix Metadata

  C. Renaming

  D. Aliases

  Correct Answer: A

  Replace References: When you successfully connect to a new data source, all worksheets in the workbook that previously referred to the original data source now refer to the new data source. If the new data source does not have the same field names as the original workbook, the fields

  

  become invalid and are marked with an exclamation point

  You can quickly resolve the problem by replacing the field's references. For example, say you have a workbook connected to a data source that contains a Customer Name field. Then you edit the data source to point to a new data source that has all the same data but instead of Customer Name, the field name has been changed to Name. The Customer Name field remains in the Data pane but is marked as invalid. To make the field valid, you can replace the references, which means you can map the invalid field to a valid field in the new data source (for example, Customer Name corresponds to Name).

  Read more at : https://help.tableau.com/current/pro/desktop/en-us/howto_connect.htm

• Question 143:

  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

  Correct Answer: A

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

  True or False: It is possible to add a field to more than one hierarchy

  A. True

  B. False

  Correct Answer: A

  Yes! It is possible to duplicate a field and add it to more than one hierarchy. Right click and choose duplicate. Reference: https://www.tableau.com/about/blog/2016/8/take-note-these-10-handy-tableau-shortcuts-57561

• Question 145:

  Using the Time Series Table, create a Line chart showing the Monthly Year over Year Growth for the Sales, broken down by Assortment. For the Electronics assortment, which Month had the most NEGATIVE value of Year over Year Growth?

  A. October

  B. September

  C. July

  D. June

  Correct Answer: A

  Follow along:

  1) Drag Assortment and Year ID (choose Discrete Month) to Columns shelf, and Sales to the Columns Shelf.

  For sales, click on the pill-> choose Quick Table calculation-> Year over Year growth.

  The view should now look like:

  

  It is clear that October with-55.3% had the lowest Year on Year growth.

• Question 146:

  When working with Excel, text file data, JSON file, .pdf file data, you can use _________________ to union files across folders, and worksheets across workbooks. Search is scoped to the selected connection.

  A. Regex Search

  B. Union Search

  C. Pattern Search

  D. Wildcard Search

  Correct Answer: D

  You can use Wildcard Search to set up search criteria to automatically include tables in your union. Use the wildcard character, which is an asterisk (*), to match a sequence or pattern of characters in the Excel workbook and worksheet names, Google Sheets workbook and worksheet names, text file names, JSON file names, .pdf file names, and database table names. When working with Excel, text file data, JSON file, .pdf file data, you can also use this method to union files across folders, and worksheets across workbooks. Search is scoped to the selected connection. The connection and the tables available in a connection are shown on the left pane of the Data source page.

  

  

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

• Question 147:

  Missing the question

  A. Bullet

  B. Line

  C. Gantt

  D. Area

  Correct Answer: D

  According to the official Tableau documentation:

  

  An example of an area chart is shown below:

  

• Question 148:

  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

  Correct Answer: B

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

  What is this view referred to as in Tableau?

  

  A. Analytics Pane

  B. Window Pane

  C. Data Pane

  D. Dimensions and Measures

  Correct Answer: C

  Tableau displays data source connections and data fields for the workbook in the Data pane on the left side of the workspace.

  The Data pane includes:

  Dimension fields ?Fields that contain qualitative values (such as names, dates, or geographical data). You can use dimensions to categorize, segment, and reveal the details in your data. Dimensions affect the level of detail in the view.

  Examples of dimensions include dates, customer names, and customer segments. Measure fields ?Fields that contain numeric, quantitative values can be measured. You can apply calculations to them and aggregate them. When you drag a

  measure into the view, Tableau applies an aggregation to that measure (by default). Examples of measures:

  sales, profit, number of employees, temperature, frequency. For more information on what dimensions and measures are, see Dimensions and Measures, Blue and Green.

  Calculated fields If your underlying data doesn't include all of the fields you need to answer your questions, you can create new fields in Tableau using calculations and then save them as part of your data source. These fields are called

  calculated fields. For more information on calculated fields, see Create Custom Fields with Calculations. Sets

  Subsets of data that you define. Sets are custom fields based on existing dimensions and criteria that you specify. For more information, see Create Sets. Named sets from an MS Analysis Services server or from a Teradata OLAP connector

  also appear in Tableau in this area of the Data pane. You can interact with these named sets in the same way you interact with other custom sets in Tableau. Parameters Values that can be used as placeholders in formulas, or replace

  constant values in calculated fields and filters. For more information, see Create Parameters.

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

• Question 150:

  _____________ charts are typically used to represent accumulated totals over time and are the conventional way to display stacked lines.

  A. Line

  B. Area

  C. Gantt

  D. Bullet

  Correct Answer: B

  According to the official Tableau documentation: