Exam AWS Certified Database - Specialty topic 1 question 273 discussion

Exam question from Amazon's AWS Certified Database - Specialty

Question #: 273
Topic #: 1

[All AWS Certified Database - Specialty Questions]

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?

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

Show Suggested Answer

Suggested Answer: D 🗳️

by Sab at Dec. 1, 2022, 9:42 p.m.

Disclaimers:

- ExamTopics 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.

Comments

Submit Cancel

Sab

Highly Voted 2 years, 7 months ago

Answer D https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/PostgreSQL_pg_cron.html

upvoted 6 times

Mintwater

2 years, 3 months ago

D pg_cron is a simple cron-based job scheduler for PostgreSQL (10 or higher) that runs inside the database as an extension. It uses the same syntax as regular cron, but it allows you to schedule PostgreSQL commands directly from the database. You can also use '[1-59] seconds' to schedule a job based on an interval. https://github.com/citusdata/pg_cron

upvoted 2 times

...

marcoforexam

Most Recent 1 year, 3 months ago

Selected Answer: B

they need new production other than posgre

upvoted 1 times

...

MultiAZ

1 year, 5 months ago

B Lambda can run for only 15 minutes. Batch and StepFunctions are better fit for long-running tasks. PG_CRON will also work, but only within the scope of the database. Batch and StepFunctions are more flexible as this will allow orchestration of multiple steps, in and outside the DB

upvoted 2 times

...

Germaneli

1 year, 9 months ago

Why wouldn't you use AWS Batch with Step Functions for long-running tasks (B)? It's not too straightforward but a valid option? Why do you have to revert to the pg_cron package (D) when there're AWS options? https://hands-on.cloud/aws-step-functions-long-running-tasks/#:~:text=Long-Running%20Jobs%20In%20AWS%20Cloud,-There're%20multiple&text=AWS%20Batch%20is%20used%20for,can%20do%20a%20bit%20more.

upvoted 3 times

...