We're so confident of our products that we provide no hassle product exchange.
QlikView 11 Developer Certification Examination Sample Questions:
1. A Straight Table Chart calculates several metrics for each individual alphanumeric transaction detail record (TRAN_ID) and its Amount over several years of data. The calculation time for the chart is over two minutes.
How can a designer decrease the calculation time for the chart without compromising core functionality?
A) create a Calculation Condition. =count(TRAN_ID) <= 10000
B) create a Calculation Condition. =TRAN_ID < 10000
C) create a Calculation Condition. =sum(Amount) > 0
D) create a Calculation Condition. =sum(TRAN_ID) <= 10000
2. A customer has an Actual Sales fact table aggregated at the transactional level and a
Budgeted Sales fact table aggregated at the monthly level. The tables share many of the same dimensional fields.
How can a developer form the data model?
A) create a link table containing the dimensional fields then link each fact table using a concatenated key
B) concatenate Load the Budgeted Sales table into the Actual Sales table loading shared fields as NULL
C) qualify both tables and Unqualify all shared fields
D) left join the Budgeted Sales table onto the fact table using Month as the key
3. A customer with a complex chart is experiencing performance issues when the organization's users view the chart without first applying several filters.
A designer needs to place a restriction on the chart so that the users are forced to make a selection before QlikView will calculate and render the chart.
Which common object property can the designer use to accomplish this?
A) the Calculate Condition property on the General tab to create a control condition that will keep the chart from calculating until user has filtered the data
B) the Auto Minimize property on the Caption tab so that the chart will be minimized and not calculate or render until the user has first made a selection and restored the chart
C) the Help Text property on the Caption tab to enter instructions directing the user to make a selection and filter their data before performing their analysis
D) the Size to Data property on the Layout tab to automatically size the filter criteria to the chart
4. 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 DepartmentID field in the SalesPerson table to match the qualified field name of DepartmentID in the Department table
B) change the QUALIFY * command to list out only the fields that need to be qualified
C) change the script to use an Inner Join instead of Left Join
D) change the Left Join command to include the name of the table being joined enclosed in parentheses
5. When should a developer create a new tab in the Load Script?
A) when portions of script are logically related
B) when entering Edit Script for the first time
C) when the tab is marked with the ///tab$ statement
D) when the critical number of 255 lines per tab has been exceeded
Solutions:
| Question # 1 Answer: A | Question # 2 Answer: A | Question # 3 Answer: A | Question # 4 Answer: B | Question # 5 Answer: A |
By Felix
