Oracle 1Z0-447 Quiz 1 Topic 2 Questions 1-5

Question: 1

If multiple GoldenGate processes are accessing a set of trial files which of the processes should include the PURGEOLDEXTRACTS parameter to trigger trail file clean up?

AManager

BExtract

CReplicat

DBoth Extract and Replicat

Show Answer

Question: 2

You must synchronize the starting point for Replicat with the restore point of the target database. How should you accomplish this?

AUse the command optionAFTERCSN.

BUse the command optionATCSN.

CUse the command optionUNTIL CANCEL.

DUse the command optionRESUME.

Show Answer

Question: 3

What is the key purpose of GoldenGate trail files?

AThey are a persistent storage area for captured transactions.

BThey are configuration files for the GoldenGate processes.

CThey are checkpoint files for the GoldenGate processes.

DThey are database auditing logs where GoldenGate captures changes.

Show Answer

Question: 4

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?

AGoldenGate deployments cannot use a shared wallet.

BView the GoldenGate log files to monitor Replicat report files to verify that the SCN was applied by allReplicat groups.

CView the report file of the newest Extract after renewing the master key to confirm the last SCN that was mined with old key.

DView 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.

Show Answer

Question: 5

You need to look up table definitions in a file. Which Replicat parameter should you use?

AASSUMETARGETDEFS

BCOLMATCH

CSOURCEDEFS

DMAP

Show Answer

Oracle 1Z0-447 Quiz:1 Topic:2 Questions:1-5