QlikView 11 Developer Certification Examination 認定 QV_Developer_01 試験問題:

1. Refer to the exhibit to the right.

The Sales table displayed in the exhibit represents the entire data set.
Given the expression.
=sum( {$< Month={'Oct'}, RegionID={'4'} >} SalesAmount)
What is the result with the selections for SalesPersonID=1 and RegionID=3?

A) 4500
B) 5000
C) 0
D) 3500

2. Which action should a developer perform on a table to reduce required memory and optimize the application?

A) make all numeric fields a fixed length by left padding with leading 0's using the Num function
B) combine multiple fields into one complex field, reducing the number of fields per table
C) split out a single complex field into multiple fields reducing the number of distinct values per field
D) convert numeric fields into text fields using the Text function

3. A customer needs to analyze Products by Product Grouping. The relationship between Product and Product Group is undefined in the original data source.
How can the Product Grouping be defined within the QlikView script?

A) by generating a lookup table using the Inline wizard
B) by using Input Box to enter the lookup table
C) by using AutoGenerate to load the lookup table
D) by loading the lookup table using an Include statement

4. Refer to the exhibit below.

The tables displayed in the exhibit need to be loaded into QlikView.
How will the data model appear once the load is complete?

A) There will be a relationship between four of the five tables and one table will be a data island.
B) There will be a synthetic key table in the data model.
C) There will be a relationship between all the tables without synthetic key tables or loosely coupled tables.
D) There will be loosely coupled tables in the data model.

5. How can a designer display the field selections that have been made within a chart caption?

A) by inserting a Current Selections box into the Text in Chart
B) by using an expression with Set Analysis and the System Fields in the Title Text option on the Caption tab
C) by using an expression with GetCurrentSelections in the Window Title option on the General tab
D) by selecting Show Current Selections on the Caption tab

質問と回答：