Oracle Database 19c: Data Guard Administration

문제1
Which two statements are true regarding asynchronous redo transport in a Data Guard

A. A transaction can commit without waiting for redo to be sent to any standby database in the data guard configuration.

B. This transport mode satisfies the minimum requirements for Maximum Availability data protection mode.

C. Real-time query performance on a physical standby database improves for current read requests when using this transport mode.

D. The performance of SQL apply on a logical standby database always improves when using this transport mode.

E. This transport mode satisfies the minimum requirements for Maximum Performance data protection mode.

정답: A,E

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

문제2
Which three are prerequisites for enabling Fast-Start Failover?

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

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

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

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

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

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

정답: A,E,F

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

문제3
Your Data Guard environment consists of these components and settings:
1. A primary database
2. Two remote physical standby databases
3. The redo transport mode is set to sync
4. Real-time query is enabled for both standby databases
5. The DB_BLOCK_CHECKING parameter is set to TRUE on both standby databases You notice an increase in redo apply lag time on both standby databases.
Which two would you recommend to reduce the redo apply lag on the standby databases?

A. Increase the size of standby redo log files on the standby databases.

B. Decrease the redo log file size on the primary database.

C. Lower DB_BLOCK_CHECKING to MEDIUM or low on the standby databases.

D. Increase the size of the buffer cache on the physical standby database instances.

E. Increase the number of standby redo log files on the standby databases.

정답: A,C

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

문제4
On your logical standby database, you specified these rules:

After completion of the weekend batch cycle you attempt to delete the SQL Apply filters:

Which is TRUE regarding the execution of the UNSKIP procedure?

A. It deletes both the SQL Apply filters.

B. It returns an error because the syntax to delete a SQL Apply filter must specify the same object names as specified when the filter was added.

C. It succeeds but the SQL Apply filters are not deleted.

D. It succeeds only if all DML statements executed on the primary have been applied on the logical standby deleting the SQL Apply filter.

E. It succeeds only if SQL apply is stopped before deleting the SQL Apply filter.

정답: A

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

문제5
Which three are prerequisites for using Data Guard Broker?

A. The primary and standby databases must run the same version of the Oracle Database server.

B. DG_BROKEB_START must be set to TRUE for a database instance before adding the database to the broker configuration.

C. The broker configuration files for a RAC database must reside in shared storage accessible by all the RAC database instances.

D. Network connectivity to the primary database instance must be defined on the servers hosting the standby database instances.

E. If any database in the configuration is a RAC database, then the broker configuration files must reside in shared storage accessible by all database instances for all databases in the broker configuration.

F. A statically defined listener end-point must be registered with the local listener on the servers hosting the standby database instances.

정답: A,D,E

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

문제6
Your expertise is requested for these customer requirements:
The Data Guard environment must be in maximum protection mode.
Reports must be offloaded to a physical standby database.
There must be no lag between the primary and standby databases that affect the reports produced.
The primary database must be resilient in case of a single network failure.
Which solution is correct for these requirements?

A. Two physical standby databases with Real-Time Query enabled, receiving redo from the primary with the LOG_ARCHIVE_DEST_n attributes SYNC NOAFFIRM to minimize the performance impact on the primary

B. One physical standby database with Real-Time Query enabled and STANDBY_MAX_DATA_DELAY parameter set to zero, receiving redo from the primary with synchronous transport

C. Two standby databases, at least one of them a physical standby with Real-Time Query enabled and the STANDBY_MAX_DATA_DELAY parameter set to zero, receiving redo from the primary with asynchronous transport

D. One physical standby database with Real-Time Query enabled, receiving redo from two Far Sync instances that are connected to the primary

E. Two standby databases, at least one of them a physical standby with Real-Time Query enabled and the STANDBY_MAX_DATA_DELAY parameter set to zero, receiving redo from the primary with synchronous transport

정답: E

문제7
Your current Data Guard environment consists of:
A primary database containing no abstract data types used for user tables.
Two separate remote physical standby databases used for reporting.
Examine these requirements for adding a new standby database to this Data Guard environment:
The new standby database must provide a disaster recovery solution.
There must be minimal additional performance overheads on the primary database.
The new standby database may require additional indexes and materialized views not present in the primary.
New tables or schemas may be required in the standby database that are not present in the primary.
What would you recommend to fulfill these requirements?

A. A logical standby database with synchronous redo transport and redo apply on.

B. A physical standby database with asynchronous redo transport and Real-Time Query enabled.

C. A logical standby database with asynchronous redo transport and SQL apply on.

D. A physical standby database with synchronous redo transport and Real-Time Query enabled.

E. A logical standby database with synchronous redo transport and SQL apply on.

정답: C

문제8
Which three are true about using RMAN in a Data Guard environment?

A. Backups of archived redo logs taken on a physical standby are interchangeable with a primary.

B. Backups of data files taken on a physical standby are interchangeable with a primary.

C. Backups of control files taken on a physical standby are not interchangeable with a primary.

D. A recovery catalog is required when RMAN is used to take backups from a physical standby database if you plan to recover the primary using those backups.

E. A recovery catalog is required when RMAN is used to take backups from a logical standby database in a Data Guard configuration if you plan to recover the primary using those backups.

정답: A,B,C

문제9
Which two are true about the use of RMAN recovery catalogs when offloading backups to a physical standby database?

A. It is not necessary to use a recovery catalog unless a far sync instance is used to route redo to the physical standby database.

B. It backups that are offloaded to a physical standby database are taken when not connected to a recovery catalog, then they may still be used for restoration on the primary database.

C. The physical standby database may be used to register the database in the recovery catalog, if the primary is not registered.

D. The primary and physical standby databases must be registered separately in the recovery catalog, if a far sync instance is used to route redo to the physical standby database.

E. Primary and physical standby databases may use different virtual recovery catalogs in the same physical recovery catalog.

정답: B,E

최신Oracle Database 19c: Data Guard Administration - 1z0-076무료샘플문제

KoreaDumps의 제품으로 GO GO GO !

자격증의 중요성:

KoreaDumps 제품의 가치:

무료샘플 받아보기:

완벽한 서비스 제공: