QV_Developer_01 by QlikView Actual Free Exam Questions And Answers

Question 1

An Address Book table has a Country Code field. A standard lookup table exists in Excel to translate the Country Code to a Country description.
The Country Code will be US for any Address Book record with no Country Code value.
Which technique should a developer use to ensure a Country description is loaded for all Address Book records?

A. load the Excel data, then load the Address Book data using an If function to default Country Code to US, and then use the Peek function to retrieve the Country description

B. load the Excel data and then load the Address Book data ensuring the Country Code field has the same name in both tables

C. load the Excel data as a Mapping table and use Applymap with a default mapping value when loading the Address Book table

D. load the Address Book records and perform a Left Join of the Excel data to the Address Book table

Discussion 0

Correct Answer: C Vote an answer

Question 2

A customer needs to have QlikView deployed to tablet devices.
When creating the QVW application, which two actions must a developer take to meet the customer's need? (Choose two.)

A. ensure that screen resolution is appropriate for the device

B. use only sheet objects suitable for tablet devices

C. create a specific QVW application for each device

D. convert the QVW application into a HTML5 document

E. convert the QVW application into a .mob document on the server

Discussion 0

Correct Answer: A,B Vote an answer

Question 3

Refer to the exhibit below.

Schema A displayed in the exhibit has been transformed into Schema B.
How can the before and after schemas be described?

A. The star schema has been transformed into a de-normalized schema.

B. The star schema has been transformed into a normalized schema.

C. The snowflake schema has been transformed into a de-normalized schema.

D. The snowflake schema has been transformed into a normalized schema.

Discussion 0

Correct Answer: C Vote an answer

Question 4

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 Settings menu > User Preferences > Design Tab and select 1280 x 800

B. Go to View menu > Resize Window > 1280 x 800

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

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

Discussion 0

Correct Answer: B Vote an answer

Question 5

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

A. when portions of script are logically related

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

C. when entering Edit Script for the first time

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

Discussion 0

Correct Answer: A Vote an answer

Question 6

Which chart should a designer use to display orders, sales, and average order value grouped by year, quarter, region, product, and salesperson?

A. Bar Chart

B. Grid Chart

C. Mekko Chart

D. Straight Table

E. Pivot Table

Discussion 0

Correct Answer: E Vote an answer

Question 7

Refer to the exhibit to the right.

A customer needs the data displayed in the exhibit loaded into QlikView for analysis.
The data is stored in a flat file and new rows are appended daily.
Which two data quality issues will a developer have to resolve? (Choose two.)

A. the Date field name is also a function name and is a reserved word

B. the Transaction ID field name contains a space

C. one or more Product field values contain the file delimiter

D. one or more Product field values contain spaces

E. the Date field values contain special characters

F. one or more header rows are included in the file data

Discussion 0

Correct Answer: C,F Vote an answer

QlikView 11 Developer Certification Examination - QV_Developer_01 Exam Practice Test

Contact Us

Useful Links

Latest Updated