1z0-066 Free Practice Test

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?

1. A. SYNC AFFIRM and Maximum Protection
2. B. SYNC NOAFFIRM and Maximum Protection
3. C. SYNC AFFIRM and Maximum Availability
4. D. SYNC NOAFFIRM and Maximum Availability
5. E. ASYNC and Maximum Performance

Correct Answer: C

Which three statements are true about Data Guard configurations?

1. A. All databases in one Data Guard environment must have the same database name.
2. B. VALID_FOR is a LOG_ARCHIVE_DEST_N attribute that enables DB role change operations without having to modify LOG_ARCHIVE_DEST_nwhen performing switchovers or failovers.
3. C. For Standard Edition, LOG_ARCHIVE_DUPLEX_DEST is used to configure redo transport, from the primary to the standby database.
4. D. When using the Data Guard Broker, an spfile is not required.
5. E. Up to 30 physical standby databases may exist within one configuration.
6. F. The Oracle recommendation for the number of standby redo log groups per thread is one more than the number of online redo log groups per thread

Correct Answer: AEF

Examine the Data Guard configuration:
<>

1. A. The FastStartFailoverTarget property is not set on Sheep.
2. B. The FastStartFailoverTarget property is not set on Dogs.
3. C. The FastStartFailoverTarget property is not set on DogsFSI.
4. D. The LogXptMode property is set to ASYNC on Dogs.
5. E. The RedoRoutes property is not set on Dogs
6. F. The RedoRoutes property is not set on DogsFSI

Correct Answer: AD

Examine the Data Guard configuration:
<>

1. A. Sheep will be an enabled logical standby database.
2. B. Cats will be an enabled physical standby database
3. C. Dogs will be the primary database
4. D. Sheep will be a disabled logical standby database
5. E. Cats will be a disabled physical standby database

Correct Answer: BCE

Examine the Data Guard configuration:
<>

1. A. Sheep will be an enabled logical standby database.
2. B. Cats will be an enabled physical standby database
3. C. Dogs will be the primary database
4. D. Sheep will be a disabled logical standby database
5. E. Cats will be a disabled physical standby database

Correct Answer: BCE