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 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 to the right.

A customer has aggregated budgets for products by year and month. Actual data is stored at a more detailed transaction level and so a one-to-many relationship exists between the Budgets to Actuals table. Budgets have been assigned for all months of the current year, but there are only transactions up to the current month of October. There are transactions for products that were not assigned budgets. How can a developer remove the synthetic key automatically generated by QlikView and be able to analyze budgets andactualsbyproduct, month, andyear?

A. load the Actuals table, and when loading the Budgets table, use Outer Join to join the BudgetAmount field to the Actuals table

B. load the Actuals table, and when loading the Budgets table, rename fields Year and Month to BudgetYear and BudgetMonth

C. load the Actuals table, and when loading the Budgets table, use the Concatenate function to append the Budgets table to the Actuals table

D. create a concatenated key of Product-Year-Month in both the Budgets and Actuals table and comment out the individual fields in the Budgets table

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

A customer needs a better understanding of inventory trends over time. However, the source database

contains only the current product inventory levels.

Which technique will take advantage of QlikView capabilities to meet the customer's needs?

A. using a QlikView script to store an accumulation of periodic snapshots to a table in the source database

B. using a QVD file to store an accumulation of periodic snapshots from the source database

C. using a QVX file to store an accumulation of periodic snapshots from the source database

D. using a QlikView script to store an accumulation of periodic snapshots to an XML file

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

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

Refer to the exhibit to the right.

How many rows and fields will TableA have after the script completes?

A. five rows and three fields

B. five rows and two fields

C. four rows and three fields

D. four rows and two fields

E. two rows and three fields

A customer needs an application to reload in a short time period. The source tables are log files that are

appended to on a daily basis.

Which performance tuning option should a developer use?

A. the QVD files to store the source tables

B. the Partial Reload command with the append option

C. the Load prefix Buffer with the incremental option

D. the Load prefix Buffer and set the Keep Outdated QVD Buffers in the Document Properties

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.