You are migrating from a legacy database server to Exadata, which requires you to use different versions of GoldenGate. What do you need to configure to ensure that backwards replication works?

A. The Replicat with the FORMAT RELEASEparameter.

B. The Extract with the FORMAT RELEASE parameter.

C. The Extract to write directly to the remote trail.

D. The collector with the FORMAT RELEASEparameter.

You want to monitor replication not only to check that the processes are running, but to specifically verify that the data continuously replicates. How should you accomplish this?

A. Implement GoldenGate Monitor.

B. Have the customer continuously update the application data.

C. Monitor the GoldenGate lag and last checkpoint time statistics.

D. Implement heartbeat tables for replication.

Which statement regarding the GoldenGate Data Pump is incorrect?

A. Data Pump is a separate process.

B. Data Pump can be used to pump trail records to multiple locations.

C. Data Pump has distance limitations.

D. Data Pump uses TCP/IP to route the trail records.

You must configure GoldenGate parameter files for conflict resolution and want to be sure that the before values are compared with current values in the target database to detect update and delete conflicts.

How should you accomplish this?

A. Use the COMPCOLSwith the GETUPDATEBEFORESoption of the MAP parameter in the Replicat parameter file to specify columns that are to be used with before values in the Replicat WHEREclause.

B. Use the COMPARECOLS option of the MAP parameter in the Replicat parameter file to specify columns that are to be used with before values in the Replicat WHERE clause.

C. Use the GETUPDATEBEFORES option of the MAP parameter in the Replicat parameter file to specify columns that are to be used with before values in the Replicat WHERE clause.

D. Use the GETBEFORECOLS option of the MAP parameter in the Replicat parameter file to specify columns that are to be used with before values in the Replicat WHERE clause.

You are running multiple installations of Oracle GoldenGate on the same Windows server. How can you differentiate the different Manager services?

A. Create a GLOBALS file for each installation and use the MGRSERVNAMEparameter, with a unique name.

B. Include the parameter SERVICENAME in each Manager, with a unique name.

C. Accept the default service name and manually edit within the Services applet.

D. Multiple Manager services are not allowed on the same Windows server.

A database that requires replication contains sensitive data that is not required on the target. How should you prevent this sensitive data from being replicated?

A. Use the FILTERoption in the MAP parameter.

B. Use the COLMAPoption in the MAP parameter.

C. Do not specify those columns in the ADDTRANDATAcommand.

D. Use the COLS and COLSEXCEPToptions in the TABLE parameter.

You want to eliminate the reporting output from processing a Macro. How should you proceed?

A. Use the optional parameter NOLIST.

B. Use the optional parameter UNLIST.

C. Use the optional parameter NOREPORT.

D. Use the optional parameter NOMACROOUTPUT.

Your GLOBALS file contains the parameter SYSLOG NONE, but the system logs contain warnings from the Manager. What could be causing this to occur?

A. The GGSCI session was configured incorrectly.

B. The Manager parameter file contains SYSLOG ALL.

C. An Extract or Replicat is overriding GLOBALS with SYSLOG WARN.

D. The user session running Manager is set to log all messages.

You must prepare the source database to send redo to the mining database. What sequence of steps should you follow to accomplish this?

A. Ensure that the source database is running with the required compatibility. Use the TRANSLOGOPTIONS parameter, set up redo transport at the source database, and enable the downstream destination.

B. Ensure that the source database is running with the required compatibility. Set DB_CONFIG at the source database. Set up redo transport at the source database.

C. Set DG_CONFIG at the source database and enable the downstream destination.

D. Ensure that the source database is running with the required compatibility. Set DG_CONFIG at the source database. Set up redo transport at the source database and enable the downstream destination.

You want to reduce an Integrated Extract's startup time by using an existing data dictionary. How should you accomplish this?

A. Set the shared memory realm of an Integrated Extract with other Integrated Extracts.

B. Use the SHARE option of the REGISTER EXTRACT command.

C. Share the registration ID with other Integrated Extracts.

D. Begin the Extract processing at the earliest SCN of the log stream.