Tableau Tableau Certifications TDS-C01 Questions & Answers

• Question 91:

  Which of the following are valid use-cases for the 'Manage Metadata' functionality?

  A. To clean and automatically fix the data issues in our data source

  B. To see the field name in the original data source

  C. To view all hidden fields

  D. To see the table a field belongs to

  Correct Answer: BCD

  Top of Form

  To clean and automatically fix the data issues in our data source-This is the definition of Data Interpreter.

  To rename the field in the original data source-We never modify the original data source when managing metadata. All changes are local to Tableau for our convenience only.

  All other options can be modified using the Manage Metadata property.

  

• Question 92:

  Which of the following is a benefit of using a Tableau Data Source (.tds)?

  A. To hold one or more worksheets, plus zero or more dashboards and stories.

  B. To 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 etc

  C. To create a single zip file that contains a workbook along with any supporting local file data and background images. This is great for sharing your work with others who don't have access to the original data.

  D. To create a local copy of a subset or entire data set that you can use to share data with others, when you need to work offline, and improve performance.

  Correct Answer: B

  The following are the official definitions from the Tableau documentation for the various file types:

  1) .tds (Tableau Data Source)-To 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 etc.

  (CORRECT ANSWER)

  2) .twbx ( Tableau packaged workbook)-To create a single zip file that contains a workbook along with any supporting local file data and background images. This is great for sharing your work with others who don't have access to the original

  data.

  3) Extract (.hyper or .tde) ?To create a local copy of a subset or entire data set that you can use to share data with others, when you need to work offline, and improve performance.

  3) (.twb) Workbooks ?To hold one or more worksheets, plus zero or more dashboards and stories.

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

• Question 93:

  Which of the following are benefits of using Data Extracts in Tableau?

  A. Improved Performance

  B. Ability to use the data offline

  C. Working with freshest data at all times

  D. Faster to work with

  Correct Answer: ABD

  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. To work with the MOST up-do-date data, use a live connection

  instead!

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

• Question 94:

  Which of the following chart type makes use of 'binned' data?

  A. Gantt Chart

  B. Bullet chart

  C. Histogram

  D. Treemaps

  Correct Answer: C

  A histogram is a chart that displays the shape of a distribution. A histogram looks like a bar chart but groups values for a continuous measure into ranges, or bins.

  

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

• Question 95:

  ______________ is a method for appending values (rows) to tables. You can use this method if both tables have the same columns. The result is a virtual table that has the same columns but extends vertically by adding rows of data.

  A. Joining

  B. Blending

  C. Combining

  D. Unioning

  Correct Answer: D

  Unioning is the correct answer! From the official documentation:

  

  For example, suppose you have the following customer purchase information stored in three tables, separated by month. The table names are "May2016" , "June2016" and "July2016."

  

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

• Question 96:

  Which of the following are valid ways of Grouping Data?

  A. Using Marks in the view

  B. Using Labels in the View

  C. From the Analytics Pane

  D. From the Dimensions Shelf

  Correct Answer: ABD

  **IMPORTANT

• Question 97:

  Is it possible to deploy a URL action on a dashboard object to open a Web Page within a dashboard rather than opening the system's web browser?

  A. YES, we can do this with the help of a plugin

  B. NO, this is not currently possible in Tableau

  C. YES, we can do this with the help of a Web-Page object

  D. YES, we can do this with the help of Tableau Public

  Correct Answer: C

  To interactively display information from the web INSIDE a dashboard, you can use a URL action with a web page object.

  For example, you might have a dashboard that shows profits by country. In addition to showing the profit data in your dashboard, you also want to display supplemental information about the countries from a web site.

  

  

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

• Question 98:

  Which of the following are valid way(s) to make either of Rows or Columns Bold without affecting the other?

  A. Right click on Rows or Columns, and choose format. In the Font option click on Bold.

  B. Select Text Label on the Marks Card, choose Rows or Columns, and then select Bold.

  C. Choose Format then Font from the Menu bar, and select Bold under the Header option

  D. Choose Format from the Menu bar, select Row or Column, and then select Bold under the header option

  Correct Answer: AD

  1) Right click on Rows or Columns, and choose format. In the Font option click on Bold. (CORRECT)-this will modify only the selected axis (row or column)

  

  2) Choose Format then Font from the Menu bar, and select Bold under the Header option (INCORRECT)-this modifies both rows and columns at the same time

  

  3) Choose Format from the Menu bar, select Row or Column, and then select Bold under the header option (CORRECT)-this will modify only the selected axis (row or column)

  

  4) Select Text Label on the Marks Card, choose Rows or Columns, and then select Bold. (INCORRECT)-no such option exists

  

• Question 99:

  True or False: We get different colour pallete options if we drop a discrete field on "Color" in the marks card compared to if we drop a continous field on Color.

  A. False

  B. True

  Correct Answer: B

  Yes! We get different color palettes. They are: *From the official Tableau documentation*

  

  To change the color for a value

  1) Click on an item on the left, under Select Data Item.

  2) Click a new color in the palette on the right. In Tableau Desktop you can hover over a swatch to identify the color.

  3) Repeat for as many values that you want to change.

  4) In Tableau Desktop, click OK to exit the Edit Colors dialog box. In Tableau Server or Tableau Online, simply close the dialog box.

  AND

  

  

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

• Question 100:

  We can join a maximum of ______ tables in Tableau

  A. 16

  B. 32

  C. 64

  D. 128

  Correct Answer: B

  It is possible to join a maximum of 32 tables in Tableau!

  Reference: https://www.mytectra.com/interview-question/tableau-interview-question-and-answers