Which three are benefits of using the Data Guard Broker to manage standby databases?
A.
It simplifies physical standby database creation.
B.
It provides an easy failover capability using a single command.
C.
It coordinates database state transitions and updates database properties dynamically.
D.
It automatically changes database properties after the protection mode for a configuration is changed.
E.
It provides an easy switchover capability using a single command.
F.
It simplifies logical standby database creation.
G.
It load balances connections between the primary and all the standby database instances that are open as read-only for reporting.
Why is D incorrect?
“Why is D incorrect?”
That’s an interesting question. From the documentation, it specifically says:
“When you set values for database properties in the broker configuration, the broker records the change in the configuration file and propagates the change to all of the databases in the Data Guard configuration.”
However, if the question is specifically asking “using the Data Guard Broker to manage STANDBY DATABASES” – then the broker will not make any change on the STANDBY DATABASE following a change in protection mode. I am quite sure that it will make a change of property on the primary database (log_archive_dest_x specifically). This is the only reason I can imagine that D is “wrong”.
As given, BCE are all definitely correct.
B,C,E
D is bit confusing but I believe B,C,E are definite.
D is incorrect becasuse you cannot change protection mode if the redo transport properties are not set correctly.
Check Question 46