Tableau TDS-C01 Online Practice Questions and Exam Preparation

Tableau TDS-C01 Online Questions & Answers

• Question 241:

  What are two requirements to combine two tables by using a union? (Choose two.)

  A. Related fields must have matching data types.
  B. Related fields must have different names.
  C. The tables must come from different connections.
  D. The tables must have the same number of fields.
  A. Related fields must have matching data types.
  D. The tables must have the same number of fields.

• Question 242:

  When creating a date filter in Tableau, to what does Anchor relative to refer?

  A. The latest date in the data source that can be found.
  B. The mid-point in the range of displayed dates.
  C. The date in a relative-date filter to which you anchor a unit of time.
  D. The date in a range-of-dates filter to which you anchor units of time.
  C. The date in a relative-date filter to which you anchor a unit of time.

• Question 243:

  Using the Time Series table, create a chart that shows the percent difference in Average Inventory on Hand for each Assortment by year and quarter. How many quarters did the Electronics Assortment show a negative percent difference in the Average Inventory On Hand?

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

  ---

  Explanation/Reference:

  If you chose 2, then you were very close but probably didn't plot the actual Percent Difference on your view. ( One of the marks is just over the line).

  Firstly, Drop the Week ID onto the column shelf, and convert it to continuous since we need both Year and Quarter as mentioned in the question. 2) Next, Drop assortment to filters shelf so that we can focus on Electronics!

  

  3) This should be your view now. Click on the Show Mark Labels icon as shown: The final view is as follows, with 3 points below 0 ( i.e negative )

  

• Question 244:

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

  A. No
  B. Yes
  B. Yes

  ---

  Explanation/Reference:

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

  For Bullet Graphs we need at least ____________ measures

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

  ---

  Explanation/Reference:

  A bullet graph is a variation of a bar graph developed to replace dashboard gauges and meters. A bullet graph is useful for comparing the performance of a primary measure to one or more other measures. Therefore, we need at least 2 measures for creating bullet graphs.

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

• Question 246:

  Dates in Tableau are typically treated as ______________

  A. Dimensions
  B. Measures
  A. Dimensions

  ---

  Explanation/Reference:

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

  You have a dashboard. You want users to be able to identify specific marks that appear in multiple sheets without losing the context of all the data in the view. Which dashboard action should you use?

  A. URL action
  B. Filter action
  C. Highlight action
  D. Set action
  C. Highlight action

• Question 248:

  You want to use visual clusters to show data trends on a map.

  Which type of map should you use?

  A. Flow
  B. Symbol
  C. Choropleth
  D. Density
  D. Density

• Question 249:

  True or False: You get different filtering options for categorical and quantitative data

  A. True
  B. False
  A. True

  ---

  Explanation/Reference:

  Yes! We get different options for filtering depending on whether we use a categorical data (think dimension) or quantitative data (think measure).

  

  Important Note: Each tab adds additional definitions to your filter. For example, you can select to exclude values under the General tab, and also add limits under the Top tab. Selections and configurations from both tabs are applied to your filter.At any time, you can see the definitions of your filter under Summary on the General tab.

  

  Note: If you have a large data source, filtering measures can lead to a significant degradation in performance. It is sometimes much more efficient to filter by creating a set containing the measure and then apply a filter to the set. For more information about creating sets, see Create Sets

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

• Question 250:

  DOWNLOAD THE DATASET FROM:

  https://drive.google.com/drive/folders/1WXzqsrNmXVdmQ- 574wld4InEplyKT8RP?usp=sharing (if you haven't already)

  Using the cwurData table, plot a Map to see which country had the Second highest number of patents in the Year 2013?

  A. United States
  B. France
  C. United Kingdom
  D. Canada
  B. France

  ---

  Explanation/Reference:

  Follow along to get the correct answer:

  Drag Country to the view, and then Patents to the Size Mark on the Marks shelf as follows :

  2) But, this isn't all right? We need to focus on the year 2013. This can be done by using the year column as it is (continuous) in the filter shelf, or by converting it to discrete first and then using it:

  2.1 As it is (continuous)

  

  2.2 Converting to discrete first and then using it

  

  and then :

  

  3) We can now see that France, with 485 has the 2nd most number of patents for the year