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

1. A customer has a set of date values in different formats.
Some dates are in Julian date format; some dates are text strings.
How can a developer ensure the data is loaded in a consistent format?

A) use the Alt function with different Date# functions
B) use the Date function to format the field during load
C) change the default DateFormat variable assignment on the Main script tab
D) use the Lookup function with a format table

2. Refer to the exhibit to the right.

How many rows and fields will TableA have after the script completes?

A) four rows and two fields
B) two rows and three fields
C) five rows and two fields
D) four rows and three fields
E) five rows and three fields

3. A developer created two QVWs. The first QVW loads data from the data source and creates QVD files. The second QVW loads the QVD files and provides the user interface for the analytics.
The customer does not have Publisher installed.
How should the reloads be configured on the server to ensure the first QVW reload completes before the second QVW reload begins?

A) An action can be placed on the OnPostReload trigger within the first QVW to submit the reload of the second QVW.
B) The second QVW reload can be scheduled to start upon the successful completion of the first QVW reload.
C) Only the first QVW reload can be automated. An alert will need to be sent to prompt an administrator to manually perform the second QVW reload.
D) Only one QVW reload can occur at a time on the QlikView server. The second QVW reload will always wait until the first QVW reload completes.

4. A designer needs to create a chart displaying the number of patients currently checked into a hospital by age group.
What is the appropriate Dimension for the chart?

A) age group
B) hospital
C) checked-in status
D) number of patients

5. A client has a data set with two tables.
The Customer table has fields CustomerID, AssignedTo, FirstName, and LastName. The
Orders table has fields CustomerID, AssignedTo, Product, and Quantity.
The AssignedTo field holds an employee reference.
Users need to see Customers and Orders by employee.
The employee assigned to the Customer may not be the same as the employee assigned
to the Order.
Which technique should be used in the script to meet the requirement?

A) comment out the AssignedTo from the Customer table
B) create a concatenated key of CustomerID and AssignedTo in both tables
C) use Rename Field syntax to alias one of the AssignedTo fields
D) load the tables leaving the automatic associations
E) comment out the AssignedTo from the Orders table

質問と回答：