QV_DEVELOPER_01 Practice Questions Preview

Question 1

Single choice

A customer needs to build a QlikView application using data in text files. A new data file is created every day and stored in a folder on the customer's network named s.\userfiles. The file name is in the form dataYYYYMMDD.txt, where YYYYMMDD represents the current date, such as data20111231.txt.

Which data load strategy should a developer use to load all of the customer's data files each day?

A
the statement 'Directory s.\userfiles\*;' preceding the Load statement
B
the 'Wildcard Load' feature by setting the 'File Location' in Document Properties
C
'Load * From [s.\userfiles\data*.txt] (ansi, txt, delimiter is '\t', embedded labels);'
D
'Load * From_Field (s.\userfiles\, 'data*.txt') (ansi, txt, delimiter is '\t', embedded labels);'

Reveal answer details Close answer details

Correct answerC

Question 2

Single choice

How does QlikView link a fact table and dimension table in the associative data model?

A
identically to all table linkages created in a relational database
B
on a field called I<tablename>.idI created by the developer in every table
C
on an identically named field in both the fact table and the dimension table
D
by manually setting the field property Keyfield on one field in both the fact table and the dimension table

Reveal answer details Close answer details

Correct answerC

Question 3

Single choice

A customer has an Addresses table with the fields. CustomerNumber, CustomerName, AddressLine1, AddressLine2, City, StateCode, PostalCode, and CountryCode.
A designer needs to design a chart to show a count of distinct customers in which the customer's
CountryCode is US or CA, while ignoring all selections on the Addresses table except the CustomerNumber and CustomerName fields.

How can the designer calculate the required value?

A
count({$<CountryCode={US, CA}, Addresses.*=>} distinct CustomerNumber)
B
count({$<CountryCode={US, CA}, AddressLine1=, AddressLine2=, City=, StateCode=, PostalCode=>}
distinct CustomerNumber)
C
count({1<CountryCode={US, CA}, CustomerName=CustomerName,
CustomerNumber=CustomerNumber>} distinct CustomerNumber)
D
count({$<CountryCode={US or CA}, AddressLine1=, AddressLine2=, City=, StateCode=,
PostalCode=>} distinct CustomerNumber)
E
count({$<(CountryCode={US} or CountryCode={CA}) AddressLine1= AddressLine2= City=
StateCode=, PostalCode=>} distinct CustomerNumber)

Reveal answer details Close answer details

Correct answerB

Question 4

Single choice

A project to develop a QlikView application for a customer requires splitting developers into two teams.
One team will focus on developing source database query knowledge to create a reusable data layer.
There are several application-specific business rules for this project. The customer needs to incrementally accumulate history for the QlikView application over time.
The second team will focus on developing the presentation layer. This team also has data modeling and scripting expertise, but does not have source database query knowledge.

Which data loading strategy should the developers use on the project?

A
create a series of QVWs that apply the business rules and then binary load them into the presentation layer QVW
B
create the presentation layer QVW and connect directly to the source data and apply the business rules in the script
C
create QVDs of the source data and load them into the presentation layer QVW and apply the business rules in the script
D
create QVDs of the source data, apply the business rules and store a second layer of QVDs, and then load these QVDs into the presentation layer QVW

Reveal answer details Close answer details

Correct answerD

Question 5

Single choice

A customer's product catalog database contains approximately 50000 individual product SKUs. The catalog is updated quarterly.
The customer needs the load on database servers to be minimized.

Which technique should a developer use to meet the customer's needs?

A
a preceding load statement when loading the product catalog quarterly from the customer's database
B
the BUFFER statement when loading the product catalog quarterly from the customer's database
C
a mapping table when loading the product catalog quarterly from the customer's database
D
a QVD file to store the product catalog quarterly from the customer's database

Reveal answer details Close answer details

Correct answerD

Question 6

Single choice

Which object should a designer use to integrate QlikView with an interactive third-party web service for use in the AJAX Zero Footprint client?

A
Custom Object
B
ButtonObject
C
QlikView Macro
D
Extension Object

Reveal answer details Close answer details

Correct answerD

Question 7

Single choice

How can a designer display the field selections that have been made within a chart caption?

A
by inserting a Current selections box into the Text in Chart
B
by using an expression with GetCurrentselections in the Window Title option on the General tab
C
by using an expression with SET Analysis and the system Fields in the Title Text option on the Caption tab
D
by selecting show Current selections on the Caption tab

Reveal answer details Close answer details

Correct answerB

Question 8

Single choice

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

Reveal answer details Close answer details

Correct answerB

Question 9

Single choice

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]

Reveal answer details Close answer details

Correct answerD

Question 10

Single choice

What must a developer consider when loading a table after the section Access statement and before the section Applicationstatement?

A
All field names must start with a $ sign.
B
All field names must be written in uppercase.
C
The field Access must be the first field loaded.
D
The fields Access, User, and Password must be loaded.

Reveal answer details Close answer details

Correct answerB

Question 11

Single choice

A customer has multiple bar charts comparing different metrics. All charts contain a single Expression all with the Dimension CustomerlD The charts are sorted by Y-Value Descending. Some Customers have Y-Values of zero for some metrics and not others.

How can the designer show the same color bar for a single CustomerlD in all the charts?

A
Properties > Colors and then define colors 1 - 6 with specific RGB values
B
Properties > Colors and then check the Multicolored and Persistent Colors checkboxes
C
Properties > Visual Cues and then set the Upper and Lower colors using specific RGB values
D
Properties > Presentation and then define the Error Bars colors with a specific RGB value

Reveal answer details Close answer details

Correct answerB