Exit QSDA2022 Qlik Sense Data Architect Certification - 2022
Question 5 of 5
0% complete
Q5 Single choice

Refer to the exhibit

A data architect is working on an app that contains orders, invoices, and shipping data. There are three different date fields within the data:

* OrderDate

* InvoiceDate

* ShippingDate

The business analyst needs to replicate the chart above to show Order and Shipping amounts on the same Month axis.

What should the data architect do?

  • A

    Create a Month field for each of the three dates in the fact table and use that in the chart

  • B

    Load the key field and the three date fields into a concatenated bridge table that contains KeyField and Date

  • C

    Left Join the three date fields onto one bridge table using the key field containing KeyField and Date