Tableau TDS-C01 Online Practice Questions and Exam Preparation

Tableau TDS-C01 Online Questions & Answers

• Question 321:

  Is SUM a table calculation?

  A. Yes
  B. No
  B. No

  ---

  Explanation/Reference:

  SUM is an aggregate function, not a table calculation! A table calculation is a transformation you apply to the values in a visualization. Table calculations are a special type of calculated field that computes on the local data in Tableau. They are calculated based on what is currently in the visualization and do not consider any measures or dimensions that are filtered out of the visualization.

  The most common Table calculations are:

  1.

  Running Total

  2.

  Percent Difference

  3.

  Difference

  4.

  Percent of Total

  5.

  Rank

  6.

  Percentile

  

  

  These can be calculated using : Table(across), Cell, or Specific dimensions!

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

• Question 322:

  Which of the following is a discrete date part?

  A. February
  B. 01/23/2021
  C. 20Sep2016:9:8:8:6546
  D. 07Mar2017
  A. February

• Question 323:

  At a minimum, what do you need to create a simple scatter plot?

  A. A measure on Columns and a measure on Rows
  B. A dimension on Detail and a measure on Columns
  C. A dimension on Columns and a measure on Rows
  D. A dimension on Columns and a dimension on Rows
  A. A measure on Columns and a measure on Rows

  ---

  Explanation/Reference:

  In Tableau you create a scatter plot by placing a measure in the columns shelf and another measure in the rows shelf.

• Question 324:

  _____________ is a snapshot of the data that Tableau stores locally. Good for very large datasets of which we only need few fields.

  A. Tableau Packaged Workbook (.twbx)
  B. Tableau Workbook (.twb)
  C. Tableau Data Extract (.tde)
  D. Tableau Data Source (.tds)
  C. Tableau Data Extract (.tde)

  ---

  Explanation/Reference:

  Tableau Data Extract (TDE) is a snapshot of the data that Tableau stores locally. Good for very large datasets of which we only need few fields. Performance is optimised because it queries its own database engine instead of the local data

  source. 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.

  Extracts are advantageous for several reasons:

  1) Supports large data sets: You can create extracts that contain billions of rows of data.

  2) Fast to create: If you're working with large data sets, creating and working with extracts can be faster than working with the original data.

  3) Help improve performance: When you interact with views that use extract data sources, you generally experience better performance than when interacting with views based on connections to the original data.

  4) Support additional functionality: Extracts allow you to take advantage of Tableau functionality that's not available or supported by the original data, such as the ability to compute Count Distinct.

  5) Provide offline access to your data: Extracts allow you to save and work with the data locally when the original data is not available. For example, when you are traveling.

• Question 325:

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

  A. COUNT
  B. AVERAGE
  C. MEDIAN
  D. SUM
  D. SUM

  ---

  Explanation/Reference:

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

  Which type of chart can you create without using a dimension?

  A. Stacked bar
  B. Highlight table
  C. Bar
  D. Treemap
  C. Bar

• Question 327:

  True or False: It is possible to change the Geographic Role of a dimension

  A. True
  B. False
  A. True

  ---

  Explanation/Reference:

  A geographic role associates each value in a field with a latitude and longitude value. Assigning a geographic role based on the type of location (such as state versus postcode) helps ensure that your data is plotted correctly on your map

  view. For example, you can assign the City geographic role to a field that contains a list of city names.

  To assign a geographic role to a field:

  In the Data pane, click the data type icon next to the field, select Geographic Role, and then select the geographic role you want to assign to the field.

  

  When you assign a geographic role to a field, Tableau adds two fields to the Measures area of the Data pane: Latitude (generated) and Longitude (generated). These fields contain latitude and longitude values and are assigned the Latitude and Longitude geographic roles. If you double-click each of these fields, Tableau adds them to the Columns and Rows shelves and creates a map view using the Tableau background map.

  

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

• Question 328:

  Which of the following can you add a reference line to?

  A. Groups
  B. Calculated Fields
  C. Measures
  D. Dimensions
  B. Calculated Fields
  C. Measures

  ---

  Explanation/Reference:

  You can add reference lines, bands, distributions, or (in Tableau Desktop but not on the web) box plots to any continuous axis in the view.

  Reference Lines-You can add a reference line at a constant or computed value on the axis. Computed values can be based on a specified field. You can also include confidence intervals with a reference line.

  

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

• Question 329:

  Which statement accurately describes an extract when the Physical Tables option is selected?

  A. Data is limited to only the Top N of data for the connection
  B. An individual table is created for each physical table in the extract
  C. Data shown in the Data pane is separated based on the table type
  D. All the data is rolled up to the current visible fields
  B. An individual table is created for each physical table in the extract

• Question 330:

  _____________ contains the visualisations, info needed to build the visualisations, and a copy of the data source.

  A. Tableau Data Extract (.tde)
  B. Tableau Packaged Workbook (.twbx)
  C. Tableau Bookmark (.tbm)
  D. Tableau Workbook (.twb)
  B. Tableau Packaged Workbook (.twbx)

  ---

  Explanation/Reference:

  TWBX is all in one. It contains viz, info needed to build the viz, and a copy of the data source. It doesn't contain extracts of the data but can contain both live and data extracts. Best if want to eliminate the barrier of data access.

  Create a .twbx with file-based data sources

  1) Select File > Save As.

  2) Specify a file name for the packaged workbook in the Save As dialog box.

  

  3)Select Tableau Packaged Workbooks on the Save as type drop-down list. 4) Click Save. 5) The default location is the Workbooks folder of the Tableau repository. However, you can save packaged workbooks to any directory you choose. The following files are included in packaged workbooks: --> Background images --> Custom geocoding --> Custom shapes --> Local cube files --> Microsoft Access files --> Microsoft Excel files --> Tableau extract files (.hyper or .tde) --> Text files (.csv, .txt, etc.)

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