Courseiva
← DBS-C01
Full test
Management and Operations →hardMultiple ChoiceObjective-mapped

DBS-C01 Management and Operations Practice Question

A company is migrating an on-premises Oracle database to Amazon Aurora PostgreSQL. The database has several stored procedures that use Oracle-specific PL/SQL. The team needs to minimize manual code changes. Which AWS service or tool should be used to automate the conversion of the stored procedures?

Answer choices

Why each option matters

Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.

Correct answer & explanation

✓

AWS Schema Conversion Tool (AWS SCT)

The AWS Schema Conversion Tool (AWS SCT) is the correct choice because it automates the conversion of Oracle PL/SQL stored procedures to PostgreSQL PL/pgSQL, minimizing manual code changes. Option B (Amazon Aurora PostgreSQL native compatibility) does not automatically convert Oracle PL/SQL; it only supports some PostgreSQL features. Option C (AWS DMS) handles data migration, not schema or code conversion. Option D (manual rewrite) is not automated and contradicts the requirement to minimize manual changes.

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

  • ✓

    AWS Schema Conversion Tool (AWS SCT)

    Why this is correct

    AWS SCT automates the conversion of database schemas and code, including PL/SQL, to target database engines.

  • ✗

    Amazon Aurora PostgreSQL native compatibility

    Why it's wrong here

    Aurora PostgreSQL does not natively convert Oracle PL/SQL; manual rewriting would be needed.

  • ✗

    AWS Database Migration Service (AWS DMS)

    Why it's wrong here

    AWS DMS migrates data, not schema or code; it does not convert stored procedures.

  • ✗

    Manual rewrite using PostgreSQL PL/pgSQL

    Why it's wrong here

    Manual rewrite is not minimizing manual changes; AWS SCT can automate a significant portion.

About these practice questions

This DBS-C01 question is part of Courseiva's 1,663-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →

How Courseiva writes practice questions · Editorial policy

JA

Written by Johnson Ajibi, MSc IT Security

Senior Network & Security Engineer · founder of Courseiva

This DBS-C01 practice question is part of Courseiva's free Amazon Web Services certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the DBS-C01 exam.