QlikView 11 Developer Certification Examination Sample Questions:

1. An Address Book table has a Country Code field. A standard lookup table exists in Excel to translate the Country Code to a Country description.
The Country Code will be US for any Address Book record with no Country Code value.
Which technique should a developer use to ensure a Country description is loaded for all Address Book records?

A) load the Address Book records and perform a Left Join of the Excel data to the Address Book table
B) load the Excel data and then load the Address Book data ensuring the Country Code field has the same name in both tables
C) load the Excel data, then load the Address Book data using an If function to default Country Code to US, and then use the Peek function to retrieve the Country description
D) load the Excel data as a Mapping table and use Applymap with a default mapping value when loading the Address Book table

2. 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) create a specific QVW application for each device
B) convert the QVW application into a HTML5 document
C) use only sheet objects suitable for tablet devices
D) convert the QVW application into a .mob document on the server
E) ensure that screen resolution is appropriate for the device

3. 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 script to use an Inner Join instead of Left Join
D) change the Left Join command to include the name of the table being joined enclosed in parentheses

4. A Straight Table Chart calculates several metrics for each individual alphanumeric transaction detail record (TRAN_ID) and its Amount over several years of data. The calculation time for the chart is over two minutes.
How can a designer decrease the calculation time for the chart without compromising core functionality?

A) create a Calculation Condition. =sum(TRAN_ID) <= 10000
B) create a Calculation Condition. =TRAN_ID < 10000
C) create a Calculation Condition. =count(TRAN_ID) <= 10000
D) create a Calculation Condition. =sum(Amount) > 0

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, use the Concatenate function to append the Budgets table to the Actuals table
B) load the Actuals table, and when loading the Budgets table, use Outer Join to join the BudgetAmount field to the Actuals table
C) 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
D) load the Actuals table, and when loading the Budgets table, rename fields Year and Month to BudgetYear and BudgetMonth

Solutions: