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. Sort( [Ticket Severity], [Severity Weight] ) AS [Ticket Severity]
B. Dual( [Ticket Severity], [Severity Weight] ) AS [Ticket Severity]
C. Rank( [Ticket Severity], [Severity Weight] ) AS [Ticket Severity]
D. Num( [Severity Weight], [Ticket Severity] ) AS [Ticket Severity]
正解:B
質問 2:
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. the statement 'Directory s. \userfiles\*;' preceding the Load statement
B. the 'Wildcard Load' feature by setting the 'File Location' in Document Properties
C. 'Load * From [s. \userfiles\data*.txt] (ansi, txt, delimiter is '\t', embedded labels);'
D. 'Load * From_Field (s. \userfiles\, 'data*.txt') (ansi, txt, delimiter is '\t', embedded labels);'
正解:C
質問 3:
Which technique should a developer use to clearly describe dimensions and measures for end users who need to use collaborative objects?
A. put descriptive information in each object's help text
B. put a How To sheet in the application
C. add a system table to the application
D. add field metadata tags to fields in the load script
正解:D
質問 4:
Refer to the exhibit to the right.
Which two data quality issues exist within the data set displayed in the exhibit? (Choose two.)
A. the City value London is associated with two different Country values
B. the Country values and SalesOrderID values do not relate properly
C. inconsistent Country abbreviations
D. duplicate key values
E. the SalesAmount field name does not contain a space
F. multiple spellings of the same City
正解:C,F
質問 5:
A customer needs multi-language support for a QlikView application.
The languages that need to be supported immediately are English, German, and Dutch; in the future, however, additional languages may be needed.
Which solution should a developer use to meet the customer's needs?
A. a separate document for each language
B. variables for language-specific items and the option to select a specific language in a field
C. a language definition table in the data model containing all descriptions for each language, and the option to select a specific language in a field
D. a language definition table in the data model containing all descriptions for each language, automatically linking the business user to a language
正解:C
質問 6:
A customer needs a better understanding of inventory trends over time. However, the source database contains only the current product inventory levels.
Which technique will take advantage of QlikView capabilities to meet the customer's needs?
A. using a QlikView script to store an accumulation of periodic snapshots to an XML file
B. using a QVD file to store an accumulation of periodic snapshots from the source database
C. using a QlikView script to store an accumulation of periodic snapshots to a table in the source database
D. using a QVX file to store an accumulation of periodic snapshots from the source database
正解:B
中田** -
QV_Developer_01ソフトバージョンをダウンロードできるのも非常にありがたいです。詳細に、QV_Developer_01出題がされているので非常に役に立っています。