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

1. Which QlikView script should a developer add to a Load script to output the resulting number of rows from a joining Load statement to the Script Execution Progress window and the script log file?

A) SET vNumRows = NoOfRows('TableName'); Response.Write 'Resulting Rows = $(vNumRows)';
B) SET vNumRows = NoOfRows('TableName'); ECHO 'Resulting Rows = $(vNumRows)';
C) LET vNumRows = NoOfRows('TableName'); PRINT 'Resulting Rows = $(vNumRows)';
D) LET vNumRows = NoOfRows('TableName'); TRACE 'Resulting Rows = $(vNumRows)';
E) LET vNumRows = NoOfRows('TableName'); ECHO 'Resulting Rows = $(vNumRows)';

2. A customer is building a dashboard to measure the performance of the Support organization.
The customer needs to dynamically sort the Ticket Severity field by Severity Weight field when the Ticket Severity column header is double-clicked in Straight Table charts.
Example ticket severities. Urgent = 1 High = 2 Normal = 3 Low = 4
Which QlikView load script function can the developer use to create the Ticket Severity field to meet the customer's needs?

A) Rank( [Ticket Severity], [Severity Weight] ) AS [Ticket Severity]
B) Dual( [Ticket Severity], [Severity Weight] ) AS [Ticket Severity]
C) Sort( [Ticket Severity], [Severity Weight] ) AS [Ticket Severity]
D) Num( [Severity Weight], [Ticket Severity] ) AS [Ticket Severity]

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

4. A customer created 20 expressions that will be used repetitively throughout a QlikView application. These expressions could appear in more than 50 objects located on 15 tabs.
How can a developer efficiently apply and maintain these expressions?

A) load the text for each expression from a text file into a table in the data model and link it to the fact table
B) create a table of indices and expression text and use the index value in place of the expression text in each object
C) create a variable for each expression that contains the expression text and use the variable in place of the expression in each object
D) create the required expression in each object as needed and edit them in the Expression Overview

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

質問と回答：