Pass4Test 10%OFF Discount Code

Oracle Database 19c: Data Guard Administration - 1z0-076 Exam Questions

QUESTION NO: 1
A customer asks for your recommendation regarding this requirement:
1. We plan to have a Data Guard Configuration with one primary database and one physical standby database.
2. We want zero data loss in case of a disaster involving the loss of one component.
3. We want to do Real Application Testing occasionally on the Standby Database.
Which solution, if any, satisfies these requirements?

A. These requirements cannot be met. B. A physical standby database with synchronous redo transport that can be converted regularly into a snapshot standby to do real application testing C. A snapshot standby database with real time query that can be converted regularly into a physical standby database open read write, to do real application testing D. A far sync instance plus a snapshot standby database and real time apply that can be converted regularly into logical standby database to do real application testing

Correct Answer: B

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

QUESTION NO: 2
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. Real-time query performance on a physical standby database improves for current read requests 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. The performance of SQL apply on a logical standby database always improves when using this transport mode.

Correct Answer: A,D

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

QUESTION NO: 3
Suppose that you manage the following databases in your environment:
* boston: Primary database with a single PDB called DEVI
* london: Physical standby database protecting the PDB called DEVI
* orcl: Stand-alone database with a single PDB called PDB1 as a remote clone source You are planning to run the following command to create a remote clone in the primary database (boston) using pdbi in orcl:
Which are the THREE prerequisites for automating instantiation of the PDB in the standby database (london)?

A. Set standby_pdb_source_file_dblink to clone_link in the london database. B. Enable Active Data Guard in the _ondon database. C. Set STANDBY_PDB_SOURCE_FILE_DIRECTORY to <location of the PDB> in the london database. D. Set STANDBY_FILE_MANAGEMENT to auto in the london database. E. Open PDBI (remote clone source) in Read Only. F. Open PDBI (remote clone source) in Read Write.

Correct Answer: C,D,E

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

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

Correct Answer: B,E

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

QUESTION NO: 5
Which THREE are true about using flashback database in a Data Guard environment?

A. When a flashback database operation is performed on a primary database, a logical standby database is also flashed back automatically. B. When a flashback database operation is performed on a primary database, a physical standby database is also flashed back automatically. C. It may not be used to flash back a primary database after a failover to a physical standby. D. You can use it when real-time apply is enabled in case the physical standby suffers from logical corruption. E. It may be used to flash back a physical standby that receives redo from a far sync instance. F. You can use it when real-time apply is enabled in case the phylt may not be used to flash back a primary database after a failover to a logical standby.

Correct Answer: C,D,E

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

QUESTION NO: 6
Which four requirements can be met by deploying a logical standby database?

A. Support for workloads requiring additional materialized views. B. It can be used to create additional tables. C. Support for workloads requiring additional indexes. D. It must have the same physical structure as the primary database. E. It must provide a disaster-recovery solution that protects all data with capability of performing switchovers and failovers. F. It can be used for Real Application Testing without affecting the disaster recovery capabilities. G. It can be used to create additional schemas.

Correct Answer: A,B,C,F

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

QUESTION NO: 7
Examine this query and its output:

Which two statements are true?

A. The master observer is not running, but should run on ol7.example.com. B. The master observer is connected to the database on which the query was executed. C. Cats is a bystander database. D. The master observer is not connected to the database on which the query was executed. E. The master observer is currently running on ol7.example.com.

Correct Answer: C,D

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

QUESTION NO: 8
Your Data Guard environment has a remote physical standby database with real-time query enabled, which is used for reporting, and a logical standby database used for DSS reporting.
Switchovers or failovers are possible due to testing or in case of a disaster.
Clients use local TNSNAMES.ORA files to define connection strings to the database instances.
Which three will prevent clients from connecting to the wrong database instances?

A. The client applications must use the correct TNS entries when requesting connections to the database instances. B. Client TNS entries for the databases use the correct service names for the intended service. C. The LOCAL_LISTENER parameter on the primary database instance must always be set. D. A service name is registered with the local listener of each database instance. E. Oracle Net connectivity to the primary database instance must be established on all the standby database instances. F. The DB_NAME and DB_UNIQUE_NAME parameters must be set to the same value for all the databases in the Data Guard environment. G. The standby database services must be defined statically with the Listeners running on the standby database hosts.

Correct Answer: A,B,G

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).