AWS Certified Database – Specialty — Question 275

A company has an application environment that deploys Amazon Aurora PostgreSQL databases as part of its CI/CD process that uses AWS CloudFormation. The company's database administrator has received reports of performance issues from the resulting database but has no way to investigate the issues.

Which combination of changes must the database administrator make to the database deployment to automate the collection of performance data? (Choose two.)

Answer options

• A. Turn on Amazon DevOps Guru for the Aurora database resources in the CloudFormation template.
• B. Turn on AWS CloudTrail in each AWS account.
• C. Turn on and configure AWS Config for all Aurora PostgreSQL databases.
• D. Update the CloudFormation template to enable Amazon CloudWatch monitoring on the Aurora PostgreSQL DB instances.
• E. Update the CloudFormation template to turn on Performance Insights for Aurora PostgreSQL.

Correct answer: B, D

Explanation

Enabling Amazon CloudWatch monitoring on the Aurora PostgreSQL DB instances via CloudFormation ensures that vital system-level performance metrics are automatically gathered and visualized. Concurrently, activating AWS CloudTrail across the AWS accounts records API calls and management events, allowing the database administrator to correlate performance anomalies with configuration changes or user actions.