Which two statements are true regarding Data Guard Broker?
A.
It automatically adds the primary database to an existing broker configuration when Enterprise Manager
Cloud Control is used to create a standby.
B.
It automatically starts the DMON process for the database instances that are part of a Data Guard
configuration.
C.
It can be used to perform failovers and switchovers.
D.
It can be used to create and manage standby databases.
E.
It can be used to monitor redo transport and log apply services.
Explanation:
B: The Data Guard monitor process (DMON) is an Oracle background process that runs for every database
instance that is managed by the broker. When you start the Data Guard broker, a DMON process is created.
C: The following list describes some of the operations the broker automates and simplifies:
* Invoking switchover or failover with a single command to initiate and control complex role changes across all
databases in the configuration.
Etc.
Incorrect Answers:
E: Oracle Enterprise Manager works with the Data Guard monitor to automate and simplify the management of
a Data Guard configuration including:
* Performance tools and graphs that help you monitor and tune redo transport services and log apply services.
https://docs.oracle.com/cd/B28359_01/server.111/b28295/concepts.htm
I think the correct answer is C & E
Though “B. It automatically starts the DMON process for the database instances that are part of a Data Guard configuration” seems correct it may not. DMON process is started when you set the initialization parameter “db_broker_start=true”.
I think it’s C and D. E is not correct. You can monitor apply rate with show database command, but not log apply services.