nerdexam
Amazon

DBS-C01 · Question #112

A company has a production environment running on Amazon RDS for SQL Server with an in- house web application as the front end. During the last application maintenance window, new functionality was…

The correct answer is B. Enable RDS Performance Insights and determine which query is creating the problem. Amazon RDS Performance Insights is a database performance tuning and monitoring feature that helps you quickly assess the load on your database, and determine when and where to take action. Performance Insights allows non-experts to detect performance problems with an easy-to…

Submitted by minji_kr· Mar 6, 2026Monitoring and Troubleshooting

Question

A company has a production environment running on Amazon RDS for SQL Server with an in- house web application as the front end. During the last application maintenance window, new functionality was added to the web application to enhance the reporting capabilities for management. Since the update, the application is slow to respond to some reporting queries. How should the company identify the source of the problem?

Options

  • AInstall and configure Amazon CloudWatch Application Insights for Microsoft .NET and Microsoft
  • BEnable RDS Performance Insights and determine which query is creating the problem.
  • CUse AWS X-Ray deployed with Amazon RDS to track query system traces.
  • DCreate a support request and work with AWS Support to identify the source of the issue.

How the community answered

(42 responses)
  • A
    5% (2)
  • B
    83% (35)
  • C
    2% (1)
  • D
    10% (4)

Explanation

Amazon RDS Performance Insights is a database performance tuning and monitoring feature that helps you quickly assess the load on your database, and determine when and where to take action. Performance Insights allows non-experts to detect performance problems with an easy-to- understand dashboard that visualizes database load. https://aws.amazon.com/rds/performance-insights/

Topics

#RDS Performance Insights#SQL Server#performance monitoring#query analysis#troubleshooting

Community Discussion

No community discussion yet for this question.

Full DBS-C01 Practice