1Z0-076 practice question 12 of 25

Which TWO statements are true regarding Data Guard Broker?

Full set: 107 questions
Answer options
A: It can be used to create and manage standby databases.
B: It can be used to perform failovers and switchovers. Correct answer
C: It automatically starts the DMON process for the database instances that are part of a Data Guard configuration.
D: It can be used to monitor redo transport and log apply services. Correct answer
E: It automatically adds the primary database to an existing broker configuration when Enterprise Manager Cloud Control is used to create a standby.
Correct Answer:
B. It can be used to perform failovers and switchovers.; D. It can be used to monitor redo transport and log apply services.
Explanation

The Data Guard Broker is a framework that automates and centralizes the management and monitoring of a Data Guard configuration. Two of its primary functions are simplifying role transitions and providing comprehensive monitoring. It allows administrators to perform complex switchover and failover operations with a single command. It also provides a consolidated view of the entire configuration's health, including the status of redo transport and log apply services, apply lag, and transport lag, making it easy to monitor the environment.

Why Incorrect

A. The Broker manages an existing Data Guard configuration; it does not create the standby database itself. Standby creation is done with tools like RMAN or Enterprise Manager.
C. The DMON process is started by the database instance when the DGBROKERSTART parameter is set to TRUE, not directly by the Broker.
E. When creating a configuration, you add the primary first. You cannot add a primary to an existing configuration, as it can only have one primary.

References

1. Oracle Database Data Guard Broker, 19c, F10242-07, Chapter 1, "Introduction to Oracle Data Guard Broker". It states the broker's benefits include "Simplified, centralized, and extended management" and "Simplified switchovers and failovers".

2. Oracle Database Data Guard Broker, 19c, F10242-07, Chapter 6, "Managing and Monitoring a Broker Configuration". This chapter details monitoring capabilities, stating you can "monitor the overall health of the configuration, a specific database, or an instance of a database."

3. Oracle Database Data Guard Broker, 19c, F10242-07, Chapter 7, "Performing Role Transitions". This chapter details the SWITCHOVER and FAILOVER commands.

Scroll to Top