Online Access Free 1Z0-066 Practice Test

You have a Data Guard broker configuration consisting of:
1. A primary database
2. One local physical standby database
3. One far sync instance
4. A remote physical standby database
The broker configuration was created with the DGMGRL utility after creating all the databases and the far sync instance with command-line tools.
What is the correct way to add this configuration to Enterprise Manager Cloud Control assuming all the nodes have been discovered already as Enterprise Manager targets?

• A.Use the DGMGRL utility to register the configuration with the Enterprise manager Cloud Control agent on the primary database node. This will enable the discovery of all the other databases in the configuration as targets which will be ready to be monitored.
• B.Discover the primary database as a target in Enterprise Cloud Control. Then discover the existing Data Guard Broker configuration for the primary and all the other databases in the configuration will be discovered as targets and be ready to be monitored.
• C.Discover either of the physical standby databases as a target by refreshing the node on which they run, and the other databases and instances in the Data Guard Broker configuration will be discovered as targets automatically and be ready to be monitored.
• D.Discover the primary as a target by refreshing the node on which it runs, and the other databases and instances in the Data Guard Broker configuration will be discovered as targets automatically and be ready to be monitored.
• E.Delete the Data Guard Broker configuration using DGMGRL and then re-create it using Enterprise Manager Cloud Control to enable all the databases in the configuration to be discovered as targets and to be ready to be monitored.

Which three are true concerning archive logs in a Data Guard Environment? (Choose three.)

• A.A far sync instance writes to the LOG_ARCHIVE_DEST directory if the remote physical standby database instance to which it routes redo, is not reachable.
• B.A logical standby database instance writes online redo logs.
• C.A far sync instance writes to the LOG_ARCHIVE_DEST directory if the remote logical standby database instance to which it routes redo, is not reachable.
• D.A logical standby database chooses an appropriate location for writing its own standby archive logs automatically.
• E.A physical standby database instance chooses an appropriate location for writing its own standby archive logs automatically.
• F.A physical standby database instance writes online redo logs.

Which three statements are true about standby redo logs in a Data Guard configuration with no Oracle Streams or Goldengate configured? (Choose three.)

• A.They are required only for synchronous redo transport.
• B.They are required on a logical standby for real-time apply.
• C.Only standby databases can write redo to them.
• D.The LGWR process writes to them on a standby database.
• E.They are required on a physical standby for real-time apply.
• F.It is recommended to have them on the primary database.

Attempting to start the observer raises an error:
DGMGRL> start observer;
DGM-16954: Unable to open and lock the Observer configuration file Failed.
Identify two possible reasons for this error. (Choose two.)

• A.The broker configuration has not yet been created.
• B.There is another observer running for a Data Guard configuration which uses the same observer configuration file.
• C.There is already an observer running for this Data Guard configuration.
• D.The observer configuration file is marked read-only.
• E.Fast-Start Failover is not yet enabled for this Data Guard configuration.

There are currently 6 APPLIER and 6 PREPARER processes running and no idle APPLIER processes on your logical standby database.
The MAX_SERVERS SQL apply parameter and number of archiver processes are both set to 12.
Identify two changes, each of which would allow you to increase the number of APPLIER processes. (Choose two.)

• A.Increase the PROCESSES initialization parameter
• B.Decrease the number of PREPARER processes
• C.Increase the PARALLEL_MAX_SERVER initialization parameter
• D.Increase the value for the MAX_SERVERS SQL apply parameter.
• E.Increase the RECOVERY_PARALLELISM initialization parameter
• F.Decrease the number of archiver processes on the standby database.