Tableau TDS-C01 Online Practice Questions and Exam Preparation

Tableau TDS-C01 Online Questions & Answers

• Question 251:

  Which type of filter affects a fixed Level of Detail (LOD) expression?

  A. Table calculation filter
  B. Measure filter
  C. Context filter
  D. Dimension filter
  C. Context filter

• Question 252:

  When exporting a worksheet as an image in Tableau, which of the following file formats are available?

  A. Portable Network Graphic (.PNG)
  B. JPEG Image (.JPG, .JPEG)
  C. Tagged Image File Format (TIFF)
  D. Windows Bitmap (.BMP)
  A. Portable Network Graphic (.PNG)
  B. JPEG Image (.JPG, .JPEG)
  D. Windows Bitmap (.BMP)

  ---

  Explanation/Reference:

  The following options are available when an image is Exported:

  

  NOTE: When we Copy an image rather than exporting it, then the image is copied to the clipboard in the TIFF file format! However, it is not available when EXPORTING an image. Reference: https://help.tableau.com/current/pro/desktop/enus/save_export_image.htm

• Question 253:

  In an extract, what are three differences between a full refresh versus an incremental refresh? (Choose three.)

  A. An incremental refresh can only be run from Tableau Server.
  B. A full refresh is usually very slow. An incremental refresh can take less time.
  C. A full refresh replaces all the extracted data with the data in the underlying data source.
  D. An incremental refresh only adds rows that are new
  E. A full refresh must be configured. An incremental refresh is the default extract in Tableau.
  B. A full refresh is usually very slow. An incremental refresh can take less time.
  C. A full refresh replaces all the extracted data with the data in the underlying data source.
  D. An incremental refresh only adds rows that are new

• Question 254:

  Which of the following are correct ways to define a join in Tableau version 2020.3 and above?

  A. Right-click a logical table and click on open to go to the Join/Union canvas in the physical layer and add joins or unions.
  B. Double-click a physical table to go to the Join/Union canvas in the logical layer and add joins or unions.
  C. Right-click a physical table and click on open to go to the Join/Union canvas in the logical layer and add joins or unions.
  D. Double-click a logical table to go to the Join/Union canvas in the physical layer and add joins or unions.
  A. Right-click a logical table and click on open to go to the Join/Union canvas in the physical layer and add joins or unions.
  D. Double-click a logical table to go to the Join/Union canvas in the physical layer and add joins or unions.

  ---

  Explanation/Reference:

  Remember that joins are defined in the physical layer and relationships in the logical layer.

  You can still specify joins between tables in the physical layer of a data source. Double-click a logical table to go to the Join/Union canvas in the physical layer and add joins or unions. Every top-level, logical table contains at least one physical table. Open a logical table to view, edit, or create joins between its physical tables. Right-click a logical table, and then click Open. Or, just double-click the table to open it.

  

  When you create a data source, it has two layers. The top-level layer is the logical layer of the data source. You combine data between tables in the logical layer using relationships. The next layer is the physical layer of the data source. You combine data between tables at the physical layer using joins. For more information, see Logical and physical tables in the data model

  

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

• Question 255:

  As a general best practice, how many categories can a pie chart display effectively?

  A. 2 to 5
  B. 3 to 5
  C. 2 to 8
  D. 3 to 7
  A. 2 to 5

  ---

  Explanation/Reference:

  As a general best practice, your pie chart should contain 2 to 5 categories. Anything more than that is not easy for the eyes to distinguish. This is a common question and mentioned in Tableau's own eLearning module as well! See how to build a pie chart: Reference: https://help.tableau.com/current/pro/desktop/en-us/buildexamples_pie.htm

  

• Question 256:

  What should you use to create headers in a visualization?

  A. A measure
  B. A dimension
  C. A parameter
  D. A filter
  B. A dimension

• Question 257:

  Tableau will automatically create a hierarchy for which two kinds of data? (Choose two.)

  A. Date and Time
  B. Date
  C. String
  D. Geographic
  A. Date and Time
  B. Date

• Question 258:

  Which chart type uses automatically generated sizes that cannot be resized by using the Marks card?

  A. Area charts
  B. Treemaps
  C. Histograms
  D. Pie charts
  A. Area charts

• Question 259:

  For a relative date filter, the default anchor is _________________

  A. The current time
  B. Today's date
  C. The target date
  D. The date we specify
  B. Today's date

  ---

  Explanation/Reference:

  Relative date filters dynamically update to show a time period relative to when you open the view, such as the current week, the year to date, or the past 10 days. Relative date filters make it easy to create views that always show the most

  recent data.

  Step 1: Drag a date field to the filter shelf

  Right-click (control-click on Mac) and drag a date field from the Data window to the Filters shelf. In the Filter Field dialog box, click Relative Date, and then click Next.

  

  Step 2: Select a time unit

  In the Filter dialog box, click Relative dates, and then select the unit of time for the filter. For example, to show only the three most recent weeks, select Weeks.

  

  Here, you can clearly see that the default date is TODAY Reference: https://help.tableau.com/current/pro/desktop/en-us/qs_relative_dates.htm

• Question 260:

  Using the atheletes table:

  i) Create a sheet with a crosstab showing the Average weight for each sport (Sheet 1)

  ii) Create a sheet with a Map showing the Total number of gold medals per Country. Use size as a Mark. (Sheet 2)

  Now, Create a Dashboard containing both these sheets, and Use Sheet 2 as a Filter for Sheet 1. What was the average weight for Badminton in Russia?

  (Ignore any nulls / unknowns)

  A. 76.25
  B. 65.67
  C. 68.77
  D. 4.87
  A. 76.25

  ---

  Explanation/Reference:

  Pretty common question on the Tableau Desktop Specialist exam.

  1) First, lets create Sheet 1. For this, drag sport to the Row shelf, and Weight to the Text mark in the Marks shelf. Change its aggregation to Average:

  

  2) Now, for sheet 2-Drag nationality to the view, and gold to the size mark in the Marks shelf.

  NOTE: Depending on your version of Tableau , you may need to assign a Geographical role to the nationality column first as follows:

  

  3) Now, let's create a dashboard, and use both these sheets in it:

  

  4) Now, for the most Important step, use SHEET 2 AS A FILTER FOR SHEET 1 as follows:

  

  Now simply click on Russia in Sheet 2, and Sheet 1 will automatically update as follows: