Tableau Tableau Certifications TDS-C01 Questions & Answers

• Question 61:

  Using the CoffeeChain table, create a chart to see the monthly Percent difference change in Profit, from the beginning of 2012 to the end of 2013. How many months saw a Negative percent difference in Profit?

  A. 9

  B. 7

  C. 10

  D. 8

  Correct Answer: C

  Follow along to reach the correct answer:

  1) First, drag Date to the Column shelf and Profit to the Rows shelf. We need to see the 2 consecutive months over this two year period (2012-2013) so this tells us we need to work with continuous dates:

  Click on Date in the Column shelf and convert it to continuous month :

  

  2) Now, click on the Profit pill in the Rows shelf, go to quick table calculation and choose Percent difference:

  

  3) Finally, click on the Show mark Labels icon:

  

  4) We finally have our view, and clearly, 10 Months have a NEGATIVE percent difference:

  

• Question 62:

  What is this entire view referred to as in Tableau?

  

  A. Data pane

  B. Analytics Pane

  C. Summary Pane

  D. Distribution Pane

  Correct Answer: B

  Distribution Pane

  This is the Analytics pane! Read more from the official documentation below:

  

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

• Question 63:

  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

  To assign a color to marks in the view, do the following:

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

  Tableau applies different colors to marks based on the field's values and members. For example, if you drop a discrete field (a blue field), such as Category, on Color, the marks in the view are broken out by category, and each category is

  assigned a color.

  

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

  Which of the following are valid ways to make the font more readable in Tableau?

  A. Decrease the font size

  B. Don't use backgrounds

  C. use a clear and readable font

  D. Make the Font color sharper / darker than the background

  E. Increase the font size

  Correct Answer: CDE

  This is one of the most common questions on the Tableau Desktop Specialist Exam.

  Wrong options1) Don't use backgrounds-This is not a solution. What if we want to use backgrounds? We can't just stop using backgrounds to solve this problem.

  2) Decrease the font size-Do you think using a smaller font will make the text more readable? No right? Hence, this is wrong too.

  All other options are ways recommended to make your text more readable!

• Question 65:

  Which of the following describes the best way to change the formatting at a workbook level?

  A. Right click anywhere in the view, choose format, and then specify the formatting in the new Format workbook pane.

  B. It is only possible to specify formatting at a worksheet level, not at the workbook level.

  C. Click on Text in the Marks card, choose format, and then specify the formatting in the new Format workbook pane.

  D. Choose Format from the menu on top and then specify the formatting in the new Format workbook pane.

  Correct Answer: D

  It is very much possible to specify the formatting at a WORKBOOK level (all sheets) instead of a single worksheet level.

  You can quickly change how fonts, titles, and lines look in every view in a workbook by specifying format settings at the workbook level, instead of the worksheet level. For example, you might want to use a specific font, size, and color so that

  all views adhere to your company's brand. You might also want to remove grid lines from your views--or make them more noticeable by increasing their pixel size or color. You can also change the theme used by your workbook. Themes

  control items like the default font, colors, and line thickness. When you create a new workbook, it automatically uses the Default theme, which uses visual best practices.

  Change fonts in your workbook:

  You can change all fonts in your workbook or you can change fonts for only certain areas, such as just worksheet titles.

  1) On the Format menu, select Workbook.

  2) The Format Workbook pane replaces the Data pane on the left and provides a series of drop-down lists where you can change all font settings in a workbook, as well as the font settings for titles of worksheets, stories, and dashboards.

  

  Note: If you have made font changes at the worksheet level, such as on a filter card or a worksheet title, changing the font at the WORKBOOK level will overwrite those changes.

  

  Reset a workbook to its default settings

  When you make changes to your workbook's font settings, a gray dot appears next to the setting in the Format Workbook pane. You can quickly switch back to default settings using the Reset to Defaults button.

  1) On the Format menu, select Workbook.

  2) In the Format Workbook pane, click Reset to Defaults.

  

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

• Question 66:

  Creating a scatter plot requires a minimum of how many measures?

  A. 2

  B. 4

  C. 1

  D. 3

  Correct Answer: A

  We can use scatter plots to visualize relationships between numerical variables!

  In Tableau, you create a scatter plot by placing at least one measure on the Columns shelf and at least one measure on the Rows shelf (Total 2 minimum). If these shelves contain both dimensions and measures, Tableau places the measures as the innermost fields, which means that measures are always to the right of any dimensions that you have also placed on these shelves. The word "innermost" in this case refers to the table structure.

  

  ( Simple Scatter Plot)

  

  (Matrix of Scatter Plots)

  A scatter plot can use several mark types. By default, Tableau uses the shape mark type. Depending on your data, you might want to use another mark type, such as a circle or a square. For more information, see Change the Type of Mark in the View.

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

• Question 67:

  Which of the following represent a valid method to create a Bullet Graph with the LEAST number of fields possible?

  A. using 2 measures

  B. using 2 dimensions

  C. using 2 dimensions and 3 measures

  D. using 1 measure

  Correct Answer: A

  A bullet graph is a variation of a bar graph developed to replace dashboard gauges and meters. A bullet graph is useful for comparing the performance of a primary measure to one or more other measures. Below is a single bullet graph showing how actual sales compared to estimated sales.

  We can create a Bullet graph with just 2 measures! This method requires the LEAST number of fields possible to create this type of chart. The best way to tackle such questions in the exam is to click the "SHOW ME" button on top right, and hover over the chart we want to create.

  In our case, it is a Bullet graph.

  

  Therefore, we need 2 measures at least to create this chart, and 0 or more dimensions.

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

• Question 68:

  When using Animations in a Tableau, which of the following is the default duration for animations?

  A. 0.4s

  B. 0.3s

  C. 0.5s

  D. 0.2s

  Correct Answer: B

  The LATEST Tableau Desktop Sepcialist exam blueprint now requires you to know some basics about animations as well! NOTE: Animations are DISABLED by default and must be manually enabled.

  

  You can also reset all settings to default by clickin on 'Reset All'

  

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

• Question 69:

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

  True or False: To concatenate fields, they must be of same data type

  A. True

  B. False

  Correct Answer: A

  Yes! To concatenate fields, they must be of same data type. However, there is a workaround which we can use-Type casting. See below:

  

  Here, State and City are Strings, but Postal Code? Nope. It's an Integer. So we can simply use the STR() function to convert it into a String, and hence the entire equation becomes valid!