QV_DEVELOPER_01 Online Practice Questions and Answers

Which statement describes a required field characteristics that will ensure QlikView associations across multiple tables?

A. The field formats (such as numeric or string) must be the same in the original data sources.

B. The fields must be defined as primary or foreign keys in the original data sources.

C. The fields must be aliased to the same name when loading into QlikView.

D. The number of distinct values in each field must be the same.

Which action should a developer perform on a table to reduce required memory and optimize the application?

A. convert numeric fields into text fields using the Text function

B. combine multiple fields into one complex field, reducing the number of fields per table

C. make all numeric fields a fixed length by left padding with leading 0's using the Num function

D. split out a single complex field into multiple fields reducing the number of distinct values per field

A developer needs to add data from a Microsoft Access database to a data model intended to run on a 64

bit Windows server.

How should the developer proceed?

A. from the script editor, on the Data tab, under Database, choose 'ODBC' from the Database pull down, assure the 'Force 32 bit' check box is selected, and then click the 'Connect' button

B. from the script editor, on the Data tab, under Database, choose 'ODBC 32 bit' from the Database pull down and then click the 'Connect' button

C. from the script editor, on the Data tab, click on the 'database conversion' button and convert the database from a 32 bit to 64 bit database

D. from the script editor, on the Data tab, under Database choose 'ODBC' from the Database pull down and then click the 'Connect' button

Refer to the exhibit to the right.

What can a developer determine from the exhibit about the values in the Fax field?

A. The Fax field has NULL values for 24 percent of the records.

B. The Fax field has blanks for 24 percent of the records.

C. The Fax field has 76 percent incomplete invalid fax numbers.

D. On average, 76 percent of the Fax field values are non-spaces.

E. The longest Fax value is 76 percent of the assigned field length.

What is the interpretation of a 98 percent subset ratio in the CustomerlD field in an Orders table when the subset ratio of the same field in the Customer table is 100 percent?

A. 98 percent of the orders have customers in the data, but only 2 percent of the orders have been shipped

B. 2 percent of the orders have customers in the data, but 100 percent of the customers have placed an order

C. 100 percent of customers are defined in the Customer table, but 2 percent of the customers have not placed an order

D. 98 percent of the customers are defined in the Customer table, but 2 percent of the customers have not placed an order

A customer specified that the QlikView application should be designed to fit a screen resolution of 1280 x

800 as a standard.

Which option will assist a designer while creating the user interface?

A. Go to View menu > Reselect Window > 1280 x 800

B. Go to View menu > Fit Zoom to Window > 1280 x 800

C. Go to settings menu > User Preferences > Design Tab and select 1280 x 800

D. Go to settings menu > User Preferences > Design Tab and select Display Grid Lines

A developer has a Container Object with multiple charts and each chart has many different expressions.

The developer needs to provide users with a method to easily obtain information related to each chart and

the expressions within.

How can the developer fulfill this requirement?

A. design a help graphic for each chart and set it as the caption background

B. create a Text Object containing help information for each chart and link each Chart Object to its corresponding Text Object using QlikView's Linked Objects feature

C. enter a thorough description of each chart and its expressions in the Text in Chart property on the Layout tab

D. enter a thorough description of each chart and its expressions in the Help Text property on the Caption tab

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

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

C. The second QVW reload can be scheduled to start upon the successful completion of the first QVW reload.

D. An action can be placed on the OnPostReload trigger within the first QVW to submit the reload of the second QVW.

Refer to the exhibit to the right.

Which two data quality issues exist within the data set displayed in the exhibit? (Choose two.)

A. multiple spellings of the same City

B. the City value London is associated with two different Country values

C. the Country values and salesOrderlD values do not relate properly

D. the salesAmount field name does not contain a space

E. inconsistent Country abbreviations F. duplicate key values

Refer to the exhibit to the right.

When the script displayed in the exhibit is reloaded, an error message is displayed.

Table not found

Left Join (salesPerson)

LOAD lD

DepartmentlD

FROM

[DatasourceA.xlsx]

(ooxml, embeddedlabels, tableissalesPersonDepartment);

What is the likely cause of the error?

A. When loaded, the salesPerson table is auto concatenated to Customer and does not exist when referenced.

B. The Left Join statement fails to correctly bracket the referenced table name, such as Left Join ([salesPerson]).

C. The Left Join statement fails to correctly quote the referenced table name, such as Left Join (IsalesPersonI).

D. There is an error in the Customer table load and it is not created in memory.