Tableau TDS-C01 Online Practice Questions and Exam Preparation

Tableau TDS-C01 Online Questions & Answers

• Question 171:

  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
  C. 112,256

  ---

  Explanation/Reference:

  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

• Question 172:

  Which of the following are valid options to define the scope of a reference line? Choose 3.

  A. Pane
  B. Table
  C. Section
  D. Window
  E. cell
  F. Axis
  A. Pane
  B. Table
  E. cell

  ---

  Explanation/Reference:

  When we create a reference line, we get the following 3 options for the scope:

  

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

• Question 173:

  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
  C. Go to URL

  ---

  Explanation/Reference:

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

  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
  C. 10

  ---

  Explanation/Reference:

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

  Using the CoffeeChain table, create a crosstab showing the Total Expenses per State and add Column Grand Totals to the view. Now group the states of New York, California and Washington. What percent of the total sales does this group contribute?

  A. 25.79%
  B. 23.39%
  C. 27.73%
  D. 29.49%
  C. 27.73%

  ---

  Explanation/Reference:

  We need to use the concept of Groups for this question. Follow along:

  1) First, Drag State to the Rows shelf, and Total Expenses to the Text Mark on the Marks Shelf:

  

  2) Now, remove the SUM aggregation from Total Expenses, and add a quick table calculation-> Percent of total:

  

  3) Next, Select the States of New York, California and Washington-> And then click the paperclip icon:

  

  We can see the answer already : 23.386% in the view above (even before grouping!)

  4) Finally, we get the following view and our answer:

• Question 176:

  You create a dashboard that tracks your team's progress on various projects.

  On the dashboard you want to display your company's web page.

  Which dashboard element should you use?

  A. A web page object
  B. An extension
  C. A navigation object
  D. A URL action
  A. A web page object

• Question 177:

  What are two methods for renaming a field in a visualization? (Choose two.)

  A. From the Data pane, use the field's drop-down menu and select Rename.
  B. From the Data pane, right-click the field and select Replace References.
  C. From the Data pane, click and hold on the field until the name is editable.
  D. From the Format menu, select Field Labels.
  A. From the Data pane, use the field's drop-down menu and select Rename.
  C. From the Data pane, click and hold on the field until the name is editable.

  ---

  Explanation/Reference:

  https://shantikanhai.medium.com/learn-tableau-how-to-rename-a-data-field-b1ef78a1c68b

• Question 178:

  Using the Time Series Table, create a Line chart showing the Monthly Year over Year Growth for the Sales, broken down by Assortment. For the Electronics assortment, which Month had the most NEGATIVE value of Year over Year Growth?

  A. October
  B. September
  C. July
  D. June
  A. October

  ---

  Explanation/Reference:

  Follow along:

  1) Drag Assortment and Year ID (choose Discrete Month) to Columns shelf, and Sales to the Columns Shelf.

  For sales, click on the pill-> choose Quick Table calculation-> Year over Year growth.

  The view should now look like:

  

  It is clear that October with-55.3% had the lowest Year on Year growth.

• Question 179:

  Data blending simulates a traditional _________________ Join

  A. Inner B. Right
  C. Full Outer
  D. Left
  D. Left

  ---

  Explanation/Reference:

  Data blending simulates a traditional left join. The main difference between the two is when the aggregation is performed. A join combines the data and then aggregates. A blend aggregates and then combines the data. From the official website:

  

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

• Question 180:

  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
  D. January 2018

  ---

  Explanation/Reference:

  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/