Question 1

Which of the following is NOT a benefit of using a snapshot standby database?

Options :

A : Accelerating data recovery in case of primary database failure.

B : Simplifying patching and upgrade processes by utilizing the snapshot database.

C : Providing a read-write copy of the database for testing and development purposes.

D : Reducing the load on the primary database by offloading reporting and queries.

Answer: A

Question 2

When would you use a Snapshot Standby database?

Options :

A : To create a copy of the primary database for testing purposes

B : To perform rolling upgrades of the Oracle database software

C : To offload read-only workloads from the primary database

Answer: B

Question 3

Which configuration option is required to enable Oracle Active Data Guard for read-only standby databases?

Options :

A : Snapshot Standby

B : Redo Apply

C : SQL Apply

D : Logical Standby

Answer: C

Question 4

What is the main benefit of using Data Guard for disaster recovery?

Options :

A : Continuous availability of critical data

B : Increased database security

C : Improved query performance

D : Reduced backup and recovery time

Answer: A

Question 5

Your Data Guard configuration consists of these components and settings: 1. A primary database 2. A remote physical standby database 3. Real-time query is enabled 4. Redo transport mode is synchronous 5. Protection mode is maximum availability 6. The Data Guard broker is used You notice that the standby destination fails to acknowledge reception of redo within net_timeout period of time. Which is true in this scenario?

Options :

A : Real-time query will be disabled on the physical standby.

B : The protection mode will automatically change to Maximum Performance.

C : Synchronous redo transport mode connections to the standby database are terminated.

D : The physical standby database instance is shut down by the Data Guard broker.

Answer: C