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

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

A company maintains several databases using Amazon RDS for MySQL and PostgreSQL. Each RDS database generates log files with retention periods set to their default values. The company has now mandated that database logs be maintained for up to 90 days in a centralized repository to facilitate real-time and after-the-fact analyses.
What should a Database Specialist do to meet these requirements with minimal effort?

  • A. Create an AWS Lambda function to pull logs from the RDS databases and consolidate the log files in an Amazon S3 bucket. Set a lifecycle policy to expire the objects after 90 days.
  • B. Modify the RDS databases to publish log to Amazon CloudWatch Logs. Change the log retention policy for each log group to expire the events after 90 days.
  • C. Write a stored procedure in each RDS database to download the logs and consolidate the log files in an Amazon S3 bucket. Set a lifecycle policy to expire the objects after 90 days.
  • D. Create an AWS Lambda function to download the logs from the RDS databases and publish the logs to Amazon CloudWatch Logs. Change the log retention policy for the log group to expire the events after 90 days.
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by learnaws at July 18, 2020, 5 a.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
learnaws
Highly Voted 3 years, 8 months ago
I'll go with B because it facilitate real-time
upvoted 12 times
szmulder
3 years, 8 months ago
I think it's due to the question need minimal effort. A need write a lambda is not minimal effort
upvoted 4 times
user0001
3 years, 3 months ago
regardless of the effort, why do you want to write code? (option A). you should always try to go with built-in fuctionality
upvoted 1 times
...
cloud4gr8
3 years, 7 months ago
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_LogAccess.html
upvoted 3 times
...
...
...
Pranava_GCP
Most Recent 1 year, 8 months ago
Selected Answer: B
B. Modify the RDS databases to publish log to Amazon CloudWatch Logs. Change the log retention policy for each log group to expire the events after 90 days. https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_LogAccess.Procedural.UploadtoCloudWatch.html "In an on-premises database, the database logs reside on the file system. Amazon RDS doesn't provide host access to the database logs on the file system of your DB instance. For this reason, Amazon RDS lets you export database logs to Amazon CloudWatch Logs. With CloudWatch Logs, you can perform real-time analysis of the log data. You can also store the data in highly durable storage and manage the data with the CloudWatch Logs Agent. "
upvoted 2 times
...
mraronsimon
1 year, 11 months ago
Selected Answer: B
The answer is B. "In an on-premises database, the database logs reside on the file system. Amazon RDS doesn't provide host access to the database logs on the file system of your DB instance. For this reason, Amazon RDS lets you export database logs to Amazon CloudWatch Logs. With CloudWatch Logs, you can perform real-time analysis of the log data. You can also store the data in highly durable storage and manage the data with the CloudWatch Logs Agent." Reference: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_LogAccess.Procedural.UploadtoCloudWatch.html
upvoted 3 times
...
ken_test1234
2 years, 2 months ago
Selected Answer: B
Because you need a centralized place for analysis and real time data , using s3 will require to search and view the logs 1 by 1 which is not a real time analyses
upvoted 1 times
...
Mintwater
2 years, 2 months ago
B. https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_LogAccess.Procedural.UploadtoCloudWatch.html Publish logs to CloudWatch
upvoted 1 times
...
awsjjj
2 years, 7 months ago
Selected Answer: B
B it is
upvoted 1 times
...
sachin
2 years, 11 months ago
with the least amount of work possible ; _the ans seems to be B but with have central repository to store logs for post-mortem analysis .. the Ans A seems to be correct.. This is confusing question :)
upvoted 1 times
...
novice_expert
3 years, 1 month ago
Selected Answer: A
no for B because: Logfiles are already created, and we do not want to mix that info with other log entries on CloudWatch so A: Lambda function to pull logs from the RDS databases -> consolidate the log files in an Amazon S3 bucket. Set a lifecycle policy to expire the objects after 90 days.
upvoted 1 times
DevoteamAnalytix
2 years, 11 months ago
Why not mix logs on CloudWatch? We can use different Log groups and we can filter logs....
upvoted 2 times
...
...
RotterDam
3 years, 3 months ago
Selected Answer: B
B is the correction Option
upvoted 1 times
...
tugboat
3 years, 3 months ago
Selected Answer: B
B can be scripted too
upvoted 1 times
...
soyyodario
3 years, 4 months ago
Selected Answer: B
B, best option with minimal effort and real time.
upvoted 2 times
...
awsmonster
3 years, 4 months ago
Going with B
upvoted 1 times
...
mnzsql365
3 years, 5 months ago
B is the right ans. https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_LogAccess.Procedural.UploadtoCloudWatch.html
upvoted 3 times
...
andy909
3 years, 6 months ago
Answer: B
upvoted 1 times
...
GMartinelli
3 years, 7 months ago
Its a tricky question, the correct option goes down to which of the options uses minimal effort, creating a lambda function or modifying all the databases. The question doesn´t tell us how many RDS, so I would choose B
upvoted 1 times
...
guru_ji
3 years, 7 months ago
B is Correct
upvoted 1 times
...
ChauPhan
3 years, 7 months ago
Vote B for minimal effort.
upvoted 1 times
...
Load full discussion...
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