Tableau Tableau Certifications TDS-C01 Questions & Answers

• Question 201:

  Which of the following is an example of a Date Part?

  A. Q4 2017

  B. March 2019

  C. September 2020

  D. November

  Correct Answer: D

  All answers except November are examples of Date Values (continuous in nature). See below:

  

  You can see that the option in Green symbolizes our correct answer, i.e only a Month. In our case that month is November (the correct answer).

  All other options are combinations of a year with one other value (like a month, quarter, or day). So this is how by looking at an option you can know if its a date part or date value!

• Question 202:

  Which of the following returns the Absolute Value of a given number?

  A. ABS(Number)

  B. CEILING(Number)

  C. FLOOR(Number)

  D. ZN(Number)

  Correct Answer: A

  From the official Tableau website: Reference: https://help.tableau.com/current/pro/desktop/en-us/functions_functions_number.htm

  

  

• Question 203:

  True or False: Physical tables remain distinct (normalized), not merged in the data source whereas logical tables are merged into a single, flat table.

  A. True

  B. False

  Correct Answer: B

  In fact, the opposite of this is true.

  Trick : Whenever you think of joins-> Think that after the join is created, we get 1 single flat combined (joined) table. This flat combined table is created prior to us creating our visualizations. This happens at the physical layer. If you ever think about relationships, know that all tables will remain distinct and separate, and relationships sit at the logical layer. At run time, when you bring in the dimensions and measures to create your viz, Tableau very smartly creates the necessary joins, relates the tables and sends queries to these tables to get the resultant data back in the most meaningful way possible. This allows you to focus on using your data and revealing insights from it and focus less on the data preparation aspect!

  Refer to logical layer vs physical layer from the official documentation: https://help.tableau.com/current/server/en-us/datasource_datamodel.htm

• Question 204:

  What is the following icon in the Data pane used to do? Larger image

  

  A. View Data

  B. Clean Data

  C. Extract Data

  D. Sort Data

  Correct Answer: A

  View Data allows you to inspect your data in a spreadsheet-like layout. You can view data either for the data source as a whole, or to see the underlying data for an individual mark or a group of marks. In a worksheet, the rows that you see in the View Data window are always scoped to the current selection or the current view. The View Data window displays as much of the data as possible by default, up to 10,000 rows. Field names are shown as column headers and can be dragged and dropped to change their display order. Click a column header to sort the values in that column.

  From the official website: Reference: https://help.tableau.com/current/pro/desktop/en-us/inspectdata_viewdata.htm

  

• Question 205:

  By definition, Tableau displays measures over time as a ____________

  A. Packed Bubble

  B. Bar

  C. Stacked Bar

  D. Line

  Correct Answer: D

  Line charts connect individual data points in a view. They provide a simple way to visualize a sequence of values and are useful when you want to see trends over time, or to forecast future values. Please refer to the images below: Reference: https://help.tableau.com/current/pro/desktop/en-us/buildexamples_line.htm

  

  

• Question 206:

  Yes or No: The number of marks will increase when you increase the number of Dimensions in a view

  A. No

  B. Yes

  Correct Answer: B

  Of course! As an example, see below:

  1) Using the Sample Superstore data, let's plot a bar chart showing the Sales for each Category:

  

  Observe that we have 3 marks-Each bar in a bar chart is called a mark. Similarly, each point in a scatter plot is also a mark , and so on for all charts. 1 row by 3 columns means that clearly on the y-axis (Sales), we have only a single mark-a single continous axis, but 3 different marks (Technology, Furniture and Office supplies ) on the x-axis.

  2) Now let's add subcategory to the view as well (another dimension):

  

  Observe that the number of marks has increased-i.e the number of Bars.

  Also, notice we now have 1 row and 17 columns. Simply because 1 row = Sales (on the y-axis), and on the x-axis, we have 17 different columns (i.e product sub categories!!)

• Question 207:

  Which of the following 2 fields CANNOT be deleted in Tableau?

  A. Number of Records

  B. Measure Names

  C. Measure Values

  D. Calculated Fields

  Correct Answer: BC

  Measure names and values CANNOT be deleted in Tableau like other columns can. These are auto-generated. Calculated Fields, and Number of records can both be deleted.

• Question 208:

  For a relative date filter, the default anchor is _________________

  A. The current time

  B. Today's date

  C. The target date

  D. The date we specify

  Correct Answer: B

  Relative date filters dynamically update to show a time period relative to when you open the view, such as the current week, the year to date, or the past 10 days. Relative date filters make it easy to create views that always show the most

  recent data.

  Step 1: Drag a date field to the filter shelf

  Right-click (control-click on Mac) and drag a date field from the Data window to the Filters shelf. In the Filter Field dialog box, click Relative Date, and then click Next.

  

  Step 2: Select a time unit

  In the Filter dialog box, click Relative dates, and then select the unit of time for the filter. For example, to show only the three most recent weeks, select Weeks.

  

  Here, you can clearly see that the default date is TODAY Reference: https://help.tableau.com/current/pro/desktop/en-us/qs_relative_dates.htm

• Question 209:

  Which of the following are interactive elements that can be added to a dashboard for users?

  A. URL Action B. Filter Action

  C. Highlight Action

  D. Edit Tooltip Action

  Correct Answer: ABC

  We can perform filter, URL and highlight actions out of the above given choices on a dashboard. Please refer to the image below:

  

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

• Question 210:

  Which of the following are the options to export the data used to build the view / visualisations?

  A. CSV file

  B. PDF File

  C. JSON format

  D. MS Access Database

  Correct Answer: AD

  You can export the data in a Tableau data source, including all or part of the records from your original data. Alternatively, you can export only the portion of data used to generate the view.

  Since the question mentions the data used to build the view, we'll focus on that :

  *Export data in the view to Microsoft Access or .csv* Export the data that is used to generate the view as an Access database (Windows only) or .csv file (Mac only).

  1) In Tableau Desktop, select Worksheet > Export > Data.

  2) Select a location and type a name for your Access database or .csv file.

  3) Click Save.

  4) If you're on Windows, the Export Data to Access dialog box displays to give you the option to immediately use the new Access database and continue working in Access without interrupting your work flow.

  

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