Oracle GoldenGate 12c Implementation Essentials

Question 1

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

A. GLOBALS

B. ENCKEYS

C. CUSTKEYS

D. ENCRYPT

Correct Answer: B

Question 2

Which GLOBALS parameter is required to initially enable monitoring?

A. CHECKMONITORING

B. JAGENTMONITORING

C. ENABLEMONITORING

D. ENABLEOEMMONITORING

Correct Answer: C

Question 3

You must synchronize the starting point for Replicat with the restore point of the target database. How should you accomplish this?

A. Use the command optionUNTIL CANCEL.

B. Use the command optionAFTERCSN.

C. Use the command optionRESUME.

D. Use the command optionATCSN.

Correct Answer: B

Question 4

Identify two correct statements regarding GoldenGate supported features.

A. GoldenGate for SQLServer supports only SQLServer Standard Edition as a source.

B. GoldenGate for Oracle supports Exadata Hybrid Columnar Compression as a source.

C. GoldenGate supports DML and DDL replication for all supported databases.

D. GoldenGate supports network encryption and compression.

Correct Answer: B,D

Question 5

You need to locate the position of the oldest unprocessed transaction by using the command INFO EXTRACT <extractgroup> SHOWCH. How should you proceed?

A. Use the Read Startup Checkpoint.

B. Use the Read Recovery Checkpoint.

C. Use the Write Startup Checkpoint.

D. Use the Read Current Checkpoint.

Correct Answer: B

Question 6

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

A. Multiple Manager services are not allowed on the same Windows server.

B. Accept the default service name and manually edit within the Services applet.

C. Create aGLOBALSfile for each installation and use theMGRSERVNAMEparameter, with a unique name.

D. Include the parameterSERVICENAMEin each Manager, with a unique name.

Correct Answer: C

Question 7

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?

A. View the GoldenGate log files to monitor Replicat report files to verify that the SCN was applied by allReplicat groups.

B. GoldenGate deployments cannot use a shared wallet.

C. 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.

D. View the report file of the newest Extract after renewing the master key to confirm the last SCN that was mined with old key.

Correct Answer: C

Question 8

What is the default threshold for message compression in OGG?

A. By default, messages are not compressed.

B. 1000

C. 100

D. O

Correct Answer: B

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

Latest Update

Useful Links

Contact Us