QlikView 11 Developer Certification Examination - QV_Developer

QUESTION NO: 1
A customer's data set contains information for multiple departments.
The customer needs a document to show only one specific department when a user first accesses the application.
Which trigger and action will meet the requirement?

A. trigger. OnSelect; action. Select in Field B. trigger. OnPostReload; action. Lock Field C. trigger. OnOpen; action. Set Variable D. trigger. OnOpen; action. Select in Field

Correct Answer: D

QUESTION NO: 2
A project to develop a QlikView application for a customer requires splitting developers into two teams.
One team will focus on developing source database query knowledge to create a reusable data layer. There are several application-specific business rules for this project. The customer needs to incrementally accumulate history for the QlikView application over time.
The second team will focus on developing the presentation layer. This team also has data modeling and scripting expertise, but does not have source database query knowledge.
Which data loading strategy should the developers use on the project?

A. create QVDs of the source data, apply the business rules and store a second layer of QVDs, and then load these QVDs into the presentation layer QVW B. create a series of QVWs that apply the business rules and then binary load them into the presentation layer QVW C. create the presentation layer QVW and connect directly to the source data and apply the business rules in the script D. create QVDs of the source data and load them into the presentation layer QVW and apply the business rules in the script

Correct Answer: A

QUESTION NO: 3
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?

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

Correct Answer: D

QUESTION NO: 4
Which object should a designer use to integrate QlikView with an interactive third-party web service for use in the AJAX Zero Footprint client?

A. Extension Object B. QlikView Macro C. Button Object D. Custom Object

Correct Answer: A

QUESTION NO: 5
Refer to the exhibit below.

A QlikView report does not match the legacy report it was designed to replace. The purpose of the report is to count the number of customers per year and in total.
Why is there a difference between the Total row values in the two reports?

A. The legacy report calculates the total customer occurrences, while the QlikView report counts only distinct customers. B. The legacy report totals the number of customers correctly, while the QlikView total row is set to Sum of rows. C. The legacy report totals the number of customers correctly, while the QlikView report is dropping records. D. The legacy report calculates the total customer occurrences, while the QlikView report calculates the customer ranking.

Correct Answer: A

QUESTION NO: 6
Refer to the exhibit to the right.

Which technique should be used by a developer to eliminate the circular reference in the data model displayed in the exhibit?

A. qualify the fields Name, Address, City, and Country in the Shippers and Suppliers tables B. rename the fields OrderID in the OrderDetails table and SupplierID in the Products table C. rename the fields ShipperID in the Shippers table and SupplierID in the Suppliers table D. qualify all the fields in the data model ending with 'ID'

Correct Answer: A

QUESTION NO: 7
A customer needs to display sales amounts for the current month and a trend of sales over the prior 12 months using a small amount of screen space.
Which chart type should the designer use to meets the customer's needs?

A. a Straight Table with one expression to display the current month sales and a second expression represented as a Mini Chart to display a trend of sales over the prior 12 months B. a Straight Table with one expression to display the current month sales and a second expression represented as a Linear Gauge to display a trend of sales over the prior 12 months C. a Straight Table with one expression to display the current month sales and a second Line Chart to display a trend of sales over the prior 12 months D. a Combo Chart with one expression to display the current month sales and a second expression represented as a Mini Chart to display a trend of sales over the prior 12 months

Correct Answer: A

QlikView 11 Developer Certification Examination - QV_Developer_01 Exam Questions