QV-Developer-01

QV-Developer-01 practice questions, page 3 of 3, with answer review and explanations.

Question 11

Which statement describes a required field characteristic that will ensure QlikView associations across multiple tables?

  1. The field formats (such as numeric or string) must be the same in the original data sources.
  2. The fields must be defined as primary or foreign keys in the original data sources.
  3. The fields must be aliased to the same name when loading into QlikView.
  4. The number of distinct values in each field must be the same.

Question 12

Which action should a developer perform on a table to reduce required memory and optimize the application?

  1. convert numeric fields into text fields using the Text function
  2. combine multiple fields into one complex field, reducing the number of fields per table
  3. make all numeric fields a fixed length by left padding with leading 0's using the Num function
  4. split out a single complex field into multiple fields reducing the number of distinct values per field

Question 13

Refer to the exhibit to the right. What is the primary key of ACCOUNT_TRANS?

  1. ACCOUNT_ID
  2. TRANS_SEQ
  3. ACCOUNT_ID and TRANS_SEQ
  4. ACCOUNT_ID, TRANS_SEQ, and TRANS_TYPE

Question 14

Refer to the exhibit to the right. What is the cardinality of the relationship between CUSTOMER and ACCOUNT?

  1. many-to-many
  2. one-to-many
  3. one-to-none
  4. one-to-one