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

A customer has an Actual Sales fact table aggregated at the transactional level and aBudgeted Sales fact table aggregated at the monthly level. The tables share many of the same dimensional fields. How can a developer form the data model?

1. A. qualify both tables and Unqualify all shared fields
2. B. left join the Budgeted Sales table onto the fact table using Month as the key
3. C. concatenate Load the Budgeted Sales table into the Actual Sales table loading shared fields as NULL
4. D. create a link table containing the dimensional fields then link each fact table using a concatenated key — đáp án hiện tại