QV_DEVELOPER_01 Online Practice Questions and Answers

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

Refer to the exhibit to the right.

A customer has two databases containing employee data for different regions. Based on the script displayed in the exhibit, what will be the resulting table schema?

A. one table named Employees_US

B. one table named Employees_UK

C. two tables named Employees_US and Employees_UK with no associations

D. two tables named Employees_US and Employees_UK with a synthetic key

A customer has data tables for financial results, staffing, sanitary conditions, and customer satisfaction.

Each table contains a date field and a location lD. Not all dates appear in all tables.

How can a developer create a master calendar that can be used with all the tables?

A. Designate one of the date fields as the reference Build a calendar spanning the minimum and maximum dates in that table Rename all other date fields to match the reference field Left join the location lD from each table into the calendar table on the date fields Drop the location and date fields from all other tables

B. Find the minimum and maximum dates spanned by all tables Create a calendar spanning those dates Rename all other date fields to match the reference field Left join the location lD from each table into the calendar table on the date fields Drop the location and date fields from all other tables

C. Designate one of the date fields as the reference Build a calendar spanning the minimum and maximum dates in that table Rename all other date fields to match the reference field Create a link table with a key of Location and date that contains all unique locations and dates Create a key of location and date in the other tables

D. Find the minimum and maximum dates spanned by all tables Create a calendar spanning those dates Create a link table with a key of location and date that contains all unique locations and dates Create a key of location and date in the other tables Drop the location and date fields from all other tables

A developer needs to load data for products from a database table and a text file. The database table and

text file can be joined by the field ProductlD

The database table contains the master list of all available products. The text file contains additional data

fields, but not for all products.

The developer loads the data from the database table first.

The developer needs to load the additional data fields from the text file into the existing table. The resulting

table needs to contain the master list of all available products.

Which type of join should the developer use when loading the text file?

A. lnner Join

B. Left Join

C. Right Join

D. Outer Join

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 customer has 30 target values that are used to evaluate the quality of an organization's facilities. At least

half the target values are changed monthly by the business users.

What is the most efficient way for the developer to store, access, and maintain the target values?

A. save the target names and values in an external file, load them into a QlikView table, and use a FOR loop to assign the values to variables

B. manually create a variable for each value in Expression Overview and maintain them in Expression Overview

C. create a Variables tab in the load script and use 30 LET statements to assign the values to variables

D. embed the target values into each expression in which they are required

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

Refer to the exhibit to the right.

The sales table displayed in the exhibit represents the entire data set. Given the expression. =sum(Given the expression.=sum( {$< Month={'Oct'}, RegionlD={'4'} >} salesAmount)

What is the result with the selections for salesPersonlD=1 and RegionlD=3?

A. 0

B. 3500

C. 4500

D. 5000

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

A. Pivot Table

B. StraightTable

C. Grid Chart

D. Mekko Chart

E. Bar Chart