Exam AWS Certified Database - Specialty topic 1 question 218 discussion

Exam question from Amazon's AWS Certified Database - Specialty

Question #: 218
Topic #: 1

[All AWS Certified Database - Specialty Questions]

A company uses Amazon Aurora MySQL as the primary database engine for many of its applications. A database specialist must create a dashboard to provide the company with information about user connections to databases. According to compliance requirements, the company must retain all connection logs for at least 7 years.
Which solution will meet these requirements MOST cost-effectively?

A. Enable advanced auditing on the Aurora cluster to log CONNECT events. Export audit logs from Amazon CloudWatch to Amazon S3 by using an AWS Lambda function that is invoked by an Amazon EventBridge (Amazon CloudWatch Events) scheduled event. Build a dashboard by using Amazon QuickSight.
B. Capture connection attempts to the Aurora cluster with AWS Cloud Trail by using the DescribeEvents API operation. Create a CloudTrail trail to export connection logs to Amazon S3. Build a dashboard by using Amazon QuickSight.
C. Start a database activity stream for the Aurora cluster. Push the activity records to an Amazon Kinesis data stream. Build a dynamic dashboard by using AWS Lambda.
D. Publish the DatabaseConnections metric for the Aurora DB instances to Amazon CloudWatch. Build a dashboard by using CloudWatch dashboards.

Show Suggested Answer

Suggested Answer: A 🗳️

by mbar94 at Sept. 5, 2022, 8:44 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

Submit Cancel

mbar94

Highly Voted 2 years, 9 months ago

Selected Answer: A

It's A, any thoughts? https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.Auditing.html

upvoted 7 times

...

Germaneli

Most Recent 1 year, 8 months ago

Selected Answer: A

A. Reasonable solution: Advanced auditing -> CloudWatch -> CloudWatch Events -> S3 -> QuickSight. x B. Sounds like a lot of manual work. AWS offers more automation than that. x C. A dynamic dashboard by using AWS Lambda? Funny idea. And where is the data stored for 7 years then? x D. Doesn't even mention data storage for 7 years.

upvoted 2 times

...

Pranava_GCP

1 year, 9 months ago

Selected Answer: A

A. Enable advanced auditing on the Aurora cluster to log CONNECT events. https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.Auditing.html

upvoted 2 times

...