최신 1z0-076 무료덤프 - Oracle Database 19c: Data Guard Administration

문제1

Examine the Data Guard configuration: DGMGRL> show configuration;
Configuration - Animals
Protection Mode: MaxPerformance
Databases:
dogs- Primary database
sheep - Physical standby database
cats- Snapshot standby database
Fast-Start Failover: DISABLED
Configuration Status: SUCCESS
You receive an error while attempting to raise the protection mode to Maximum Protection:
DGMGRL> edit configuration set protection mode as maxprotection;
Error: ORA-16627: operation disallowed since no standby databases would remain to support protection mode Failed.
What can you conclude based on this error?

A. The redo transport mode is set to async for the standby database Sheep.

B. The redo transport mode is set to async for both standby databases.

C. Cats is a snapshot standby database.

D. The redo transport mode is set to asyn: for the standby database Cats.

정답: C

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

문제2

You have a Data Guard broker configuration consisting of:
A primary database
One local physical standby database
One far sync instance
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. 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.

B. Discover the primary database as a target in Enterprise Manager 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.

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

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

정답: B

문제3

Which three Data Guard monitoring activities may be performed using Enterprise Manager Cloud Control?

A. You can check the potential data loss in the event of a disaster.

B. You can set a critical threshold on the redo generation rate metric for a primary database.

C. You can monitor the redo apply rate on a snapshot standby database.

D. You can monitor the redo apply rate on a logical standby database.

E. You can set a warning threshold on the redo generation rate metric for a physical standby database.

F. You can check if redo apply needs to be tuned.

정답: A,B,D

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

문제4

Which THREE statements are true about snapshot standby databases?

A. A snapshot standby database may be opened read-write.

B. FLASHBACK DATABASE is enabled automatically on a snapshot standby database after converting it from a physical standby database if not already enabled.

C. FLASHBACK DATABASE is enabled automatically on a physical standby database as part of the conversion into a snapshot standby database, if not already enabled.

D. A snapshot standby database may be opened read-only.

E. A snapshot standby database can have Real-Time apply enabled.

F. FLASHBACK DATABASE must be manually enabled on a physical standby database before converting it into a snapshot standby database.

정답: A,B,C

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

문제5

You created two remote physical standby databases using SQL and RMAN.
The primary database is a four-instance RAC database and each physical standby database has two instances.
Roles-based services are used for client connectivity and have been defined in the Grid Infrastructure.
Consider these operational requirements:
* The ability to manage multiple standby databases with a single tool
* The simplification of switchovers, failovers, reinstatements, and conversions to and from snapshot standby databases
* The automation of failovers to a specified target standby database
Which TWO tools can be used to fulfill these requirements7

A. Enterprise Manager Cloud Control

B. CRSCTL

C. RMAN

D. SRVCTL

E. GDCCTL

F. SQL*Plus

G. DGMGRL

정답: A,G

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

문제6

Which TWO statements are true about Far Sync instances?

A. They work in Maximum Protection mode.

B. They do not work with Logical Standby databases.

C. They do not work with Snapshot Standby databases.

D. They work in Maximum Availability mode.

E. They work in Maximum Performance mode.

정답: B,E

문제7

Which three are true concerning database states after a successful switchover?

A. If the former primary database became a logical standby database it will be in mount state.

B. If the former primary database became a physical standby database it will always be open readonly.

C. The former primary database will always be open.

D. If the former primary database became a physical standby database it will be in the same state as the former physical standby database.

E. The new primary database will be open read-write.

F. If the former primary database became a logical standby database it will be open read-write.

정답: D,E,F

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

문제8

Which statement is true regarding Oracle Net connectivity for a Data Guard Broker configuration?

A. A TNS entry enabling connectivity to the primary database instance must be defined on each of the standby database hosts.

B. To enable Real-Time Query on a physical standby database, a TNS entry enabling connectivity to the standby database instance must be defined on the primary database host.

C. The LOCAL_LISTENER initialization parameter must be set to the listener used to register the primary database instance.

D. To start SQL Apply on a logical standby database, a TNS entry enabling connectivity to the primary database instance must be defined on the logical standby database host.

E. A TNS entry or entries enabling connectivity to standby database instance(s) must be defined on the primary database host.

정답: E

문제9

Which feature is available when monitoring a Data Guard configuration using Enterprise Manager Cloud Control, but is not available using DGMGRL or by using SQL?

A. Performing a verify operation

B. Automatic creation of standby redo logs

C. Analyzing the dmon process trace file

D. Viewing a logical standby database apply lag

E. Creating a broker configuration before creating the databases

정답: D

문제10

You detected an unrecoverable archive gap in your data guard environment. So, you need to roll standby.
forward in time without applying a large number of archive log files using this command:
RMAN> RECOVER STANDBY DATABASE FROM SERVICE-<primary database name>;
When running this command, which of the following steps can be performed automatically?
1. Remember all data file names on the standby.
2. Restart standby in nomount.
3. Restore controlfile from primary.
4. Mount standby database.
5. Rename data files from stored standby names.
6. Restore new data files to new names.
7. Recover standby.

A. 1,3,5,6,7

B. 2,3,6,7

C. 1,2,3,4,5,6,7

D. 2,3,5,6,7

E. 1, 2,3,4,6,7

정답: E

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

최신 1z0-076 무료덤프 - Oracle Database 19c: Data Guard Administration

우리와 연락하기

유용한 링크

최신 업데이트