1z0-076

1z0-076 practice questions, page 2 of 3, with answer review and explanations.

Question 6

Examine the Data Guard configuration: An attempt to enable fast-start failover raises an error: Identify two possible reasons for this error. (Choose two.)

  1. The LogXptMode property is set to ASYNC on Dogs.
  2. The RedoRoutes property us not set on DogsFS1.
  3. The RedoRoutes property is not set on Dogs.
  4. The FastStartFailoverTarget property is not set on Sheep.
  5. The FastStartFailoverTarget property is not set on Dogs.
  6. The FastStartFailoverTarget property is not set on DogsFS1.

Question 7

Which three are prerequisites for enabling Fast-Start Failover? (Choose three.)

  1. The configuration must be operating in either Maximum Performance or Maximum Availability mode.
  2. Flashback Database must be enabled on both the primary database and the Fast-Start Failover target standby database.
  3. The maximum protection mode can be used, but with two or more standby databases.
  4. The Data Guard environment must be managed by the Data Guard Broker.
  5. The Fast-Start Failover target standby database must receive REDO directly from the primary database.
  6. You can specify only one standby database as the fast-start failover target.

Question 8

Which two statements are true regarding asynchronous redo transport in a Data Guard environment? (Choose two.)

  1. This transport mode satisfies the minimum requirements for Maximum Performance data protection mode.
  2. This transport mode satisfies the minimum requirements for Maximum Availability data protection mode.
  3. The performance of SQL apply on a logical database always improves when using this transport mode.
  4. Real-time query performance on a physical database improves for current read requests when using this transport mode.
  5. A transaction can commit without waiting for redo to be sent to any standby database in the data guard configuration.

Question 9

Your Data Guard configuration consists of these components and settings: 1. A primary database 2. A remote physical standby database 3. Real-time query is enabled 4. Redo transport mode is synchronous 5. Protection mode is maximum availability 6. The Data Guard broker is used You notice that the standby destination fails to acknowledge reception of redo within NET_TIMEOUT period of time. Which is true is this scenario?

  1. Real-time query will be disabled on the physical standby.
  2. The protection mode will automatically change to Maximum Performance.
  3. Synchronous redo transport mode connections to the standby database are terminated.
  4. The physical standby database instance is shut down by the Data Guard broker.

Question 10

Which TWO statements are true regarding Data Guard Broker? (Choose two.)

  1. It automatically starts the DMON process for the database instances that are part of a Data Guard configuration.
  2. It can be used to create and manage standby databases.
  3. It can be used to monitor redo transport and log apply services.
  4. It automatically adds the primary database to an existing broker configuration when Enterprise Manager Cloud Control is used to create a standby.
  5. It can be used to perform failovers and switchovers.