DAS-C01 Question #4: Real Exam Question with Answer & Explanation

Question

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?

Options

• AUse AWS Glue to connect to the data source using JDBC Drivers.
• BUse AWS Glue to connect to the data source using JDBC Drivers.
• CUse AWS Glue to connect to the data source using JDBC Drivers and ingest the entire dataset.
• DUse AWS Glue to connect to the data source using JDBC Drivers and ingest the full data.

Explanation

To ingest incremental time-series data daily from a relational database into Amazon S3 using managed services cost-effectively, AWS Glue is the appropriate choice. AWS Glue ETL jobs can connect via JDBC and be configured to process only new data.

Common mistakes.

• B. This option is identical to option A and provides the same correct solution for ingesting incremental data from a relational database into Amazon S3 using AWS Glue's capabilities.
• C. Ingesting the entire dataset daily contradicts the requirement to 'bring incremental data only.' Processing the full dataset repeatedly is less efficient and more costly than an incremental approach, especially with time-series data that grows continuously.
• D. Ingesting the full data daily is explicitly against the requirement to load 'incremental data only.' This method would incur higher costs and processing overhead by repeatedly processing unchanged historical data, making it inefficient and not cost-effective.

Concept tested. Incremental data loading with AWS Glue for relational databases

Reference. https://docs.aws.amazon.com/glue/latest/dg/monitor-exceptions-jobs.html

No community discussion yet for this question.