A company has a highly available production 10 TB SQL Server relational database running on Amazon EC2. Users have recently been reporting performance and connectivity issues. The Database Specialist

Question

Options

• AConfigure AWS CloudTrail logs to monitor and detect signs of potential problems. Create an AWS
• BInstall an Amazon Inspector agent on the DB instance. Configure the agent to stream server and
• CMigrate the database to Amazon RDS for SQL Server and use Performance Insights to monitor
• DConfigure Amazon CloudWatch Application Insights for .NET and SQL Server to monitor and

• A
  7% (2)
• B
  19% (5)
• C
  4% (1)
• D
  70% (19)

Explanation

Explanation

Option D is correct because Amazon CloudWatch Application Insights for .NET and SQL Server is specifically designed to provide automated monitoring, metric visibility, and intelligent alerting for SQL Server workloads running on EC2 - it detects performance anomalies, connectivity issues, and generates CloudWatch alarms and dashboards without requiring a database migration.

Why the distractors are wrong:

• Option A (CloudTrail) is incorrect because CloudTrail tracks API calls and audit events, not database performance metrics or connectivity issues - it's a governance/compliance tool, not a performance monitoring solution.
• Option B (Amazon Inspector) is incorrect because Inspector is a security vulnerability assessment tool, not a database performance monitoring solution - it doesn't provide SQL Server metrics or connectivity diagnostics.
• Option C (RDS Migration) is incorrect because the question specifies the database is running on EC2, and migrating a 10 TB production database to RDS just to gain monitoring capabilities would be unnecessarily complex, risky, and costly.

Memory Tip

Think: "Application Insights = App + DB Performance on EC2." When you see SQL Server on EC2 + performance/connectivity issues + monitoring, CloudWatch Application Insights is the purpose-built AWS service. If the database were already on RDS, then Performance Insights would be the right answer.

No community discussion yet for this question.