nerdexam
Oracle

1Z0-497 · Question #52

Your customer has three data centers in three different locations, location A has their production database running on Oracle Database 12c. They want to replicate the data from location A to…

The correct answer is A. Oracle GoldenGate C. Oracle Active Data Guard. https://docs.oracle.com/database/121/UPGRD/deprecated.htm#UPGRD60159 Deprecation of Oracle Streams Oracle Streams is deprecated in Oracle Database 12c and may be desupported and unavailable in a later Oracle Database release. Use Oracle GoldenGate to replace all replication…

Oracle Database Cloud Services Overview

Question

Your customer has three data centers in three different locations, location A has their production database running on Oracle Database 12c. They want to replicate the data from location A to location B. which is 50 miles away and is used for disaster protection and database rolling upgrades. They also want to create a replica database at location C, which must be open in read- write mode, while synchronizing with the primary database. Which two solutions would you recommend to your customer?

Options

  • AOracle GoldenGate
  • BOracle Advanced Replication
  • COracle Active Data Guard
  • DOracle Streams

How the community answered

(57 responses)
  • A
    84% (48)
  • B
    11% (6)
  • D
    5% (3)

Explanation

https://docs.oracle.com/database/121/UPGRD/deprecated.htm#UPGRD60159 Deprecation of Oracle Streams Oracle Streams is deprecated in Oracle Database 12c and may be desupported and unavailable in a later Oracle Database release. Use Oracle GoldenGate to replace all replication features of Deprecation of Advanced Replication Oracle Database Advanced Replication is deprecated in Oracle Database 12c. Use Oracle GoldenGate to replace all features of Advanced Replication, including multimaster replication, updatable materialized views, hierarchical materialized views, and deployment templates.

Topics

#Active Data Guard#GoldenGate#disaster recovery#read-write replica

Community Discussion

No community discussion yet for this question.

Full 1Z0-497 Practice