Exit QV_DEVELOPER_01 QlikView 11 Developer Certification
Question 5 of 5
0% complete
Q5 Single choice

A customer has an Actual sales fact table aggregated at the transactional level and a Budgeted 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?

  • A

    qualify both tables and Unqualify all shared fields

  • B

    left join the Budgeted sales table onto the fact table using Month as the key

  • C

    concatenate Load the Budgeted sales table into the Actual sales table loading shared fields as NULL

  • D

    create a link table containing the dimensional fields then link each fact table using a concatenated key

Previous Save & finish