DBS-C01 Deployment and Migration Practice Question
A company is migrating a 5 TB Oracle database to Amazon RDS for Oracle. The database contains large BFILEs stored in a file system. The company needs to migrate the data with minimal downtime and ensure the BFILEs are migrated. Which THREE steps should the company take?
⚠ Common exam trap
Test-takers frequently assume BFILEs must be converted to BLOBs before migration (Option A), but AWS DMS can handle BFILEs natively during the migration process, avoiding pre-migration schema changes and reducing downtime.
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
✓
Use AWS SCT to convert any incompatible schema objects.
The correct steps for migrating a 5 TB Oracle database with BFILEs to Amazon RDS for Oracle with minimal downtime are: (B) Use AWS Schema Conversion Tool (SCT) to identify and convert incompatible schema objects, ensuring the target schema is ready. (C) Upload the BFILEs to Amazon S3 and use Oracle Directory objects to reference them in the target database, as BFILEs reference files stored outside the database. (E) Use AWS Database Migration Service (DMS) with the Oracle source endpoint configured to include the BFILE directory path, enabling DMS to migrate the BFILEs during the continuous replication phase, minimizing downtime. Option A (replacing BFILEs with BLOBs) is unnecessary because DMS handles BFILEs natively, and such a change would increase complexity and downtime. Option D (using CloudEndure Migration) is designed for server-level migration, not database-level, and would not be appropriate for this database migration.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Replace BFILEs with BLOBs in the source database before migration.
Why it's wrong here
This requires schema changes and downtime.
- ✓
Use AWS SCT to convert any incompatible schema objects.
Why this is correct
SCT helps convert Oracle-specific objects to RDS-compatible ones.
- ✓
Upload the BFILEs to Amazon S3 and use Oracle Directory objects to reference them.
Why this is correct
After migration, BFILEs can be stored in S3 and accessed via directories.
- ✗
Use AWS CloudEndure Migration to replicate the entire server.
Why it's wrong here
CloudEndure migrates servers, not database objects like BFILEs.
- ✓
Use AWS DMS with the Oracle source endpoint configured to include the BFILE directory path.
Why this is correct
DMS can migrate BFILEs when the directory path is specified.
Quick reference
AWS S3 Storage Class Comparison
| Storage Class | Min Duration | Retrieval | Use Case |
|---|---|---|---|
| S3 Standard | None | Immediate | Frequently accessed data |
| S3 Standard-IA | 30 days | Immediate | Infrequent access, rapid retrieval |
| S3 One Zone-IA | 30 days | Immediate | Non-critical infrequent data |
| S3 Intelligent-Tiering | None | Immediate–hours | Unknown or changing access patterns |
| S3 Glacier Instant | 90 days | Milliseconds | Archive with instant retrieval |
| S3 Glacier Flexible | 90 days | Minutes–hours | Archive, flexible retrieval |
| S3 Glacier Deep Archive | 180 days | Hours | Long-term compliance archive |
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.