Oracle Exam 1Z0-076 Topic 1 Question 8 Discussion

Actual exam question for Oracle's 1Z0-076 exam

Question #: 8
Topic #: 1

Your Data Guard environment has two remote physical standby databases.

Client applications use the local naming method to connect to the primary database instance.

You want applications to automatically connect to the new primary database instance in case of a switchover or a failover.

Which set of actions will fulfill this requirement?

ASet the LOCAL_LISTENER parameter for all the database instance to register services with the default listener on the primary database host.

BCreate a database service on the primary database that is started automatically by a trigger, when the database role is PRIMARY; modify the connection descriptors used by client applications to include all the standby hosts and connect to the database instance using that service name.

CSet DB_NAME and DB_UNIQUE_NAME identically on all databases; modify the connection descriptors on client applications to include all the standby hosts and connect to the database instance using that service name.

DSet the INSTANCE NAME parameter identically on all databases; modify the connection descriptor on client applications to include all the standby hosts and connect to the database instance using that service name.

Show Suggested Answer

Suggested Answer: B

For seamless client redirection in a Data Guard environment, the following steps should be taken:

Create a database service on the primary database that is started automatically by a trigger when the database role is PRIMARY (B): This ensures that the service is only available on the primary database and is automatically started after a role transition due to switchover or failover.

Modify the connection descriptors used by client applications to include all the standby hosts and connect to the database instance using that service name (B): Client applications use the connection descriptors that include all potential primary hosts (i.e., the current primary and all standbys). This enables clients to connect to whichever database is currently acting as the primary using the service name. Reference:

Oracle Data Guard Concepts and Administration Guide

Oracle Real Application Clusters Administration and Deployment Guide

by Micah at Apr 28, 2024, 12:22 AM

Limited Time Offer

25%

Off

Get Premium 1Z0-076 Questions as Interactive Web-Based Practice Test or PDF