QlikView 11 Developer Certification Examination Sample Questions:

1. 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 calculates the total customer occurrences, while the QlikView report calculates the customer ranking.
D) The legacy report totals the number of customers correctly, while the QlikView report is dropping records.

2. 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 DepartmentID field in the SalesPerson table to match the qualified field name of DepartmentID in the Department table
B) change the script to use an Inner Join instead of Left Join
C) change the QUALIFY * command to list out only the fields that need to be qualified
D) change the Left Join command to include the name of the table being joined enclosed in parentheses

3. A customer has an Actual Sales fact table aggregated at the transactional level and a
Budgeted Sales fact table aggregated at the monthly level. The tables share many of the same dimensional fields.

How can a developer form the data model?

A) left join the Budgeted Sales table onto the fact table using Month as the key
B) qualify both tables and Unqualify all shared fields
C) concatenate Load the Budgeted Sales table into the Actual Sales table loading shared fields as NULL
D) create a link table containing the dimensional fields then link each fact table using a concatenated key

4. Refer to the exhibit to the right.

A customer has two databases containing employee data for different regions.
Based on the script displayed in the exhibit, what will be the resulting table schema?

A) one table named Employees_UK
B) two tables named Employees_US and Employees_UK with a synthetic key
C) two tables named Employees_US and Employees_UK with no associations
D) one table named Employees_US

5. Which objects are the most appropriate for setting one or more values for use in a "what-if" scenario?

A) Input Box Object and Calendar/Slider Object
B) Input Box Object and Chart Object
C) Button Object and Extension Object
D) Calendar/Slider Object and Chart Object
E) Input Box Object and Text Object

Solutions: