DBS-C01 Database Security Practice Question
A company uses Amazon Aurora MySQL-Compatible Edition and needs to audit all SQL statements executed by database users. Which feature should be enabled?
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Enable the database engine audit logs (advanced auditing).
Aurora MySQL supports advanced auditing through database engine audit logs. Option B is wrong because CloudTrail logs API calls, not SQL queries. Option C is wrong because RDS Enhanced Monitoring provides OS metrics, not SQL audit. Option D is wrong because database activity streams capture activity in near real-time but are designed for monitoring and not primarily for SQL audit logging; however, they can be used, but the most direct answer is advanced auditing.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Enable the database engine audit logs (advanced auditing).
Why this is correct
Aurora MySQL can log SQL statements using the audit plugin.
- ✗
Enable AWS CloudTrail data events for the DB instance.
Why it's wrong here
CloudTrail does not log SQL queries.
- ✗
Enable database activity streams.
Why it's wrong here
Database activity streams capture activity but are more focused on monitoring; advanced auditing is the standard for SQL audit.
- ✗
Enable RDS Enhanced Monitoring.
Why it's wrong here
Enhanced Monitoring provides OS-level metrics, not SQL audit.
Go deeper
Related to this question
About these practice questions
One of 1,663 original DBS-C01 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This DBS-C01 practice question is part of Courseiva's free Amazon Web Services certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the DBS-C01 exam.