Oracle 1Z0-066 問題集

質問 1：
You administer a Data Guard environment with a primary and two physical standby databases.
One of the physical standby databases is used for reporting and is on the same host as the primary database.
The other physical standby database is remote, used for disaster recovery and REDO is routed to it via a far sync instance.
Backups are offloaded to the remote physical standby.
Which three are true concerning the management of archive logs in this Data Guard configuration? (Choose three.)
A. Archive logs on the primary database may be deleted once they are applied on all standby databases.
B. Archive logs on the primary database may be deleted once they are archived locally to disk.
C. Archive logs on the primary database may be deleted once they are shipped on all standby databases.
D. The deletion policy for archive logs on the remote physical standby should be set so that archived logs are deleted once they are applied on all standby databases.
E. The deletion policy for archive logs on the remote physical standby should be set so that archived logs are deleted once they backed up at least once on the remote physical standby database.
正解：A,B,D

質問 2：
Which three are true about disabling of the Data Guard Broker management of databases in a configuration and the effects of doing this? (Choose three.)
A. The only way to disable broker management of the primary database is to use the disable configuration DGMGRL command.
B. The configuration transport mode may be modified while the entire configuration is disabled from broker management.
C. The only way to disable broker management of a far sync instance is to use the disable configuration DGMGRL command.
D. Database properties may be modified when that database is disabled from broker management.
E. A standby database that is the fast start failover target, may be disabled from broker management only by using the disable database DGMGRL command.
正解：A,D,E

質問 3：
Examine the Data Guard configuration:
DGMGRL> show configuration;
Configuration - Animals
Protection Mode: MaxAvailability
Databases:
dogs - Primary database
sheep - (*) Physical standby database
cats - Physical standby database
Fast-Start Failover: ENABLED
Configuration Status:
SUCCESS
What happens if you issue "switchover" to sheep;" at the DGMGRL prompt?
A. The switchover succeeds and Dogs become the new failover target.
B. The switchover succeeds and Cats become the new failover target.
C. It results in an error indicating that a switchover is not allowed.
D. The switchover succeeds but Fast-Start Failover is suspended.
E. The switchover succeeds but Dogs need to be reinstated.
正解：A

質問 4：
A customer asks you to propose the most appropriate solution for this set of requirements:
1. We need a disaster recovery solution that enables us to fail over from our production database with zero data loss.
2. We want to generate reports from the proposed standby database at the same time that it is used for other purposes.
3. Developers may need to test occasionally on a copy of the live database.
You have already confirmed that there are no unsupported data types on the primary database.
Which two solutions would you recommend? (Choose two.)
A. a remote physical standby database with RedoRoutes via a far sync instance
B. a logical standby database
C. a read mostly implementation of a physical standby database
D. a physical standby database with real-time query enabled
E. a snapshot standby database with synchronous redo transport
正解：D,E

質問 5：
You must configure an Oracle Data Guard environment consisting of:
1. A primary database
2. A Physical Standby Database
3. A Snapshot Standby Database
You must meet these requirements:
1. Primary database availability should not be compromised by the availability of the standby databases.
2. Under normal operations, transactions executed on the primary database should not commit before redo is written to disk on the primary database and on at least one standby database.
Which redo transport mode, and which protection mode should you configure to meet these requirements?
A. SYNC AFFIRM and Maximum Protection
B. SYNC AFFIRM and Maximum Availability
C. ASYNC and Maximum Performance
D. SYNC NOAFFIRM and Maximum Protection
E. SYNC NOAFFIRM and Maximum Availability
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 6：
Which two statements are true regarding Data Guard Broker? (Choose two.)
A. It automatically starts the DMON process for the database instances that are part of a Data Guard configuration.
B. It automatically adds the primary database to an existing broker configuration when Enterprise Manager Cloud Control is used to create a standby.
C. It can be used to create and manage standby databases.
D. It can be used to perform failovers and switchovers.
E. It can be used to monitor redo transport and log apply services.
正解：A,D
解説: (Topexam メンバーにのみ表示されます)