Tableau Tableau Certifications TDS-C01 Questions & Answers

• Question 171:

  ________________ can only create header. _______________ will create header and axis both.

  A. Dimensions, Measures

  B. Measures, Dimensions

  C. Groups, Sets

  D. Dates, Strings

  Correct Answer: A

  Using the Sample superstore as a reference:

  1) Let's plot a bar chart showing SUM(Quantity) for each Segment:

  2) Right click on the x-axis (Segment):

  Notice we don't have an option to edit the axis, only header. This is because only continous values form the AXIS.

  3) Similarly, right click on the y-axis (Quantity):

  Now we have the option to edit BOTH the axis and the header. Reference: https://help.tableau.com/current/pro/desktop/en-us/view_parts.htm

  2) Right click on the x-axis (Segment):

  Notice we don't have an option to edit the axis, only header. This is because only continous values form the AXIS.

  3) Similarly, right click on the y-axis (Quantity):

  Now we have the option to edit BOTH the axis and the header.

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

• Question 172:

  Which of the following options best describe measures?

  A. They are categorical, qualitative

  B. They are categorical, quantitative

  C. They are numerical, qualitative

  D. They are numerical, quantitative

  Correct Answer: D

  Data fields are made from the columns in your data source. Each field is automatically assigned a data type (such as integer, string, date), and a role: Discrete Dimension or Continuous Measure (more common), or Continuous Dimension or

  Discrete Measure (less common).

  Dimensions contain qualitative values (such as names, dates, or geographical data). You can use dimensions to categorize, segment, and reveal the details in your data. Dimensions affect the level of detail in the view.

  Measures contain numeric, quantitative values that you can measure. Measures can be aggregated. When you drag a measure into the view, Tableau applies an aggregation to that measure (by default).

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

• Question 173:

  Dates in Tableau are typically treated as ______________

  A. Dimensions

  B. Measures

  Correct Answer: A

  For relational data sources, dates and times are automatically placed in the Dimensions area of the Data pane and are identified by the date or date-time icon. For example, the Order Date and Ship Date dimensions from an Excel data source are shown below:

  

  When you place a relational date on a shelf, the field name is automatically modified to reflect the default date level. Tableau defines the default date level to be the level at which there are multiple instances. For example, if the date field includes multiple years, the default level is year. However, if the date field contains data for just one year but includes multiple months, then the default level is month.

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

• Question 174:

  A field that shows average home values for the United States in 2016 is most likely :

  A. A discrete date part dimension

  B. A continuous date value dimension

  C. A geographical dimension

  D. An aggregated measure

  Correct Answer: D

  This question is directly from the Official Tableau Desktop Specialist exam guide. Since we are talking about the AVERAGE home values for the United States in 2016, the question is directly offering us a hint that the answer has something to do with aggregation and that too the values tell us that we're working with MEASURES. Date part and Date values don't really make much sense given the question, and neither does geography.

  Therefore, the answer naturally is "An aggregated measure".

• Question 175:

  True or False: It is possible to change the Geographic Role of a dimension

  A. True

  B. False

  Correct Answer: A

  A geographic role associates each value in a field with a latitude and longitude value. Assigning a geographic role based on the type of location (such as state versus postcode) helps ensure that your data is plotted correctly on your map

  view. For example, you can assign the City geographic role to a field that contains a list of city names.

  To assign a geographic role to a field:

  In the Data pane, click the data type icon next to the field, select Geographic Role, and then select the geographic role you want to assign to the field.

  

  When you assign a geographic role to a field, Tableau adds two fields to the Measures area of the Data pane: Latitude (generated) and Longitude (generated). These fields contain latitude and longitude values and are assigned the Latitude and Longitude geographic roles. If you double-click each of these fields, Tableau adds them to the Columns and Rows shelves and creates a map view using the Tableau background map.

  

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

• Question 176:

  Data blending simulates a traditional _________________ Join

  A. Inner B. Right

  C. Full Outer

  D. Left

  Correct Answer: D

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

  You have just created a histogram and now want to be able to change the size of bins dynamically. Using which of the following will easily satisfy your requirement?

  A. Sets

  B. Groups

  C. Calculation

  D. Parameters

  Correct Answer: D

  A parameter is a global placeholder value such as a number, date, or string that can replace a constant value in a calculation, filter, or reference line.

  For example, you may create a calculated field that returns True if Sales is greater than $500,000 and otherwise returns False. You can replace the constant value of "500000" in the formula with a parameter. Then, using the parameter control, you can dynamically change the threshold in your calculation. Reference: https://help.tableau.com/current/pro/desktop/en-us/parameters_create.htm

• Question 178:

  Using the CoffeeChain table, create a Dual Axis chart showing the Sales (Bar chart) and Profit (Line Chart) for each Product type. What was the Profit for the Herbal Tea product type in 2013?

  A. 68,620

  B. 74,683

  C. 37,455

  D. 46,493

  Correct Answer: C

  If you answered this question quickly and correctly, you're well prepared for the exam! Most students stumble while creating a Dual axis chart, so go ahead and give yourself a pat on the back! To create a dual axis chart for the problem mentioned:

  1) Drag Product Type to the column shelf, and Sales and Profit to the Row shelf:

  

  2) Now, to focus on 2013, drag Date to the filter shelf and select only 2013:

  

  3) Now, click on the Profit pill in the Rows Shelf, and select dual axis:

  

  4) Now, in the marks shelf, choose Sales, and change the chart type to bar. Similarly, for Profit, change the chart type to Line.

  

  Now the chart looks like this:

  

  Now we change the Profit chart type to line:

  

  

  5) Finally, we synchronise the axis as follows: Right click on the axis, and choose 'Synchronise axis'

  

• Question 179:

  True or False: The Highlighting action can be disabled for the entire workbook.

  A. True

  B. False

  Correct Answer: A

  Yes, it is possible to disable highlighting for the entire workbook.

  

  For more information : https://help.tableau.com/current/pro/desktop/en-gb/actions_highlight.htm

• Question 180:

  

  You clicked Sheet 1 from the data source page, and now you have opened the Tableau Desktop workspace as shown above. What is the main thing that you do here?

  A. Clean the data

  B. Preview the data

  C. Create visualisations to analyze your data

  D. Rename the fields and change data types

  Correct Answer: C

  The Tableau workspace consists of menus, a toolbar, the Data pane, cards and shelves, and one or more sheets. Sheets can be worksheets, dashboards, or stories. For details on dashboard or story workspaces, see Create a Dashboard or The Story Workspace.

  

  The main thing you do in the workspace is to create visualisations to analyze your data.

  Renaming data fields, cleaning the data, previewing the data can all be done in the Data source window.

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