1Z0-066試験無料問題集（112題）「Oracle Database 12c: Data Guard Administrator 認定」

出題：1

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
You 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 sheep to physical standby;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 cats to physical standby;

E. DGMGRL>edit configuration set protection mode as maxperformance;DGMGRL> convert database sheep to physical standby;

正解：C 解答を投票する

出題：2

Attempting to start the observer raises an error:
DGMGRL> start observer;
DGM-16954: Unable to open and lock the Observer configuration file Failed.
Identify two possible reasons for this error. (Choose two.)

A. There is another observer running for a Data Guard configuration which uses the same observer configuration file.

B. The observer configuration file is marked read-only.

C. The broker configuration has not yet been created.

D. There is already an observer running for this Data Guard configuration.

E. Fast-Start Failover is not yet enabled for this Data Guard configuration.

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

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

出題：3

Your expertise is requested for these customer requirements:
1. The Data Guard environment must be in maximum protection mode.
2. Reports must be offloaded to a physical standby database.
3. There must be no lag between the primary and standby databases that affect the reports produced.
4. 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 the
STANDBY_MAX_DATA_DELAY parameter set to zero, receiving redo from the primary with synchronous transport

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

D. 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. two standby databases, at least one of them a physical standby with Real-Time Query enabled and the STANDBY_MAX_DELAY parameter set to zero, receiving redo from the primary with asynchronous transport

正解：D 解答を投票する

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

出題：4

You have a Data Guard broker configuration consisting of:
1. A primary database
2. One local physical standby database
3. One far sync instance
4. A remote physical standby database
The broker configuration was created with the DGMGRL utility after creating all the databases and the far sync instance with command-line tools.
What is the correct way to add this configuration to Enterprise Manager Cloud Control assuming all the nodes have been discovered already as Enterprise Manager targets?

A. Discover the primary database as a target in Enterprise Cloud Control. Then discover the existing Data Guard Broker configuration for the primary and all the other databases in the configuration will be discovered as targets and be ready to be monitored.

B. Discover either of the physical standby databases as a target by refreshing the node on which they run, and the other databases and instances in the Data Guard Broker configuration will be discovered as targets automatically and be ready to be monitored.

C. Discover the primary as a target by refreshing the node on which it runs, and the other databases and instances in the Data Guard Broker configuration will be discovered as targets automatically and be ready to be monitored.

D. Delete the Data Guard Broker configuration using DGMGRL and then re-create it using Enterprise Manager Cloud Control to enable all the databases in the configuration to be discovered as targets and to be ready to be monitored.

E. Use the DGMGRL utility to register the configuration with the Enterprise manager Cloud Control agent on the primary database node. This will enable the discovery of all the other databases in the configuration as targets which will be ready to be monitored.

正解：D 解答を投票する

出題：5

Examine the Fast-start configuration:
DGMGRL> show fast_start failover;
Fast-Start Failover: ENABLED
Threshold : 30 seconds
Target: sheep
Observer : ol7.example.com
Lag Limit: 30 seconds (not in use)
Shutdown Primary: TRUE
Auto-reinstate: TRUE
Observer Reconnect: (none)
Observer Override: FALSE
Configurable Failover Conditions
Health Conditions:
Corrupted Controlfile YES
Corrupted Dictionary YES
Inaccessible Logfile NO
Stuck Archiver YES
Datafile Offline YES
Oracle Error Conditions:
(none)
Which three are true? (Choose three.)

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

B. The configuration operates in Maximum Availability mode.

C. 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.

D. An automatic failover will be initiated even if the target standby database lags behind the primary.

E. The observer is running.

F. The configuration operates in Maximum Performance mode.

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

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

出題：6

A customer asks you to propose the most appropriate solution for this set of requirements:
1. We need a disaster recovery solution that enables us to fail over from our production database with zero data loss.
2. We want to generate reports from the proposed standby database at the same time that it is used for other purposes.
3. Developers may need to test occasionally on a copy of the live database.
You have already confirmed that there are no unsupported data types on the primary database.
Which two solutions would you recommend? (Choose two.)

A. a remote physical standby database with RedoRoutes via a far sync instance

B. a physical standby database with real-time query enabled

C. a read mostly implementation of a physical standby database

D. a logical standby database

E. a snapshot standby database with synchronous redo transport

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

出題：7

Your Data Guard environment has one physical standby database using Real-Time Query.
Two sequences have been created by these SQL statements:
create sequence a global;
create sequence b session;
Neither sequence has been used since being created.
Session 1 connects to the primary database instance and issues these two SQL statements:
SELECT a.nextval FROM DUAL;
SELECT b.nextval FROM DUAL;
Then session 2 connects to the physical standby database instance and issues the same SQL statements.
What output will be seen for session 2?

A. Option D

B. Option C

C. Option A

D. Option B

正解：C 解答を投票する

出題：8

Which two are true about database roles in an Oracle Data Guard Configuration? (Choose two.)

A. A Logical Standby Database can be converted to a Snapshot Standby Database.

B. A Logical Standby Database can cascade redo to a terminal destination.

C. A configuration consisting only of a primary and one or more physical standby databases can support a rolling release upgrade.

D. A Snapshot Standby Database can be a fast-start failover target.

E. A Physical Standby Database can be converted into a Logical Standby Database.

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

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

出題：9

Examine this query and its output:
SQL> select fs_failover_status, fs_failover_current_target,
2 fs_failover_observer_present, fs_failover_oserver_host
3 from v$database:
FS_FAILOVER_STATUS FS_FAILOVER_CURRENT_TARGET
------------------ --------------------------
BYSTANDER cats
FS_FAILOVER_OBSERVER_PRESENT FS_FAILOVER_OBSERVER_HOST
---------------------------- -------------------------
NO ol7.example.com
Which are true?

A. The observer is not running, but should run on ol7.example.com.

B. Cats is a bystander database.

C. The observer is connected to the database on which the query was executed.

D. The observer is currently running on ol7.example.com.

E. The observer is not connected to the database on which the query was executed.

正解：E 解答を投票する

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

出題：10

Which two statements are true regarding Data Guard Broker? (Choose two.)

A. It can be used to create and manage standby databases.

B. It automatically starts the DMON process for the database instances that are part of a Data Guard configuration.

C. It can be used to monitor redo transport and log apply services.

D. It automatically adds the primary database to an existing broker configuration when Enterprise Manager Cloud Control is used to create a standby.

E. It can be used to perform failovers and switchovers.

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

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

1Z0-066試験無料問題集「Oracle Database 12c: Data Guard Administrator 認定」