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(PatientlD)
D. Load all three tables, create a copy of PatientID in the lab orders table as LabPatientID, and use Count(LabPatientlD)
Answer:A
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(PatientlD) D. Load all three tables, create a copy of PatientID in the lab orders table as LabPatientID, and use Count(LabPatientlD)