nerdexam
Amazon

SAA-C03 · Question #648

A company runs an ecommerce application on premises on Microsoft SQL Server. The company is planning to migrate the application to the AWS Cloud. The application code contains complex T-SQL queries an

The correct answer is A. Migrate the database to Amazon Aurora PostgreSQL. Turn on Babelfish.. Aurora PostgreSQL with Babelfish allows the database to accept TDS protocol and understand T- SQL queries and stored procedures with high compatibility, so most SQL Server-specific code can run with little or no change. Aurora is a fully managed, license-free engine, which signif

Submitted by ricky.ec· Mar 4, 2026Design Cost-Optimized Architectures

Question

A company runs an ecommerce application on premises on Microsoft SQL Server. The company is planning to migrate the application to the AWS Cloud. The application code contains complex T-SQL queries and stored procedures. The company wants to minimize database server maintenance and operating costs after the migration is completed. The company also wants to minimize the need to rewrite code as part of the migration effort. Which solution will meet these requirements?

Options

  • AMigrate the database to Amazon Aurora PostgreSQL. Turn on Babelfish.
  • BMigrate the database to Amazon S3. Use Amazon Redshift Spectrum for query processing.
  • CMigrate the database to Amazon RDS for SQL Server. Turn on Kerberos authentication.
  • DMigrate the database to an Amazon EMR cluster that includes multiple primary nodes.

How the community answered

(45 responses)
  • A
    73% (33)
  • B
    16% (7)
  • C
    2% (1)
  • D
    9% (4)

Explanation

Aurora PostgreSQL with Babelfish allows the database to accept TDS protocol and understand T- SQL queries and stored procedures with high compatibility, so most SQL Server-specific code can run with little or no change. Aurora is a fully managed, license-free engine, which significantly reduces maintenance overhead and operating costs compared to running SQL Server (including RDS for SQL Server). This combination best meets both goals: minimizing code rewrite and minimizing ongoing database costs.

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full SAA-C03 Practice