Online 1Z0-447 Practice Test

Question 1

A database that requires replication contains sensitive data that is not required on the target. How should you prevent this sensitive data from being replicated?

Options :

A : Use the FILTER option in the MAP parameter.

B : Use the COLMAP option in the MAP parameter

C : Do not specify those columns in the ADD TRANDATA command.

D : Use the COLS and COLSEXCEPT options in the TABLE parameter.

Answer: B

Question 2

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

Options :

A : Manager

B : Replicat

C : Extract

D : Extract and Replicat

Answer: A

Question 3

Which parameter for GoldenGate 12c enables DDL replication for a Replicat?

Options :

A : TARGETDDL

B : GETDDL

C : DDL for Replicat is enabled by default.

D : USEDDL

Answer: C

Question 4

What is the function of the GoldenGate JAgent?

Options :

A : It performs connections via JDBC to run the Veridata comparisons.

B : It enables communication between GoldenGate and Monitor, and Enterprise Manager Agent.

C : It reads the database transaction logs.

D : It integrates GoldenGate with Oracle Data Integrator.

Answer: B

Question 5

You want to reduce an Integrated Extract’s startup time by using an existing data dictionary. How should you accomplish this?

Options :

A : Set the shared memory realm of an Integrated Extract with other Integrated Extracts.

B : Use the SHARE option of the REGISTER EXTRACT command.

C : Share the registration ID with other Integrated Extracts.

D : Begin the Extract processing at the earliest SCN of the log stream.

Answer: B

EXPERTY DESIGNED 1Z0-447 PRACTICE TEST