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) create a table of indices and expression text and use the index value in place of the expression text in each object
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) load the text for each expression from a text file into a table in the data model and link it to the fact table

2. Which action should a developer perform on a table to reduce required memory and optimize the application?

A) combine multiple fields into one complex field, reducing the number of fields per table
B) convert numeric fields into text fields using the Text function
C) split out a single complex field into multiple fields reducing the number of distinct values per field
D) make all numeric fields a fixed length by left padding with leading 0's using the Num function

3. A developer created two QVWs. The first QVW loads data from the data source and creates QVD files. The second QVW loads the QVD files and provides the user interface for the analytics.
The customer does not have Publisher installed.
How should the reloads be configured on the server to ensure the first QVW reload completes before the second QVW reload begins?

A) Only one QVW reload can occur at a time on the QlikView server. The second QVW reload will always wait until the first QVW reload completes.
B) The second QVW reload can be scheduled to start upon the successful completion of the first QVW reload.
C) An action can be placed on the OnPostReload trigger within the first QVW to submit the reload of the second QVW.
D) Only the first QVW reload can be automated. An alert will need to be sent to prompt an administrator to manually perform the second QVW reload.

4. What is the interpretation of a 98 percent subset ratio in the CustomerID field in an Orders table when the subset ratio of the same field in the Customer table is 100 percent?

A) 98 percent of the customers are defined in the Customer table, but 2 percent of the customers have not placed an order
B) 2 percent of the orders have customers in the data, but 100 percent of the customers have placed an order
C) 100 percent of customers are defined in the Customer table, but 2 percent of the customers have not placed an order
D) 98 percent of the orders have customers in the data, but only 2 percent of the orders have been shipped

5. Refer to the exhibit to the right.

A customer has aggregated budgets for products by year and month. Actual data is stored at a more detailed transaction level and so a one-to-many relationship exists between the Budgets to Actuals table.
Budgets have been assigned for all months of the current year, but there are only transactions up to the current month of October. There are transactions for products that were not assigned budgets.
How can a developer remove the synthetic key automatically generated by QlikView and be able to analyze budgets and actuals by product, month, and year?

A) load the Actuals table, and when loading the Budgets table, rename fields Year and Month to BudgetYear and BudgetMonth
B) load the Actuals table, and when loading the Budgets table, use Outer Join to join the BudgetAmount field to the Actuals table
C) load the Actuals table, and when loading the Budgets table, use the Concatenate function to append the Budgets table to the Actuals table
D) create a concatenated key of Product-Year-Month in both the Budgets and Actuals table and comment out the individual fields in the Budgets table

Solutions: