exam questions

Exam AWS Certified Database - Specialty All Questions

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

Exam AWS Certified Database - Specialty topic 1 question 192 discussion

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

A software-as-a-service (SaaS) company is using an Amazon Aurora Serverless DB cluster for its production MySQL database. The DB cluster has general logs and slow query logs enabled. A database engineer must use the most operationally efficient solution with minimal resource utilization to retain the logs and facilitate interactive search and analysis.
Which solution meets these requirements?

  • A. Use an AWS Lambda function to ship database logs to an Amazon S3 bucket. Use Amazon Athena and Amazon QuickSight to search and analyze the logs.
  • B. Download the logs from the DB cluster and store them in Amazon S3 by using manual scripts. Use Amazon Athena and Amazon QuickSight to search and analyze the logs.
  • C. Use an AWS Lambda function to ship database logs to an Amazon S3 bucket. Use Amazon Elasticsearch Service (Amazon ES) and Kibana to search and analyze the logs.
  • D. Use Amazon CloudWatch Logs Insights to search and analyze the logs when the logs are automatically uploaded by the DB cluster.
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️

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
cloudsunriser
Highly Voted 2 years, 8 months ago
Selected Answer: D
https://aws.amazon.com/premiumsupport/knowledge-center/aurora-serverless-logs-enable-view/
upvoted 5 times
...
Sathish_dbs
Most Recent 1 year, 8 months ago
A, B , C are trap as you don't need manual scripts to publish the logs to S3 in RDS or Aurora, it can be done by settings and options
upvoted 2 times
...
SonamDhingra
2 years, 9 months ago
Selected Answer: D
D is correct
upvoted 1 times
...
mbar94
2 years, 9 months ago
Selected Answer: D
Minimal resource utilization - I'd go with D - https://docs.aws.amazon.com/AmazonCloudWatch/latest/logs/AnalyzingLogData.html
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
Loading ...