nerdexam
Amazon

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.

Submitted by mateo_ar· Mar 6, 2026Deployment and Migration

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)
  • B
    6% (1)
  • C
    81% (13)
  • D
    13% (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.

AIn AWS SCT, turn on the balance speed with memory consumption performance option with the

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.

BProvision the target Aurora PostgreSQL database with a higher instance class. In AWS SCT. turn

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.

CIn AWS SCT, turn on the fast conversion with large memory consumption performance option andCorrect

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.

DProvision a client Amazon EC2 machine with more CPU and memory resources in the same

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

#AWS SCT#schema conversion#Oracle to PostgreSQL#performance optimization

Community Discussion

No community discussion yet for this question.

Full DBS-C01 Practice