File Info
| Exam | QlikView 11 Developer Certification Examination (qv_developer_01) |
| Number | QV-DEVELOPER-01 |
| File Name | QlikView.QV-DEVELOPER-01.SelfTestEngine.2018-09-07.40q.tqb |
| Size | 2 MB |
| Posted | Sep 07, 2018 |
| Download | QlikView.QV-DEVELOPER-01.SelfTestEngine.2018-09-07.40q.tqb |
How to open VCEX & EXAM Files?
Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.
Coupon: MASTEREXAM
With discount: 20%
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.)
- the Transaction ID field name contains a space
- one or more Product field values contain spaces
- the Date field values contain special characters
- one or more header rows are included in the file data
- one or more Product field values contain the file delimiter
- 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?
- NULL
- 1; 2; 3
- 1100; 1300; 2210; 2250; 3125; 3130; 3120
- 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?
- change the default DateFormat variable assignment on the Main script tab
- use the Date function to format the field during load
- use the Alt function with different Date# functions
- use the Lookup function with a format table
Correct answer: C
