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

1. A customer needs to build a QlikView application using data in text files. A new data file is created every day and stored in a folder on the customer's network named s. \userfiles.
The file name is in the form dataYYYYMMDD.txt, where YYYYMMDD represents the current date, such as data20111231.txt.
Which data load strategy should a developer use to load all of the customer's data files each day?

A) 'Load * From_Field (s. \userfiles\, 'data*.txt') (ansi, txt, delimiter is '\t', embedded labels);'
B) the 'Wildcard Load' feature by setting the 'File Location' in Document Properties
C) the statement 'Directory s. \userfiles\*;' preceding the Load statement
D) 'Load * From [s. \userfiles\data*.txt] (ansi, txt, delimiter is '\t', embedded labels);'

2. When should a developer create a new tab in the Load Script?

A) when portions of script are logically related
B) when entering Edit Script for the first time
C) when the critical number of 255 lines per tab has been exceeded
D) when the tab is marked with the ///tab$ statement

3. A customer needs an application to reload in a short time period. The source tables are log files that are appended to on a daily basis.
Which performance tuning option should a developer use?

A) the QVD files to store the source tables
B) the Partial Reload command with the append option
C) the Load prefix Buffer with the incremental option
D) the Load prefix Buffer and set the Keep Outdated QVD Buffers in the Document Properties

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

5. A developer needs to load data for products from a database table and a text file. The database table and text file can be joined by the field ProductID.
The database table contains the master list of all available products. The text file contains additional data fields, but not for all products.
The developer loads the data from the database table first.
The developer needs to load the additional data fields from the text file into the existing table. The resulting table needs to contain the master list of all available products.
Which type of join should the developer use when loading the text file?

A) Right Join
B) Outer Join
C) Left Join
D) Inner Join

質問と回答：