1Z0-447 Online Practice Questions and Answers

You must return column-level detail for out-of-sync rows. How can you accomplish this?

A. The Oracle GoldenGate Veridata Agent executes database-related requests on behalf of the Oracle GoldenGate Veridata Server.

B. The Oracle GoldenGate Veridata Manager executes auto-memory database-related requests on behalf of the Oracle GoldenGate Veridata Server.

C. The Oracle GoldenGate Veridata Agent source database executes database-related requests on behalf of the Oracle GoldenGate Veridata Server.

D. The Oracle GoldenGate Veridata Manager executes database-related requests on behalf of the Oracle GoldenGate Veridata Server.

When is a Pump not required to connect to a source database?

A. when transformations, filtering, and mapping are required

B. when look-ups are needed against the source database

C. when a PASSTHRU parameter is used

D. when a NOPASSTHRUparameter is used

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. GoldenGate deployments cannot use a shared wallet.

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

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

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

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

A. Run the chkpt_db_extracttrail.sql script.

B. Run the chkpt_db_create.sql script.

C. Use the ADDExtract Trail command.

D. Use the INFOREPLICAT command with the SHOWCH option.

E. Use the ADDCHECKPOINTTABLEcommand.

Which database setting for the Oracle 11.2.0.4 database is required to enable Oracle GoldenGate?

A. ENABLE_GOLDENGATE_REPLICATION=true

B. ENABLE_STREAMS_REPLICATION=true

C. Configure the STREAMS_POOL_SIZEdatabase parameter

D. ENABLE_DATABASE_REPLICATION=true

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.propertiesare not defined properly”.

What is the first thing to check?

A. if The Enterprise Manager Agent is running

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

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

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

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

A. in the checkpoint file area

B. in the trail files area

C. in the server temporary file system

D. in the bounded recovery area

Which replication topology requires conflict resolution?

A. Broadcast

B. Consolidation

C. Master-to-Master

D. Cascading