QlikView 11 Developer Certification Examination Sample Questions:

1. A customer created 20 expressions that will be used repetitively throughout a QlikView application. These expressions could appear in more than 50 objects located on 15 tabs.
How can a developer efficiently apply and maintain these expressions?

A) load the text for each expression from a text file into a table in the data model and link it to the fact table
B) create a variable for each expression that contains the expression text and use the variable in place of the expression in each object
C) create the required expression in each object as needed and edit them in the Expression Overview
D) create a table of indices and expression text and use the index value in place of the expression text in each object

2. Which statement describes a required field characteristics that will ensure QlikView associations across multiple tables?

A) The fields must be defined as primary or foreign keys in the original data sources.
B) The number of distinct values in each field must be the same.
C) The field formats (such as numeric or string) must be the same in the original data sources.
D) The fields must be aliased to the same name when loading into QlikView.

3. A customer who operates a large national sales organization needs to divide a Sales.qvw document into region-specific documents using the Region field (North, South, East, and West).
Each region should have access to region-specific data.
Which instruction should a developer give to the Server/Publisher administrator to meet the customer's needs?

A) create a QlikView Publisher task to reduce the Sales.qvw document based on the Region field and distribute to region-specific folders with appropriate file permissions
B) create a QlikView Publisher task to reduce data from the Sales.qvw document to create four QVX files with data only for each region and distribute to region-specific folders with appropriate file permissions
C) create four QlikView Server tasks to reload data from the Sales.qvw document with data only for each region and distribute to region-specific folders with appropriate file permissions
D) create a QlikView Server task to reduce the Sales.qvw document based on the Region field and distribute to region-specific folders with appropriate file permissions

4. Which chart should a designer use to display orders, sales, and average order value grouped by year, quarter, region, product, and salesperson?

A) Pivot Table
B) Mekko Chart
C) Bar Chart
D) Straight Table
E) Grid Chart

5. How can a developer use QVD files to optimize reload performance?

A) create an incremental load strategy that reduces the query sizes against the source data
B) enable a direct interface between the database server memory and the QlikView server memory
C) enable the binary load functionality and directly load files in binary from the hard disk into system memory
D) decrease latency between the QlikView reload engine and the source data

Solutions: