Oracle GoldenGate 12c Implementation Essentials

Question 1

Select four Oracle GoldenGate use cases.

A. offload reporting

B. data center load balancing by using multi-master replication

C. zero downtime upgrades and migrations

D. real-time data warehousing

E. backup and recovery

F. real-time discovery

Correct Answer: A,B,C,D

Question 2

You want to eliminate the reporting output from processing a Macro. How should you proceed?

A. Use the optional parameterNOREPORT.

B. Use the optional parameterNOMACROOUTPUT.

C. Use the optional parameterUNLIST.

D. Use the optional parameterNOLIST.

Correct Answer: D

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

GoldenGate has cached long-running open transactions to disk for an Oracle database.
Where can you locate them?

A. in the server temporary file system

B. in the bounded recovery area

C. in the trail files area

D. in the checkpoint file area

Correct Answer: A

Question 5

Replicat makes checkpoints in the trail file to mark its last read position. Select two ways to create checkpoint tables.

A. Use theADD CHECKPOINTTABLEcommand.

B. Run thechkpt_db_create.sqlscript.

C. Use theADD Extract Trailcommand.

D. Run thechkpt_db_extracttrail.sqlscript.

E. Use theINFO REPLICATcommand with theSHOWCHoption.

Correct Answer: A,B

Question 6

You are implementing GoldenGate monitoring via the Enterprise Manager Plug-In. When you start JAgent, it fails with "ajavA.lang.Exception: One or more Java Agent properties in Config.properties are not defined properly".
What is the first thing to check?

A. if The Enterprise Manager Agent is running

B. if the Oracle Wallet has been created for the JAgent

C. if the agent type is set to OEM in JAgent properties

D. if the JAgent has been enabled in the GoldenGate Manager

Correct Answer: C

Question 7

You want to use multiple concurrent Extract process groups. What is the key factor in determining how many can be running at the same time?

A. system memory

B. the number of compound keys on the source tables

C. disk space

D. the number of concurrent users

Correct Answer: A

Question 8

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

A. Data type (e.g. integer, alphanumeric)

B. Before or after image indicator

C. Time of the transaction

D. Relative byte address of the commit record

Correct Answer: A,B,D

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

Latest Update

Useful Links

Contact Us