最新的QlikView Certification認證 QV_Developer_01考試題庫

問題1

What must a developer consider when loading a table after the Section Access statement and before the Section Application statement?

A. The field Access must be the first field loaded.

B. The fields Access, User, and Password must be loaded.

C. All field names must be written in uppercase.

D. All field names must start with a $ sign.

正確答案: C

說明：（僅 VCESoft 成員可見）

問題2

Refer to the exhibit to the right.

What is the primary key of ACCOUNT_TRANS?

A. ACCOUNT_ID, TRANS_SEQ, and TRANS_TYPE

B. ACCOUNT_ID and TRANS_SEQ

C. TRANS_SEQ

D. ACCOUNT_ID

正確答案: B

問題3

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

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

C. the Size to Data property on the Layout tab to automatically size the filter criteria to the chart

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

問題4

A customer has a Sales data table and needs a chart to display sales figures by date, including dates without sales.
The Sales table is sorted by the primary key which is generated based on the type of order and the SalesPersonID who generated it.
Which technique should a developer use to achieve this requirement?

A. Peek, when loading the Sales data, to create records within the Sales data table for dates with no sales

B. a Resident Load and Peek, to determine the minimum and maximum dates and then AutoGenerate to create a master calendar

C. the today() function, to determine the required date range and use an Inline load to generate the master calendar

D. calculated dimensions in Chart Objects and expressions in List Boxes, to generate the required dates

正確答案: B

問題5

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. Num( [Severity Weight], [Ticket Severity] ) AS [Ticket Severity]

C. Dual( [Ticket Severity], [Severity Weight] ) AS [Ticket Severity]

D. Sort( [Ticket Severity], [Severity Weight] ) AS [Ticket Severity]

正確答案: C

問題6

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

正確答案: C

問題7

In which two places in the Chart Properties of a Gauge can expressions be entered?
(Choose two.)

A. Auto Minimize of the object

B. Number of major/minor units for the scale

C. Calculation Condition of the object

D. Show Condition of the object

E. X and Y position of the object

正確答案: C,D

最新的QlikView 11 Developer Certification Examination - QV_Developer_01免費考試真題

最新更新

站內鏈接

聯系我們