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

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?

1. A. load the Actuals table, and when loading the Budgets table, use Outer Join to join the BudgetAmount field to the Actuals table
2. B. load the Actuals table, and when loading the Budgets table, rename fields Year and Month to BudgetYear and BudgetMonth
3. C. load the Actuals table, and when loading the Budgets table, use the Concatenate function to append the Budgets table to the Actuals table — đáp án hiện tại
4. 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