SAA-C03 Exam Dumps : AWS Certified Solutions Architect - Associate (SAA-C03)

The correct answer isDbecause the application peak hours occur at thesame time each day, and the performance issue happens specifically at thestart of peak hours. This indicates that the company knows in advance when additional capacity will be needed. Ascheduled scaling policyis the most appropriate solution because it allows the Auto Scaling group to increase capacitybeforedemand rises, ensuring that instances are already launched and available when users begin accessing the application.

Dynamic scaling based on CPU or memory reacts onlyafterutilization increases. Because launching EC2 instances takes time, reactive scaling can lead to delays and degraded user experience at the beginning of peak periods. That directly matches the problem described in the question, where performance is slow at the start but normalizes later once capacity catches up. Scheduled scaling solves this by making capacity available proactively.

Option A is incorrect because an Application Load Balancer distributes traffic among existing instances but does not add capacity ahead of predictable demand. Option B is incorrect because Auto Scaling does not natively scale on memory utilization unless a custom metric is configured, and even then it would still be reactive rather than proactive. Option C is also incorrect because CPU-based dynamic scaling reacts after demand increases and therefore may not prevent the startup lag during peak traffic.

AWS design guidance recommends usingscheduled scalingwhen traffic patterns are predictable and occur at known times. This approach improves application responsiveness and user experience by making sure enough EC2 capacity is available before the workload surge begins.

Comprehensive and Detailed 250 to 300 words of Explanation (AWS documentation-based, no links):

The company wants to increase security and reduce operational overhead for SQL Server relational databases. The most direct AWS managed service for SQL Server is Amazon RDS for SQL Server, which offloads routine database administration tasks such as provisioning, backups, patching (within managed service controls), monitoring integrations, and high availability management compared with running SQL Server on self-managed EC2.

Choosing Multi-AZ enhances availability and resilience by maintaining a synchronous standby in a separate Availability Zone with automated failover. This improves overall security posture and operational reliability because the platform handles common infrastructure failure scenarios without requiring custom clustering or manual intervention.

For encryption of sensitive data, integrating RDS with AWS KMS allows encryption at rest using KMS keys. Using an AWS managed key is operationally simple while still providing strong encryption controls, auditability, and centralized key management.

Option A still requires managing the database on EC2 (OS patching, SQL Server patching, backups, HA design, monitoring, recovery), which increases operational overhead significantly. Option C is not a database migration approach; S3 plus Macie does not provide a relational SQL Server engine for applications. Option D changes the data model by moving to DynamoDB and does not preserve SQL Server relational capabilities; CloudWatch Logs is not a data security control for database content.

Therefore, B best satisfies the goals: a managed relational database service (RDS for SQL Server) with built-in high availability (Multi-AZ) and encryption at rest via KMS, reducing ongoing operational work while improving security controls.

For maximum resiliency and fault tolerance in a mission-critical scenario, AWS recommends redundant Direct Connect connections from multiple data centers to multiple AWS Direct Connect locations.

This protects against:

Data center failure

Device failure

Location outages

“For workloads that require high availability, we recommend that you use multiple Direct Connect connections at multiple Direct Connect locations.”

— AWS Direct Connect Resiliency Recommendations

Option C follows AWS maximum resiliency model.