TDS-C01

TDS-C01 practice questions, page 4 of 5, with answer review and explanations.

Question 16

When should you use a relationship instead of a join for two data sets?

  1. To use both data sets across multiple sheets in a visualization.
  2. The data sets are in two separate tables within a single spreadsheet.
  3. The data sets include similar data aggregated at different levels of detail.
  4. The data sets include similar data aggregated up to the highest level.

Question 17

What is created by a calculated field that has a formula of SUM(Sales) / SUM(Profit)?

  1. A measure
  2. A dimension
  3. A set
  4. A parameter

Question 18

Which two types of fields appear blue? (Choose two.)

  1. Continuous measures
  2. Discrete dimensions
  3. Discrete measures
  4. Continuous dimensions

Question 19

Which two filter modes can you use with dimension filters? (Choose two.)

  1. Range of Values
  2. At most
  3. Wildcard Match
  4. Multiple Values (drop-down)

Question 20

When viewing quick table calculations, such as Percent Difference from, that use a value in the previous column, what will be the first data value in the visualization?

  1. Zero (0)
  2. Null
  3. Duplicated from the nearest column
  4. The current value