1Z0-076 practice question 23 of 25

Which THREE statements are true about snapshot standby databases?

Answer options

A: A snapshot standby database may be opened read-only.

B: FLASHBACK DATABASE is enabled automatically on a snapshot standby database after converting it from a physical standby database if not already enabled. Correct answer

C: FLASHBACK DATABASE is enabled automatically on a physical standby database as part of the conversion into a snapshot standby database, if not already enabled. Correct answer

D: A snapshot standby database can have Real-Time apply enabled.

E: A snapshot standby database may be opened read-write. Correct answer

F: FLASHBACK DATABASE must be manually enabled on a physical standby database before converting it into a snapshot standby database.

Correct Answer:

B. FLASHBACK DATABASE is enabled automatically on a snapshot standby database after converting it from a physical standby database if not already enabled.; C. FLASHBACK DATABASE is enabled automatically on a physical standby database as part of the conversion into a snapshot standby database, if not already enabled.; E. A snapshot standby database may be opened read-write.

Explanation

When a physical standby is converted to a snapshot standby, Data Guard automatically enables Flashback Database (and creates a guaranteed restore point) if it is not already enabled; consequently, the resulting snapshot standby always has flashback turned on. Snapshot standbys are opened read-write for full testing capability. They cannot run Redo Apply while in snapshot mode.

Why Incorrect

A. Snapshot standbys are intended for read-write; opening read-only provides no extra benefit.
D. Redo Apply (and thus Real-Time Apply) is disabled while a standby is in snapshot mode.
F. Flashback is enabled automatically; no manual action is needed before the conversion.

References

1. Oracle Data Guard Concepts & Administration 19c, §14.4 “Using Snapshot Standby Databases” (p. 14-5).

2. Oracle Data Guard Concepts & Administration 19c, §14.4.1 “Converting a Physical Standby to Snapshot Standby” (p. 14-6).

3. Oracle Data Guard Broker 19c, §7.1 “Snapshot Standby Conversions” (p. 7-3).

Keep practicing

Take the free 1Z0-076 practice test

Ten exam-style questions with answers and explanations, plus the exam facts and study guides.

Start the free practice test