DAS-C01 · Question #146
A hospital uses an electronic health records (EHR) system to collect two types of data. - Patient information, which includes a patient's name and address - Diagnostic tests conducted and the results
Sign in or unlock DAS-C01 to reveal the answer and full explanation for question #146. The question stem and answer options stay visible for context.
Question
A hospital uses an electronic health records (EHR) system to collect two types of data.
- Patient information, which includes a patient's name and address
- Diagnostic tests conducted and the results of these tests Patient information is expected to
change periodically Existing diagnostic test data never changes and only new records are added. The hospital runs an Amazon Redshift cluster with four dc2.large nodes and wants to automate the ingestion of the patient information and diagnostic test data into respective Amazon Redshift tables for analysis. The EHR system exports data as CSV files to an Amazon S3 bucket on a daily basis. Two sets of CSV files are generated. One set of files is for patient information with updates, deletes, and inserts. The other set of files is for new diagnostic test data only. What is the MOST cost-effective solution to meet these requirements?
Options
- AUse Amazon EMR with Apache Hudi.
- BUse an AWS Glue crawler to catalog the data in Amazon S3
- CUse an AWS Lambda function to run a COPY command that appends new diagnostic test data to
- DUse AWS Database Migration Service (AWS DMS) to collect and process change data capture
Unlock DAS-C01 to see the answer
You've previewed enough free DAS-C01 questions. Unlock DAS-C01 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.