QlikView QV-Developer-01 Exam Practice Questions (P. 4)

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?