Exam AWS Certified Data Engineer - Associate DEA-C01 topic 1 question 146 discussion

Exam question from Amazon's AWS Certified Data Engineer - Associate DEA-C01

Question #: 146
Topic #: 1

[All AWS Certified Data Engineer - Associate DEA-C01 Questions]

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?

A. Create an Apache Sqoop job in Amazon EMR to read the data from the Oracle database. Configure the Sqoop job to write the data to Amazon S3 in Parquet format.
B. Create an AWS Glue connection to the Oracle database. Create an AWS Glue bookmark job to ingest the data incrementally and to write the data to Amazon S3 in Parquet format.
C. Create an AWS Database Migration Service (AWS DMS) task for ongoing replication. Set the Oracle database as the source. Set Amazon S3 as the target. Configure the task to write the data in Parquet format.
D. Create an Oracle database in Amazon RDS. Use AWS Database Migration Service (AWS DMS) to migrate the on-premises Oracle database to Amazon RDS. Configure triggers on the tables to invoke AWS Lambda functions to write changed records to Amazon S3 in Parquet format.

Show Suggested Answer

Suggested Answer: C 🗳️

by dashapetr at Sept. 5, 2024, 8:14 a.m.

Disclaimers:

- ExamTopics website is not related to, affiliated with, endorsed or authorized by Amazon.
- Trademarks, certification & product names are used for reference only and belong to Amazon.

Comments

Submit Cancel

dashapetr

Highly Voted 8 months ago

Selected Answer: C

C: You can use S3 as a target and configure files to be in Parquet format https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Target.S3.html

upvoted 8 times

...

michele_scar

Most Recent 5 months, 3 weeks ago

Selected Answer: C

A and D wrong. B also wrong because Bookmark is used to mantain files that you don't want to re-analyze in case of a re-run about a glue job.

upvoted 1 times

...

siheom

8 months ago

Selected Answer: B

VOTE B

upvoted 1 times

PashoQ

7 months, 2 weeks ago

You can no see any updates to the data after the records are ingested by Glue. B is not correct

upvoted 2 times

...

Exam AWS Certified Data Engineer - Associate DEA-C01 All Questions

View all questions & answers for the AWS Certified Data Engineer - Associate DEA-C01 exam