DBS-C01 Deployment and Migration Practice Question
A company is migrating a PostgreSQL database to Amazon RDS for PostgreSQL. The source database uses custom functions written in PL/Python. What should the company consider?
⚠ Common exam trap
Candidates often assume RDS Custom or Aurora PostgreSQL can bypass the PL/Python limitation, but AWS does not support untrusted languages in any managed PostgreSQL offering, and RDS Custom still relies on the standard PostgreSQL engine which lacks PL/Python support.
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
✓
Rewrite the functions in PL/pgSQL or another supported language.
Amazon RDS for PostgreSQL does not support PL/Python because it requires the installation of an untrusted procedural language, which poses security risks in a managed database environment. The correct approach is to rewrite the custom functions in a supported language such as PL/pgSQL, PL/Perl, or PL/Tcl, which are trusted languages available in RDS for PostgreSQL.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Rewrite the functions in PL/pgSQL or another supported language.
Why this is correct
RDS PostgreSQL supports only specific procedural languages; PL/Python is not one of them.
- ✗
Modify the DB parameter group to enable PL/Python.
Why it's wrong here
Parameter groups control settings, not language support.
- ✗
Use RDS Custom for PostgreSQL to install PL/Python.
Why it's wrong here
While RDS Custom for PostgreSQL allows installing custom operating system packages and PostgreSQL extensions like PL/Python, making it tempting for this scenario, the standard Amazon RDS for PostgreSQL service does not natively support PL/Python. This option is incorrect because it implies a shift to a different RDS offering with increased management overhead, rather than addressing the lack of PL/Python support within the fully managed standard RDS for PostgreSQL. RDS Custom is specifically designed for workloads requiring OS-level customisation or unsupported extensions, where it would be the correct choice to maintain such dependencies.
- ✗
Migrate to Aurora PostgreSQL which supports PL/Python.
Why it's wrong here
Aurora PostgreSQL also does not support PL/Python.
Go deeper
Related to this question
About these practice questions
Courseiva writes every DBS-C01 question from scratch — 1,663 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →
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.