We're so confident of our products that we provide no hassle product exchange.
QlikView 11 Developer Certification Examination Sample Questions:
1. Refer to the exhibit to the right.
When a customer reloads the script displayed in the exhibit, it fails to respond and complete, and displays an error message.
OBJECT OUT OF MEMORY.
How should the developer resolve the logic error in the script?
A) change the Left Join command to include the name of the table being joined enclosed in parentheses
B) change the QUALIFY * command to list out only the fields that need to be qualified
C) change the DepartmentID field in the SalesPerson table to match the qualified field name of DepartmentID in the Department table
D) change the script to use an Inner Join instead of Left Join
2. A customer needs an application to reload in a short time period. The source tables are log files that are appended to on a daily basis.
Which performance tuning option should a developer use?
A) the Partial Reload command with the append option
B) the QVD files to store the source tables
C) the Load prefix Buffer with the incremental option
D) the Load prefix Buffer and set the Keep Outdated QVD Buffers in the Document Properties
3. A customer specified that the QlikView application should be designed to fit a screen resolution of 1280 x 800 as a standard.
Which option will assist a designer while creating the user interface?
A) Go to Settings menu > User Preferences > Design Tab and select 1280 x 800
B) Go to View menu > Resize Window > 1280 x 800
C) Go to View menu > Fit Zoom to Window > 1280 x 800
D) Go to Settings menu > User Preferences > Design Tab and select Display Grid Lines
4. In which two places in the Chart Properties of a Gauge can expressions be entered?
(Choose two.)
A) X and Y position of the object
B) Calculation Condition of the object
C) Number of major/minor units for the scale
D) Auto Minimize of the object
E) Show Condition of the object
5. A developer needs to load data for products from a database table and a text file. The database table and text file can be joined by the field ProductID.
The database table contains the master list of all available products. The text file contains additional data fields, but not for all products.
The developer loads the data from the database table first.
The developer needs to load the additional data fields from the text file into the existing table. The resulting table needs to contain the master list of all available products.
Which type of join should the developer use when loading the text file?
A) Right Join
B) Outer Join
C) Inner Join
D) Left Join
Solutions:
| Question # 1 Answer: B | Question # 2 Answer: C | Question # 3 Answer: B | Question # 4 Answer: B,E | Question # 5 Answer: D |
By Isidore
