1z0-066: Oracle Database 12c Data Guard Administration Standby Practice Questions

You must propose an Oracle Data Guard configuration tor a database supporting an OLTP workload that meets these permanent requirements: 1. Data loss is not permitted. 2. Read-only applications should not connect to the primary database instance. Additionally, there are these requirements, only one of which is ever done at any one time: 3. It should be possible to apply and test designated patches with a minimum amount of downtime. 4. Upgrading to a new database release should be performed with the least possible amount of downtime. 5. New application software releases should be tested against an exact up-to-date replica of the production database. You propose a primary database with one physical standby database configured in Maximum Protection mode. Which requirements do you meet?

• AA. 2,3, 4, and 5
• BB. 1,2, 3,4, and 5
• CC. 1 and 2
• DD. only requirement 5
• EE. only requirement 1

You must use a physical standby database file to recover a data file on a primary database in a Data Guard environment. Which three of these steps must be performed on the primary database after the file has been backed up using RMAN on the physical standby database?

Select 3 answers.

• AA. Connect to the primary database as the AUXILIARY.
• BB. Catalog the data file copy for RMAN to use on the primary database for restore.
• CC. Back up the data file as copy on the standby host to a location on the standby host.
• DD. Switch to the data file copy using the RMAN SWITCH command.
• EE. Back up the data file as copy on the standby host to a location on the primary host
• FF. Connect to the primary database as the TARGET.

Your expertise is requested for these customer requirements: 1. The Data Guard environment must be in maximum protection mode. 2 Reports must be offloaded to a physical standby database. 3. There must be no lag between the primary and standby databases that affect the reports produced. 4. The primary database must be resilient in case of a single network failure. Which solution is correct for these requirements?

• AA. two standby databases, at least one of them a physical standby with Real-Time Query enabled and the STANDBY_MAX_DELAY parameter set to zero, receiving redo from the primary with asynchronous transport
• BB. two standby databases, at least one of them a physical standby with Real-Time Query enabled and the STANDBY_MAX_DATA_DELAY parameter set to zero, receiving redo from the primary with synchronous transport
• CC. one physical standby database with Real-Time Query enabled, receiving redo from two Far Sync instances that are connected the primary
• DD. one physical standby database with Real-Time Query enabled and the STANDBY_MAX_DATA_DELAY parameter set to zero, receiving redo from the primary with synchronous transport
• EE. two physical standby databases with Real-Time Query enabled, receiving redo from the primary with the LOG_ARCHIVE_DEST_n attributes SYNC NOAFFIRM to minimize the performance impact on the primary.

Which three are benefits of using the Data Guard Broker to manage standby databases?

Select 3 answers.

• AA. it simplifies physical standby database creation
• BB. It provides an easy failover capability using a single command.
• CC. it coordinates database state transitions and updates database properties dynamically.
• DD. it automatically changes database properties after the protection mode for a configuration is changed
• EE. It provides an easy switchover capability using a single command.
• FF. It simplifies logical standby database creation.

You must configure an Oracle Data Guard environment consisting of: 1. A primary database 2 One Physical Standby Database 3. One Logical Standby Database You must meet these requirements: 1. Primary database availability should not be compromised by the availability of the standby databases. 2. Under normal operations, transactions executed on the primary database should not commit before redo is written to disk on both the primary database and at least one standby database. Which redo transport mode and which protection mode would you configure to meet these requirements?

• AA. SYNC AFFIRM and Maximum Protection
• BB. SYNC NOAFFIRM and Maximum Protection
• CC. SYNC AFFIRM and Maximum Availability
• DD. SYNC NOAFFIRM and Maximum Availability
• EE. ASYNC and Maximum Performance