Free 1Z0-447 Exam Dumps

Question 6

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

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

Correct Answer:A

Question 7

Which combination of DBMS, Extract, and GoldenGate version is required to avoid using a DDL trigger?

A. Oracle Database 11.2.0.3 or greater, Integrated Extract, and GoldenGate 12.1 or greater
B. any version of Oracle Database, Integrated Extract, and GoldenGate 11.2 or greater
C. Oracle Database 11.2.0.4 or greater, Integrated Extract, and GoldenGate 12.1 or greater
D. Oracle Database 12c or greater, Integrated Extract, and GoldenGate 11.2 or greater

Correct Answer:C

Question 8

You have configured and added the Extract and Replicat tasks by using the Direct Load method. What do you need to do to get the processes up and running?

A. Start the Extract task.
B. Start the Extract task, wait for it to stop, and then start the Replicat task.
C. Start the Extract task and then start the Replicat task.
D. Start the Replicat task.

Correct Answer:C

Question 9

For which database, other than SQL Server, does an Extract use a method of Secondary Truncation Point management?

A. Teradata
B. Informix
C. Sybase
D. DB2

Correct Answer:D

Question 10

Select four Oracle GoldenGate use cases.

A. real-time discovery
B. real-time data warehousing
C. offload reporting
D. zero downtime upgrades and migrations
E. backup and recovery
F. data center load balancing by using multi-master replication

Correct Answer:BCDF

The certification names are the trademarks of their respective owners. testpreplab.com certstest.com