Tableau Tableau Certifications TDS-C01 Questions & Answers

• Question 41:

  Create a Set containing Customer Names whose Sales are GREATER than 30,000. Which customer had the LEAST sales in this set?

  A. Tom Ashbrook B. Sanjit Engle

  C. Penelope Sewall

  D. Tamara Chand

  Correct Answer: C

  As the question mentions, we need to create a SET with the following conditions-> Choose only those customers whose Sales > 30,000 1) Right click on customer name--> Create--> Set

  

  2) Let's Name the Set-Customer>30k ( you can name it anything you want :) ) Select USE ALL, and then move to the CONDITION TAB:

  

  3) In the Condition Tab, Choose BY FIELD-> Select Sales-> Sum-> Greater than 30000 , and click OK

  

  4) You should now have a new Set in the Data Pane as follows:

  

  5) Drag this set to the rows shelf, and click on SHOW MEMBERS IN SET. Now drag Sales to the Column Shelf.

  

  6) Click on the Show Mark Labels, and Sort ascending icons as shown:

  

  7) Voila! We have our answer:

  

• Question 42:

  A _____________ action is a hyperlink that points to a web page, file, or other web-based resource outside of Tableau.

  A. Go to Hyperlink

  B. Go to Web page

  C. Go to URL

  D. Go to Sheet

  Correct Answer: C

  Tricky options! Go to hyperlink and Go to Web page are not valid Actions in Tableau.

  

  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.

  

  

  , email

  

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

• Question 43:

  Which of the following charts types always includes bars sorted in descending order?

  A. Pareto Chart

  B. Pie Chart

  C. Gantt Chart

  D. Stacked Bar Chart

  Correct Answer: A

  A Pareto chart is a type of chart that contains both bars and a line graph, where individual values are represented in descending order by bars, and the ascending cumulative total is represented by the line.

  On the primary axis, bars are used to show the raw quantities for each dimension member, sorted in descending order.

  On the secondary axis, a line graph is used to show the cumulative total in percent format.

  

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

• Question 44:

  True or False: You get different filtering options for categorical and quantitative data

  A. True

  B. False

  Correct Answer: A

  Yes! We get different options for filtering depending on whether we use a categorical data (think dimension) or quantitative data (think measure).

  

  Important Note: Each tab adds additional definitions to your filter. For example, you can select to exclude values under the General tab, and also add limits under the Top tab. Selections and configurations from both tabs are applied to your filter.At any time, you can see the definitions of your filter under Summary on the General tab.

  

  Note: If you have a large data source, filtering measures can lead to a significant degradation in performance. It is sometimes much more efficient to filter by creating a set containing the measure and then apply a filter to the set. For more information about creating sets, see Create Sets

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

• Question 45:

  Which of the following are correct ways to define a join in Tableau version 2020.3 and above?

  A. Right-click a logical table and click on open to go to the Join/Union canvas in the physical layer and add joins or unions.

  B. Double-click a physical table to go to the Join/Union canvas in the logical layer and add joins or unions.

  C. Right-click a physical table and click on open to go to the Join/Union canvas in the logical layer and add joins or unions.

  D. Double-click a logical table to go to the Join/Union canvas in the physical layer and add joins or unions.

  Correct Answer: AD

  Remember that joins are defined in the physical layer and relationships in the logical layer.

  You can still specify joins between tables in the physical layer of a data source. Double-click a logical table to go to the Join/Union canvas in the physical layer and add joins or unions. Every top-level, logical table contains at least one physical table. Open a logical table to view, edit, or create joins between its physical tables. Right-click a logical table, and then click Open. Or, just double-click the table to open it.

  

  When you create a data source, it has two layers. The top-level layer is the logical layer of the data source. You combine data between tables in the logical layer using relationships. The next layer is the physical layer of the data source. You combine data between tables at the physical layer using joins. For more information, see Logical and physical tables in the data model

  

  Reference: https://help.tableau.com/current/online/en-us/datasource_relationships_learnmorepage.htm

• Question 46:

  According to Tableau's 'Order of Operations', which of the following filters is applied FIRST?

  A. Dimension Filter

  B. Measure Filter

  C. Context Filter

  D. Extract Filter

  Correct Answer: D

  According to Tableau's order of operations, the Extract filter is right at the top of the hierarchy. The data filtered in the Extract is then passed on to what we see in the Data Pane. See below: Reference: https://help.tableau.com/current/pro/desktop/en-us/order_of_operations.htm

  

• Question 47:

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

  For a ____________ sort, no matter how the data changes, the values will always stay in the sort order we kept stuff in.

  A. Random

  B. Manual

  C. Topological

  D. Hierarchical

  Correct Answer: B

  For a manual sort, no matter how the data changes, the values will always stay in the sort order you kept stuff in. From the official website: Reference: https://help.tableau.com/current/reader/desktop/en-us/reader_sort.htm

  

• Question 49:

  Which of the following is NOT a new feature introduced in Tableau 2020.1?

  A. Dynamic Paramaters

  B. Viz Animations

  C. Buffer Calculations

  D. Set Control

  Correct Answer: D

  Your Tableau Desktop Specialist exam will be based on the 2020.1 version. Set controls are a new feature introduced in the 2020.2 version, and hence is the correct answer-it is not a part of 2020.1

  For the 2020.1 version the new features were:

  1) Viz animations:

  Viz animations help you see and understand your changing data. It's easy to track the logical steps behind data's evolution and tell powerful data stories. Sorting, filtering, adding fields, and other actions will now smoothly animate your

  visualizations. Choose whether to turn Viz Animations on or off, and decide how you'd best like to apply animations to your new workbooks.

  

  2) Dynamic Parameters:

  Say goodbye to republishing workbooks with parameters every time the underlying data changes. Set your parameter once, and Tableau will automatically update the parameter's list of values every time someone opens the workbook.

  

  3) Buffer Calculations:

  

  Buffer calculations allow you to visualize the distance around point locations. Give Tableau three parameters--location, distance, and a unit of measure--and a buffer, or boundary is instantly created. Answering complex spatial questions becomes easier than ever before--visualize what properties are within 200 meters of a proposed transit site, or how many competitors' stores are within 1 mile of their store, and more.

• Question 50:

  Download the Dataset from: https://drive.google.com/file/d/12AYHfiPWkwBmvH0zbumOURgUX6Az00Rw/view?usp=sh aring

  Using the Time Series Table, create a line chart to show Sales over time. Which Month and Year witnessed the lowest Sales?

  A. September 2017

  B. March 2018

  C. December 2017

  D. January 2018

  Correct Answer: D

  Follow the steps to get the correct answer : January 2018

  

  We are talking about dates, so use the Time series sheet as follows:

  Next, the following should be your view and clearly, January 2018 is the lowest point:

  

  Read more about dates: https://interworks.com/blog/rcurtis/2017/01/30/tableau-deep-dive-dates-introduction-dates/