QV_DEVELOPER_01 Online Practice Questions and Answers

Refer to the exhibit to the right and the Load script provided below. Exhibit.

LOAD ltemlD

LocationlD,

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. 1100; 1300; 2210; 2250; 3125; 3130; 3120

D. 1100; 1300; 2210; 2250; 3125; 3130; 3120

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. change the default DateFormat variable assignment on the Main script tab

B. use the Date function to format the field during load

C. use the Alt function with different Date# functions

D. use the Lookup function with a format table

Refer to the exhibit to the right.

What is the primary key of ACCOUNT_TRANS?

A. ACCOUNT_lD

B. TRANS_SEQ

C. ACCOUNT_lD and TRANS_SEQ

D. ACCOUNT_lD, TRANS_SEQ, and TRANS_TYPE

A client has a data set with two tables.

The Customer table has fields CustomerlD, AssignedTo, FirstName, and LastName.

The Orders table has fields CustomerlD, 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. load the tables leaving the automatic associations

B. comment out the AssignedTo from the Orders table

C. comment out the AssignedTo from the Customer table

D. use Rename Field syntax to alias one of the AssignedTo fields

E. create a concatenated key of CustomerlD and AssignedTo in both tables

Refer to the exhibit to the right.

Which technique should be used by a developer to eliminate the circular reference in the data model displayed in the exhibit?

A. qualify all the fields in the data model ending with 'lD'

B. qualify the fields Name, Address, City, and Country in the shippers and suppliers tables

C. rename the fields shipperlD in the shippers table and supplierlD in the suppliers table

D. rename the fields OrderlD in the OrderDetails table and supplierlD in the Products table

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 ProductlD

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. lnner Join

B. Left Join

C. Right Join

D. Outer Join

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

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

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

When should a developer create a new tab in the Load script?

A. when the critical number of 255 lines per tab has been exceeded

B. when the tab is marked with the ///tab$ statement

C. when portions of script are logically related

D. when entering Edit script for the first time

A customer who operates a large national sales organization needs to divide a sales.qvw document into

region- specificdocumentsusingtheRegionfield(North, South, East, andWest).

Each region should have access to region-specific data.

Which instruction should a developer give to the server/Publisher administrator to meet the customer's

needs?

A. create a QlikView server task to reduce the sales.qvw document based on the Region field and distribute to region- specific folders with appropriate file permissions

B. create a QlikView Publisher task to reduce the sales.qvw document based on the Region field and distribute to region-specific folders with appropriate file permissions

C. create four QlikView server tasks to reload data from the sales.qvw document with data only for each region and distributetoregion-specificfolderswith appropriatefilepermissions

D. create a QlikView Publisher task to reduce data from the sales.qvw document to create four QVX files with data only for each region and distribute to region-specific folders with appropriate file permissions