QlikView QV_DEVELOPER_01 Online Practice Questions and Exam Preparation

QlikView QV_DEVELOPER_01 Online Questions & Answers

• Question 1:

  A developer needs to modify the data model of a document that consumes 5GB of RAM when opened in memory. Which type of client should the developer use?

  A. lnternet Explorer Plug-in client on a 64 bit Windows 7 operating system
  B. QlikView local client on a 32 bit Windows 7 operating system
  C. QlikView local client on a 64 bit Mac operating system
  D. QlikView local client on a 64 bit Windows 7 operating system
  D. QlikView local client on a 64 bit Windows 7 operating system

• Question 2:

  A customer has a sales data table and needs a chart to display sales figures by date, including dates without sales. The sales table is sorted by the primary key which is generated based on the type of order and the salesPersonlD who

  generated it.

  Which technique should a developer use to achieve this requirement?

  A. a Resident Load and Peek, to determine the minimum and maximum dates and then AutoGenerate to create a master calendar
  B. the today() function, to determine the required date range and use an lnline load to generate the master calendar
  C. Peek, when loading the sales data, to create records within the sales data table for dates with no sales
  D. calculated dimensions in Chart Objects and expressions in List Boxes, to generate the required dates
  A. a Resident Load and Peek, to determine the minimum and maximum dates and then AutoGenerate to create a master calendar

• Question 3:

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

• Question 4:

  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)
  B. create a Calculation Condition. =sum(TRAN_lD)
  C. create a Calculation Condition. =sum(Amount) > 0
  D. create a Calculation Condition. =TRAN_lD < 10000
  A. create a Calculation Condition. =count(TRAN_lD)

• Question 5:

  Refer to the exhibit to the right.

  

  What can a developer determine from the exhibit about the values in the Fax field?

  A. The Fax field has NULL values for 24 percent of the records.
  B. The Fax field has blanks for 24 percent of the records.
  C. The Fax field has 76 percent incomplete invalid fax numbers.
  D. On average, 76 percent of the Fax field values are non-spaces.
  E. The longest Fax value is 76 percent of the assigned field length.
  A. The Fax field has NULL values for 24 percent of the records.

• Question 6:

  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
  A. Pivot Table

• Question 7:

  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
  D. Extension Object

• Question 8:

  A customer needs to display sales amounts for the current month and a trend of sales over the prior 12 months using asmall amountof screenspace. Which chart type should the designer use to meets the customer's needs?

  A. a Combo Chart with one expression to display the current month sales and a second expression represented as a Mini Chart to display a trend of sales over the prior 12 months
  B. a Straight Table with one expression to display the current month sales and a second Line Chart to display a trend of sales over the prior 12 months
  C. a Straight Table with one expression to display the current month sales and a second expression represented as a Mini Chart to display a trend of sales over the prior 12 months
  D. a Straight Table with one expression to display the current month sales and a second expression represented as a Linear Gauge to display a trend of sales over the prior 12 months
  C. a Straight Table with one expression to display the current month sales and a second expression represented as a Mini Chart to display a trend of sales over the prior 12 months

• Question 9:

  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
  D. a QVD file to store the product catalog quarterly from the customer's database

• Question 10:

  A customer needs to analyze Products by Product Grouping. The relationship between Product and Product Group is undefined in the original data source. How can the Product Grouping be defined within the QlikView script?

  A. by using lnput Box to enter the lookup table
  B. by using AutoGenerate to load the lookup table
  C. by generating a lookup table using the lnline wizard
  D. by loading the lookup table using an lnclude statement
  C. by generating a lookup table using the lnline wizard