Free Oracle Database 19c: Data Guard AdministrationPractice Test

Which three components are required to implement a basic Oracle Data Guard configuration?

A database administrator is configuring a standby database and wants to ensure maximum protection against data loss, even at the cost of primary database availability. Which protection mode should be configured?

You need to monitor the synchronization lag between the primary and standby databases. Which Data Guard view provides information about the apply lag on a physical standby database?

During a switchover operation, what happens to the original primary database?

Which redo transport mode ensures that redo data is written synchronously to the standby database with acknowledgment before the primary commits?

A company is implementing Data Guard with a physical standby database. The standby database needs to be opened in read-only mode while redo apply continues. Which feature enables this functionality?

An administrator needs to configure automatic failover for a Data Guard environment. Which component is required to implement Fast-Start Failover (FSFO)?

You are troubleshooting a Data Guard configuration where redo transport has stopped. Upon investigation, you find that the LOG_ARCHIVE_DEST_2 parameter on the primary database has the STATE attribute set to DEFER. What action should you take to resolve this issue?

A physical standby database is experiencing an apply lag of several hours. Which Data Guard feature can be used to temporarily convert the standby to read-write mode for testing purposes while preserving the ability to quickly resynchronize with the primary?

In a Data Guard configuration using Maximum Availability mode, the network connection to all standby databases is lost. What will happen to the primary database?

An organization has a requirement to maintain a standby database in a remote location that is more than 1000 miles away, but wants to ensure synchronous redo transport without maintaining a full database copy at that location. Which Data Guard component should be implemented?

During a manual failover operation, you discover that there are archived redo logs on the primary database that were not transmitted to the standby before the failure. What Data Guard Broker command should you use to recover and apply these logs from the failed primary?

You need to configure redo transport compression to reduce network bandwidth usage between the primary and standby databases. Which LOG_ARCHIVE_DEST_n parameter attribute enables redo transport compression?

A physical standby database shows a gap in the archived redo log sequence. Which view on the standby database should you query to identify the missing archived log files?

After a failover operation, you want to reinstate the former primary database as a standby in the configuration. What prerequisite condition must be met for the REINSTATE command to succeed?

An enterprise is designing a Data Guard configuration with the following requirements: zero data loss, ability to query standby for reporting, and automatic failover capability. The standby is located 50 miles from the primary with a high-speed network connection. Which configuration best meets these requirements?

You are troubleshooting a Data Guard environment where Fast-Start Failover is enabled but the observer repeatedly reports false primary failures. Investigation reveals network instability causing brief disconnections. Which two parameters should be adjusted to reduce false failure detection?

A corporation operates a Data Guard configuration with a primary database in New York, a Far Sync instance in Chicago, and a physical standby in Los Angeles. The primary sends redo synchronously to the Far Sync instance, which forwards it asynchronously to the physical standby. If the network between Chicago and Los Angeles fails completely, what is the impact on the primary database operation and data protection?

During a switchover operation using Data Guard Broker, the switchover verification shows: 'Warning: standby database has 150 seconds of apply lag.' According to best practices, what should be the next action?

A financial institution requires a Data Guard configuration where the standby database can apply redo data while filtering out specific tables from replication to support a regulatory requirement. Additionally, they need to run reports against the standby database. Which standby database type and configuration should be recommended?