1z0-076 무료 덤프문제 온라인 액세스

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

• A.You can monitor the redo apply rate on a snapshot standby database.
• B.You can check the potential data loss in the event of a disaster.
• C.You can set a critical threshold on the redo generation rate metric for a primary database.
• D.You can set a warning threshold on the redo generation rate metric for a physical standby database.
• E.You can check if redo apply needs to be tuned.
• F.You can monitor the redo apply rate on a logical standby database.

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 asynchronous redo transport and SQL apply on.
• B.A physical standby database with asynchronous redo transport and Real-Time Query enabled.
• C.A logical standby database with synchronous redo transport and SQL apply on.
• D.A logical standby database with synchronous redo transport and redo apply on.
• E.A physical standby database with synchronous redo transport and Real-Time Query enabled.

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.CRSCTL
• B.SRVCTL
• C.RMAN
• D.GDCCTL
• E.Enterprise Manager Cloud Control
• F.DGMGRL
• G.SQL*Plus

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 asyn: for the standby database Cats.
• C.Cats is a snapshot standby database.
• D.The redo transport mode is set to async for both standby databases.

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

• A.The performance of SQL apply on a logical standby database always improves when using this transport mode.
• 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.This transport mode satisfies the minimum requirements for Maximum Performance data protection mode.
• E.A transaction can commit without waiting for redo to be sent to any standby database in the data guard configuration.