A company currently has an application that writes data onto AWS RDS-MySQL. They want to push data on a daily basis to archive records from MySQL tables to S3 for future analysis. How can you accomplish this in the easiest way?

Answer options:

A.Create an S3 event to ingest the data from the MySQL table
B.Use the AWS DataPipeline service and run a job on a daily basis
C.Create an EMR Cluster which will run a MapReduce job
D.Use the database migration service to transfer the data

Answer – B
A sample of this is given in the AWS Documentation
#######
Export MySQL Data to Amazon S3 Using AWS Data Pipeline
This tutorial walks you through the process of creating a data pipeline to copy data (rows) from a table in MySQL database to a CSV (comma-separated values) file in an Amazon S3 bucket and then sending an Amazon SNS notification after the copy activity completes successfully. You will use an EC2 instance provided by AWS Data Pipeline for this copy activity.
#######
Option A is incorrect since the events can only trigger an event but not directly be used to ingest data
Option C is incorrect since this would be not be cost effective option just to try to ingest data
Option D is incorrect since the database migration service should ideally be used for a one time activity
For more information on this tutorial, please visit the url
https://docs.aws.amazon.com/datapipeline/latest/DeveloperGuide/dp-copydata-mysql.html