Câu 18: QV-DEVELOPER-01: QlikView 11 Developer Certification Examination (qv_developer_01)

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?

1. A. build a Link Table to connect the four transaction tables and add a summary table with pre-calculated counts, totals, and averages
2. B. build a Link Table to connect the four transaction tables and alias fields that must be kept in their respective table
3. C. concatenate the four transaction tables and add a summary table with pre-calculated counts, totals, and averages
4. D. concatenate the four transaction tables and add fields to identify the record type and count flag — đáp án hiện tại
5. E. keep the four transaction tables separate and qualify the names to control correct linkage