DEA-C01 · Question #156
DEA-C01 Question #156: Real Exam Question with Answer & Explanation
Sign in or unlock DEA-C01 to reveal the answer and full explanation for question #156. The question stem and answer options stay visible for context.
Question
A company is building a data lake for a new analytics team. The company is using Amazon S3 for storage and Amazon Athena for query analysis. All data that is in Amazon S3 is in Apache Parquet format. The company is running a new Oracle database as a source system in the company's data center. The company has 70 tables in the Oracle database. All the tables have primary keys. Data can occasionally change in the source system. The company wants to ingest the tables every day into the data lake. Which solution will meet this requirement with the LEAST effort?
Options
- ACreate an Apache Sqoop job in Amazon EMR to read the data from the Oracle database.
- BCreate an AWS Glue connection to the Oracle database. Create an AWS Glue bookmark job to
- CCreate an AWS Database Migration Service (AWS DMS) task for ongoing replication. Set the
- DCreate an Oracle database in Amazon RDS. Use AWS Database Migration Service (AWS DMS)
Unlock DEA-C01 to see the answer
You've previewed enough free DEA-C01 questions. Unlock DEA-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.