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

1. A global sales organization needs sales figures in both the local currencies and the corporate standard of $USD.
How can a developer achieve this goal and enable users to only consume a single Document CAL?

A) create a separate QVW containing values in the data model for both the local and $USD currency amounts
B) create a single QVW and add a table containing currency multipliers while using $USD as a baseline currency
C) create a separate QVW for each currency ($USD is considered its own currency) and document chain them all together
D) create a single QVW with duplicate tables for each currency in data islands and associate each data island to each user or group

2. A customer with a complex chart is experiencing performance issues when the organization's users view the chart without first applying several filters.
A designer needs to place a restriction on the chart so that the users are forced to make a selection before QlikView will calculate and render the chart.
Which common object property can the designer use to accomplish this?

A) the Auto Minimize property on the Caption tab so that the chart will be minimized and not calculate or render until the user has first made a selection and restored the chart
B) the Help Text property on the Caption tab to enter instructions directing the user to make a selection and filter their data before performing their analysis
C) the Calculate Condition property on the General tab to create a control condition that will keep the chart from calculating until user has filtered the data
D) the Size to Data property on the Layout tab to automatically size the filter criteria to the chart

3. Which statement describes a required field characteristics that will ensure QlikView associations across multiple tables?

A) The fields must be aliased to the same name when loading into QlikView.
B) The fields must be defined as primary or foreign keys in the original data sources.
C) The number of distinct values in each field must be the same.
D) The field formats (such as numeric or string) must be the same in the original data sources.

4. Which QlikView feature should a developer use to provide information throughout the QVW application about how a field was calculated in the Load script?

A) Variable Comment
B) Dimension Tag
C) Expression Comment
D) Field Comment
E) Field Tag

5. Refer to the exhibit to the right and the Load Script provided below. Exhibit.

LOAD ItemID,
LocationID,
Quantity
FROM
[inventory.txt]
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);
When the developer runs the script, which values will the field Quantity contain?

A) NULL
B) 1; 2; 3
C) 1,100; 1,300; 2,210; 2,250; 3,125; 3,130; 3,120
D) 1100; 1300; 2210; 2250; 3125; 3130; 3120

質問と回答：