Tableau Tableau Certifications TDS-C01 Questions & Answers

• Question 11:

  If you decide you want to see all of the marks in the view at the most detailed level of granularity, you can __________________ the view.

  A. sort the measures

  B. disaggregate the measures

  C. break-down the measures

  D. aggregate the measures

  E. split the measures

  Correct Answer: B

  

  The different aggregations available for a measure determine how the individual values are collected: they can be added (SUM), averaged (AVG), or set to the maximum (MAX) or minimum (MIN) value from the individual row values. For a

  complete list of the available aggregations, check out-List of Predefined Aggregations in Tableau.

  The level of detail is determined by the dimensions in your view--for information about the concept of level of detail, see How dimensions affect the level of detail in the view. Disaggregating your data can be useful for analyzing measures that

  you may want to use both independently and dependently in the view. For example, you may be analyzing the results from a product satisfaction survey with the Age of participants along one axis. You can aggregate the Age field to determine

  the average age of participants or disaggregate the data to determine at what age participants were most satisfied with the product. Disaggregating data can be useful when you are viewing data as a scatter plot. See Example: Scatter Plots,

  Aggregation, and Granularity.

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

• Question 12:

  Which of the following are valid ways to export a dashboard with multiple visualisations as an image?

  A. Click on Worksheet in the Menu bar followed by Export, then choose Image

  B. using the floating export worksheet option on the Dashboard

  C. Right click on the dashboard, and choose Copy, then image.

  D. Click on Dashboard in the Menu bar followed by Copy Image

  Correct Answer: D

  Only 1 option is correct Click on Dashboard in the Menu bar followed by Copy Image

  

  Right click on the dashboard, and choose Copy, then image-Try doing this, you will end up copying just one of the worksheets not the entire dashboard Click on Worksheet in the Menu bar followed by Export, then choose Image-Again, try doing this. You will end up copying just one of the worksheets not the entire dashboard Using the floating export worksheet option on the Dashboard-No such option exists

• Question 13:

  Broadly speaking, after an importing a dataset in Tableau Desktop, all fields in it are broken down into _______________________

  A. Dimensions and Measures

  B. Rows and Columns

  C. Labels and Values

  D. Numbers and Headers

  Correct Answer: A

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

  For Bullet Graphs we need at least ____________ measures

  A. 3

  B. 1

  C. 2

  D. 4

  Correct Answer: C

  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. Therefore, we need at least 2 measures for creating bullet graphs.

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

• Question 15:

  Using the Geo Data table, create a Bar chart showing the In-Stock percentage for each Color. What is the Average In-Stock percentage for the Color Red? Present your answer correctly upto 2 decimal places.

  A. 96.46%

  B. 95.12%

  C. 97.12%

  D. 99.46%

  Correct Answer: C

  Not too tough. Follow along the steps:

  Drag Color to Filter and choose Red:

  3) Now to display the percentage correctly, lets format it. Click on the In Stock % pill in the Row shelf, and select format:

  And your final view will look like :

  

• Question 16:

  You have cleaned a data source properly, created some calculated fields and renamed some columns. You want to save these changes for future use cases. Which of the following would BEST satisfy this requirement?

  A. Save it as a .twm file

  B. Save it as a .twb file

  C. Save it as a .tds file

  D. Save it as a .twbx file

  Correct Answer: C

  After making changes to Data, we can save that new data source as a .tds file. To do so, go to data menu on top and then choose your current connected data source. Then next click on Add to Saved Data sources. This will save all calculated fields, changes to fields etc. It will be saved in My Tableau Repository-> Mydatasources. This will then also appear on Tableau Home Page under saved data sources like SampleSuperStore. Note: Data source files do not contain the actual data but rather the information necessary to connect to the actual data as well as any modifications you've made on top of the actual data such as changing default properties, creating calculated fields, adding groups, and so on.

  twb and .twbx are not the BEST solutions since the questions nowhere mentions that we need to store our workbooks as well. twm is a bookmark which contains a single worksheet and are an easy way to quickly share your work.

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

• Question 17:

  Is it possible to make a Measure discrete?

  A. No

  B. Yes

  Correct Answer: B

  Right click on any measure, and choose Discrete as shown:

  

  Once you do this, the green pill becomes blue in colour, indicating that it is now Discrete!

  

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

• Question 18:

  DOWNLOAD THE DATASET FROM:

  https://drive.google.com/drive/folders/1WXzqsrNmXVdmQ- 574wld4InEplyKT8RP?usp=sharing (if you haven't already)

  Using the cwurData table, plot a Map to see which country had the Second highest number of patents in the Year 2013?

  A. United States

  B. France

  C. United Kingdom

  D. Canada

  Correct Answer: B

  Follow along to get the correct answer:

  Drag Country to the view, and then Patents to the Size Mark on the Marks shelf as follows :

  2) But, this isn't all right? We need to focus on the year 2013. This can be done by using the year column as it is (continuous) in the filter shelf, or by converting it to discrete first and then using it:

  2.1 As it is (continuous)

  

  2.2 Converting to discrete first and then using it

  

  and then :

  

  3) We can now see that France, with 485 has the 2nd most number of patents for the year

  

• Question 19:

  The icon associated with the field that has been grouped is a ______________

  A. Paper Clip

  B. Globe

  C. Intersection

  D. =#

  Correct Answer: A

  You can create a group to combine related members in a field. The icon associated with a group is a paper clip!

  

• Question 20:

  Which of the following are valid Layout Container types when using Dashboards in Tableau?

  A. Vertical Container

  B. Diagonal Container

  C. Horizontal Container

  D. Split Container

  Correct Answer: AC

  

  Chart

  

  

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