TDS-C01

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

Question 6

What are two characteristics of relationships? (Choose two.)

  1. Relationships will query every table in a data model regardless of whether the fields are in the visualization.
  2. Relationships will query only the tables and fields needed to create a visualization.
  3. Relationships are only supported when using extracts.
  4. Relationships are aware automatically of the native level of detail of logical tables.

Question 7

What are two examples of a date value? (Choose two.)

  1. January 1, 1995
  2. December
  3. Wednesday
  4. 2020-05-01

Question 8

What are three reasons to use joins instead of relationships? (Choose three.)

  1. You need to use a specific join type.
  2. You need to create an extract that will have multiple tables.
  3. You need to use row-level security.
  4. You need to use a data model that supports shared dimensions.
  5. You need to connect to multiple databases.

Question 9

What are three benefits of using an extract as compared to a live connection to a data source? (Choose three.)

  1. A live connection to a data source provides the best performance for data connections.
  2. Calculated fields perform better in workbooks connected to extracts than in workbooks with live connections to a data source.
  3. Extracts are stored in memory (RAM), resulting in faster query performance as compared with live data connections.
  4. An extract reduces the amount of data stored on a client computer as compared to a live data connection.
  5. A live connection to a data source can be slow due to network and user traffic, whereas a connection to an extract improves performance.

Question 10

Which string function should you use to find a substring within a column and return a Boolean value?

  1. RTRIM
  2. SPLIT
  3. CONTAINS
  4. ENDSWITH