QlikView 11 Developer Certification Examination: QV_DEVELOPER_01

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

LOAD ltemlD

LocationlD,

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?

A. NULL

B. 1; 2; 3

C. 1100; 1300; 2210; 2250; 3125; 3130; 3120

D. 1100; 1300; 2210; 2250; 3125; 3130; 3120

Refer to the exhibit below.

The tables displayed in the exhibit need to be loaded into QlikView. How will the data model appear once the load is complete?

A. There will be a relationship between all the tables without synthetic key tables or loosely coupled tables.

B. There will be a relationship between four of the five tables and one table will be a data island.

C. There will be a synthetic key table in the data model.

D. There will be loosely coupled tables in the data model.

A customer is building a dashboard to measure the performance of the support organization. The customer needs to dynamically sort the Ticket Severity field by Severity Weight field when the Ticket Severity columnheaderisdouble-clickedinStraightTablecharts. Example ticket severities. Urgent = 1 High = 2 Normal = 3 Low = 4

Which QlikView load script function can the developer use to create the Ticket Severity field to meet the customer's needs?

A. Rank( [Ticket Severity], [Severity Weight] ) AS [Ticket Severity]

B. Num( [Severity Weight], [Ticket Severity] ) AS [Ticket Severity]

C. Sort( [Ticket Severity], [Severity Weight] ) AS [Ticket Severity]

D. Dual( [Ticket Severity], [Severity Weight] ) AS [Ticket Severity]