AWS Certified Database – Specialty — Question 129

A company has multiple applications serving data from a secure on-premises database. The company is migrating all applications and databases to the AWS
Cloud. The IT Risk and Compliance department requires that auditing be enabled on all secure databases to capture all log ins, log outs, failed logins, permission changes, and database schema changes. A Database Specialist has recommended Amazon Aurora MySQL as the migration target, and leveraging the Advanced
Auditing feature in Aurora.
Which events need to be specified in the Advanced Auditing configuration to satisfy the minimum auditing requirements? (Choose three.)

Answer options

• A. CONNECT
• B. QUERY_DCL
• C. QUERY_DDL
• D. QUERY_DML
• E. TABLE
• F. QUERY

Correct answer: A, B, C

Explanation

The correct answer includes CONNECT, QUERY_DCL, and QUERY_DDL because these events are essential for auditing user connections, data control language operations, and data definition language changes. The other options, QUERY_DML, TABLE, and QUERY, do not cover the specific minimum auditing requirements outlined by the IT Risk and Compliance department.