Tableau Tableau Certifications TDS-C01 Questions & Answers

• Question 131:

  Using the dataset, create a bar chart showing the average Quantity broken down by Region, and filtered by Country to only show Japan. What was the average Quantity in the State of Tokyo?

  A. 3.000

  B. 3.840

  C. 3.704

  D. 3.500

  Correct Answer: C

  Since we need to focus on 1 country-> Japan, let's filter on it first as follows: 1) Drag Country to the filter shelf, and choose only Japan. Click OK.

  

  2) Read the Question Carefully, we need to break down the visualisation by Region, then by Country, and then by State. So let's do that:

  Drag Region to the column shelf, followed by Country. Drill down into Country to include states as well.

  Then drag Quantity to the Row Shelf, and change the Aggregation to AVERAGE.

  The following is our visualisation:

  

  Now that you think of it, EVEN IF YOU REMOVE THE REGION, THE ANSWER REMAINS THE SAME. Such elements will be present in the actual exam too, just to make the question sound a little difficult, but actually it is pretty straightforward

• Question 132:

  Which of the following calculations DO NOT need a quick table calculation?

  A. Variance

  B. Rank

  C. Moving Average

  D. Standard Deviation

  Correct Answer: AD

  For Standard Deviation and Variance, we don't need to use quick table calculations, since they are available by default. See below:

  

  However, as seen in the types of quick table calculations available in Tableau, Rank and Moving Average belong to only this category.

  

• Question 133:

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

  A. 1 , 4

  B. 2 , 2

  C. 2 , 3

  D. 1 , 2

  Correct Answer: A

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

  Relationships are represented by __________________ and operate at the ____________________.

  A. noodles, logical layer

  B. noodles, physical layer

  C. Venn diagrams, physical layer

  D. Venn diagrams, logical layer

  Correct Answer: A

  From the official documentation:

  The default view that you first see in the Data Source page canvas is the logical layer of the data source. You combine data in the logical layer using relationships (or noodles).

  

  Reference: https://help.tableau.com/current/server/en-us/datasource_datamodel.htm

• Question 135:

  The View Data window displays as much of the data as possible by default, up to _______________ rows.

  A. 20,000

  B. 5,000

  C. 10,000

  D. 15,000

  Correct Answer: C

  The View Data window displays as much of the data as possible by default, up to 10,000 rows. This can be increased though, if you wish to.

  

  Read more: https://help.tableau.com/current/pro/desktop/en-gb/inspectdata_viewdata.htm

• Question 136:

  By default, measures placed in a view are aggregated by ______________

  A. COUNT

  B. AVERAGE

  C. MEDIAN

  D. SUM

  Correct Answer: D

  By default, measures placed in a view are aggregated by SUM, which means that the data for that field in all of the rows is combined. Measures can also be aggregated as average, median, count, or count distinct. Reference: https://help.tableau.com/current/pro/desktop/en-us/calculations_aggregation.htm

• Question 137:

  You just added this field to the Columns shelf.

  

  What will this create?

  A. A vertical header

  B. A horizontal axis

  C. A vertical axis

  D. A horizontal header

  Correct Answer: B

  We know that continuous fields will always create an axis, so options stating 'header' are automatically eliminated. For our question, see below: Teams Had the question asked us to place this pill on the Rows shelf instead, we would've gotten a different answer:

  

• Question 138:

  How can you change the Default Aggregation for a measure in Tableau?

  A. By changing its properties manually every time we need to use it

  B. By right clicking the dimension-> Default properties and choosing Aggregation

  C. By right clicking the measure-> Default properties and choosing Aggregation

  D. By double clicking on the measure, and then choosing Window-> Default Aggregation

  Correct Answer: C

  According to the official Tableau documentation:

  

  Dimensions don't have aggregation properties, and adding properties manually each time defeats the whole DEFAULT aggregation purpose. Window tab doesn't have any default aggregation option! Reference: https://help.tableau.com/current/pro/desktop/en-us/datafields_fieldproperties.htm

• Question 139:

  Which of the following are valid Dashboard size options?

  A. Range

  B. Fixed Size

  C. Automatic

  D. Scaled

  Correct Answer: ABC

  Scaled is NOT a valid size options when creating Dashboards in Tableau!

  After you create a dashboard, you might need to resize and reorganize it to work better for your users.

  

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

• Question 140:

  To connect Tableau to a CSV data source what type of connection should you use?

  A. Spatial

  B. Excel

  C. Text

  D. JSON

  Correct Answer: C

  Tableau recognises a CSV file as a TEXT file, and therefore it is the correct option. The following are the steps to import a CSV file: 1) From the data connection screen, click on Text:

  

  2) Choose the appropriate file, and click Open:

  

  3) Finally, Tableau imports the data as shown below:

  

  Reference: https://intellipaat.com/community/46338/how-to-import-csv-file-in-tableau