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

出題：1

Which THREE statements are true about Far Sync instances?

A. The Data Guard Broker must be used to deploy and manage Far Sync instances.

B. They enable standby databases to be configured at remote distances from the primary without impacting performance on the primary.

C. A primary database can ship redo directly to multiple Far Sync instances.

D. They work with any protection level.

E. They use an spfMe, a standby controlfile, and standby redo logs.

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

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

出題：2

You notice that the SQL apply lag on your logical standby database has increased but the redo transport lag has not.
Which four could be reasons for the increase in SQL apply lag?

A. Many SQL apply operations do full table scans

B. An increased number of bulk updates on the primary

C. An undersized shared pool

D. An undersized undo tablespace on the logical standby

E. The standby redo log files are undersized on the primary database

F. An increased number of bulk inserts on the primary

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

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

出題：3

Examine the following parameter settings of the physical standby database:
* STANDBY_FILE_MANAGEMENT=AUTO
* ENABLED_PDBS_ON_STANDBY=<null>
During which TWO tasks are files automatically created in the physical standby database after structure changes on the primary database?

A. Renaming a data file in the primary database

B. Adding or dropping a redo file group

C. Performing transportable tablespaces

D. Adding a data file or creating a tablespace

E. Creating a PDB from the existing PDB within the same CDB

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

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

出題：4

Which two statements are true regarding Data Guard environments in an Oracle Muti-tenant architecture?

A. Different redo transport methods can be configured for different pluggable databases within one Data Guard environment.

B. A Data Guard environment with a multi-tenant primary database can operate in any Protection mode.

C. Standby redo log files are required for each pluggable database that is protected with Data Guard.

D. The Data Guard broker may be used for multi-tenant databases.

E. PDB_FILE_NAME CONVERT must be set to enable creation of standby databases if they are created on the same host as the primary.

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

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

出題：5

Which four requirements can be met by deploying a logical standby database?

A. It must have the same physical structure as the primary database.

B. It can be used to create additional schemas.

C. Support for workloads requiring additional indexes.

D. Support for workloads requiring additional materialized views.

E. It must provide a disaster-recovery solution that protects all data with capability of performing switchovers and failovers.

F. It can be used to create additional tables.

G. It can be used for Real Application Testing without affecting the disaster recovery capabilities.

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

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

出題：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?

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

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

C. Change the protection mode to Maximum Protection.

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

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

F. Change the protection mode to Maximum Performance.

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

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

出題：7

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 メンバーにのみ表示されます)

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