Tableau TDS-C01 Online Practice Questions and Exam Preparation

Tableau TDS-C01 Online Questions & Answers

• Question 181:

  Which of the following are valid ways to trigger actions for a Dashboard?

  A. Hover
  B. Click
  C. Select
  D. Menu
  E. Double click
  A. Hover
  C. Select
  D. Menu

  ---

  Explanation/Reference:

  Whenever we want to add actions to a Dashboard, we can trigger then in the following 3 ways: 1) Select 2) Hover 3) Menu Hover is best for highlighting, select for filtering. Menu action is added to the tooltip and user can decide whether to run that action or not (best for URL actions)

  

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

• Question 182:

  Which two types of data are represented as measures in Tableau Desktop? (Choose two.)

  A. Numerical totals such as test scores, sales and profit totals
  B. Quantities such as student enrollment and products sold
  C. Names of people such as students and customers
  D. Years such as 1989, 2006, and 2020
  A. Numerical totals such as test scores, sales and profit totals
  B. Quantities such as student enrollment and products sold

• Question 183:

  You have a dashboard that shows car rental statistics by city, including a field named Car Dropoff City in the view. A URL action in the dashboard uses https://en.wikipedia.org/wiki/ as the URL target. When you click Salt Lake City in the view, to where will the URL action direct you?

  A. https://en.wikipedia.org/wiki/Salt_Lake_City
  B. https://en.wikipedia.org/wiki/Salt+Lake+City+Car+Dropoff+City
  C. https://en.wikipedia.org/wiki/
  D. https://en.wikipedia.org/wiki/
  A. https://en.wikipedia.org/wiki/Salt_Lake_City

• Question 184:

  True or False: To concatenate fields, they must be of same data type

  A. True
  B. False
  A. True

  ---

  Explanation/Reference:

  Yes! To concatenate fields, they must be of same data type. However, there is a workaround which we can use-Type casting. See below:

  

  Here, State and City are Strings, but Postal Code? Nope. It's an Integer. So we can simply use the STR() function to convert it into a String, and hence the entire equation becomes valid!

• Question 185:

  You create a visualization by first adding a measure to rows. Next, you add a dimension with 11 members to columns.

  Assuming that all the dimensions have a non-zero value how many marks are in the view before and after the dimension is added?

  A. 1 before and 12 after
  B. 1 before and 11 after
  C. 2 before and 11 after
  D. 1 before and 2 after
  B. 1 before and 11 after

  ---

  Explanation/Reference:

  Drop Sales on row ==> 1Mark - 1row by 1 column drop Segment on Column==> 3 Mark - 1row by 3 column if you drop Sales and Segment ==> 3 Mark - 1row by 3 column

• Question 186:

  Using the cwurData table, create a cross-tab showing the number of Publications per Country broken down by Institution, and filtered by Country to only show United Kingdown (UK). For the University of Manchester, what percent of the total publications were contributed in 2014?

  A. 28.415%
  B. 23.497%
  C. 25.683%
  D. 22.404%
  D. 22.404%

  ---

  Explanation/Reference:

  Phew! Tricky one for sure. This question tests multiple concepts and will help you revise them. We'll be using filters, as well as quick table calculations (percent of total) for this one. 1) Firstly, let's drag Country and Institution to the Rows shelf, and year (discrete) to the Columns shelf. Then, drag Publications to the Text Icon in the Marks Shelf. The following is our view:

  

• Question 187:

  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
  C. Context Filter

  ---

  Explanation/Reference:

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

  Which of the following is a valid way to create Sets in Tableau?

  A. In the Data pane, right-click a dimension and select Create > Set.
  B. In the Tableau Main Menu, Choose Worksheet and select Create > Set
  C. In the Tableau Main Menu, choose Dashboard and select Create > Set
  D. In the Data pane, right-click a measure and select Create > Set.
  A. In the Data pane, right-click a dimension and select Create > Set.

  ---

  Explanation/Reference:

  There are two types of sets: dynamic sets and fixed sets. The members of a dynamic set change when the underlying data changes. Dynamic sets can only be based on a single dimension.

  To create a dynamic set:

  1) In the Data pane, right-click a dimension and select Create > Set.

  2) In the Create Set dialog box, configure your set. You can configure your set using the following tabs:

  General: Use the General tab to select one or more values that will be considered when computing the set.

  You can alternatively select the Use all option to always consider all members even when new members are added or removed.

  None of the other options exist, and therefore are incorrect answers.

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

• Question 189:

  Which of the following are the options to export the data used to build the view / visualisations?

  A. CSV file
  B. PDF File
  C. JSON format
  D. MS Access Database
  A. CSV file
  D. MS Access Database

  ---

  Explanation/Reference:

  You can export the data in a Tableau data source, including all or part of the records from your original data. Alternatively, you can export only the portion of data used to generate the view.

  Since the question mentions the data used to build the view, we'll focus on that :

  *Export data in the view to Microsoft Access or .csv* Export the data that is used to generate the view as an Access database (Windows only) or .csv file (Mac only).

  1) In Tableau Desktop, select Worksheet > Export > Data.

  2) Select a location and type a name for your Access database or .csv file.

  3) Click Save.

  4) If you're on Windows, the Export Data to Access dialog box displays to give you the option to immediately use the new Access database and continue working in Access without interrupting your work flow.

  

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

• Question 190:

  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
  C. 37,455

  ---

  Explanation/Reference:

  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'