Tableau Tableau Certifications TDS-C01 Questions & Answers

• Question 71:

  _________________ is useful when you need to change how the data source is configured on a sheet-by-sheet basis, and when you want to combine databases that don't allow relationships or joins

  A. Union

  B. Data Joining

  C. Data segregation

  D. Data Blending

  Correct Answer: D

  Data blending is performed on a sheet-by-sheet basis and is established when a field from a second data source is used in the view. To create a blend in a workbook already connected to at least two data sources, bring a field from one data

  source to the sheet--it becomes the primary data source.

  Switch to the other data source and use a field on the same sheet--it becomes a secondary data source. An orange linking icon will appear in the data pane, indicating which field(s) are being used to blend the data sources.

  

  According to the official Tableau Documentation:

  

  To read more about Data Blending, click on THIS link.

• Question 72:

  True or False: Sets can be created on Measures

  A. True

  B. False

  Correct Answer: B

  Sets are custom fields that are created within Tableau Desktop based on dimensions from your data source. They are subsets of your data, which can be created manually or computed. Either dimensions or measures can be used to determine what is included or excluded from a set using conditional logic, but to CREATE a set we use dimensions.

  

  

  Reference : https://interworks.com/blog/rcurtis/2016/10/26/tableau-deep-dive-sets-introduction-sets/

• Question 73:

  Using the Time Series Table, create a Line chart showing the Monthly Year over Year Growth for the Sales, broken down by Assortment. For the Electronics assortment, which Month had the most NEGATIVE value of Year over Year Growth?

  A. October

  B. September

  C. July

  D. June

  Correct Answer: A

  Drag Assortment and Year ID (choose Discrete Month) to Columns shelf, and Sales to the Columns Shelf. For sales, click on the pill-> choose Quick Table calculation-> Year over Year growth.

• Question 74:

  In order to avoid any confusions, what should you do after creating a Dual-axis chart?

  A. Hide the axis

  B. Change the colours

  C. Synchronise the axis

  D. Edit the labels

  Correct Answer: C

  After creating a dual axis chart, make sure to synchronise their axis since they both might not be having the same y-axis.

  

  , chart, line chart

  To align the two axes in a dual axes chart to use the same scale, right-click (control-click on Mac) the secondary axis, and select Synchronize Axis. This aligns the scale of the secondary axis to the scale of the primary axis. In this example,

  the Sales axis is the secondary axis and the Profit axis is the primary axis. If you would like to change which axis is the primary, and which axis is the secondary, select the field on the Columns or Rows shelf that is the secondary, and drag it

  in front of the primary field on the shelf until you see an orange triangle appear.

  In this example, you can select the SUM(Sales) field on the Rows shelf, and drag it in front of the SUM(Profit) field. The Sales axis is now the primary and the Profit axis is the secondary.

  

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

• Question 75:

  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)

  Correct Answer: C

  THIS IS A VERY IMPORTANT

• Question 76:

  Which of the following is a compelling reason to export a sheet in Tableau to a PDF?

  A. If we want a static view of the visualisation.

  B. If we want to use filters in the visualisation.

  C. If we want to interact with the visualisation.

  D. If we want to dynamically enter parameters to the visualisation.

  Correct Answer: A

  Exporting the visualisation gives us a static view of the visualisation.

  It is NOT possible to interact with it, use filters, or dynamically enter anything in a visualisation exported PDF.

  In Tableau Desktop, you can save views as PDF files rather than printing them as hard copies. You do not need to have Adobe Acrobat installed on your computer. When you print an individual sheet to PDF, filters in the view are not included.

  To show filters, create a dashboard containing the sheet and export the dashboard to PDF.

  (IMPORTANT)

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

• Question 77:

  When field names in the Union do not match, then:

  A. An error is raised and both fields are dropped from the resulting Union

  B. Only one field name is present in the Union with null values

  C. Only one field name is present in the Union with correct values since Tableau automatically corrects field name mismatch

  D. Both field names are present in the Union, but contain several null values

  Correct Answer: D

  By default, both field names are present in the Union, but contain several null values!

  When field names in the union do not match, fields in the union contain null values. You can merge the non-matching fields into a single field using the merge option to remove the null values. When you use the merge option, the original fields

  are replaced by a new field that displays the first non-null value for each row in the non-matching fields. You can also create your own calculation or, if possible, modify the underlying data to combine the non-matching fields.

  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."

  

  A union of these tables creates the following single table that contains all rows from all tables.

  

  Now suppose a fourth table, "August2016", is added to the underlying data. Instead of the standard "Customer" field name, it contains an abbreviated version called "Cust."

  

  

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

• Question 78:

  When you want to first apply a filter and THEN show the Top N or Bottom N elements, which of the following filters would you use?

  A. Data source Filter

  B. Extract Filter

  C. Context Filter

  D. None of the these

  Correct Answer: C

  By default, all filters that you set in Tableau are computed independently. That is, each filter accesses all rows in your data source without regard to other filters. However, you can set one or more categorical filters as context filters for the

  view. You can think of a context filter as being an independent filter. Any other filters that you set are defined as dependent filters because they process only the data that passes through the context filter.

  You may create a context filter to:

  1) Improve performance ?If you set a lot of filters or have a large data source, the queries can be slow. You can set one or more context filters to improve performance.

  2) Create a dependent numerical or top N filter You can set a context filter to include only the data of interest, and then set a numerical or a top N filter.

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

• Question 79:

  Given a map, which of the following fields can be placed on Size,Shape,Detail,Color

  A. Region, Country, Profit, State

  B. Sales, State, Country, Profit

  C. Profit, State, Number of Records, Sales

  D. Longitude, Country, State, Sales

  Correct Answer: B

  Since Sales is a measure, it can easily be depicted via size. To drill down and change the level of detail, Country is the correct choice since it will contain STATE. We can then depict the various states by different shapes such as circle,

  square etc.

  Finally, the Profit can be depicted via a color! Eg-Red for poor and green for excellent profits!

  Reference: https://www.tableau.com/learn/tutorials/on-demand/aggregation-granularity-and-ratio-calculations

• Question 80:

  True or False : Bins can be created on dimensions

  A. False

  B. True

  Correct Answer: B

  Bin are a user-defined grouping of numerical data in the data source. According to the official Tableau documentation: It's sometimes useful to convert a continuous measure (or a numeric dimension) into bins. Have a look at the following image. When we right click a measure, we get the following options:

  

  However, for a dimension (this is because the DATA TYPE of this dimension is a string:

  

  But what if we have a dimension of type NUMBER (NUMERIC DIMENSION)? See below:

  

  We can clearly create bins from dimensions too-they just have to be numeric :)

  For more information, please refer to : https://help.tableau.com/current/pro/desktop/en-us/calculations_bins.htm