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

出題：1

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

出題：2

Which THREE statements are TRUE about Global Sequences when connected to a physical standby database with Real-Time Query enabled?

A. If the CACHE option is set then the size of the cache must be at least 100.

B. Their usage may have a performance impact on the physical standby database if the CACHE size is too small.

C. Their creation requires that a LOG archive_dest_n parameter be defined in the standby that points back to the primary.

D. Their usage will always have a performance impact on the primary database.

E. They must have the NOORDEK and CACHE options set.

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

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

出題：3

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. The performance of SQL apply on a logical standby database always improves when using this transport mode.

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

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

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

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

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

出題：4

You must configure an Oracle Data..........
1. A primary database
2. A physical standby database
Examine these requirements: 1. Data loss is not permitted.
1. Data loss is not permitted.
2. It should be possible to convert the physical standby database to a snapshot standby database.
3. Under normal operations, transactions should commit when redo is written to disk on the primary database and as soon as it has been received by the standby database instance.
4. The availability of the primary database should not be compromised by the availability of the standby database.
5. It should be possible to convert the physical standby database to a logical standby database
6. It should be possible to deploy Real Application Clusters on the primary database.
7. It should be possible to deploy Real Application Clusters on the physical standby database.
You configure SYNC redo transport mode in combination with Maximum Protection mode.

A. 1, 2, 6, and 7

B. 1, 2, 3, 6, and 7

C. 1, 2, and 5

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

E. 1, 6, and 7

正解：D 解答を投票する

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

出題：5

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

出題：6

Active Data Guard (ADG) databases are widely used to offload reporting or ad hoc query-only jobs from the primary database. Reporting workload profile is different from the primary database and often requires tuning.
Which tool is used to tune SQL workloads running on an ADG database?

A. Standby Statspack

B. SQL Tuning Advisor

C. Automatic Workload Repository (AWR)

D. Automatic Diagnostic Database Monitor (ADDM)

E. In-Memory Active Session History (ASH)

正解：C 解答を投票する

解説: (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 認定」