You work as a machine learning specialist for a book publishing company. Your company has several publishing data stores housed in relational databases across its infrastructure. Your company recently purchased another publishing company and is in the process of merging the two company’s systems infrastructure. A part of this merger activity is joining the two publisher book databases. Your team has been given the assignment to build a data lake sourced from the two company’s relational data stores.
How would you construct an ETL pipeline to achieve this goal? (Select FOUR)

Answer options:

A.Use AWS DataSync to ingest the relational data from your book data stores and store it in S3.
B.Use an AWS Glue crawler to build your AWS Glue catalog.
C.Have a lambda function triggered by an S3 trigger to start your AWS Glue crawler.
D.Use an AWS SageMaker trigger to start your AWS Glue ETL job that processes/transforms your data and places it into your S3 data lake.
E.Use a lambda function triggered by a CloudWatch event trigger to start your AWS Glue ETL job that processes/transforms your data and places it into your S3 data lake.
F.Use AWS Database Migration Service to ingest the relational data from your book data stores and store it in S3.

Answers: B, C, E, F
Option A is incorrect. AWS DataSync is used to ingest data from a Network File System (NFS), not relational databases.
Option B is correct. Once your data has been ingested from your databases, you need to catalog the data using an AWS Glue crawler.
Option C is correct. The AWS Glue crawler can be started by a lambda function that is triggered by an S3 object create event.
Option D is incorrect. There is no SageMaker trigger service.
Option E is correct. You can have your AWS Glue ETL job started by a lambda function that is triggered by a CloudWatch event trigger.
Option F is correct. You can use the AWS Database Migration Service to ingest your data from your relational databases and then store the data in an S3 bucket.
Reference:
Please see the AWS Big Data blog titled Build and automate a serverless data lake using an AWS Glue trigger for the Data Catalog and ETL jobs, and the AWS article titled How can I automatically start an AWS Glue job when a crawler run completes?
Here is a diagram representing the proposed solution: