QV_Developer_01 Exam Dumps | Refer to the exhibit. (Exhibit) A customer needs to analyze transactions across the Dimensions and Metrics

<< Prev Question Next Question >>

Question 46/50

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. build a Link Table to connect the four transaction tables and add a summary table with pre-calculated counts, totals, and averages

B. concatenate the four transaction tables and add fields to identify the record type and count flag

C. concatenate the four transaction tables and add a summary table with pre-calculated counts, totals, and averages

D. keep the four transaction tables separate and qualify the names to control correct linkage

E. build a Link Table to connect the four transaction tables and alias fields that must be kept in their respective table

Question 46/50

LEAVE A REPLY

Download PDF File