Oracle 1z0-076 問題集

質問 1：
You are monitoring your Data Guard broker configuration and issue this set of DGMGRL commands:
DGMGRL> SHOW CONFIGURATION;
Configuration - DRSolution
Protection Mode: MaxPerformance
Databases:
Close_by - Primary database
FS_inst - Far Sync
Far_away - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
What is true concerning this configuration?
A. The FS_inst Far Sync instance forwards redo to the Far_away physical standby only if the Close_by primary database is not able to do so.
B. The Far Sync instance will not forward redo to the Far_away physical standby because Fast-Start Failover is disabled.
C. The Close_by primary database forwards redo to the Far_away physical standby directly and also sends redo to the FS_inst Far Sync instance.
D. The Close_by primary database instance forwards redo to the FS_inst Far Sync instance, which forwards the redo in turn to the Far_away physical standby database instance.
E. The Far Sync instance will not forward redo to the Far_away physical standby because the Protection mode is not MaxProtection.
正解：D

質問 2：
Examine the fast-start failover configuration:

A. A failover may occur if the observer has lost connectivity to the primary database, even if the Fast-Start Failover target standby database has a good connection to the primary database
B. The observer is running.
C. The observer will initiate a failover when the primary database is unable to produce local archived redo log files.
D. You must disable fast-start failover first to change the fast-start failover target to East sales.
E. If South_Sales develops a problem and cannot be the target of a failover, the broker automatically changes the fast-start failover target to one of the other candidate targets.
正解：A,B,C

質問 3：
Which three Data Guard monitoring activities may be performed using Enterprise Manager Cloud Control?
A. You can set a warning threshold on the redo generation rate metric for a physical standby database.
B. You can monitor the redo apply rate on a logical standby database.
C. You can check if redo apply needs to be tuned.
D. You can check the potential data loss in the event of a disaster.
E. You can set a critical threshold on the redo generation rate metric for a primary database.
F. You can monitor the redo apply rate on a snapshot standby database.
正解：B,D,E
解説: (Topexam メンバーにのみ表示されます)

質問 4：
Which three statements are true about redo transport?
A. Multiple RFS processes may receive redo on one far sync instance.
B. An RFS process on a standby database instance may receive redo from an archiver process on the primary database instance to perform archive gap resolution.
C. With asynchronous redo transport, TTnn processes may read redo from the log buffer or from standby redo logs on the primary database.
D. Multiple RFS processes may receive redo on one standby database instance.
E. With synchronous redo transport, LGWR ships redo directly to RFS processes on the standby database instances and waits for an acknowledgment.
正解：B,D,E

質問 5：
Which statement is true regarding Oracle Net connectivity for a Data Guard Broker configuration?
A. A TNS entry or entries enabling connectivity to standby database instance(s) must be defined on the primary database host.
B. The LOCAL_LISTENER initialization parameter must be set to the listener used to register the primary database instance.
C. To start SQL Apply on a logical standby database, a TNS entry enabling connectivity to the primary database instance must be defined on the logical standby database host.
D. A TNS entry enabling connectivity to the primary database instance must be defined on each of the standby database hosts.
E. To enable Real-Time Query on a physical standby database, a TNS entry enabling connectivity to the standby database instance must be defined on the primary database host.
正解：A