Tableau Tableau Certifications TDS-C01 Questions & Answers

• Question 21:

  True or False: Tableau can create worksheet-specific filters

  A. True

  B. False

  Correct Answer: A

  Yes, it is possible to create worksheet-specific filters in Tableau. When you add a filter to a worksheet, by default it applies to the current worksheet. Sometimes, however, you might want to apply the filter to other worksheets in the workbook. Then, you can select specific worksheets to apply the filter to or apply it globally to all worksheets that use the same data source or related data sources.

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

• Question 22:

  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%

  Correct Answer: C

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

  Which of the following are compelling reasons to use a Stacked Bar Chart?

  A. To visualize parts of a whole

  B. To easily visualize trends over time

  C. To be able to visualize complex information with fewer bars / marks

  D. To visualize each discrete category using a separate bar.

  Correct Answer: AC

  Stacked bar charts will usually have lesser number of bars compared to a normal bar chart:

  Normal bar chart-9 bars

  

  Stacked Bar Chart-3 bars

  

  We can easily see a 'part-of-a-whole' methodology being used here as well-we are seeing the breakdown of Segments within each Category.

  To easily visualize trends over time-This is the definition of a line chart. To visualize each discrete category using a separate bar-This can be accomplished using a simple bar chart, why use a stacked one?

• Question 24:

  To customize links based on the data in your dashboard, you can automatically enter field values as _______________ in URLs

  A. parameters

  B. sets

  C. values

  D. inputs

  Correct Answer: A

  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.

  Read more in depth at : https://help.tableau.com/current/pro/desktop/en-us/actions_url.htm

• Question 25:

  How would you calculate GDP per capita in Tableau?

  A. SUM([GDP]/[POPULATION])

  B. SUM([Population]/[GDP]])

  C. SUM([GDP]*[POPULATION])

  D. SUM([GDP]) / SUM([Population])

  Correct Answer: D

  GDP / Population = GDP Per Capita

  

  Here Sum is a function, / and + are operators. On the bottom there are comments.

• Question 26:

  Which of the following sets would you use to compare the members?

  A. None of these

  B. Dynamic Sets

  C. Static Sets

  D. Combined Sets

  Correct Answer: D

  You can combine two sets to compare the members. When you combine sets you create a new set containing either the combination of all members, just the members that exist in both, or members that exist in one set but not the other. Combining sets allows you to answer complex questions and compare cohorts of your data. For example, to determine the percentage of customers who purchased both last year and this year, you can combine two sets containing the customers from each year and return only the customers that exist in both sets. To combine two sets, they must be based on the same dimensions. That is, you can combine a set containing the top customers with another set containing the customers that purchased last year. However, you cannot combine the top customers set with a top products set.

  

  Text, letter

  

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

• Question 27:

  In which of the following scenarios would having a live connection be more beneficial than using an extract?

  A. Analyzing real time stock prices

  B. Analyzing real time data from production systems

  C. Analyzing historical housing prices

  D. Analyzing and tracking real time flight updates

  E. Analyzing a subset of a dataset having 1 billion rows

  Correct Answer: ABD

  Extracts would be more beneficial for analyzing historical prices where we won't be making use of any real time data being streamed. Same is the case for enormous datasets having billions of rows (extracts will be more efficient in analyzing subsets of such large data).

  As for live stock prices, flight updates, real time updates from production or mission critical systems-having a live connection is the most logical choice, since we need access to the most fresh and recent data possible at all times!

• Question 28:

  How do you identify a continuous field in Tableau?

  A. It is identified by a blue pill in the visualization

  B. It is identified by a green pill in a visualization

  C. It is preceded by a '=#' symbol in the data window

  D. It is preceded by a 'Abc' symbol in the data window

  Correct Answer: B

  When you connect to a new data source, Tableau assigns each field in the data source as dimension or measure in the Data pane, depending on the type of data the field contains. You use these fields to build views of your data.

  

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

• Question 29:

  As a general best practice, how many categories can a pie chart display effectively?

  A. 2 to 5

  B. 3 to 5

  C. 2 to 8

  D. 3 to 7

  Correct Answer: A

  As a general best practice, your pie chart should contain 2 to 5 categories. Anything more than that is not easy for the eyes to distinguish. This is a common question and mentioned in Tableau's own eLearning module as well! See how to build a pie chart: Reference: https://help.tableau.com/current/pro/desktop/en-us/buildexamples_pie.htm

  

• Question 30:

  _____________ is a snapshot of the data that Tableau stores locally. Good for very large datasets of which we only need few fields.

  A. Tableau Packaged Workbook (.twbx)

  B. Tableau Workbook (.twb)

  C. Tableau Data Extract (.tde)

  D. Tableau Data Source (.tds)

  Correct Answer: C

  Tableau Data Extract (TDE) is a snapshot of the data that Tableau stores locally. Good for very large datasets of which we only need few fields. Performance is optimised because it queries its own database engine instead of the local data

  source. When you create an extract of your data, you can reduce the total amount of data by using filters and configuring other limits. After you create an extract, you can refresh it with data from the original data. When refreshing the data,

  you have the option to either do a full refresh, which replaces all of the contents in the extract, or you can do an incremental refresh, which only adds rows that are new since the previous refresh.

  Extracts are advantageous for several reasons:

  1) Supports large data sets: You can create extracts that contain billions of rows of data.

  2) Fast to create: If you're working with large data sets, creating and working with extracts can be faster than working with the original data.

  3) Help improve performance: When you interact with views that use extract data sources, you generally experience better performance than when interacting with views based on connections to the original data.

  4) Support additional functionality: Extracts allow you to take advantage of Tableau functionality that's not available or supported by the original data, such as the ability to compute Count Distinct.

  5) Provide offline access to your data: Extracts allow you to save and work with the data locally when the original data is not available. For example, when you are traveling.