Online Access Free QSDA2019 Practice Test

Refer to the exhibit.

The data architect needs to create a KPI that displays the average amount of orders per customer. This aggregated field should be added to the existing orders table Which script should the data architect use?
A)

B)

C)

D)

• A.Option D
• B.Option A
• C.Option C
• D.Option B

A data architect needs to load data from two different databases. Additional data will be added from a folder that contains QVDs, text files, and Excel files. What is the minimum number of data connections required?

• A.Five
• B.Two
• C.Three
• D.Four

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 dateWhich action should the data architect perform first to meet these requirements?

• A.Calculate the days since previous discharge using admission date and discharge date
• B.Order patient records by patient ID and admission date
• C.Sequence patient records by hospital account ID and patient ID using the Peek function
• D.Sequence patient records by patient ID using the Peek function

A data architect plans to build an app that contains geographically diverse data that must be specific to user run-time selections. The source contains transactional data.
The app must have minimal impact on already limited server resources.
Which approach should the data architect use?

• A.QVDs
• B.Loop and Reduce
• C.In-memory
• D.ODAG

Refer to the exhibit.

A data architect is loading the tables and a synthetic key is generated.
How should the data architect resolve the synthetic key?

• A.Create a composite key using OrderlD and LineNo, and remove OrderlD and LineNo from Shipments
• B.Create a composite key using OrderlD and LineNo
• C.Remove the LineNo field from Shipments and use the AutoNumber function on the OrderlD field
• D.Remove the LineNo field from both tables and use the AutoNumber function on the OrderlD field