Which combination of changes must the database administrator make to the database deployment to automate the collection of performance data?
(Choose two.)
Turn on Amazon DevOps Guru for the Aurora database resources in the CloudFormation template.
Turn on AWS CloudTrail in each AWS account.
Turn on and configure AWS Config for all Aurora PostgreSQL databases.
Update the CloudFormation template to enable Amazon CloudWatch monitoring on the Aurora PostgreSQL DB instances.
Update the CloudFormation template to turn on Performance Insights for Aurora PostgreSQL.
Explanations:
Amazon DevOps Guru is a service for monitoring application performance, but it is not specifically designed to collect performance data from Amazon Aurora PostgreSQL databases. It helps with operational issues in the application layer, not directly with database performance.
AWS CloudTrail records API calls and user activity across AWS services. It doesn’t provide performance monitoring for databases. It would not directly assist with investigating database performance issues.
AWS Config monitors configuration changes and compliance but does not provide performance metrics or detailed monitoring data for databases. It helps track resource configuration but not performance data.
Amazon Aurora supports integration with Amazon CloudWatch for monitoring database performance. Enabling CloudWatch monitoring through CloudFormation allows the collection of key metrics like CPU usage, disk I/O, and memory usage, which are important for performance investigation.
Enabling Performance Insights for Aurora PostgreSQL provides detailed insights into database performance, such as query performance, wait times, and bottlenecks. This feature can be enabled through CloudFormation and is specifically designed to help troubleshoot performance issues.
I chart that the answer is:
Update the CloudFormation template to enable Amazon CloudWatch monitoring on the Aurora PostgreSQL DB instances.