QlikView QV_DEVELOPER_01 Online Practice Questions and Exam Preparation

QlikView QV_DEVELOPER_01 Online Questions & Answers

• Question 41:

  Refer to the exhibit to the right.

  

  Which technique should be used by a developer to eliminate the circular reference in the data model displayed in the exhibit?

  A. qualify all the fields in the data model ending with 'lD'
  B. qualify the fields Name, Address, City, and Country in the shippers and suppliers tables
  C. rename the fields shipperlD in the shippers table and supplierlD in the suppliers table
  D. rename the fields OrderlD in the OrderDetails table and supplierlD in the Products table
  B. qualify the fields Name, Address, City, and Country in the shippers and suppliers tables

• Question 42:

  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
  D. use Rename Field syntax to alias one of the AssignedTo fields

• Question 43:

  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?

  B. 3500
  C. 4500
  D. 5000
  A

• Question 44:

  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
  C. ACCOUNT_lD and TRANS_SEQ

• Question 45:

  A customer needs multi-language support for a QlikView application. The languages that need to be supported immediately are English, German, and Dutch; in the future, however, additional languages may be needed. Which solution should a developer use to meet the customer's needs?

  A. a separate document for each language
  B. variables for language-specific items and the option to select a specific language in a field
  C. a language definition table in the data model containing all descriptions for each language, and the option to select a specific language in a field
  D. a language definition table in the data model containing all descriptions for each language, automatically linking the business user to a language
  C. a language definition table in the data model containing all descriptions for each language, and the option to select a specific language in a field

• Question 46:

  A customer needs to build a QlikView application using data in text files. A new data file is created every day and stored in a folder on the customer's network named s.\userfiles. The file name is in the form dataYYYYMMDD.txt, where

  YYYYMMDD represents the current date, such as data20111231.txt.

  Which data load strategy should a developer use to load all of the customer's data files each day?

  A. the statement 'Directory s.\userfiles\*;' preceding the Load statement
  B. the 'Wildcard Load' feature by setting the 'File Location' in Document Properties
  C. 'Load * From [s.\userfiles\data*.txt] (ansi, txt, delimiter is '\t', embedded labels);'
  D. 'Load * From_Field (s.\userfiles\, 'data*.txt') (ansi, txt, delimiter is '\t', embedded labels);'
  C. 'Load * From [s.\userfiles\data*.txt] (ansi, txt, delimiter is '\t', embedded labels);'

• Question 47:

  How can a developer use QVD files to optimize reload performance?

  A. create an incremental load strategy that reduces the query selects against the source data
  B. decrease latency between the QlikView reload engine and the source data
  C. enable a direct interface between the database server memory and the QlikView server memory
  D. enable the binary load functionality and directly load files in binary from the hard disk into system memory
  A. create an incremental load strategy that reduces the query selects against the source data

• Question 48:

  How can a designer display the field selections that have been made within a chart caption?

  A. by inserting a Current selections box into the Text in Chart
  B. by using an expression with GetCurrentselections in the Window Title option on the General tab
  C. by using an expression with SET Analysis and the system Fields in the Title Text option on the Caption tab
  D. by selecting show Current selections on the Caption tab
  B. by using an expression with GetCurrentselections in the Window Title option on the General tab

• Question 49:

  What must a developer consider when loading a table after the section Access statement and before the section Applicationstatement?

  A. All field names must start with a $ sign.
  B. All field names must be written in uppercase.
  C. The field Access must be the first field loaded.
  D. The fields Access, User, and Password must be loaded.
  B. All field names must be written in uppercase.

• Question 50:

  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
  C. trigger. OnOpen; action. select in Field