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?
Answer : A
Explanation:
In reference guide, page 256, and I quote "If multiple groups are reading the same set of trail files, one process could purge a file before another is finished with it. Instead, use the
Manager version of PURGEOLDEXTRACTS, which is the preferred use of the parameter in all GoldenGate configurations because it allows you to manage trail files in a centralized fashion."
Which parameter could you use to start an Extract when Manager starts?
Answer : C
Reference:
http://download.oracle.com/docs/cd/E15881_01/doc.104/gg_wux_ref_v104.pdf
Which could be used to map a value stored in a user token to a target column?
Answer : D
Reference:
http://download.oracle.com/docs/cd/E15881_01/doc.104/gg_wux_ref_v104.pdf
Ideally which process should be configured purge old trial files?
Answer : A
Reference:
http://download.oracle.com/docs/cd/E15881_01/doc.104/gg_wux_ref_v104.pdf
When would you use the PASSTHRU parameter?
Answer : A
Reference:
http://download.oracle.com/docs/cd/E15881_01/doc.104/gg_wux_ref_v104.pdf
Which three types of information are stored in the GoldenGate trial header?
Answer : A,B,C
Reference:
http://download.oracle.com/docs/cd/E15881_01/doc.104/gg_wux_ref_v104.pdf
What Oracle GoldenGate feature provides recoverability without loss of transactions?
Answer : A
Nicole is preparing initial data load Extract task EINI_HR using the parameter
DBOPTIONS FECHBATCHSIZE 2000. What is likely to happen if one of her source tables includes LOB data?
Answer : A
What file must be configured in order to use custom encryption keys?
Answer : A
Reference:
http://download.oracle.com/docs/cd/E15881_01/doc.104/gg_wux_ref_v104.pdf
Which parameters) would be used for one-time initial replicat?
Answer : E
Reference:
http://download.oracle.com/docs/cd/E15881_01/doc.104/gg_wux_ref_v104.pdf
What is the default format for a GoldenGate trail?
Answer : A
You have discovered that an OGG checkpoint table has become corrupted. What is you best strategy to recover From this?
Answer : A
Reference:
http://www.outofboundstechnology.com/files/oracle/oraclegg_part3_trouble.pdf
Which translations are captured if you ADD EXTRACT BEGIN now 1:00 p.m., but
START EXTRACT at 2:00 p.m.?
Answer : D
Explanation:
The START EXTRACT starts the Extract and Data Pump processes.
Reference:
http://www.pythian.com/news/7959/oracle-goldengate-installation-part-1/
You want encrypt message sent or over TCP/IP to server usserver1, where the goldenGate manage process is running on port 7809. Your requirements include using a custom encryption key and advanced encryption standard (AES), and you have created an
ENCKEYS file -
What parameters should you use?
Answer : D
Explanation: Reference :
http://gavinsoorma.com/2010/07/goldengate-encrypting-data-and-passwords/
Which three describe a valid OGG Event Action?
Answer : A,B,C
Explanation:
In reference guide, page 312, Syntax EVENTACTIONS ([STOP | ABORT |
FORCESTOP][IGNORE [TRANSACTION [INCLUDEVENT]][DISCARD][LOG [INFO |
WARNING]][REPORT][ROLLOVER][SHELL <command>][TRACE <trace file>
[TRANSACTION] [PURGE | APPEND]][CHECKPOINT [BEFORE | AFTER | BOTH]][, ...])