Crucial Exams

AWS Certified Solutions Architect Professional SAP-C02 Practice Question

A company operates an 8 TB Microsoft SQL Server Enterprise 2016 database that supports its business-critical order-processing application. Management wants to migrate the workload to AWS to reduce ongoing licensing costs. The application relies on hundreds of T-SQL stored procedures and functions and requires automatic, database-level failover within the same Region. The operations team has limited DBA capacity and prefers a fully managed service that minimizes application changes and downtime.

Which database platform will meet these requirements MOST cost-effectively?

  • Amazon DynamoDB tables migrated with AWS Database Migration Service and configured with on-demand capacity mode

  • Self-managed PostgreSQL on Amazon EC2 instances using streaming replication across two Availability Zones

  • Amazon RDS for SQL Server Enterprise Edition in a Multi-AZ configuration

  • Amazon Aurora PostgreSQL-Compatible Edition with Babelfish enabled, deployed as a Multi-AZ cluster

AWS Certified Solutions Architect Professional SAP-C02
Accelerate Workload Migration and Modernization
Your Score:
Settings & Objectives
Random Mixed
Questions are selected randomly from all chosen topics, with a preference for those you haven’t seen before. You may see several questions from the same objective or domain in a row.
Rotate by Objective
Questions cycle through each objective or domain in turn, helping you avoid long streaks of questions from the same area. You may see some repeat questions, but the distribution will be more balanced across topics.

Check or uncheck an objective to set which questions you will receive.

Wipe Score
Bash, the Crucial Exams Chat Bot
AI Bot