Tableau Tableau Certifications TDS-C01 Questions & Answers

• Question 111:

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

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

  A. Data cleaner

  B. Data manager

  C. Data interpreter

  D. Data organiser

  Correct Answer: C

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

  Using the Geo Data Table, create a Map showing Sales made per State. For the State of New York (NY), what was the amount in Sales ($) made for Phone Assortments with White color?

  A. $16,581

  B. (Correct)

  C. $147,950

  D. $48,115

  E. $33,768

  Correct Answer: A

  Phew! Tricky one! You needed to use filters in this one. Follow along:

  

  2) Next, as the question mentions, we need to focus on the Assortment PHONE, the color WHITE, and the state of NEW YORK.-> so we use filters for this! i) First drag Assortment to Filters, and select only Phones :

  

  ii) Next, drag Color to Filters and Choose only White:

  

  iii) Next, drag State ID to Filters, and choose New York (NY):

  

  And Voila! We have our answer as follows:

  

  iv) Last, drag Sales to Label

• Question 114:

  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

  Correct Answer: B

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

  When you drop a continuous field on Color, Tableau displays a quantitative legend with a ___________ range of colors.

  A. Discrete

  B. Fading

  C. Continuous

  D. Mixed

  Correct Answer: C

  When you drop a discrete field on Color in the Marks card, Tableau displays a categorical palette and assigns a color to each value of the field. When you drop a continuous field on Color, Tableau displays a quantitative legend with a continuous range of colors.

  Web version:

  

  Desktop Version:

  

  For more information about color palettes, see Color Palettes and Effects.

• Question 116:

  Which Sub-Category had the least Profit in the Office Supplies category?

  A. Fasteners

  B. Labels

  C. Envelopes

  D. Binders

  Correct Answer: A

  To reach the correct answer, follow the steps below:

  

  1) Drag Category, and sub-category to the row shelf. Drag Profit to the Column shelf

  2) Click the Sort-ascending icon as shown above, to sort the profits from least to greatest as shown:

  Click the 'Show mark labels icon'

  

  As we can see, Fasteners has the least Profit in the Office Supplies Category, and hence is our correct answer!

• Question 117:

  Our use case states that we need to create a set showing the Bottom 10 products by Profit in each Region. Which of the following filter types should you apply on Region?

  A. Measure Filters

  B. Context Filters

  C. Extract Filters

  D. Dimension Filters

  Correct Answer: B

  The beauty of context filters is that according to Tableau's Order of Operations, they are executed before Sets.

  

  Diagram

  This means that based on what Region's you've selected-Tableau will first only preserve the rows for those Regions. THEN, after this it will compute the Set , i.e , Bottom 10 products in each Region.

  1) First let's create a set to compute the Bottom 10 Products by Profit.

  

  2) Next, take region on the Rows Shelf followed by the Set we just created. Drag Region and the Set to the Filters Shelf as well.

  

  3) Now, try to only visualize the data for the South Region:

  

  4) The problem right now is that Tableau is computing the Set first (Bottom 10 Products), and then applying the Dimension Filter-South Region and hence these values are incorrect. Note how these aren't even 10 products, but rather just 8. To fix this, simply add Region to Context:

  

  Upon doing this, we get the correct answer as :

  

  References: https://help.tableau.com/current/pro/desktop/en-us/order_of_operations.htm https://help.tableau.com/current/pro/desktop/en-us/filtering_context.htm

• Question 118:

  Dimensions containing ____________ and ____________ values cannot be continuous.

  A. Boolean

  B. Date

  C. Date and Time

  D. String

  Correct Answer: AD

  According to Tableau's official documentationReference: https://help.tableau.com/current/pro/desktop/en-us/datafields_typesandroles.htm

  

• Question 119:

  Which of the following are valid ways to trigger actions for a Dashboard?

  A. Hover

  B. Click

  C. Select

  D. Menu

  E. Double click

  Correct Answer: ACD

  Whenever we want to add actions to a Dashboard, we can trigger then in the following 3 ways: 1) Select 2) Hover 3) Menu Hover is best for highlighting, select for filtering. Menu action is added to the tooltip and user can decide whether to run that action or not (best for URL actions)

  

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

• Question 120:

  Using the Time Series table, create a cross-tab showing sales for each Assortment broken down by Year and Quarter. In Q4 of October 2017, what was the Average sales amount for the Hardware assortment?

  A. 111,060

  B. 1,461

  C. 112,256

  D. 1,222

  Correct Answer: C

  If you chose 111,060 you were SO close to the correct answer but made a small mistake-you didn't change the aggregation to AVERAGE! This is one of the common mistakes many test takers make, so keep this in mind.

  To reach the correct answer, follow the steps below:

  1) Draw Assortment to the Column shelf, and drag Year to the Rows Shelf. Then Drill down further on Year to accomodate Quarters and Months as well! Although this seems enough, DON'T FORGET to change the aggregation like in the

  next step, which will completely change the values!

  

  The correct answer as you can see is 1,461-Sales for Harware Assortment in 2017 Q4, October