Exam AWS Certified Database - Specialty topic 1 question 181 discussion

Exam question from Amazon's AWS Certified Database - Specialty

Question #: 181
Topic #: 1

[All AWS Certified Database - Specialty Questions]

A financial services company has an application deployed on AWS that uses an Amazon Aurora PostgreSQL DB cluster. A recent audit showed that no log files contained database administrator activity. A database specialist needs to recommend a solution to provide database access and activity logs. The solution should use the least amount of effort and have a minimal impact on performance.
Which solution should the database specialist recommend?

A. Enable Aurora Database Activity Streams on the database in synchronous mode. Connect the Amazon Kinesis data stream to Kinesis Data Firehose. Set the Kinesis Data Firehose destination to an Amazon S3 bucket.
B. Create an AWS CloudTrail trail in the Region where the database runs. Associate the database activity logs with the trail.
C. Enable Aurora Database Activity Streams on the database in asynchronous mode. Connect the Amazon Kinesis data stream to Kinesis Data Firehose. Set the Firehose destination to an Amazon S3 bucket.
D. Allow connections to the DB cluster through a bastion host only. Restrict database access to the bastion host and application servers. Push the bastion host logs to Amazon CloudWatch Logs using the CloudWatch Logs agent.

Show Suggested Answer

Suggested Answer: C 🗳️

by leunamE at Nov. 14, 2021, 6:51 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

Submit Cancel

Pranava_GCP

1 year, 10 months ago

Selected Answer: C

C. Enable Aurora Database Activity Streams on the database in asynchronous mode. Asynchronous mode favors database performance so to alleviate performance impact.

upvoted 1 times

...

justfmm

3 years, 2 months ago

If the question states that we are able to have negligible effect on performance, should we use sync mode instead as it prioritize accuracy over performance ? Asynchronous mode favors database performance over the accuracy of the activity stream. The synchronous mode favors the accuracy of the activity stream over database performance. https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/DBActivityStreams.Overview.html#DBActivityStreams.Overview.sync-mode I believe the answer should be sync mode.

upvoted 1 times

...