Tableau Tableau Certifications TDS-C01 Questions & Answers

• Question 51:

  When using the manage metadata option, we can create custom names for columns where _____________ is the original name of the column whereas _____________ is the custom name we created in Tableau.

  A. Remote Field Name, Field Name

  B. Local Name, Actual Name

  C. Column Name, Actual Name

  D. Local Field, Global Field

  Correct Answer: A

  Using the Sample superstore as a reference, click on the manage metadata icon as follows:

  

  We can rename a particular column name to make it easier to remember and use in Tableau. Let's change Order ID to oID as shown:

  

  Now, we'll see oID when using this data source in Tableau. This WILL NOT affect the original data source. The remote field name let's us see what the name of the column is in the ORIGINAL Data source. Reference: https://help.tableau.com/current/pro/desktop/en-us/environment_datasource_page.htm#Metadata

• Question 52:

  Which of the following is true about 'Incremental refresh' when creating Extracts in Tableau?

  A. It only adds rows that are new since the previous refresh.

  B. There is no difference, both are the same when using extracts. They are different when using live connections.

  C. It replaces all of the contents in the extract

  D. They can only be used with large datasets

  Correct Answer: A

  Extracts are saved subsets of data that you can use to improve performance or to take advantage of Tableau functionality not available or supported in your original data. When you create an extract of your data, you can reduce the total

  amount of data by using filters and configuring other limits. After you create an extract, you can refresh it with data from the original data.

  When refreshing the data, you have the option to either do a full refresh, which replaces all of the contents in the extract, or you can do an incremental refresh, which only adds rows that are new since the previous refresh.

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

• Question 53:

  True or False: All rows from both tables are returned in an INNER JOIN

  A. True

  B. False

  Correct Answer: B

  The INNER JOIN keyword selects all rows from both tables as long as there is a match between the columns. Consider 2 tables "Orders" and "Customers". If there are records in the "Orders" table that do not have matches in "Customers", these orders will not be shown!

  

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

• Question 54:

  If you are working with a huge dataset, which of the following are strong reasons to use a context filter?

  A. Improve query performance

  B. To make the context filter a dependent filter

  C. To help clean the data

  D. To include only the data of interest

  Correct Answer: AD

  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 (Option stating-To create a dependent filter eliminated here). 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.

  For example, suppose you're in charge of breakfast products for a large grocery chain. Your task is to find the top 10 breakfast products by profitability for all stores. If the data source is very large, you can set a context filter to include only breakfast products. Then you can create a top 10 filter by profit as a dependent filter, which would process only the data that passes through the context filter.

  

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

• Question 55:

  True or False: When relating tables, the fields that define the relationships must have the same data type.

  A. True

  B. False

  Correct Answer: A

  According to the official documentation, the following are the requirements for using relationships:

  1) When relating tables, the fields that define the relationships must have the same data type. Changing the data type in the Data Source page does not change this requirement. Tableau will still use the data type in the underlying database

  for queries.

  2) You can't define relationships based on geographic fields.

  3) Circular relationships aren't supported in the data model.

  4) You can't edit relationships in a published data source.

  5) You can't define relationships between published data sources.

  6) Your workbook must use an embedded data source for you to be able to edit relationships and performance options in the Data Source page in Tableau Online or Tableau Server.

  Reference: https://help.tableau.com/current/online/en-us/datasource_relationships_learnmorepage.htm

• Question 56:

  If you see the following Filter, then you're working with _______________________ Larger image

  

  A. Grouped Dates

  B. Date Functions

  C. Date Parts

  D. Date Values

  Correct Answer: D

  Dates in Tableau will behave differently depending on whether they are a Datepart (blue) or a Datevalue (green). This affects how the axes display/behave and also how visualisations such as line charts will display. The difference essentially boils down to Dateparts behaving like a dimension as opposed to a measure which is how Datevalues behave. This means that Dateparts behave like discrete categories on the view whereas Datevalues are more like continuous numeric values.

  Dateparts are discrete and they behave the same as dimension filters. If all dates are used on the filter then each individual date will be a datepart that can be selected/excluded. This is the same for each level of date, if datepart months is placed on filters January to December will be tick-able options in the filter. This also means that conditions and top/bottom filters can be applied to datepart filters like any other dimension filter. Datevalues placed on filters behave like measure filters. A min and a max date can be set and there is a relative dates option which allows you to choose things like only show the previous 3 months or years etc.

  

  Reference: https://www.thedataschool.co.uk/harry-cooney/tableau-dateparts-vs-datevalues/

• Question 57:

  In Tree maps, the size begins with the largest rectangle on the ________________ and the smallest rectangle on the ________________.

  A. top left bottom left

  B. top right, bottom right

  C. top left, bottom right

  D. top right, bottom left

  Correct Answer: C

  Tree maps size begins from maximum in top left to smallest in bottom right.

  

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

• Question 58:

  _______________ enables us to create workbooks and views, dashboards, and data sources in Tableau Desktop, and then publish this content to our own server.

  A. Tableau Server

  B. Tableau Prep

  C. Tableau Public

  D. Tableau myServer

  Correct Answer: A

  Tableau SERVER enables us to create workbooks and views, dashboards, and data sources in Tableau Desktop, and then publish this content to our own server. Moreover, as a Tableau Server administrator you will control who has access to server content to help protect sensitive data. Administrators can set user permissions on projects, workbooks, views, and data sources.

  Reference: https://www.tableau.com/learn/webinars/introduction-tableau-server

• Question 59:

  _________________ are 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.

  A. .twb files

  B. .tbm files

  C. .twbx files

  D. .tde files

  Correct Answer: D

  According to the official Tableau documentation:

  Depending on the version the extract was created in, Tableau extract files can have either the .hyper or .tde file extension. Extract files are 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. For more information, see Extract Your Data.

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

• Question 60:

  We can use ______________ as a static tool to open and interact with packaged workbooks with extracted data sources that have been created in Tableau Desktop.

  A. Tableau Reader

  B. Tableau Online

  C. Tableau Server

  D. Tableau Desktop

  Correct Answer: A

  The word 'static tool' gives it away. According to the official website :

  

  Reference: https://help.tableau.com/current/reader/desktop/en-us/reader_welcome.htm