QV_DEVELOPER_01 Online Practice Questions and Answers

A customer needs to measure the Amount of sales by Days sales Outstanding (DSO). Days sales

Outstanding does not exist in the data model.

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

A. on the Dimensions tab, press the Add Calculated Dimension button

B. on the Expressions tab, add an expression using the Class function

C. on the Expressions tab, add an expression using the Aggr function

D. on the Dimensions tab, press the Add Dynamic Dimension button

Refer to the exhibit.

A customer needs to analyze transactions across the Dimensions and Metrics identified below.

Required Dimensions:

Project lD

Month

Year Account lD Transaction Type Client lD Required Metrics: Number of transactions Total Amount Total Cost Average Amount Average Cost

Which approach will provide the most effective QlikView data model to meet the customer's requirements while optimizing performance and maintaining accuracy?

A. build a Link Table to connect the four transaction tables and add a summary table with pre-calculated counts, totals, and averages

B. build a Link Table to connect the four transaction tables and alias fields that must be kept in their respective table

C. concatenate the four transaction tables and add a summary table with pre-calculated counts, totals, and averages

D. concatenate the four transaction tables and add fields to identify the record type and count fag

E. keep the four transaction tables separate and qualify the names to control correct linkage

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

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.

ln which two places in the Chart Properties of a Gauge can expressions be entered? (Choose two.)

A. Calculation Condition of the object

B. Number of major/minor units for the scale

C. show Condition of the object

D. X and Y position of the object

E. Auto Minimize of the object

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

Which objects are the most appropriate for setting one or more values for use in a "what-if" scenario?

A. lnput Box Object and Chart Object

B. lnput Box Object and Calendar/slider Object

C. Button Object and Extension Object

D. Calendar/slider Object and Chart Object

E. lnput Box Object and Text Object

A developer made several changes to a 25-tab load script that normally runs for at least two hours. Which step should the developer take first to efficiently debug the script logic?

A. place a Go To Exit statement after each block of revised script code, run the script, and comment each successive Go To Exit after a successful run

B. move each revised tab in succession to the second tab position, place an Exit script statement at the end of the tab script, and run the script

C. open the QlikView Debugger and use the step button to execute each line of the script

D. open the QlikView Debugger and use Limited Load to execute the script

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

An invoices table has a DaysOverdue field. A chart is required to analyze overdue invoices in 30 day

intervals.

Which function should a designer use within a chart to meet this requirement?

A. Class(DaysOverdue30)

B. Aggr(DaysOverdue30)

C. GroupBy(DaysOverdue30)

D. lntervalMatch(DaysOverdue30)