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?

Question

Accepted Answer

D. Turn on the pg_cron extension in the Aurora PostgreSOL database and schedule the database

Answer

A. Configure an Amazon EC2 instance to run on a schedule to initiate database maintenance jobs

Answer

B. Configure AWS Batch with AWS Step Functions to schedule long-running database maintenance

Answer

C. Create an Amazon EventBridae (Amazon CloudWatch Events) rule with AWS Lambda that runs

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…

Question

Options

How the community answered

Explanation

Topics

Community Discussion