Free QV_DEVELOPER_01 Exam Braindumps (page: 4)

Page 3 of 18

Refer to the exhibit to the right and the Load Script provided below.
Exhibit.

LOAD ItemID,
LocationID,
Quantity
FROM
[inventory.txt]
(txt, codepage is 1252, embedded labels, delimiter is ', ', msq);
When the developer runs the script, which values will the field Quantity contain?

  1. NULL
  2. 1; 2; 3
  3. 1100; 1300; 2210; 2250; 3125; 3130; 3120
  4. 1, 100; 1, 300; 2, 210; 2, 250; 3, 125; 3, 130; 3, 120

Answer(s): B



A customer has a set of date values in different formats.
Some dates are in Julian date format; some dates are text strings.
How can a developer ensure the data is loaded in a consistent format?

  1. change the default DateFormat variable assignment on the Main script tab
  2. use the Date function to format the field during load
  3. use the Alt function with different Date# functions
  4. use the Lookup function with a format table

Answer(s): C



Which statement describes a required field characteristics 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.

Answer(s): C



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

Answer(s): D






Post your Comments and Discuss QlikView QV_DEVELOPER_01 exam with other Community members:

QV_DEVELOPER_01 Discussions & Posts