Hard1 markMultiple Choice
Domain 4.2: New Architecture DesignMigrationDatabaseEC2Operational Excellence

AWS SAP-C02 · Question 68 · Domain 4.2: New Architecture Design

A company is migrating a legacy application to AWS. The application requires a relational database. The company wants to minimize the operational overhead of managing the database, including patching, backups, and scaling. However, the application uses legacy stored procedures that require OS-level access to the database server to execute custom scripts. Which TWO actions should the architect take? (Select TWO)

Answer options:

A.

Migrate the database to Amazon RDS.

B.

Migrate the database to Amazon EC2 instances.

C.

Migrate the database to Amazon Aurora Serverless.

D.

Use AWS Systems Manager to automate OS patching and backups.

E.

Use AWS Database Migration Service (DMS) to convert the stored procedures to AWS Lambda functions.

F.

Enable RDS Custom for the database.

How to approach this question

Recognize that 'OS-level access' eliminates standard RDS/Aurora, requiring EC2. Then use Systems Manager to reduce the resulting operational overhead.

Full Answer

Because the application requires OS-level access, fully managed services like Amazon RDS and Aurora cannot be used. You must host the database on Amazon EC2. To meet the requirement of minimizing operational overhead, you can use AWS Systems Manager to automate patching and AWS Backup for backups.

Common mistakes

Choosing RDS and ignoring the 'OS-level access' constraint.

Practice the full AWS Solutions Architect Professional SAP-C02 Practice Exam 1

75 questions · hints · full answers · grading

More questions from this exam