QV_DEVELOPER_01 Online Practice Questions and Answers

A designer needs to create a chart displaying the number of patients currently checked into a hospital by

age group.

What is the appropriate Dimension for the chart?

A. number of patients

B. checked-in status

C. hospital

D. age group

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

Refer to the exhibit to the right.

What is the cardinality of the relationship between CUSTOMER and ACCOUNT?

A. many-to-many

B. one-to-many

C. one-to-none

D. one-to-one

Refer to the exhibit below.

A QlikView report does not match the legacy report it was designed to replace. The purpose of the report

is to count the number of customers per year and in total.

Why is there a difference between the Total row values in the two reports?

A. The legacy report calculates the total customer occurrences, while the QlikView report counts only distinct customers.

B. The legacy report calculates the total customer occurrences, while the QlikView report calculates the customer ranking.

C. The legacy report totals the number of customers correctly, while the QlikView report is dropping records.

D. The legacy report totals the number of customers correctly, while the QlikView total row is set to sum of rows.

Which QlikView script should a developer add to a Load script to output the resulting number of rows from a joining Load statement to the script Execution Progress window and the script log file?

A. LET vNumRows = NoOfRows('TableName'); ECHO 'Resulting Rows = $(vNumRows)';

B. SET vNumRows = NoOfRows('TableName'); ECHO 'Resulting Rows = $(vNumRows)';

C. LET vNumRows = NoOfRows('TableName'); PRlNT 'Resulting Rows = $(vNumRows)';

D. SET vNumRows = NoOfRows('TableName'); Response.Write 'Resulting Rows = $(vNumRows)';

E. LET vNumRows = NoOfRows('TableName'); TRACE 'Resulting Rows = $(vNumRows)';

Refer to the exhibit to the right.

When a customer reloads the script displayed in the exhibit, it fails to respond and complete, and displays

an error message.

OBJECT OUT OF MEMORY.

How should the developer resolve the logic error in the script?

A. change the script to use an lnner Join instead of Left Join

B. change the QUALlFY * command to list out only the fields that need to be qualified

C. change the Left Join command to include the name of the table being joined enclosed in parentheses

D. change the DepartmentlD field in the salesPerson table to match the qualified field name of DepartmentlD in the Department table

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

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

D. the size to Data property on the Layout tab to automatically select the filter criteria to the chart

Which QlikView feature should a developer use to provide information throughout the QVW application about how a field was calculated in the Load script?

A. Field Tag

B. Field Comment

C. Dimension Tag

D. Variable Comment

E. Expression Comment

A developer needs to modify the data model of a document that consumes 5GB of RAM when opened in

memory.

Which type of client should the developer use?

A. lnternet Explorer Plug-in client on a 64 bit Windows 7 operating system

B. QlikView local client on a 32 bit Windows 7 operating system

C. QlikView local client on a 64 bit Mac operating system

D. QlikView local client on a 64 bit Windows 7 operating system

A Straight Table Chart calculates several metrics for each individual alphanumeric transaction detail record

(TRAN_lD) and it's Amount over several years of data. The calculation time for the chart is over two

minutes.

How can a designer decrease the calculation time for the chart without compromising core functionality?

A. create a Calculation Condition. =count(TRAN_lD) <= 10000

B. create a Calculation Condition. =sum(TRAN_lD) <= 10000

C. create a Calculation Condition. =sum(Amount) > 0

D. create a Calculation Condition. =TRAN_lD < 10000