1Z0-997-26 Workload Migration Practice Question
Your organization is preparing to migrate several large Oracle databases to OCI using Oracle Data Pump. Which THREE best practices should you follow to optimize the export and import performance over network connections? (Choose three.)
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 the `PARALLEL` parameter during both export and import operations to utilize multiple worker processes.
Data Pump performance can be significantly improved by using parallel execution (PARALLEL parameter), compressing dump files, and staging files on high-performance storage or directly streaming via network links.
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 the `PARALLEL` parameter during both export and import operations to utilize multiple worker processes.
Why this is correct
Parallelism drastically reduces total export and import time for large databases by running multiple threads concurrently.
- ✗
Execute all Data Pump jobs from a local laptop connected via public Wi-Fi without compression.
Why it's wrong here
Running large database migrations over unstable Wi-Fi without compression causes disconnections and extreme slowness.
- ✓
Enable data compression using the `COMPRESS` parameter to minimize network transfer times.
Why this is correct
Compressing dump files reduces the volume of data transferred over the network.
- ✗
Disable database undo tablespaces entirely during the Data Pump import phase.
Why it's wrong here
Disabling undo tablespaces will cause database corruption and transaction failure.
- ✓
Use network-linked Data Pump (`NETWORK_LINK`) to stream data directly from source to target database without generating intermediate dump files on disk.
Why this is correct
Network links allow direct transfer between databases, bypassing intermediate disk storage bottlenecks.
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.