How can the Database Specialist schedule these jobs so the setup requires minimal maintenance and provides high availability?

A Database Specialist has migrated an on-premises Oracle database to Amazon Aurora PostgreSQL. The schema and the data have been migrated successfully. The on-premises database server was also being used to run database maintenance cron jobs written in Python to perform tasks including data purging and generating data exports. The logs for these jobs show that, most of the time, the jobs completed within 5 minutes, but a few jobs took up to 10 minutes to complete. These maintenance jobs need to be set up for Aurora PostgreSQL.

How can the Database Specialist schedule these jobs so the setup requires minimal maintenance and provides high availability?
A . Create cron jobs on an Amazon EC2 instance to run the maintenance jobs following the required schedule.
B . Connect to the Aurora host and create cron jobs to run the maintenance jobs following the required schedule.
C . Create AWS Lambda functions to run the maintenance jobs and schedule them with Amazon CloudWatch Events.
D . Create the maintenance job using the Amazon CloudWatch job scheduling plugin.

View Answer

Answer: C

Explanation:

https://docs.aws.amazon.com/AmazonCloudWatch/latest/events/Create-CloudWatch-Events-Scheduled-Rule.html

https://docs.aws.amazon.com/prescriptive-guidance/latest/patterns/schedule-jobs-for-amazon-rds-and-aurora-postgresql-using-lambda-and-secrets-manager.html

a job for data extraction or a job for data purging can easily be scheduled using cron. For these jobs, database credentials are typically either hard-coded or stored in a properties file. However, when you migrate to Amazon Relational Database Service (Amazon RDS) or Amazon Aurora PostgreSQL, you lose the ability to log in to the host instance to schedule cron jobs. This pattern describes how to use AWS Lambda and AWS Secrets Manager to schedule jobs for Amazon RDS and Aurora PostgreSQL databases after migration.

https://docs.aws.amazon.com/AmazonCloudWatch/latest/events/RunLambdaSchedule.html