QlikView QV_DEVELOPER_01 Online Practice Questions and Exam Preparation

QlikView QV_DEVELOPER_01 Online Questions & Answers

• Question 61:

  When should a developer create a new tab in the Load script?

  A. when the critical number of 255 lines per tab has been exceeded
  B. when the tab is marked with the ///tab$ statement
  C. when portions of script are logically related
  D. when entering Edit script for the first time
  C. when portions of script are logically related

• Question 62:

  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 columnheaderisdoubleclickedinStraightTablecharts. 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]
  D. Dual( [Ticket Severity], [Severity Weight] ) AS [Ticket Severity]

• Question 63:

  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
  C. load the Actuals table, and when loading the Budgets table, use the Concatenate function to append the Budgets table to the Actuals table

• Question 64:

  Refer to the exhibit to the right and the Load script provided below. Exhibit.

  

  LOAD ltemlD

  LocationlD,

  Quantity

  FROM

  [inventory.txt]

  (txt, codepage is 1252, embedded labels, delimiter is '', msq);

  When the developer runs the script, which values will the field Quantity contain?

  A. NULL
  B. 1; 2; 3
  C. 1100; 1300; 2210; 2250; 3125; 3130; 3120
  D. 1100; 1300; 2210; 2250; 3125; 3130; 3120
  B. 1; 2; 3

• Question 65:

  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
  C. the Load prefix Buffer with the incremental option

• Question 66:

  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)
  A. Class(DaysOverdue30)

• Question 67:

  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
  A. Calculation Condition of the object
  C. show Condition of the object

• Question 68:

  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
  D. concatenate the four transaction tables and add fields to identify the record type and count fag

• Question 69:

  A customer with a complex chart is experiencing performance issues when the organization's users view the chart without first applying several filters. A designer needs to place a restriction on the chart so that the users are forced to make a selection before QlikView will calculate and render the chart. Which common object property can the designer use to accomplish this?

  A. the Help Text property on the Caption tab to enter instructions directing the user to make a selection and filter their data before performing their analysis
  B. the Auto Minimize property on the Caption tab so that the chart will be minimized and not calculate or render until the user has first made a selection and restored the chart
  C. the Calculate Condition property on the General tab to create a control condition that will keep the chart from calculating until user has filtered the data
  D. the size to Data property on the Layout tab to automatically select the filter criteria to the chart
  C. the Calculate Condition property on the General tab to create a control condition that will keep the chart from calculating until user has filtered the data

• Question 70:

  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
  B. using a QVD file to store an accumulation of periodic snapshots from the source database