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

Exam question from Amazon's AWS Certified Database - Specialty

Question #: 125
Topic #: 1

[All AWS Certified Database - Specialty Questions]

A company has an ecommerce web application with an Amazon RDS for MySQL DB instance. The marketing team has noticed some unexpected updates to the product and pricing information on the website, which is impacting sales targets. The marketing team wants a database specialist to audit future database activity to help identify how and when the changes are being made.
What should the database specialist do to meet these requirements? (Choose two.)

A. Create an RDS event subscription to the audit event type.
B. Enable auditing of CONNECT and QUERY_DML events.
C. SSH to the DB instance and review the database logs.
D. Publish the database logs to Amazon CloudWatch Logs.
E. Enable Enhanced Monitoring on the DB instance.

Show Suggested Answer

Suggested Answer: BD 🗳️

by shantest1 at April 2, 2021, 4:50 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

shantest1

Highly Voted 3 years, 9 months ago

B and D

upvoted 11 times

gelsm

3 years, 8 months ago

https://aws.amazon.com/blogs/database/configuring-an-audit-log-to-capture-database-activities-for-amazon-rds-for-mysql-and-amazon-aurora-with-mysql-compatibility/

upvoted 3 times

...

MultiAZ

Most Recent 1 year, 6 months ago

Selected Answer: BD

B and D.

upvoted 1 times

...

aqiao

2 years, 3 months ago

Selected Answer: BD

A rules out because RDS event can not monitor data self change, it only monitor RDS config and parameter change, like DB snapshot,DB parameter group and so forth. https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_Events.overview.html

upvoted 3 times

...

redman50

2 years, 3 months ago

Selected Answer: AD

CONNECT and QUERY_DML events are part of Aurora, not RDS, so answers A and D

upvoted 4 times

clarksu

2 years, 2 months ago

CONNECT and QUERY_DML events are available for RDS. Your statement is false. https://aws.amazon.com/blogs/database/configuring-an-audit-log-to-capture-database-activities-for-amazon-rds-for-mysql-and-amazon-aurora-with-mysql-compatibility/

upvoted 3 times

...

praffuln

3 years, 1 month ago

Selected Answer: BD

enabling server_audit_events to auditing of CONNECT AND QUERY_DML events.

upvoted 1 times

...

novice_expert

3 years, 2 months ago

Selected Answer: BD

x A. RDS event not helpful for DML B. Enable auditing of CONNECT and QUERY_DML events. x C. SSH not allowed D. Publish the database logs to Amazon CloudWatch Logs. x E. Enhanced Monitoring for performance

upvoted 3 times

...

RotterDam

3 years, 4 months ago

Selected Answer: BD

B and D is correct. You ENABLE audit logging via MARIADB_AUDIT_PLUGIN. You then modify the rds instance > select the option to export Audit Logs > this publishes it to Cloudwatch

upvoted 2 times

...