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 40 discussion

Exam question from Amazon's AWS Certified Database - Specialty
Question #: 40
Topic #: 1
[All AWS Certified Database - Specialty Questions]

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.
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️
by [deleted] at July 13, 2020, 5:48 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
Mickysingh
Highly Voted 3 years, 8 months ago
Answer should be C but below link confuses 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. it confirms that answer is C
upvoted 13 times
BillyMadison
3 years, 8 months ago
I agree with C via your second link: https://docs.aws.amazon.com/prescriptive-guidance/latest/patterns/schedule-jobs-for-amazon-rds-and-aurora-postgresql-using-lambda-and-secrets-manager.html
upvoted 3 times
...
waterh30
3 years, 8 months ago
https://medium.com/better-programming/cron-job-patterns-in-aws-126fbf54a276
upvoted 2 times
...
...
Pranava_GCP
Most Recent 1 year, 9 months ago
Selected Answer: C
C. Create AWS Lambda functions to run the maintenance jobs and schedule them with Amazon CloudWatch Events.
upvoted 1 times
...
IhorK
1 year, 10 months ago
Selected Answer: C
- You can also use CloudWatch Events to schedule automated actions that self-initiate at certain times using cron or rate expressions. - Lambda supports Python. - CloudWatch Events can call Lambda functions. - Less then 15 min job. https://docs.aws.amazon.com/prescriptive-guidance/latest/patterns/schedule-jobs-for-amazon-rds-for-postgresql-and-aurora-postgresql-by-using-lambda-and-secrets-manager.html
upvoted 2 times
...
RotterDam
3 years, 3 months ago
Selected Answer: C
C. Whenever its asked to create Cron Jobs Lambda vs EC2 : Its ALWAYS Lambda!!
upvoted 4 times
im_not_robot
2 years, 4 months ago
It depends on how long the job run. Because lambda has 15 minutes limitation. If the job needs more than 15 minutes to run, then can consider AWS Batch, ECS, EC2
upvoted 2 times
...
...
GMartinelli
3 years, 6 months ago
Selected Answer: C
Option C
upvoted 1 times
...
guru_ji
3 years, 7 months ago
Correct Answer ==>> C
upvoted 2 times
...
ChauPhan
3 years, 7 months ago
C is correct. A B is not HA. D, there is no such maintenance JOB for CW Events. CW Events has to trigger the other functions (Lambda/SSM/Step Function/ Batch) to do the task.
upvoted 1 times
guru_ji
3 years, 7 months ago
Correct Answer: C
upvoted 1 times
...
...
Dip11
3 years, 7 months ago
Answer should be C. I don't think there is anything like CloudWatch job scheduling plugin. Internet search doesn't show anything like this.
upvoted 2 times
...
LMax
3 years, 7 months ago
Agree with Answer C
upvoted 2 times
...
LMax
3 years, 8 months ago
Agree with Answer C
upvoted 2 times
...
Windy
3 years, 8 months ago
C for me
upvoted 1 times
...
myutran
3 years, 8 months ago
Ans: C
upvoted 2 times
...
JobinAkaJoe
3 years, 8 months ago
C is the best answer. Eventbridge would have been a better choice to schedule lambda. https://docs.aws.amazon.com/AmazonCloudWatch/latest/events/RunLambdaSchedule.html
upvoted 2 times
...
Ashoks
3 years, 8 months ago
Ans is C. CloudWatch scheduling and Lambda execution and this option should be fine as long as job completes within 15 minutes.
upvoted 4 times
...
BillyC
3 years, 8 months ago
Answer should be C
upvoted 4 times
...
[Removed]
3 years, 8 months ago
The document referenced has no mention of job scheduling plugin for cloudwatch.... it is for systems manager. I will have to go with C.
upvoted 2 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