1z1-076試験無料問題集（72題）「Oracle Database 19c: Data Guard Administration 認定」

出題：1

Examine the Data Guard configuration: DGMGRL> show configuration;
Configuration - Animals
Protection Mode: MaxPerformance
Databases:
dogs- Primary database
sheep - Physical standby database
cats- Snapshot standby database
Fast-Start Failover: DISABLED
Configuration Status: SUCCESS
You receive an error while attempting to raise the protection mode to Maximum Protection:
DGMGRL> edit configuration set protection mode as maxprotection;
Error: ORA-16627: operation disallowed since no standby databases would remain to support protection mode Failed.
What can you conclude based on this error?

A. The redo transport mode is set to async for both standby databases.

B. Cats is a snapshot standby database.

C. The redo transport mode is set to async for the standby database Sheep.

D. The redo transport mode is set to asyn: for the standby database Cats.

正解：B 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：2

You must configure on Oracle Data .......
1. A primary database
2. Three Physical Standby Databases
Examine these requirements:
A designated physical standby database should become the primary database automatically whenever the primary database fails.
2. The chosen protection mode should provide the highest level of protection possible without violating the other requirement.
Which redo transport mode and protection mode would you configure to meet these requirements?

A. SYNC and Maximum Protection

B. FASTSYNC and Maximum Availability

C. ASYNC and Maximum Performance

D. FASTSYNC and Maximum Protection

正解：B 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：3

Which FOUR database parameters might be affected by or influence the creation of standby databases?

A. STANDBY_ARCHIVE_DEST

B. ARCHIVE_LAG_TARGET

C. db_file_name_convert

D. FALSERVER

E. DB_NAME

F. COMPATIBLE

正解：A,C,E,F 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：4

Which three actions are performed by the START PLAN procedure of the DBMS ROLLING package?

A. starting media recovery on all the Leading Group Standby databases

B. creating a guaranteed restore point on the primary database

C. converting the designated physical standby database into a logical standby database

D. creating a guaranteed restore point on the standby databases

E. switching the primary database to the logical standby role

F. building a LogMiner dictionary on the primary database instance

正解：B,D,F 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：5

Which TWO statements are true about Real-Time Query?

A. A standby database enabled for Real-Time Query cannot be the Fast-Start Failover target of the Data Guard configuration.

B. Disabling Real-Time Query prevents the automatic start of redo apply when a physical standby databases opened read only.

C. Real-Time Query has no limitations regarding the protection level of the Data Guard environment.

D. Setting standby_max_data_delay=0 requires synchronous redo transport.

E. Real-Time Query sessions can be connected to a Far Sync instance.

正解：B,D 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：6

Which three Data Guard monitoring activities may be performed using Enterprise Manager Cloud Control?

A. You can check if redo apply needs to be tuned.

B. You can monitor the redo apply rate on a logical standby database.

C. You can check the potential data loss in the event of a disaster.

D. You can set a critical threshold on the redo generation rate metric for a primary database.

E. You can monitor the redo apply rate on a snapshot standby database.

F. You can set a warning threshold on the redo generation rate metric for a physical standby database.

正解：B,C,D 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：7

Examine this list of possible steps:
1. Raise the compatibility level on both databases.
2. Restart SQL Apply on the upgraded logical standby database.
3. Start SQL Apply on the old primary database.
4. Perform a Switchover to the logical standby database.
5. Upgrade the logical standby database.
6. Upgrade the old primary database.
Which is the minimum number of steps in the correct order, to perform a rolling release upgrade of a data guard environment using an existing logical standby database and to enable the new functionality?

A. 5,2,4,3,6,1

B. 4,6,5,2,3,1

C. 5,2,4,1

D. 5,2,4,6,3,1

E. 1,5,2,4,6,3

正解：E 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

1z1-076試験無料問題集「Oracle Database 19c: Data Guard Administration 認定」