Free Oracle 1z0-076 Exam Dumps Questions & Answers

A customer asks you to propose the most appropriate solution for this set of requirements:
We need a disaster recovery solution that enables us to fail over from our production database with zero data loss.
We want to generate reports from the proposed standby database at the same time that it is used for data protection.
Developers may need to test occasionally on a copy of the live database Which TWO solutions would you recommend?

• A.  A logical standby database with real-time query enabled
• B.  A physical standby database with real-time apply enabled
• C.  A physical standby database with real-time query enabled
• D.  A logical standby database with real-time apply enabled
• E.  A snapshot standby database with synchronous redo transport

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

• A.  This transport mode satisfies the minimum requirements for Maximum Performance data protection mode.
• B.  This transport mode satisfies the minimum requirements for Maximum Availability data protection mode.
• C.  The performance of SQL apply on a logical standby database always improves when using this transport mode.
• D.  A transaction can commit without waiting for redo to be sent to any standby database in the data guard configuration.
• E.  Real-time query performance on a physical standby database improves for current read requests when using this transport mode.

Which two are true about database roles in an Oracle Data Guard configuration?

• A.  A configuration consisting only of a primary and one or more physical standby databases can support a rolling release upgrade.
• B.  A Logical Standby Database can cascade redo to a terminal destination.
• C.  A Logical Standby Database can be converted to a Snapshot Standby Database.
• 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.

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

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

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 for each database and use event triggers to make sure that services are activated only when the database is in the correct role.
• B.  Create database services on each of the standby databases, start the services, and add connection descriptors on the clients to connect to those services.
• C.  Establish Oracle Net connectivity to the primary database instance from all the standby database instances.
• D.  Create role based services with the si vet] utility when using clusterware for Oracle RAC databases or Oracle Restart for single instance Oracle databases.
• E.  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.