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

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

A company is loading sensitive data into an Amazon Aurora MySQL database. To meet compliance requirements, the company needs to enable audit logging on the Aurora MySQL DB cluster to audit database activity. This logging will include events such as connections, disconnections, queries, and tables queried. The company also needs to publish the DB logs to Amazon CloudWatch to perform real-time data analysis.
Which solution meets these requirements?

  • A. Modify the default option group parameters to enable Advanced Auditing. Restart the database for the changes to take effect.
  • B. Create a custom DB cluster parameter group. Modify the parameters for Advanced Auditing. Modify the cluster to associate the new custom DB parameter group with the Aurora MySQL DB cluster.
  • C. Take a snapshot of the database. Create a new DB instance, and enable custom auditing and logging to CloudWatch. Deactivate the DB instance that has no logging.
  • D. Enable AWS CloudTrail for the DB instance. Create a filter that provides only connections, disconnections, queries, and tables queried.
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by mbar94 at Sept. 3, 2022, 10:05 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
mbar94
Highly Voted 2 years, 9 months ago
Selected Answer: B
Vote for B. https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.Auditing.html
upvoted 9 times
...
Germaneli
Most Recent 1 year, 8 months ago
Selected Answer: B
There's nothing like an 'option' group. There's a default parameter group, and that cannot directly be modified. However, you can create a new custom parameter group and change the settings in there.
upvoted 2 times
...
cloudsunriser
2 years, 8 months ago
Selected Answer: B
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.Auditing.html
upvoted 2 times
...
SonamDhingra
2 years, 9 months ago
Selected Answer: B
B is correct, custom parameter group
upvoted 3 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