DBS-C01 Question #73: Real Exam Question with Answer & Explanation

Question

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 has been asked to configure a monitoring and alerting strategy that will provide metrics visibility and notifications to troubleshoot these issues. Which solution will meet these requirements?

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

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.