Online Access Free 1z0-447 Exam Questions

Which database setting for the Oracle 11.2.0.4 database is required to enable Oracle GoldenGate?

• A.Configure theSTREAMS_POOL_SIZEdatabase parameter
• B.ENABLE_GOLDENGATE_REPLICATION=true
• C.ENABLE_STREAMS_REPLICATION=true
• D.ENABLE_DATABASE_REPLICATION=true

Your Goldengate deployment is using a shared wallet, and older versions of the master key should be retained after the master key is renewed until all processes are using the newest version.
How should you determine whether all of the processes are using the newest version so that you can delete older versions of the master key?

• A.GoldenGate deployments cannot use a shared wallet.
• B.View the report file of each Extract immediately after renewing the master key to confirm the last SCN that was mined with the old key. Then, monitor the Replicat report files to verify that this SCN was applied by all Replicat groups.
• C.View the report file of the newest Extract after renewing the master key to confirm the last SCN that was mined with old key.
• D.View the GoldenGate log files to monitor Replicat report files to verify that the SCN was applied by allReplicat groups.

Which three describe a valid OGG Event Action?

• A.Stop the process
• B.Run a shell command
• C.Write a checkpoint before and/or after writing the record to the trail.
• D.Purge old trail files

When is a Pump not required to connect to a source database?

• A.when look-ups are needed against the source database
• B.when aPASSTHRUparameter is used
• C.when aNOPASSTHRUparameter is used
• D.when transformations, filtering, and mapping are required

How can you tell if GoldenGate has been configured for batch processing?

• A.TheSPECIALRUNparameter is in theGLOBALSparameter file.
• B.Replicat is started with theINITIALLOADtask.
• C.TheSPECIALRUNparameter is in the Replicat parameter file.
• D.There is a dedicated GoldenGate process calledSPECIALRUN.