Which AWS service is the most cost-effective method to ingest incremental records from a relational database into Amazon S3?

Boost your AWS Data Analytics knowledge with flashcards and multiple choice questions, including hints and explanations. Prepare for success!

AWS Glue using job bookmarks is the most cost-effective method for ingesting incremental records from a relational database into Amazon S3 because it efficiently manages and tracks the state of data ingestion. Job bookmarks enable AWS Glue to recognize which records have already been processed in previous runs, thus only ingesting new or changed records during subsequent runs. This incremental approach minimizes the amount of data that needs to be moved, reducing both the data transfer costs and the computational resources required for processing.

Additionally, AWS Glue is a fully managed extract, transform, and load (ETL) service designed to simplify data preparation for analytics. It seamlessly integrates with Amazon S3, allowing you to easily write the ingested records to S3 storage in various formats. The combination of job bookmarks and Glue's ETL capabilities makes it particularly effective for use cases involving ongoing data ingestion from relational databases.

In contrast, while other services like Amazon Kinesis Data Streams can handle real-time data ingestion, they may not be as cost-effective for batch processing of incremental data. AWS DataSync is more suited for transferring large datasets between on-premises storage and AWS services, rather than specifically for incremental records from a relational database. DynamoDB, on the other hand, is a NoSQL database service that does

Subscribe

Get the latest from Examzify

You can unsubscribe at any time. Read our privacy policy