Download QlikView 11 Developer Certification Examination (qv_developer_01).QV-DEVELOPER-01.SelfTestEngine.2018-09-07.40q.vcex

ProfExam Suite - Black Friday
Vendor: QlikView
Exam Code: QV-DEVELOPER-01
Exam Name: QlikView 11 Developer Certification Examination (qv_developer_01)
Date: Sep 07, 2018
File Size: 2 MB
Download Exam

How to open VCEX files?

Files with VCEX extension can be opened by ProfExam Simulator.

Download
ProfExam Simulator

Purchase
Coupon: EXAM_HUB

Discount: 20%

ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator

Demo Questions

Question 1
Refer to the exhibit to the right.  
    
A customer needs the data displayed in the exhibit loaded into QlikView for analysis.  
The data is stored in a flat file and new rows are appended daily.  
Which two data quality issues will a developer have to resolve? (Choose two.)  
  1. the Transaction ID field name contains a space
  2. one or more Product field values contain spaces
  3. the Date field values contain special characters
  4. one or more header rows are included in the file data
  5. one or more Product field values contain the file delimiter
  6. the Date field name is also a function name and is a reserved word
Correct answer: DE
Question 2
Refer to the exhibit to the right and the Load Script provided below.  
Exhibit.  
    
LOAD ItemID, 
LocationID, 
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?
  1. NULL
  2. 1; 2; 3
  3. 1100; 1300; 2210; 2250; 3125; 3130; 3120
  4. 1,100; 1,300; 2,210; 2,250; 3,125; 3,130; 3,120
Correct answer: B
Question 3
A customer has a set of date values in different formats.  
Some dates are in Julian date format; some dates are text strings.  
How can a developer ensure the data is loaded in a consistent format?
  1. change the default DateFormat variable assignment on the Main script tab
  2. use the Date function to format the field during load
  3. use the Alt function with different Date# functions
  4. use the Lookup function with a format table
Correct answer: C
Question 4
Which statement describes a required field characteristic that will ensure QlikView associations across multiple tables?  
  1. The field formats (such as numeric or string) must be the same in the original data sources.
  2. The fields must be defined as primary or foreign keys in the original data sources.
  3. The fields must be aliased to the same name when loading into QlikView.
  4. The number of distinct values in each field must be the same.
Correct answer: C
Question 5
Which action should a developer perform on a table to reduce required memory and optimize the application?
  1. convert numeric fields into text fields using the Text function
  2. combine multiple fields into one complex field, reducing the number of fields per table
  3. make all numeric fields a fixed length by left padding with leading 0's using the Num function
  4. split out a single complex field into multiple fields reducing the number of distinct values per field
Correct answer: D
Question 6
Refer to the exhibit to the right.  
    
What is the primary key of ACCOUNT_TRANS?
  1. ACCOUNT_ID
  2. TRANS_SEQ
  3. ACCOUNT_ID and TRANS_SEQ
  4. ACCOUNT_ID, TRANS_SEQ, and TRANS_TYPE
Correct answer: C
Question 7
Refer to the exhibit to the right.  
    
What is the cardinality of the relationship between CUSTOMER and ACCOUNT?
  1. many-to-many
  2. one-to-many
  3. one-to-none
  4. one-to-one
Correct answer: A
Question 8
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?  
  1. The snowflake schema has been transformed into a de-normalized schema.
  2. The snowflake schema has been transformed into a normalized schema.
  3. The star schema has been transformed into a de-normalized schema.
  4. The star schema has been transformed into a normalized schema.
Correct answer: A
Question 9
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?
  1. There will be a relationship between all the tables without synthetic key tables or loosely coupled tables.
  2. There will be a relationship between four of the five tables and one table will be a data island.
  3. There will be a synthetic key table in the data model.
  4. There will be loosely coupled tables in the data model.
Correct answer: D
Question 10
A client has a data set with two tables.  
The Customer table has fields CustomerID, AssignedTo, FirstName, and LastName. The Orders table has fields CustomerID, 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? 
  1. load the tables leaving the automatic associations
  2. comment out the AssignedTo from the Orders table
  3. comment out the AssignedTo from the Customer table
  4. use Rename Field syntax to alias one of the AssignedTo fields
  5. create a concatenated key of CustomerID and AssignedTo in both tables
Correct answer: D
CONNECT US
HOW TO OPEN VCE FILES

Use VCE Exam Simulator to open VCE files
Avanaset

HOW TO OPEN VCEX AND EXAM FILES

Use ProfExam Simulator to open VCEX and EXAM files
ProfExam Screen

ProfExam
ProfExam at a 20% markdown

You have the opportunity to purchase ProfExam at a 20% reduced price

Get Now!