1z1-447 by Oracle Actual Free Exam Questions And Answers

Question 1

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 and then start the Replicat task.

B. Start the Replicat task.

C. Start the Extract task.

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

Discussion 0

Correct Answer: A Vote an answer

Question 2

What Oracle GoldenGate feature provides recoverability without loss of transactions?

A. Transactional integrity

B. Checkpointing

C. Two-phase commits

D. Sub-second latency

Discussion 0

Correct Answer: B Vote an answer

Question 3

You must configure GoldenGate parameter files for conflict resolution and want to be sure that the before values are compared with current values in the target database to detect update and delete conflicts.
How should you accomplish this?

A. Use theCOMPCOLSwith theGETUPDATEBEFORESoption of the MAP parameter in the Replicat parameter file to specify columns that are to be used with before values in the ReplicatWHERE clause.

B. Use theGETBEFORECOLSoption of the MAP parameter in the Replicat parameter file to specify columns that are to be used with before values in the ReplicatWHEREclause.

C. Use theCOMPARECOLSoption of the MAP parameter in the Replicat parameter file to specify columns that are to be used with before values in the ReplicatWHEREclause.

D. Use theGETUPDATEBEFORESoption of the MAP parameter in the Replicat parameter file to specify columns that are to be used with before values in the ReplicatWHEREclause.

Discussion 0

Correct Answer: C Vote an answer

Question 4

You need to configure the source database, target database, and Oracle GoldenGate for conflict detection and resolution (CDR). You want the full before image of each record, but your database does not provide a before image in the log record and must be configured to do so with supplemental logging.
How should you proceed?

A. Include theADD TRANDATAcommand.

B. Include theOVERWRITEcommand.

C. Include theUSEDELTAcommand.

D. Include theUPDATAROWEXISTScommand.

Discussion 0

Correct Answer: A Vote an answer

Question 5

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?

A. Use theFILTERoption in theMAPparameter.

B. Use theCOLSandCOLSEXCEPToptions in theTABLEparameter.

C. Do not specify those columns in theADD TRANDATAcommand.

D. Use theCOLMAPoption in theMAPparameter.

Discussion 0

Correct Answer: D Vote an answer

Question 6

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

A. TARGETDDL

B. DDL for Replicat is enabled by default.

C. USEDDL

D. GETDDL

Discussion 0

Correct Answer: B Vote an answer

Question 7

What file must be configured in order to use custom encryption keys?

A. ENCKEYS

B. GLOBALS

C. ENCRYPT

D. CUSTKEYS

Discussion 0

Correct Answer: A Vote an answer

Question 8

Which three are required to correctly configure an OGG?

A. Designation as local or remote

B. A maximum file size

C. A trail file identifier

D. An extract process

Discussion 0

Correct Answer: A,C,D Vote an answer

Oracle GoldenGate 12c Implementation Essentials - 1z1-447 Exam Practice Test

Contact Us

Useful Links

Latest Updated