Question 1
For which database, other than SQL Server, does an Extract use a method of Secondary Truncation Point management?
Correct Answer:
D. DB2
Free Oracle GoldenGate 12c Implementation Essentials 1Z0-447 Exam Questions
Question 2
Select four Oracle GoldenGate use cases.
Correct Answer:
B. real-time data warehousing; C. offload reporting; D. zero downtime upgrades and migrations; F. data center load balancing by using multi-master replication
Question 3
You installed GoldenGate on your server, but you received an error when you tried to start GGSCI. What is the reason for this issue?
Correct Answer:
A. The incorrect version of GoldenGate was installed for your CPU architecture.
Question 4
Which option is an invalid GLOBALS parameter?
Correct Answer:
A. DISCARDFILE
Question 5
Replicat makes checkpoints in the trail file to mark its last read position. Select two ways to create checkpoint tables.
Correct Answer:
B. Run thechkpt_db_create.sqlscript.; E. Use theADD CHECKPOINTTABLEcommand.
Question 6
GoldenGate has cached long-running open transactions to disk for an Oracle database. Where can you locate them?
Correct Answer:
C. in the server temporary file system
Question 7
What is the key purpose of GoldenGate trail files?
Correct Answer:
C. They are checkpoint files for the GoldenGate processes.
Question 8
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?
Correct Answer:
D. 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.
Question 9
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?
Correct Answer:
A. The Extract will revert to single-row fetch mode, and then resume array fetches afterwards.
Question 10
Which three are valid Extract or Replicat statements using the @RANGE function for an Acct table with a
Primary Key on the AccountID column? (Select three.)
Correct Answer:
A. MAP sales.acct, TARGET sales.acct, FILTER (@RANGE (2, 3, AccountID));; B. MAP sales.acct, TARGET sales.acct, FILTER (@RANGE (1, 3, ID));; C. TABLE fin.Sales, FILTER (@RANGE (1, 2));