QlikView QV_DEVELOPER_01 Exam Questions & Answers

A customer has sales data containing a fact table, sales and dimension tables, Customer, ltem, and

Vendor. After loading the data, the Entity Relationship Diagram (ERD) has a synthetic table containing the

fields Name and Address from the Vendor and Customer tables.

How can a developer eliminate the synthetic keys and appropriately link the data?

A. qualify all tables

B. alias all primary key fields

C. left join the Customer data onto the sales table

D. qualify all tables and then unqualify all key fields

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]

A developer needs to modify the data model of a document that consumes 5GB of RAM when opened in

memory.

Which type of client should the developer use?

A. lnternet Explorer Plug-in client on a 64 bit Windows 7 operating system

B. QlikView local client on a 32 bit Windows 7 operating system

C. QlikView local client on a 64 bit Mac operating system

D. QlikView local client on a 64 bit Windows 7 operating system