Câu 13: QSDA2018: Qlik Sense Data Architect Certification Exam

Refer to the exhibit. A major healthcare organization requests a new app with the following requirements: ✑ Users can filter AdmissionDate and DischargeDate by all fields in the master Calendar table ✑ Use an existing QVD file, which includes dates 20 years into the future ✑ Users should not be able to filter on dates that have no associated encountersWhich approach should the data architect take to meet these requirements?

1. A. 1. Load the Encounters table 2. Perform a Left Join Load on the Encounters table to the master calendar and alias the date fields appropriately for the Admission Date 3. Perform a Left Join Load on the Encounters table to the master calendar and alias the date fields appropriately for the Discharge Date
2. B. 1. Load the master calendar 2. Create two mapping tables called AdmissionCalendar and DischargeCalendar from the Resident master calendar that has all fields appropriately named 3. Load the Encounters and use ApplyMap for the AdmissionDate and DischangeDate appropriately. — đáp án hiện tại
3. C. 1. Load the Master Calendar and Encounters tables. 2. Perform a Join Load on the Encounters table to the Resident master calendar and alias the date fields appropriately for the Admission Date 3. Perform a Join Load on the Encounters table to the Resident master calendar and alias the date fields appropriately for the Discharge Date
4. D. 1. Load the master calendar as AdmissionCalendar and alias the fields to reflect they are for Admission 2. Load the master calendar as Discharge Calendar and alias the fields to reflect they are for Discharge 3. Load the Encounters table