A healthcare organization needs an app to track patient encounters, patient lab orders, and patient medications.
– Encounters, lab orders, and medication data are maintained in three separate tables linked by PatientID
– PatientID values in all three tables are completely accurate
– Patients may have encounters without lab orders or medications
The data architect needs to make sure that the count of patient lab orders is correct.
Which method should the data architect to meet this requirement?
A . Load all three tables, create a copy of PatientID in the lab orders table as LabPatientID, and use Count (Distinct LabPatientID)
B . load all three tables and use Count(Distinct PatientID)
C . load all three tables and use Count(PatientID)
D . Load all three tables, create a copy of PatientID in the lab orders table as LabPatientID, and use count (LabPatientID)
Answer: D