QlikView QlikView Certification QV_DEVELOPER_01 Questions & Answers

• Question 51:

  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

  Correct Answer: C

• Question 52:

  A developer needs to add data from a Microsoft Access database to a data model intended to run on a 64

  bit Windows server.

  How should the developer proceed?

  A. from the script editor, on the Data tab, under Database, choose 'ODBC' from the Database pull down, assure the 'Force 32 bit' check box is selected, and then click the 'Connect' button

  B. from the script editor, on the Data tab, under Database, choose 'ODBC 32 bit' from the Database pull down and then click the 'Connect' button

  C. from the script editor, on the Data tab, click on the 'database conversion' button and convert the database from a 32 bit to 64 bit database

  D. from the script editor, on the Data tab, under Database choose 'ODBC' from the Database pull down and then click the 'Connect' button

  Correct Answer: A

• Question 53:

  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

  Correct Answer: C

• Question 54:

  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

  Correct Answer: D

• Question 55:

  A client has a data set with two tables.

  The Customer table has fields CustomerlD, AssignedTo, FirstName, and LastName.

  The Orders table has fields CustomerlD, AssignedTo, Product, and Quantity.

  The AssignedTo field holds an employee reference.

  Users need to see Customers and Orders by employee.

  The employee assigned to the Customer may not be the same as the employee assigned to the Order.

  Which technique should be used in the script to meet the requirement?

  A. load the tables leaving the automatic associations

  B. comment out the AssignedTo from the Orders table

  C. comment out the AssignedTo from the Customer table

  D. use Rename Field syntax to alias one of the AssignedTo fields

  E. create a concatenated key of CustomerlD and AssignedTo in both tables

  Correct Answer: D

• Question 56:

  Refer to the exhibit below.

  

  Schema A displayed in the exhibit has been transformed into schema B. How can the before and after schemas be described?

  A. The snowfake schema has been transformed into a de-normalized schema.

  B. The snowfake schema has been transformed into a normalized schema.

  C. The star schema has been transformed into a de-normalized schema.

  D. The star schema has been transformed into a normalized schema.

  Correct Answer: A

• Question 57:

  Refer to the exhibit below.

  

  The tables displayed in the exhibit need to be loaded into QlikView. How will the data model appear once the load is complete?

  A. There will be a relationship between all the tables without synthetic key tables or loosely coupled tables.

  B. There will be a relationship between four of the five tables and one table will be a data island.

  C. There will be a synthetic key table in the data model.

  D. There will be loosely coupled tables in the data model.

  Correct Answer: D

• Question 58:

  Which statement describes a required field characteristics that will ensure QlikView associations across multiple tables?

  A. The field formats (such as numeric or string) must be the same in the original data sources.

  B. The fields must be defined as primary or foreign keys in the original data sources.

  C. The fields must be aliased to the same name when loading into QlikView.

  D. The number of distinct values in each field must be the same.

  Correct Answer: C

• Question 59:

  Which action should a developer perform on a table to reduce required memory and optimize the application?

  A. convert numeric fields into text fields using the Text function

  B. combine multiple fields into one complex field, reducing the number of fields per table

  C. make all numeric fields a fixed length by left padding with leading 0's using the Num function

  D. split out a single complex field into multiple fields reducing the number of distinct values per field

  Correct Answer: D

• Question 60:

  Refer to the exhibit to the right.

  

  What is the primary key of ACCOUNT_TRANS?

  A. ACCOUNT_lD

  B. TRANS_SEQ

  C. ACCOUNT_lD and TRANS_SEQ

  D. ACCOUNT_lD, TRANS_SEQ, and TRANS_TYPE

  Correct Answer: C