Summer Sale - Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: dpt65

QSDA2019 Questions and Answers

Note! Following QSDA2019 Exam is Retired now. Please select the alternative replacement for your Exam Certification. The new exam code is QSDA2021

QSDA2019 Questions and Answers

Question # 6

A data architect needs to create an app to analyze 30-day re-admissions at a hospital.

• The medical record system does NOT calculate re-admission data

• The business rule to follow: if a patient is admitted to a hospital within 30 days after being discharged from a previous hospital stay, that event should be captured in the app with a flag called "30-day Re-admission"

• Data being used from the patient record includes hospital account ID, patient ID, admission dater and discharge date

Which action should the data architect perform first to meet these requirements?

A.

Sequence patient records by hospital account ID and patient ID using the Peek function

B.

Sequence patient records by patient ID using the Peek function

C.

Calculate the days since previous discharge using admission date and discharge date

D.

Order patient records by patient ID and admission date

Full Access
Question # 7

Refer to the exhibit.

Refer to the exhibits.

While using an app, the users report that some Sales Reps do NOT have personal details, like Division or Address Number A data architect has been called in to investigate.

The data architect uses the data model viewer to determine the relationship between the SalesRepMaster and CustomerMaster tables.

What is the cause of the issue?

A.

26 values for Sales Rep are null in CustomerMaster

B.

40.7% of the Sales Rep have CustomerMaster information

C.

59.3% of the Sales Rep have CustomerMaster information

D.

Density is 100% while Total Distinct and Present Distinct are NOT the same

Full Access