AWS Certified Data Analytics – Specialty — Question 35

A company is building a data lake and needs to ingest data from a relational database that has time-series data. The company wants to use managed services to accomplish this. The process needs to be scheduled daily and bring incremental data only from the source into Amazon S3.
What is the MOST cost-effective approach to meet these requirements?

Answer options

• A. Use AWS Glue to connect to the data source using JDBC Drivers. Ingest incremental records only using job bookmarks.
• B. Use AWS Glue to connect to the data source using JDBC Drivers. Store the last updated key in an Amazon DynamoDB table and ingest the data using the updated key as a filter.
• C. Use AWS Glue to connect to the data source using JDBC Drivers and ingest the entire dataset. Use appropriate Apache Spark libraries to compare the dataset, and find the delta.
• D. Use AWS Glue to connect to the data source using JDBC Drivers and ingest the full data. Use AWS DataSync to ensure the delta only is written into Amazon S3.

Correct answer: A

Explanation

Option A is the most cost-effective choice because it leverages job bookmarks in AWS Glue to efficiently track and ingest only the incremental changes. Option B introduces additional complexity and potential costs by involving DynamoDB. Option C requires processing the entire dataset, which is inefficient and more expensive. Similarly, option D unnecessarily ingests all data before filtering, making it less cost-effective than option A.