Tableau Tableau Certifications TDS-C01 Questions & Answers

• Question 211:

  Which of the following lets you group related dashboard items together so you can quickly position them?

  A. Layout Extensions

  B. Layout Blanks

  C. Layout Containers

  D. Layout positioners

  Correct Answer: C

  Layout containers let you group related dashboard items together so you can quickly position them. As you change the size and placement of items inside a container, other container items automatically adjust

  

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

• Question 212:

  True or False: A LEFT JOIN or INNER JOIN creates a row each time the join criteria is satisfied, which can result in duplicate rows. One way to avoid this is to use data blending instead.

  A. True

  B. False

  Correct Answer: A

  Joins combine tables by adding more columns of data across similar row structures. This can cause data loss or duplication if tables are at different levels of detail, and joined data sources must be fixed before analysis can begin.

  

  Inner join

  

  Left Join

  Blends, unlike relationships or joins, never truly combine the data. Instead, blends query each data source independently, the results are aggregated to the appropriate level, then the results are presented visually together in the view.

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

• Question 213:

  Which of the following URL prefixes are permitted when creating a URL Action in Tableau?

  A. SMTP

  B. FTP

  C. HTTPS

  D. HTTP

  Correct Answer: BCD

  A URL action is a hyperlink that points to a web page, file, or other web-based resource outside of Tableau. You can use URL actions to create an email or link to additional information about your data. To customize links based on your data, you can automatically enter field values as parameters in URLs.

  

  

  

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

• Question 214:

  Suppose you create a bar chart by dragging a dimension to the Column shelf and a measure to the Rows shelf. Which of the following would create a stacked bar chart?

  A. By dragging another dimension to the Rows shelf

  B. By dragging another measure to Color on the Marks card

  C. By dragging another dimension to Color on the Marks card

  D. By dragging another measure to the Columns shelf

  Correct Answer: C

  Very important question for the exam and appears quite a lot too.

  The correct answer is-By dragging another dimension to Color on the Marks card.

  

  Chart, bar chart

  This is what the question says we have already created. Now to convert this into a Stacked bar chart, we will drop another dimension on Color in the Marks card.

  

  Chart, bar chart

  The rest won't create stacked bar charts, and hence are incorrect choices. The best way to answer such questions on the real exam is to quickly do what the options say and see if they satisfy the requirements in the question.

• Question 215:

  Is SUM a table calculation?

  A. Yes

  B. No

  Correct Answer: B

  SUM is an aggregate function, not a table calculation! A table calculation is a transformation you apply to the values in a visualization. Table calculations are a special type of calculated field that computes on the local data in Tableau. They are calculated based on what is currently in the visualization and do not consider any measures or dimensions that are filtered out of the visualization.

  The most common Table calculations are:

  1.

  Running Total

  2.

  Percent Difference

  3.

  Difference

  4.

  Percent of Total

  5.

  Rank

  6.

  Percentile

  

  

  These can be calculated using : Table(across), Cell, or Specific dimensions!

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

• Question 216:

  Using the Time Series table, create a chart that shows the percent difference in Average Inventory on Hand for each Assortment by year and quarter. How many quarters did the Electronics Assortment show a negative percent difference in the Average Inventory On Hand?

  A. 1

  B. 2

  C. 3

  D. 4

  Correct Answer: C

  If you chose 2, then you were very close but probably didn't plot the actual Percent Difference on your view. ( One of the marks is just over the line).

  Firstly, Drop the Week ID onto the column shelf, and convert it to continuous since we need both Year and Quarter as mentioned in the question. 2) Next, Drop assortment to filters shelf so that we can focus on Electronics!

  

  3) This should be your view now. Click on the Show Mark Labels icon as shown: The final view is as follows, with 3 points below 0 ( i.e negative )

  

• Question 217:

  When creating a dashboard for multiple devices, which of the following Device options are available in the Device Preview section?

  A. Monitor, Default, Phone, Tablet

  B. Phone, Tablet, Laptop, Desktop

  C. Default, Phone, Tablet, Desktop

  D. Phone, Monitor, Laptop, Default

  Correct Answer: C

  The following options are available in the Device preview section when creating a Dashboard:

  

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

• Question 218:

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

  A. A live connection to a database server requires less network overhead than an extract.

  B. A workbook connected to a live connection will have fresher data than a workbook connected to an extract.

  C. A live connection reduces the amount of memory used on a client computer as compared to an extract.

  D. A live connection is always faster than an extract.

  Correct Answer: BC

• Question 219:

  Which two functionalities can you provide to consumers by adding a parameter to a visualization? (Choose two.)

  A. Change fields in the visualization.

  B. Download the underlying data as a CSV file.

  C. Change the results of calculations in the visualization.

  D. Create a new field in the data source.

  Correct Answer: AC

• Question 220:

  What are two requirements to combine two tables by using a union? (Choose two.)

  A. Related fields must have matching data types.

  B. Related fields must have different names.

  C. The tables must come from different connections.

  D. The tables must have the same number of fields.

  Correct Answer: AD