Tableau TDS-C01 Online Practice Questions and Exam Preparation

Tableau TDS-C01 Online Questions & Answers

• Question 11:

  You have a scatter plot visualization.

  What should you do to configure the visualization as a density map?

  A. Change the mark shape of the view.
  B. Change the mark type of the view.
  C. Create a custom color palette.
  D. Select heat maps from Show Me.
  B. Change the mark type of the view.

• Question 12:

  True or False: LEFT JOIN returns all rows from the left table, with the matching rows in the right table

  A. True
  B. False
  A. True

  ---

  Explanation/Reference:

  This is true, indeed!

  The LEFT JOIN keyword returns all records from the left table (table1), and the matched records from the right table (table2). The result is NULL from the right side, if there is no match.

  

  Reference: https://www.w3schools.com/sql/sql_join_left.asp

• Question 13:

  What are three reasons to use joins instead of relationships? (Choose three.)

  A. You need to use a specific join type.
  B. You need to create an extract that will have multiple tables.
  C. You need to use row-level security.
  D. You need to use a data model that supports shared dimensions.
  E. You need to connect to multiple databases.
  A. You need to use a specific join type.
  C. You need to use row-level security.
  D. You need to use a data model that supports shared dimensions.

  ---

  Explanation/Reference:

  https://help.tableau.com/current/pro/desktop/en-us/datasource_datamodel_faq.htm#can-i-use-joins-between-logical-tables Use joins only when you absolutely need to. Situations where you might still use joins include when you want to: Continue to use a data source from a pre-2020.2 version to Tableau that you have upgraded to 2020.2 (https://www.youtube.com/watch?v=bypr1QPclao), Join only can be done between data that come from the same connection. Explicitly use a specific join type Use a data model that supports shared dimensions Join need to implement row level security

• Question 14:

  Which statement accurately describes aliases?

  A. You can assign an alias to a field member before creating a visualization.
  B. When you assign an alias, the name changes in the database.
  C. You can create an alias for a discrete measure.
  D. You can create an alias for a continuous dimension.
  A. You can assign an alias to a field member before creating a visualization.

  ---

  Explanation/Reference:

  Alias is only available for discrete dimensions. So C and D are wrong. B is wrong because it doesn't change the real database. So the answer is A.

• Question 15:

  Using the dataset provided, create a crosstab showing the Profit of each Region per Year, then add grand totals to the view. What was the total Profit for Canada in 2012 and the total Profit for Canada for 2011 through 2014, respectively?

  A. 5,129 and 88,872
  B. 52,678 and 311,404
  C. 1,807 and 34,571
  D. 4,888 and 17,817
  D. 4,888 and 17,817

  ---

  Explanation/Reference:

  To reach the correct answer, follow these steps:

  1) Drag Order Date (Discrete Year) to the Column shelf, and Region to the Row Shelf as shown:

  

  2) Drag Profit to Text in the Marks Shelf as shown:

  

  3) Click on Analysis as shown-> Totals-> SELECT ROW GRAND TOTALS The following will be the final view:

  

  You could also Filter by Region to only Focus on Canada, but that's your choice:

  

  THEREFORE,

  2012 = 4,888 2011-> 2014 = 17,817

• Question 16:

  How can you MANUALLY assign geographic roles to a dimension from the data pane?

  A. Edit the config file in My Documents-> MyTableauRepository for a quick fix
  B. Right click it-> Geographic role-> and then assign the appropriate geographic role
  C. Edit the data source manually for a quick resolution
  D. Right click it-> Edit Default properties-> Assign geographic roles
  B. Right click it-> Geographic role-> and then assign the appropriate geographic role

  ---

  Explanation/Reference:

  From the data pane, simply right click on the dimension, choose geographic role, and then select the appropriate role as follows:

  

• Question 17:

  Which of the following is the correct way to calculate Profit Ratio in Tableau?

  A. Profit / Sales
  B. Sales / Profit
  C. SUM(Profit) / SUM(Sales)
  D. SUM(Sales)/SUM(Profit)
  C. SUM(Profit) / SUM(Sales)

  ---

  Explanation/Reference:

  THIS IS A VERY IMPORTANT

• Question 18:

  Tableau auto-generates ____________ dimension(s) and _____________ measure(s) for us

  A. 1 , 4
  B. 2 , 2
  C. 2 , 3
  D. 1 , 2
  A. 1 , 4

  ---

  Explanation/Reference:

  Tableau auto-generates : 1 Dimension-Measure Names 4 Measures-Latitude, Longitude, Number of records, Measure Values

  Starting with Tableau 2020.2, every table in a data source has a Count field, in the form of NameofTable(Count). The table count field is an automatically generated, calculated field. (THIS IS NOT PRESENT IN VERSION 2020.1 ON WHICH THE EXAM IS CURRENTLY BASED)

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

• Question 19:

  Which of the following describes the best way to change the formatting at a workbook level?

  A. Right click anywhere in the view, choose format, and then specify the formatting in the new Format workbook pane.
  B. It is only possible to specify formatting at a worksheet level, not at the workbook level.
  C. Click on Text in the Marks card, choose format, and then specify the formatting in the new Format workbook pane.
  D. Choose Format from the menu on top and then specify the formatting in the new Format workbook pane.
  D. Choose Format from the menu on top and then specify the formatting in the new Format workbook pane.

  ---

  Explanation/Reference:

  It is very much possible to specify the formatting at a WORKBOOK level (all sheets) instead of a single worksheet level.

  You can quickly change how fonts, titles, and lines look in every view in a workbook by specifying format settings at the workbook level, instead of the worksheet level. For example, you might want to use a specific font, size, and color so that

  all views adhere to your company's brand. You might also want to remove grid lines from your views--or make them more noticeable by increasing their pixel size or color. You can also change the theme used by your workbook. Themes

  control items like the default font, colors, and line thickness. When you create a new workbook, it automatically uses the Default theme, which uses visual best practices.

  Change fonts in your workbook:

  You can change all fonts in your workbook or you can change fonts for only certain areas, such as just worksheet titles.

  1) On the Format menu, select Workbook.

  2) The Format Workbook pane replaces the Data pane on the left and provides a series of drop-down lists where you can change all font settings in a workbook, as well as the font settings for titles of worksheets, stories, and dashboards.

  

  Note: If you have made font changes at the worksheet level, such as on a filter card or a worksheet title, changing the font at the WORKBOOK level will overwrite those changes.

  

  Reset a workbook to its default settings

  When you make changes to your workbook's font settings, a gray dot appears next to the setting in the Format Workbook pane. You can quickly switch back to default settings using the Reset to Defaults button.

  1) On the Format menu, select Workbook.

  2) In the Format Workbook pane, click Reset to Defaults.

  

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

• Question 20:

  How can you format an axis as Bold in Tableau?

  A. By choosing the axis and selecting Command/Control + B on your keyboard
  B. By right clicking on the axis, choosing Edit Axis, and then setting its font to bold.
  C. By right clicking on the axis, choosing format, and then setting its font to bold.
  D. By clicking on Format on the main menu bar, choosing field labels, and setting it to bold.
  C. By right clicking on the axis, choosing format, and then setting its font to bold.

  ---

  Explanation/Reference:

  To make an axis bold, simply right click it, select format, and then click on Font to choose Bold:

  

  None of the other options are valid ways to make the axis bold. Read more about editing axis: https://help.tableau.com/current/pro/desktop/en-us/formatting_editaxes.htm