Oracle GoldenGate 12c Implementation Essentials - 1z0-447 FREE EXAM DUMPS QUESTIONS & ANSWERS]

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?

A. Use theCOLSandCOLSEXCEPToptions in theTABLEparameter. B. Use theFILTERoption in theMAPparameter. C. Do not specify those columns in theADD TRANDATAcommand. D. Use theCOLMAPoption in theMAPparameter.

Discussion 0

Correct Answer: D Vote an answer

Question 2

Which statement regarding the GoldenGate Data Pump is incorrect?

A. Data Pump can be used to pump trail records to multiple locations. B. Data Pump has distance limitations. C. Data Pump uses TCP/IP to route the trail records. D. Data Pump is a separate process.

Discussion 0

Correct Answer: D Vote an answer

Question 3

What Oracle GoldenGate feature provides recoverability without loss of transactions?

A. Two-phase commits B. Checkpointing C. Transactional integrity D. Sub-second latency

Discussion 0

Correct Answer: B Vote an answer

Question 4

What is the key purpose of GoldenGate trail files?

A. They are a persistent storage area for captured transactions. B. They are checkpoint files for the GoldenGate processes. C. They are database auditing logs where GoldenGate captures changes. D. They are configuration files for the GoldenGate processes.

Discussion 0

Correct Answer: B Vote an answer

Question 5

What is the default format for a GoldenGate trail?

A. CDF: Canonical Data format B. XML: XML statement C. INPUT ASCII: from 1to 127 representing ASCII characters D. SQL: SQL statements E. ASCII:ASCII format

Discussion 0

Correct Answer: E Vote an answer

Question 6

You are running multiple installations of Oracle GoldenGate on the same Windows server.
How can you differentiate the different Manager services?

A. Include the parameterSERVICENAMEin each Manager, with a unique name. B. Multiple Manager services are not allowed on the same Windows server. C. Create aGLOBALSfile for each installation and use theMGRSERVNAMEparameter, with a unique name. D. Accept the default service name and manually edit within the Services applet.

Discussion 0

Correct Answer: C Vote an answer

Question 7

In which process should you configure the warning for long-running transactions?

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

Discussion 0

Correct Answer: A Vote an answer

Question 8

Which three types of information are stored in the GoldenGate trial header?

A. Time of the transaction B. Relative byte address of the commit record C. Before or after image indicator D. Data type (e.g. integer, alphanumeric)

Discussion 0

Correct Answer: B,C,D Vote an answer