AWS Certified Database – Specialty — Question 207

A company is working on migrating a large Oracle database schema with 3,500 stored procedures to Amazon Aurora PostgreSQL. An application developer is using the AWS Schema Conversion Tool (AWS SCT) to convert code from Oracle to Aurora PostgreSQL. However, the code conversion is taking a longer time with performance issues. The application team has reached out to a database specialist to improve the performance of the AWS SCT conversion.

What should the database specialist do to resolve the performance issues?

Answer options

• A. In AWS SCT, turn on the balance speed with memory consumption performance option with the optimal memory settings on local desktop.
• B. Provision the target Aurora PostgreSQL database with a higher instance class. In AWS SCT. turn on the balance speed with memory consumption performance option.
• C. In AWS SCT, turn on the fast conversion with large memory consumption performance option and set the JavaOptions section to the maximum memory available.
• D. Provision a client Amazon EC2 machine with more CPU and memory resources in the same AWS Region as the Aurora PostgreSQL database.

Correct answer: C

Explanation

The correct answer is C because enabling the fast conversion option with large memory consumption allows AWS SCT to process the conversion more efficiently, utilizing more memory to handle the workload. Options A and B do not prioritize speed, while option D may help but does not directly address the performance settings within AWS SCT, which is crucial for the conversion process.