Oracle Database 12c: Data Guard Administrator - 1Z1-066 Exam Questions

QUESTION NO: 1
Examine the Data Guard configuration:
Properties:
FastStartFailoverThreshold= '30'
OperationTimeout= '30'
TraceLevel= 'USER'
FastStartFailoverLagLimit= '30'
CommunicationTimeout= '180'
ObserverReconnect= '10'
FastStartFailoverAutReinstate= 'TRUE'
FastStartFailoverPmyShutdown= 'TRUE'
BystandersFollowRoleChange= 'all'
ObserverOverride= 'FALSE'
Fast-Start Failover:ENABLED
Threshold:30 seconds
Target:dogs
Observer:prutser6.example.com
Lag Limit:30 seconds (not in use)
Shutdown Primary:TRUE
Auto-reinstate:TRUE
Observer Reconnect:10 seconds
Observer Override:
Configuration Status:
SUCCESS
What happens if you issue "failover to dogs;" at the DGMGRL prompt while connected to Dogs?

QUESTION NO: 2
Which three statements are true about Far Sync instances? (Choose three.)

QUESTION NO: 3
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.)

QUESTION NO: 4
Your Data Guard environment has two remote physical standby databases.
Client applications use the local naming method to define connectivity to the primary database instance.
Which will automatically redirect clients to the new primary database in case of a switchover or failover?

QUESTION NO: 5
Which three are benefits of using the Data Guard Broker to manage standby databases? (Choose three.)

QUESTION NO: 6
You must propose an Oracle Data Guard configuration for a database supporting a DSS workload that meets these permanent requirements:
1. The performance impact on the primary database should be kept to a minimum.
2. Creating and maintaining materialized views should not impact the performance of the primary database.
Additionally, there are these requirements, only the one of which is ever done at any one time:
3. It should be possible to apply designated patches with a minimum amount of downtime.
4. Upgrading to a new database release should be performed with the least possible amount of downtime.
5. New application software releases should be tested against an exact up-to-date replica of the production database.
You propose a configuration operating in Maximum Performance mode with a primary database and one logical standby database.
Which requirements do you meet?

QUESTION NO: 7
Which two statements are true about Far Sync instances? (Choose two.)

QUESTION NO: 8
Examine the Fast-start configuration:
DGMGRL> show fast_start failover;
Fast-Start Failover: ENABLED
Threshold : 30 seconds
Target: sheep
Observer : ol7.example.com
Lag Limit: 30 seconds (not in use)
Shutdown Primary: TRUE
Auto-reinstate: TRUE
Observer Reconnect: (none)
Observer Override: FALSE
Configurable Failover Conditions
Health Conditions:
Corrupted Controlfile YES
Corrupted Dictionary YES
Inaccessible Logfile NO
Stuck Archiver YES
Datafile Offline YES
Oracle Error Conditions:
(none)
Which three are true? (Choose three.)

QUESTION NO: 9
Which two are true about offloading backups to a physical standby database in a Data Guard environment?
(Choose two.)