Free QV_DEVELOPER_01 Exam Braindumps
QlikView 11 Developer Certification Examination Questions 16–20 (page: 5)

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?

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?

Refer to the exhibit.

A customer needs to analyze transactions across the Dimensions and Metrics identified below.
Required Dimensions.
Project ID
Month
Year
Account ID
Transaction Type
Client ID
Required Metrics.
Number of transactions
Total Amount
Total Cost
Average Amount
Average Cost
Which approach will provide the most effective QlikView data model to meet the customer's requirements while optimizing performance and maintaining accuracy?

Refer to the exhibit to the right.


A customer has aggregated budgets for products by year and month. Actual data is stored at a more detailed transaction level and so a one-to-many relationship exists between the Budgets to Actuals table.
Budgets have been assigned for all months of the current year, but there are only transactions up to the current month of October. There are transactions for products that were not assigned budgets.
How can a developer remove the synthetic key automatically generated by QlikView and be able to analyze budgets and actuals by product, month, and year?

A developer needs to add data from a Microsoft Access database to a data model intended to run on a 64 bit Windows Server.
How should the developer proceed?