1Z0-076: Oracle Database 19c: Data Guard AdministrationDemo

By Oracle · Question Mode

QuestionQ4

Oracle Data Guard Overview

You need to propose an Oracle Data Giard configuration for a database that supports an OLTP workload and meets these permanent requirements:

  1. Data loss is not allowed.
  2. Read-only applications must not connect to the primary database instance.

Additionally, the following requirements exist, with only one ever performed at a time:

  1. It must be possible to apply and test designated patches with minimal downtime.
  2. An upgrade to a new database release must be performed with the least possible downtime.
  3. New application software releases must be tested against an exact, up-to-date replica of the production database.

You propose a primary database with one physical database configured in Maximum Protection mode.

Which requirements are met?

  • A 1 and 2
  • B 1, 2, 3, 4, and 5
  • C only requirement 5
  • D only requirement 1
  • E 2, 3, 4, and 5
  • F 1, 2, and 4
Explanation

Maximum Protection guarantees no data loss when the primary fails, and a physical standby can be opened for read-only access to offload queries from the primary. With only that single physical standby, the configuration cannot preserve Maximum Protection while using the standby as a snapshot or transient logical standby for general patch testing, rolling release upgrades, or writable application-release testing. A snapshot standby also cannot be the only standby in a Maximum Protection configuration.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!