1Z0-997-26 Databases Practice Question
You are configuring Oracle Data Guard between an Exadata Database Service on Dedicated Infrastructure primary database and a remote standby database in another OCI region. To ensure maximum performance with zero data loss risk under normal operations, which Data Guard protection mode and transport setting should you configure?
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
✓
Maximum Protection mode with SYNC and AFFIRM transport.
Maximum Protection mode guarantees zero data loss (Zero Data Loss architecture) by ensuring transactions do not commit until the redo data is written to the standby redo log files on at least one synchronized standby database.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Maximum Protection mode with SYNC and AFFIRM transport.
Why this is correct
Maximum Protection mode with SYNC and AFFIRM ensures redo is written to the standby disk before the primary transaction commits, guaranteeing zero data loss.
- ✗
Maximum Availability mode with SYNC transport and NOAFFIRM.
Why it's wrong here
Maximum Availability provides high availability with automatic failover capability, but Maximum Protection provides stricter zero data loss enforcement by halting the primary if all standbys fail.
- ✗
Maximum Availability mode with ASYNC transport and ARCHivelog compression.
Why it's wrong here
ASYNC transport in Maximum Availability does not guarantee zero data loss.
- ✗
Maximum Performance mode with ASYNC transport.
Why it's wrong here
Maximum Performance mode uses ASYNC and can experience minor data loss in the event of an unexpected primary failure.
About these practice questions
One of 344 original 1Z0-997-26 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 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.