An online bookstore recently migrated its database from on-premises Oracle to Amazon Aurora PostgreSQL 13. The bookstore uses scheduled jobs to run customized SQL scripts to administer the Oracle database, running hours-long maintenance tasks, such as partition maintenance and statistics gathering. The bookstore’s application team has reached out to a database specialist seeking an ideal replacement for scheduling jobs with Aurora PostgreSQL. What should the database specialist implement to meet these requirements with MINIMAL operational overhead?

Topic #: - All AWS Certified Database - Specialty Questions

A. Configure an Amazon EC2 instance to run on a schedule to initiate database maintenance jobs
B. Configure AWS Batch with AWS Step Functions to schedule long-running database maintenance tasks
C. Create an Amazon EventBridae (Amazon CloudWatch Events) rule with AWS Lambda that runs on a schedule to initiate database maintenance jobs
D. Turn on the pg_cron extension in the Aurora PostgreSOL database and schedule the database maintenance tasks by using the cron.schedule function

- Awsexamhub website is not related to, affiliated with, endorsed or authorized by Amazon.
- Trademarks, certification & product names are used for reference only and belong to Amazon.

Suggested Answer:

Share this post

Join the Discussion