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

質問 1

Your Data Guard environment contains a primary database and three standby databases with these attributes:
1. prod : Primary database
2. prod_prq : Physical standby database with real-time query enabled used by reporting applications
3. prod_lsby: Logical standby database used by DSS
4. PROD_SSBY: Snapshot standby database used for Real Application Testing Which TWO can be used to prevent clients from connecting to the wrong database instance?

（A）Create database services on each of the standby databases, start the services, and add connection descriptors on the clients to connect to those services.

（B）Establish Oracle Net connectivity to the primary database instance from all the standby database instances.

（C）Create database services for each database and use event triggers to make sure that services are activated only when the database is in the correct role.

（D）Create a static service for each of the databases, register it with the local listener of each database instance, and add connection descriptors on clients to connect to those services.

（E）Create role based services with the si vet] utility when using clusterware for Oracle RAC databases or Oracle Restart for single instance Oracle databases.

正解：A、C 解答を投票する

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

質問 2

Which THREE statements are TRUE about the supported workload in Active Data Guard standby databases?

（A）Read-mostly reporting applications that use global temporary tables for storing temporary data can be offloaded.

（B）PL/SQL blocks that you run on Active Data Guard standby databases can be always redirected to and run on the primary database.

（C）The DML operations on a standby can be transparently redirected to and run on the primary database

（D）The DDL operations on private temporary tables are transparently redirected to the primary database.

（E）You might have to use sequences with global temporary tables to support read-mostly applications by using Active Data Guard.

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

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

質問 3

Examine the Data Guard configuration:
DGMGRL> show configuration;
Configuration - Animals
Protection Mode: MaxAvailability
Databases:
dogs - Primary database
cats - Snapshot standby database
sheep - Snapshot standby database
Fast-Start Failover: DISABLED
Configuration Status:
ORA-01034: ORACLE not available
ORA-16625: cannot reach database "dogs"
DGM-17017: unable to determine configuration status
ou wish to perform a failover to sheep. Which command, or sequence of commands, should you issue to the broker before executing failover to sheep; using the broker?

（A）DGMGRL> convert database cats to physical standby;

（B）DGMGRL> convert database sheep to physical standby;

（C）None, because you can directly failover to a Snapshot Standby Database.

（D）DGMGRL> convert database sheep to physical standby;
DGMGRL> edit configuration set protection mode as maxperformance;
DGMGRL> convert database sheep to physical standby;

（E）DGMGRL> convert database cats to physical standby;

正解：B 解答を投票する

質問 4

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）ASYNC and Maximum Performance

（B）FASTSYNC and Maximum Protection

（C）SYNC and Maximum Protection

（D）FASTSYNC and Maximum Availability

正解：D 解答を投票する

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

質問 5

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

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

（B）It can be used to create additional tables.

（C）It can be used to create additional schemas.

（D）It must have the same physical structure as the primary database.

（E）It can be used for Real Application Testing without affecting the disaster recovery capabilities.

（F）Support for workloads requiring additional materialized views.

（G）Support for workloads requiring additional indexes.

正解：B、E、F、G 解答を投票する

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

質問 6

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 LogXptMode property is set to async on Dogs.

（B）The fastStartFailoverTarget property is not set on Dogs.

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

（D）The LogXptMode property is set to fastsync on Dogs.

（E）The LogxptModr property is set to async on Sheep while Sheep is the target standby database.

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

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

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

弊社を連絡する

関連リンク

トップ試験