DBS-C01 Workload-Specific Database Design Practice Question
A company is migrating a MySQL database from on-premises to Amazon RDS for MySQL. The current database has several stored procedures and triggers that use user-defined functions (UDFs) compiled as shared libraries. What is the best practice for handling these UDFs in RDS?
⚠ Common exam trap
Watch out — candidates often assume RDS Custom or Aurora MySQL will support custom UDFs, but neither service allows loading arbitrary shared libraries, making refactoring the only viable option.
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
✓
Refactor the stored procedures to avoid using the custom UDFs.
Amazon RDS for MySQL does not allow access to the underlying file system, so you cannot upload custom UDF shared libraries (.so files). The best practice is to refactor the stored procedures and triggers to remove dependencies on these UDFs, replacing their logic with native MySQL functions or application-level code. This ensures compatibility with the managed RDS environment without requiring custom binaries.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Use Amazon RDS Custom for MySQL to upload the UDF libraries.
Why it's wrong here
RDS Custom allows limited customization but does not support uploading arbitrary shared libraries for UDFs.
- ✗
Use AWS Lambda to replace the UDFs.
Why it's wrong here
Lambda can be used as an alternative but is not a direct replacement for compiled UDFs; the application needs refactoring.
- ✗
Migrate to Amazon Aurora MySQL, which supports custom UDFs.
Why it's wrong here
Aurora MySQL does not support custom compiled UDFs either.
- ✓
Refactor the stored procedures to avoid using the custom UDFs.
Why this is correct
RDS does not support custom compiled UDFs; the application must be refactored.
Go deeper
Related to this question
About these practice questions
One of 1,663 original DBS-C01 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. 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.