QV-Developer-01: QlikView 11 Developer Certification Examination (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?
The field formats (such as numeric or string) must be the same in the original data sources.
The fields must be defined as primary or foreign keys in the original data sources.
The fields must be aliased to the same name when loading into QlikView.
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?
convert numeric fields into text fields using the Text function
combine multiple fields into one complex field, reducing the number of fields per table
make all numeric fields a fixed length by left padding with leading 0's using the Num function
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?
ACCOUNT_ID
TRANS_SEQ
ACCOUNT_ID and TRANS_SEQ
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?