Oracle GoldenGate 12c Implementation Essentials - 1z1-447 Exam Questions [2026]

QUESTION NO: 1
What is the name and the location of the file that lists the key values used by extract for encryptions and Server Collector for decryption?

A. GGSKEY file in the GoldenGate installation location B. ENCKEYS file in the GoldenGate installation location C. COBGEN file in the GoldenGate installation location D. GGSKEY file in the GoldenGate data location E. KEYGEN file in the GoldenGate data location

Correct Answer: B

QUESTION NO: 2
Which parameters) would be used for one-time initial replicat?

A. SOURCEISTABLE B. CHECKMINUTES C. SOURCEISFILE D. PASSTHRU E. SPECIALRUN

Correct Answer: E

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

A. Create aGLOBALSfile for each installation and use theMGRSERVNAMEparameter, with a unique name. B. Multiple Manager services are not allowed on the same Windows server. C. Accept the default service name and manually edit within the Services applet. D. Include the parameterSERVICENAMEin each Manager, with a unique name.

Correct Answer: A

QUESTION NO: 4
Replicat makes checkpoints in the trail file to mark its last read position. Select two ways to create checkpoint tables.

A. Use theINFO REPLICATcommand with theSHOWCHoption. B. Run thechkpt_db_extracttrail.sqlscript. C. Use theADD CHECKPOINTTABLEcommand. D. Run thechkpt_db_create.sqlscript. E. Use theADD Extract Trailcommand.

Correct Answer: C,D

QUESTION NO: 5
You are implementing GoldenGate monitoring via the Enterprise Manager Plug-In. When you start JAgent, it fails with "ajavA.lang.Exception: One or more Java Agent properties in Config.properties are not defined properly".
What is the first thing to check?

A. if the JAgent has been enabled in the GoldenGate Manager B. if the agent type is set to OEM in JAgent properties C. if the Oracle Wallet has been created for the JAgent D. if The Enterprise Manager Agent is running

Correct Answer: B

QUESTION NO: 6
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 theGETUPDATEBEFORESoption of the MAP parameter in the Replicat parameter file to specify columns that are to be used with before values in the ReplicatWHEREclause. B. Use theGETBEFORECOLSoption of the MAP parameter in the Replicat parameter file to specify columns that are to be used with before values in the ReplicatWHEREclause. C. Use theCOMPCOLSwith theGETUPDATEBEFORESoption of the MAP parameter in the Replicat parameter file to specify columns that are to be used with before values in the ReplicatWHERE clause. D. Use theCOMPARECOLSoption of the MAP parameter in the Replicat parameter file to specify columns that are to be used with before values in the ReplicatWHEREclause.

Correct Answer: D

QUESTION NO: 7
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 containsSYSLOG ALL. C. The user session running Manager is set to log all messages. D. An Extract or Replicat is overriding GLOBALS withSYSLOG WARN.

Correct Answer: D

QUESTION NO: 8
In which process should you configure the warning for long-running transactions?

A. Jagent B. Manager C. Replicat D. Extract

Correct Answer: D