Tableau Tableau Desktop Specialist DESKTOP-SPECIALIST Questions & Answers

• Question 1:

  Which of the following is a compelling reason to export a sheet in Tableau to a PDF?

  A. If we want a static view of the visualisation.

  B. If we want to use filters in the visualisation.

  C. If we want to interact with the visualisation.

  D. If we want to dynamically enter parameters to the visualisation.

  Correct Answer: A

  Exporting the visualisation gives us a static view of the visualisation. It is NOT possible to interact with it, use filters, or dynamically enter anything in a visualisation exported PDF. In Tableau Desktop, you can save views as PDF files rather than printing them as hard copies. You do not need to have Adobe Acrobat installed on your computer.

  When you print an individual sheet to PDF, filters in the view are not included. To show filters, create a dashboard containing the sheet and export the dashboard to PDF. (IMPORTANT) Reference: https://help.tableau.com/current/pro/desktop/en-us/printing.htm

• Question 2:

  Which of the following are valid reasons to use a Tableau Data Extract (.tde) over Live Connections?

  A. To support additional functionality such as count distinct

  B. Fast to create

  C. Help improve performance

  D. To have access to the freshest possible data at all times

  Correct Answer: ABC

  From the official documentation, the following are the major advantages of using Tableau Data Extracts:

  

  From Tableau 2020.2 onwards, .hyper is the recommended way since it is faster than .tde! Reference: https://help.tableau.com/current/pro/desktop/en-us/extracting_data.htm

• Question 3:

  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.

  Correct Answer: B

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

  If you have a dashboard and are displaying its filter, how can you rearrange it?

  A. By clicking on the 2 lines on top and dragging the filter.

  B. By clicking on the dropdown and dragging the filter

  C. By clicking on the filter title and dragging it.

  D. By clicking anywhere inside the filter and dragging it.

  Correct Answer: A

  You can drag the filter by clicking on the 2 lines on top, and then dragging the filter as shown:

  

• Question 5:

  Which of the following can you add a reference line to?

  A. Groups

  B. Calculated Fields

  C. Measures

  D. Dimensions

  Correct Answer: BC

  You can add reference lines, bands, distributions, or (in Tableau Desktop but not on the web) box plots to any continuous axis in the view. Reference Lines - You can add a reference line at a constant or computed value on the axis. Computed values can be based on a specified field. You can also include confidence intervals with a reference line.

  

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

• Question 6:

  Are animations enabled by default in Tableau?

  A. No

  B. Yes

  Correct Answer: A

  No, by default, animations are not enabled in Tableau. We can animate visualizations to better highlight

  changing patterns in your data, reveal spikes and outliers, and see how data points cluster and separate.

  Animations visually transition between filter, sort, and zoom settings, different pages, and changes to filter,

  parameter, and set actions. As visualizations animate in response to these changes, viewers can more

  clearly see how data differs, helping them make better informed decisions. When you author animations,

  you can choose between two different styles: simultaneous or sequential. Here are examples of each type.

  1) Simultaneous animations

  The default simultaneous animations are faster and work well when showing value changes in simpler

  charts and dashboards.

  

  2) Sequential animations Sequential animations take more time but make complex changes clearer by presenting them step- by-step.

  

  To Animate visualizations in a workbook:

  1) Choose Format > Animations.

  2) If you want to animate every sheet, under Workbook Default, click On. Then do the following:

  For Duration, choose a preset, or specify a custom duration of up to 10 seconds. For Style, choose

  Simultaneous to play all animations at once or Sequential to fade out marks, move and sort them, and then

  fade them in.

  3) To override workbook defaults for a particular sheet, change the settings under Selected Sheet.

  

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

• Question 7:

  Which of the following calculations DO NOT need a quick table calculation?

  A. Variance

  B. Rank

  C. Moving Average

  D. Standard Deviation

  Correct Answer: A

  

  However, as seen in the types of quick table calculations available in Tableau, Rank and Moving Average

  belong to only this category.

  

• Question 8:

  How can you add color to marks in the view in Tableau?

  A. Click on Data in the main menu above, and click on choose color.

  B. From the Data pane, drag a field to Color on the Marks card.

  C. In the column/row shelf, right click the field and click on edit in shelf to select the color.

  D. From the Analytics pane, drag a model to Color on the Marks card.

  Correct Answer: B

  

  If you drop a continuous field, such as SUM(sales), on Color, each mark in the view is colored based on its sales value.

  

• Question 9:

  Which one of the following is a dimension?

  A. Longitude

  B. Measure Names

  C. Number of records

  D. Latitude

  Correct Answer: B

  Measure Names is a dimension. Latitude, Longitude, and Number of records are all measures.

  

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

• Question 10:

  Suppose you have a bar chart. When we group by labels in a view, which of the following happens?

  A. Nothing changes in the view, but a group is created in the Dimensions shelf.

  B. The colours of the members selected are now the same, and different for the rest of the members.

  C. Trick question! It is not possible to group by labels.

  D. A new mark (bar) is created, which consolidates all members of the group.

  Correct Answer: D

  *Very important question*

  If we select the labels in the view and then group, a new consolidated mark is created - in our case bar

  since we are talking about a bar chart in the question. See below:

  

  Then on grouping, a new bar is created, and the colour of all bars remain the same. Had we grouped by choosing the marks instead of the labels, the following would be the result:

  

  

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