QlikView 11 Developer Certification Examination Sample Questions:

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

2. A project to develop a QlikView application for a customer requires splitting developers into two teams.
One team will focus on developing source database query knowledge to create a reusable data layer. There are several application-specific business rules for this project. The customer needs to incrementally accumulate history for the QlikView application over time.
The second team will focus on developing the presentation layer. This team also has data modeling and scripting expertise, but does not have source database query knowledge.
Which data loading strategy should the developers use on the project?

A) create QVDs of the source data and load them into the presentation layer QVW and apply the business rules in the script
B) create QVDs of the source data, apply the business rules and store a second layer of QVDs, and then load these QVDs into the presentation layer QVW
C) create a series of QVWs that apply the business rules and then binary load them into the presentation layer QVW
D) create the presentation layer QVW and connect directly to the source data and apply the business rules in the script

3. 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.

4. Refer to the exhibit to the right.

What is the primary key of ACCOUNT_TRANS?

A) ACCOUNT_ID, TRANS_SEQ, and TRANS_TYPE
B) TRANS_SEQ
C) ACCOUNT_ID
D) ACCOUNT_ID and TRANS_SEQ

5. Refer to the exhibit to the right.

When the script displayed in the exhibit is reloaded, an error message is displayed.
Table not found
Left Join (SalesPerson)
LOAD ID,
DepartmentID
FROM
[DataSourceA.xlsx]
(ooxml, embedded labels, table is SalesPersonDepartment);
What is the likely cause of the error?

A) The Left Join statement fails to correctly bracket the referenced table name, such as Left Join ([SalesPerson]).
B) There is an error in the Customer table load and it is not created in memory.
C) When loaded, the SalesPerson table is auto concatenated to Customer and does not exist when referenced.
D) The Left Join statement fails to correctly quote the referenced table name, such as Left Join ("SalesPerson").

Solutions: