QlikView 11 Developer Certification Examination Sample Questions:

1. 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) Right Join
B) Outer Join
C) Left Join
D) Inner Join

2. A customer needs to produce formatted output as a PDF to distribute it to non-QlikView
users.
Each page should show sales trending for a different sales team.
The number of sales teams will change frequently.
What should a developer create to efficiently enable users to create the required output?

A) separate reports referencing bookmarks for each SalesTeam
B) a report with GROUP BY on SalesTeam
C) separate reports with where clauses for each SalesTeam
D) a report that uses current selections where the user selects each SalesTeam in turn
E) a report with banding on SalesTeam

3. 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) two tables named Employees_US and Employees_UK with no associations
B) one table named Employees_UK
C) two tables named Employees_US and Employees_UK with a synthetic key
D) one table named Employees_US

4. A customer has 30 target values that are used to evaluate the quality of an organization's facilities. At least half the target values are changed monthly by the business users.
What is the most efficient way for the developer to store, access, and maintain the target values?

A) manually create a variable for each value in Expression Overview and maintain them in Expression Overview
B) create a Variables tab in the load script and use 30 LET statements to assign the values to variables
C) embed the target values into each expression in which they are required
D) save the target names and values in an external file, load them into a QlikView table, and use a FOR loop to assign the values to variables

5. A customer has data tables for financial results, staffing, sanitary conditions, and customer satisfaction. Each table contains a date field and a location ID. Not all dates appear in all tables.
How can a developer create a master calendar that can be used with all the tables?

A) Designate one of the date fields as the reference Build a calendar spanning the minimum and maximum dates in that table Rename all other date fields to match the reference field Left join the location ID from each table into the calendar table on the date fields Drop the location and date fields from all other tables
B) Designate one of the date fields as the reference Build a calendar spanning the minimum and maximum dates in that table Rename all other date fields to match the reference field Create a link table with a key of Location and date that contains all unique locations and dates Create a key of location and date in the other tables
C) Find the minimum and maximum dates spanned by all tables Create a calendar spanning those dates Create a link table with a key of location and date that contains all unique locations and dates
Create a key of location and date in the other tables
Drop the location and date fields from all other tables
D) Find the minimum and maximum dates spanned by all tables Create a calendar spanning those dates Rename all other date fields to match the reference field Left join the location ID from each table into the calendar table on the date fields Drop the location and date fields from all other tables

Solutions: