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

出題：1

You must design an Oracle Data Guard configuration for a DSS database that meets these permanent requirements:
1. Creating and maintaining bitmap indexes should not impact the performance of the primary database.
2. Creating and maintaining materialized views should not impact the performance of the primary database.
Additionally, there are these requirements, only one of which is ever done at any one time:
1. It should be possible to apply designated patches with a minimum amount of downtime.
2. Upgrading to a new database release should be performed with the least possible amount of downtime.
3. New application software releases should be tested against an exact and up-to-date replica of the primary database.
Which configuration meets these requirements with the fewest of databases?

A. a primary database with one logical standby database

B. a primary database with one physical standby database

C. a primary database with two logical standby databases

D. A primary database with one logical and one physical standby database

E. a primary database with two physical standby databases

正解：A 解答を投票する

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

出題：2

Which two statements are true when using non-rolling release upgrades in a Data Guard environment?

A. The compatible parameter on a standby database that is applying redo, must be equal to or greater than the compatible parameter on the primary that is shipping redo to that standby.

B. During the upgrade of a logical standby database, standby redo log files must reside on O/S file systems.

C. Modifications to the data dictionary on the primary database caused by the upgrade, are applied on a logical standby database.

D. User equivalence must be established for the owner of the Oracle software on the affected hosts prior to the upgrade.

E. Modifications to the data dictionary on the primary database caused by the upgrade, are applied on a physical standby database.

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

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

出題：3

Which three are prerequisites for enabling Fast-Start Failover?

A. You can specify only one standby database as the fast-start failover target.

B. The configuration must be operating in either Maximum Performance or Maximum Protection mode.

C. The maximum protection mode can be used, but with two or more standby databases.

D. The Data Guard environment must be managed by the Data Guard Broker.

E. Flashback Database must be enabled only on the Fast-Start Failover target standby database.

F. Flashback Database must be enabled on both the primary database and the Fast-Start Failover target standby database.

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

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

出題：4

Examine the Data Guard configuration:
DGMGRL> show configuration;
Configuration - Animals
Protection Mode: Max Availability
Databases:
dogs - Primary database sheep
- Physical standby database cats
- Physical standby database
Fast-Start Failover: DISABLED
Configuration Status: SUCCESS
An attempt to enable fast-start failover raises an error:
DGMGRL> enable fast_start failover;
Error: ORA-16693: requirements not met for enabling fast-start failover Failed.
Identify three possible reasons for this error.

A. The LogxptModr property is set to async on Sheep while Sheep is the target standby database.

B. The LogXptMode property is set to fastsync on Dogs.

C. The LogXptMode property is set to async on Dogs.

D. The LogXptMode property is set to FASTSYNC on Cats while Sheep is the target standby database.

E. The fastStartFailoverTarget property is not set on Dogs.

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

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

出題：5

Examine the Data Guard configuration:

What happens if you issue "switchover to sheep;" at the DGMGRL prompt?

A. The switchover succeeds and Cats becomes the new failover target.

B. The switchover succeeds but Dogs needs to be reinstated.

C. It results in an error indicating that a switchover is not allowed.

D. The switchover succeeds and Fast-Start Failover is suspended.

E. The switchover succeeds and Dogs becomes the new failover target.

正解：E 解答を投票する

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

出題：6

Which THREE statements are true........ open in real time query mode, which becomes a new.

A. Sessions that have long running queries can be retained.

B. User sessions can be retained.

C. User sessions and Current Buffers are maintained by default.

D. All sessions are disconnected and all

E. All current buffers can be retained.

F. Sessions that are using database links

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

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

出題：7

Examine the fast-start failover configuration:

A. A failover may occur if the observer has lost connectivity to the primary database, even if the Fast-Start Failover target standby database has a good connection to the primary database

B. The observer will initiate a failover when the primary database is unable to produce local archived redo log files.

C. You must disable fast-start failover first to change the fast-start failover target to East sales.

D. If South_Sales develops a problem and cannot be the target of a failover, the broker automatically changes the fast-start failover target to one of the other candidate targets.

E. The observer is running.

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

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