QlikView 11 Developer Certification Examination (QV_Developer_01) Free Practice Test

Question 1

Refer to the exhibit to the right.

When a customer reloads the script displayed in the exhibit, it fails to respond and complete, and displays an error message.
OBJECT OUT OF MEMORY.
How should the developer resolve the logic error in the script?

A. change the QUALIFY * command to list out only the fields that need to be qualified

B. change the DepartmentID field in the SalesPerson table to match the qualified field name of DepartmentID in the Department table

C. change the Left Join command to include the name of the table being joined enclosed in parentheses

D. change the script to use an Inner Join instead of Left Join

Correct Answer: A

Question 2

In which two places in the Chart Properties of a Gauge can expressions be entered?
(Choose two.)

A. X and Y position of the object

B. Show Condition of the object

C. Auto Minimize of the object

D. Calculation Condition of the object

E. Number of major/minor units for the scale

Correct Answer: B,D

Question 3

Refer to the exhibit below.

Schema A displayed in the exhibit has been transformed into Schema B.
How can the before and after schemas be described?

A. The snowflake schema has been transformed into a de-normalized schema.

B. The snowflake schema has been transformed into a normalized schema.

C. The star schema has been transformed into a normalized schema.

D. The star schema has been transformed into a de-normalized schema.

Correct Answer: A

Question 4

A developer needs to load data for products from a database table and a text file. The database table and text file can be joined by the field ProductID.
The database table contains the master list of all available products. The text file contains additional data fields, but not for all products.
The developer loads the data from the database table first.
The developer needs to load the additional data fields from the text file into the existing table. The resulting table needs to contain the master list of all available products.
Which type of join should the developer use when loading the text file?

A. Outer Join

B. Right Join

C. Inner Join

D. Left Join

Correct Answer: D

Question 5

A customer needs multi-language support for a QlikView application.
The languages that need to be supported immediately are English, German, and Dutch; in the future, however, additional languages may be needed.
Which solution should a developer use to meet the customer's needs?

A. a language definition table in the data model containing all descriptions for each language, automatically linking the business user to a language

B. variables for language-specific items and the option to select a specific language in a field

C. a language definition table in the data model containing all descriptions for each language, and the option to select a specific language in a field

D. a separate document for each language

Correct Answer: C

Question 6

A customer needs to have QlikView deployed to tablet devices.
When creating the QVW application, which two actions must a developer take to meet the customer's need? (Choose two.)

A. use only sheet objects suitable for tablet devices

B. create a specific QVW application for each device

C. convert the QVW application into a HTML5 document

D. ensure that screen resolution is appropriate for the device

E. convert the QVW application into a .mob document on the server

Correct Answer: A,D

Question 7

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. OnOpen; action. Select in Field

B. trigger. OnPostReload; action. Lock Field

C. trigger. OnOpen; action. Set Variable

D. trigger. OnSelect; action. Select in Field

Correct Answer: A

Welcome to TestSimulate

QlikView 11 Developer Certification Examination (QV_Developer_01) Free Practice Test