A Company Has a Production Environment Running on Amazon RDS

question 76

Multiple Choice

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?

• A) Install and configure Amazon CloudWatch Application Insights for Microsoft .NET and Microsoft SQL Server. Use a CloudWatch dashboard to identify the root cause.
• B) Enable RDS Performance Insights and determine which query is creating the problem. Request changes to the query to address the problem.
• C) Use AWS X-Ray deployed with Amazon RDS to track query system traces.
• D) Create a support request and work with AWS Support to identify the source of the issue.

---

Definitions:

Visuals

Graphical elements used to enhance or illustrate content.

Deviation Bar Charts

Bar charts that identify positive and negative values, or winners and losers.

Paired Bar Charts

A graphical display of information using two bars side by side at various heights to compare two sets of data.

Geographic Regions

Specific areas or locations defined by natural or artificial boundaries, often characterized by specific climatic conditions, topography, or cultural attributes.