DBS-C01 · Question #293
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
The correct answer is C. In AWS SCT, turn on the fast conversion with large memory consumption performance option and. To improve AWS SCT performance for large schema conversions, enabling the "fast conversion with large memory consumption" option within SCT, combined with allocating more memory to the client machine running SCT, is the most effective approach.
Question
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?
Options
- AIn AWS SCT, turn on the balance speed with memory consumption performance option with the
- BProvision the target Aurora PostgreSQL database with a higher instance class. In AWS SCT. turn
- CIn AWS SCT, turn on the fast conversion with large memory consumption performance option and
- DProvision a client Amazon EC2 machine with more CPU and memory resources in the same
How the community answered
(16 responses)- B6% (1)
- C81% (13)
- D13% (2)
Why each option
To improve AWS SCT performance for large schema conversions, enabling the "fast conversion with large memory consumption" option within SCT, combined with allocating more memory to the client machine running SCT, is the most effective approach.
The "balance speed with memory consumption" option aims for a middle ground, which might not be sufficient for a large schema with 3,500 stored procedures experiencing significant performance issues.
Provisioning a higher instance class for the target Aurora PostgreSQL database does not directly impact the performance of the AWS SCT client-side schema and code conversion process, as SCT performs the conversion logic on the client before applying it to the target.
The "fast conversion with large memory consumption" performance option in AWS SCT is designed to optimize the conversion process for large and complex schemas by leveraging more available memory on the client machine. Allocating more memory to the client machine running SCT further supports this option, allowing SCT to process more data in memory and reduce I/O operations, thereby accelerating the conversion of numerous stored procedures.
While provisioning a client EC2 machine with more CPU and memory resources can help, it's not the most direct or complete solution without also configuring AWS SCT to utilize those resources optimally through its performance options.
Concept tested: AWS SCT performance optimization
Source: https://docs.aws.amazon.com/sct/latest/userguide/sct-managing-projects-performance.html
Topics
Community Discussion
No community discussion yet for this question.