1Z0-997-26 Workload Migration Practice Question
An architect is designing a database migration from an on-premises Oracle Database (Non-CDB structure) to an OCI Autonomous Database (Serverless). Which migration method is mandatory because of the architectural constraints of Autonomous Database?
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
✓
Logical migration using Oracle Data Pump or Oracle Zero Downtime Migration (logical workflow)
OCI Autonomous Database restricts direct low-level OS access and traditional physical database structures, requiring logical migration methods such as Oracle Data Pump, SQL Developer, or Zero Downtime Migration using logical transport mechanisms.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Logical migration using Oracle Data Pump or Oracle Zero Downtime Migration (logical workflow)
Why this is correct
Because Autonomous Database is a managed cloud service with strict security and architectural bounds, logical migration via Data Pump or ZDM logical mode is required.
- ✗
Direct block-level storage snapshot replication using OCI Block Volume replication
Why it's wrong here
Block-level storage replication is used for IaaS compute volumes, not managed PaaS database services like Autonomous Database.
- ✗
RMAN transportable tablespaces with physical file conversion
Why it's wrong here
Transportable tablespaces with direct physical file access are not supported for Autonomous Database Serverless.
- ✗
Physical standby database via Oracle Data Guard broker
Why it's wrong here
Autonomous Database does not support traditional physical Data Guard standby configurations from external non-CDB on-premises databases.
Quick reference
Cloud Service Model Comparison
| Model | You Manage | Provider Manages | Examples |
|---|---|---|---|
| IaaS | OS, runtime, apps, data | Hardware, hypervisor, networking | EC2, Azure VMs, GCP Compute Engine |
| PaaS | Apps and data | OS, runtime, middleware, hardware | Elastic Beanstalk, Azure App Service |
| SaaS | Data and settings only | Everything else | Microsoft 365, Salesforce, Workday |
| FaaS / Serverless | Function code only | Infra, scaling, runtime | Lambda, Azure Functions, Cloud Run |
| CaaS | Containers and apps | Kubernetes, OS, hardware | EKS, AKS, GKE |
About these practice questions
Courseiva writes every 1Z0-997-26 question from scratch — 344 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 and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed August 2026 · checked against the official Oracle exam blueprint
This 1Z0-997-26 practice question is part of Courseiva's free Oracle 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 1Z0-997-26 exam.