nerdexam
Amazon

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.

Submitted by dimitri_ru· Mar 6, 2026Monitoring and Troubleshooting

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)
  • A
    5% (1)
  • B
    5% (1)
  • C
    14% (3)
  • D
    76% (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.

ATurn on Amazon DevOps Guru for the Aurora database resources in the CloudFormation

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.

BTurn on AWS CloudTrail in each AWS account.

AWS CloudTrail records API calls and events for auditing and governance, not for collecting real-time performance metrics of database operations.

CTurn on and configure AWS Config for all Aurora PostgreSQL databases.

AWS Config records resource configuration changes for compliance and security auditing, not for monitoring database performance metrics.

DUpdate the CloudFormation template to enable Amazon CloudWatch monitoring on the AuroraCorrect

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.

EUpdate the CloudFormation template to turn on Performance Insights for Aurora PostgreSQL.Correct

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

#Aurora PostgreSQL#Performance Insights#CloudWatch#CloudFormation

Community Discussion

No community discussion yet for this question.

Full DBS-C01 Practice