DBS-C01 · Question #363
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…
The correct answer is D. Update the CloudFormation template to enable Amazon CloudWatch monitoring on the Aurora E. Update the CloudFormation template to turn on Performance Insights for Aurora PostgreSQL. To automate the collection of performance data for Aurora PostgreSQL databases deployed via CloudFormation, the administrator must enable Amazon CloudWatch monitoring and Amazon RDS Performance Insights.
Question
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.)
Options
- ATurn on Amazon DevOps Guru for the Aurora database resources in the CloudFormation
- BTurn on AWS CloudTrail in each AWS account.
- CTurn on and configure AWS Config for all Aurora PostgreSQL databases.
- DUpdate the CloudFormation template to enable Amazon CloudWatch monitoring on the Aurora
- EUpdate the CloudFormation template to turn on Performance Insights for Aurora PostgreSQL.
How the community answered
(21 responses)- A5% (1)
- B5% (1)
- C14% (3)
- D76% (16)
Why each option
To automate the collection of performance data for Aurora PostgreSQL databases deployed via CloudFormation, the administrator must enable Amazon CloudWatch monitoring and Amazon RDS Performance Insights.
Amazon DevOps Guru is a service that *analyzes* operational data to identify issues and recommend solutions, but it is not primarily a service for *collecting* raw performance data itself; it relies on underlying monitoring tools like CloudWatch and Performance Insights.
AWS CloudTrail records API calls and events for auditing and governance, not for collecting real-time performance metrics of database operations.
AWS Config records resource configuration changes for compliance and security auditing, not for monitoring database performance metrics.
Updating the CloudFormation template to enable Amazon CloudWatch monitoring on the Aurora database is essential for automatically collecting fundamental performance metrics such as CPU utilization, I/O operations, and network throughput, which are critical for initial performance investigations.
Updating the CloudFormation template to turn on Performance Insights for Aurora PostgreSQL provides deeper, more granular performance data, allowing the DBA to visualize database load, identify top queries, waits, and users, which is crucial for diagnosing specific performance bottlenecks.
Concept tested: Automated Aurora PostgreSQL performance data collection (CloudWatch, Performance Insights) via CloudFormation
Source: https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/USER_PerfInsights.html
Topics
Community Discussion
No community discussion yet for this question.