QlikView QlikView Certification QV_DEVELOPER_01 Questions & Answers

• Question 1:

  A Straight Table Chart calculates several metrics for each individual alphanumeric transaction detail record

  (TRAN_lD) and it's Amount over several years of data. The calculation time for the chart is over two

  minutes.

  How can a designer decrease the calculation time for the chart without compromising core functionality?

  A. create a Calculation Condition. =count(TRAN_lD) <= 10000

  B. create a Calculation Condition. =sum(TRAN_lD) <= 10000

  C. create a Calculation Condition. =sum(Amount) > 0

  D. create a Calculation Condition. =TRAN_lD < 10000

  Correct Answer: A

• Question 2:

  A customer who operates a large national sales organization needs to divide a sales.qvw document into

  region- specificdocumentsusingtheRegionfield(North, South, East, andWest).

  Each region should have access to region-specific data.

  Which instruction should a developer give to the server/Publisher administrator to meet the customer's

  needs?

  A. create a QlikView server task to reduce the sales.qvw document based on the Region field and distribute to region- specific folders with appropriate file permissions

  B. create a QlikView Publisher task to reduce the sales.qvw document based on the Region field and distribute to region-specific folders with appropriate file permissions

  C. create four QlikView server tasks to reload data from the sales.qvw document with data only for each region and distributetoregion-specificfolderswith appropriatefilepermissions

  D. create a QlikView Publisher task to reduce data from the sales.qvw document to create four QVX files with data only for each region and distribute to region-specific folders with appropriate file permissions

  Correct Answer: B

• Question 3:

  A customer's data set contains information for multiple departments. The customer needs a document to

  show only one specific department when a user first accesses the application.

  Which trigger and action will meet the requirement?

  A. trigger. OnPostReload; action. Lock Field

  B. trigger. OnOpen; action. SET Variable

  C. trigger. OnOpen; action. select in Field

  D. trigger. Onselect; action. select in Field

  Correct Answer: C

• Question 4:

  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

  Correct Answer: A

• Question 5:

  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

  Correct Answer: D

• Question 6:

  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

  Correct Answer: A

• Question 7:

  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)

  Correct Answer: A

• Question 8:

  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

  Correct Answer: D

• Question 9:

  Refer to the exhibit to the right.

  

  When the script displayed in the exhibit is reloaded, an error message is displayed.

  Table not found

  Left Join (salesPerson)

  LOAD lD

  DepartmentlD

  FROM

  [DatasourceA.xlsx]

  (ooxml, embeddedlabels, tableissalesPersonDepartment);

  What is the likely cause of the error?

  A. When loaded, the salesPerson table is auto concatenated to Customer and does not exist when referenced.

  B. The Left Join statement fails to correctly bracket the referenced table name, such as Left Join ([salesPerson]).

  C. The Left Join statement fails to correctly quote the referenced table name, such as Left Join (IsalesPersonI).

  D. There is an error in the Customer table load and it is not created in memory.

  Correct Answer: A

• Question 10:

  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

  Correct Answer: A