ExamTopics Logo
Mail Us[email protected]
Menu
Amazon Discussions
exam questions

Exam AWS Certified Database - Specialty All Questions

View all questions & answers for the AWS Certified Database - Specialty exam
Go to Exam

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 Hide 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

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Sab
Highly Voted 2 years, 5 months ago
Answer D https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/PostgreSQL_pg_cron.html
upvoted 6 times
Mintwater
2 years, 1 month 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, 1 month ago
Selected Answer: B
they need new production other than posgre
upvoted 1 times
...
MultiAZ
1 year, 4 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, 7 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
...
parle101
2 years, 4 months ago
Selected Answer: D
Ans: D I check for the closest answers and then research on my own. That way I get a chance to figure which answer is right and why.
upvoted 4 times
...
lollyj
2 years, 5 months ago
I'm confused. What's the correct answer? Sorry I'm new to this site. My answer was C but it says "Suggested Answer" smh
upvoted 1 times
khun
2 years, 5 months ago
Most of the time community answers are the correct ones.
upvoted 2 times
...
...
Mardoyyy
2 years, 5 months ago
Selected Answer: D
Answer D
upvoted 4 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago