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.

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.

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 the COMPCOLSwith the GETUPDATEBEFORESoption of the MAP parameter in the Replicat parameter file to specify columns that are to be used with before values in the Replicat WHEREclause.

B. Use the COMPARECOLS option of the MAP parameter in the Replicat parameter file to specify columns that are to be used with before values in the Replicat WHERE clause.

C. Use the GETUPDATEBEFORES option of the MAP parameter in the Replicat parameter file to specify columns that are to be used with before values in the Replicat WHERE clause.

D. Use the GETBEFORECOLS option of the MAP parameter in the Replicat parameter file to specify columns that are to be used with before values in the Replicat WHERE clause.

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 the FILTERoption in the MAP parameter.

B. Use the COLMAPoption in the MAP parameter.

C. Do not specify those columns in the ADDTRANDATAcommand.

D. Use the COLS and COLSEXCEPToptions in the TABLE parameter.

Which two are valid macros?

A. Option A

B. Option B

C. Option C

D. Option D

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

A. Jagent

B. Extract

C. Replicat

D. Manager

Your GLOBALS file contains the parameter SYSLOG NONE, but the system logs contain warnings from the Manager. What could be causing this to occur?

A. The GGSCI session was configured incorrectly.

B. The Manager parameter file contains SYSLOG ALL.

C. An Extract or Replicat is overriding GLOBALS with SYSLOG WARN.

D. The user session running Manager is set to log all messages.

Which replication topology requires conflict resolution?

A. Broadcast

B. Consolidation

C. Master-to-Master

D. Cascading

With BATCHSQLenabled, what causes a Replicat to use normal mode operation?

A. statements with rows between 8k and 24k in length

B. when BATCHSQLand GROUPTRANSOPScoexist

C. statements which cause errors

D. when server memory < 8GB

Which other character, besides the COMMENT parameter, can you use to enter remarks in a parameter file?

A. \\

B. //

C. -

D. \*