[2026] Oracle Database 12c: Data Guard Administrator

문제1

Examine the Data Guard configuration after an accidental switchover to Sheep:
DGMGRL> show configuration;
Configuration Animals
Protection Mode: MaxAvailability
Databases:
sheep Primary database
dogs Logical standby database
cats Physical standby database (disabled)
ORA-16795: the standby database needs to be re-created
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
Which three will be true after a switchover to Dogs? (Choose three.)

A. Sheep will be an enabled logical standby database.

B. Cats will be an enabled physical standby database.

C. Dogs will be the primary database.

D. Cats will be a disabled physical standby database that can be manually enabled.

E. Sheep will be a disabled logical standby database.

정답: A,C,D

문제2

Which three are always benefits of using a logical standby database? (Choose three.)

A. It can be used for reporting workloads requiring additional indexes or materialized views or both.

B. It provides a disaster-recovery solution with switchover and failover options that can recover any data updated on the primary database.

C. It can be used as an updatable database for Real Application Testing and then converted back to a standby database without affecting the updates.

D. It can be used to replicate a single pluggable database (PDB) in a multitenant container database.

E. It can be used for database rolling release upgrades.

F. It can be used for testing patchsets without affecting the primary database.

정답: A,C,F

설명: (Fast2test 회원만 볼 수 있음)

문제3

Which two are true about the creation of a Data Guard Broker configuration? (Choose two.)

A. In a broker configuration, the primary database name must match the DB_UNIQUE_NAME value in the database initialization parameter file.

B. A primary database profile may be added to the configuration prior to creating the primary database.

C. A newly created broker configuration requires at least one standby database profile to be specified at the time the configuration is created.

D. A standby database profile may be added to the configuration prior to creating that standby database.

E. A newly created broker configuration is in the disabled state.

정답: C,E

설명: (Fast2test 회원만 볼 수 있음)

문제4

You are required to change the Data Guard Configuration protection mode from MAXPERFORMANCE to MAXAVAILABILITY using Enterprise Manager Cloud Control.
Which two are true about this change? (Choose two.)

A. The primary database instance will remain up and running, if it cannot write redo to at least one synchronized standby database.

B. Real time apply will be automatically turned on.

C. If the primary database cannot write its redo to at least one synchronized standby database, then the protection level remains unchanged.

D. Fast start failover can be enabled when making the chance.

E. Transactions will not commit until all redo data needed to recover those transactions are written to the online redo log, and to the standby redo log on at least one synchronizes standby database.

정답: A,E

설명: (Fast2test 회원만 볼 수 있음)

문제5

Examine the Data Guard configuration:
DGMGRL> show configuration verbose;
Configuration - Animals
Protection Mode: MaxPerformance
Databases:
cats - Primary database
dogs - (*) Physical standby database
sheep - Physical standby database
(*) Fast-Start Failover target
Properties:
FastStartFailoverThreshold = '30'
OperationTimeout = '30'
TraceLevel = 'USER'
FastStartFailoverLagLimit = '30'
CommunicationTimeout= '180'
ObserverReconnect= '10'
FastStartFailoverAutoReinstate= 'FALSE'
FastStartFailoverPmyShutdown= 'TRUE'
BystandersFollowRoleChange= 'none'
ObserverOverride = 'FALSE'
Fast-Start Failover: ENABLED
Threshold: 30 seconds
Target: dogs
Observer: ol5.example.com
Lag Limit: 30 seconds
Shutdown Primary:TRUE
Auto-reinstate: FALSE
Observer Reconnect: 10 seconds
Observer Override: TRUE
Configuration Status:
SUCCESS
Which two are true? (Choose two.)

A. The observer will detect if the primary database is unable to accept new connections.

B. The observer will mark another standby database as the failover target if the original failover target becomes unavailable.

C. The observer must run on host ol5.example.com and is currently not running.

D. The former primary database will not be reinstated automatically after a failover.

E. The observer will reinstate Sheep automatically after a failover, if required.

정답: D,E

설명: (Fast2test 회원만 볼 수 있음)

문제6

Your Data Guard environment consists of these components and settings:
1. A primary database
2. A remote physical standby database
3. Real-time query is enabled.
4. The redo transport mode is set to SYNC.
5. The protection mode is set to Maximum Availability.
You notice that queries executed on the physical standby database receive errors:
ORA- 03172: STANDBY_MAX_DATA_DELAY of 15 seconds exceeded.
Which two would you recommend to avoid this error? (Choose two.)

A. Change the protection mode to Maximum Protection.

B. Increase the size of the buffer cache on the standby database instance.

C. Increase the number of standby redo log files on the primary database.

D. Reduce I/O latency for the storage used by the primary database.

E. Increase the network bandwidth between the primary and standby databases.

F. Change the protection mode to Maximum Performance.

정답: E,F

설명: (Fast2test 회원만 볼 수 있음)

Oracle Database 12c: Data Guard Administrator - 1Z0-066무료 덤프문제 풀어보기

우리와 연락하기

유용한 링크

최신 업데이트