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?

• A. keep the four transaction tables separate and qualify the names to control correct linkage
• B. concatenate the four transaction tables and add a summary table with pre-calculated counts, totals, and averages
• C. concatenate the four transaction tables and add fields to identify the record type and count flag
• D. build a Link Table to connect the four transaction tables and add a summary table with pre-calculated counts, totals, and averages
• E. build a Link Table to connect the four transaction tables and alias fields that must be kept in their respective table

How can a developer use QVD files to optimize reload performance?

• A. enable a direct interface between the database server memory and the QlikView server memory
• B. create an incremental load strategy that reduces the query sizes against the source data
• C. enable the binary load functionality and directly load files in binary from the hard disk into system memory
• D. decrease latency between the QlikView reload engine and the source data

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. load the Actuals table, and when loading the Budgets table, use Outer Join to join the BudgetAmount field to the Actuals table
• B. load the Actuals table, and when loading the Budgets table, use the Concatenate function to append the Budgets table to the Actuals table
• C. load the Actuals table, and when loading the Budgets table, rename fields Year and Month to BudgetYear and BudgetMonth
• D. create a concatenated key of Product-Year-Month in both the Budgets and Actuals table and comment out the individual fields in the Budgets table

A customer who operates a large national sales organization needs to divide a Sales.qvw document into region-specific documents using the Region field (North, South, East, and West).
Each region should have access to region-specific data.
Which instruction should a developer give to the Server/Publisher administrator to meet the customer's needs?

• A. create four QlikView Server tasks to reload data from the Sales.qvw document with data only for each region and distribute to region-specific folders with appropriate file permissions
• B. create a QlikView Publisher task to reduce the Sales.qvw document based on the Region field and distribute to region-specific folders with appropriate file permissions
• C. create a QlikView Server task to reduce the Sales.qvw document based on the Region field and distribute to region-specific folders with appropriate file permissions
• D. create a QlikView Publisher task to reduce data from the Sales.qvw document to create four QVX files with data only for each region and distribute to region-specific folders with appropriate file permissions