Review

Let's now practice a few exam-style questions, as follows:

1. A company has a critical system that runs on RDS SQL Server and is accessed through an in-house web application. The web application has recently been improved with additional reporting capabilities. The program has been slow to reply to certain reporting requests after the upgrade. How can you find the root cause of the issue?
   1. Install and configure Amazon CloudWatch Application Insights for Microsoft .NET and Microsoft SQL Server. Use a CloudWatch dashboard to identify the root cause of application issues.
   2. Enable RDS Performance Insights and determine which query is creating the problem. Request changes to the query to address the problem.
   3. Use AWS X-Ray deployed with Amazon RDS to track query system traces.
   4. Create a support request and work with AWS Support to identify the source of the issue.
2. You are a database administrator for a small company. Over the weekend, some security modifications were made...