QlikView 11 Developer Certification Examination Sample Questions:

1. A customer needs a better understanding of inventory trends over time. However, the source database contains only the current product inventory levels.
Which technique will take advantage of QlikView capabilities to meet the customer's needs?

A) using a QVX file to store an accumulation of periodic snapshots from the source database
B) using a QlikView script to store an accumulation of periodic snapshots to an XML file
C) using a QVD file to store an accumulation of periodic snapshots from the source database
D) using a QlikView script to store an accumulation of periodic snapshots to a table in the source database

2. A customer who operates a large national sales organization needs to divide a Sales.qvw document into region-specific documents using the Region field (North, South, East, and West).
Each region should have access to region-specific data.
Which instruction should a developer give to the Server/Publisher administrator to meet the customer's needs?

A) create a QlikView Server task to reduce the Sales.qvw document based on the Region field and distribute to region-specific folders with appropriate file permissions
B) create a QlikView Publisher task to reduce data from the Sales.qvw document to create four QVX files with data only for each region and distribute to region-specific folders with appropriate file permissions
C) create a QlikView Publisher task to reduce the Sales.qvw document based on the Region field and distribute to region-specific folders with appropriate file permissions
D) create four QlikView Server tasks to reload data from the Sales.qvw document with data only for each region and distribute to region-specific folders with appropriate file permissions

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

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

4. 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 Excel data and then load the Address Book data ensuring the Country Code field has the same name in both tables
B) 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
C) load the Excel data as a Mapping table and use Applymap with a default mapping value when loading the Address Book table
D) load the Address Book records and perform a Left Join of the Excel data to the Address Book table

5. Refer to the exhibit to the right.

Which two data quality issues exist within the data set displayed in the exhibit? (Choose two.)

A) inconsistent Country abbreviations
B) the City value London is associated with two different Country values
C) the Country values and SalesOrderID values do not relate properly
D) the SalesAmount field name does not contain a space
E) duplicate key values
F) multiple spellings of the same City

Solutions: