nerdexam
AmazonAmazon

SAP-C02 · Question #475

SAP-C02 Question #475: Real Exam Question with Answer & Explanation

The correct answer is A: Deploy Amazon EC2 instances in an Auto Scaling group behind an Application Load Balancer for. It includes a network end-point added to PostgreSQL to enable your PostgreSQL database to understand the SQL Server wire protocol and commonly used SQL Server commands. With Babelfish, applications that were originally built for SQL Server can work directly with PostgreSQL, with

Submitted by sofia.br· Mar 6, 2026Migrate Workloads and Modernize Solutions

Question

An online retail company is migrating its legacy on-premises .NET application to AWS. The application runs on load-balanced frontend web servers, load-balanced application servers, and a Microsoft SQL Server database. The company wants to use AWS managed services where possible and does not want to rewrite the application. A solutions architect needs to implement a solution to resolve scaling issues and minimize licensing costs as the application scales. Which solution will meet these requirements MOST cost-effectively?

Options

  • ADeploy Amazon EC2 instances in an Auto Scaling group behind an Application Load Balancer for
  • BCreate images of all the servers by using AWS Database Migration Service (AWS DMS). Deploy
  • CContainerize the web frontend tier and the application tier. Provision an Amazon Elastic
  • DSeparate the application functions into AWS Lambda functions. Use Amazon API Gateway for the

Explanation

It includes a network end-point added to PostgreSQL to enable your PostgreSQL database to understand the SQL Server wire protocol and commonly used SQL Server commands. With Babelfish, applications that were originally built for SQL Server can work directly with PostgreSQL, with little to no code changes, and without changing database drivers. https://aws.amazon.com/rds/aurora/babelfish/

Community Discussion

No community discussion yet for this question.

Full SAP-C02 PracticeBrowse All SAP-C02 Questions