Online Access Free 1z1-447 Exam Questions

You want to generate an extract file or trail in a non-GoldenGate canonical format like those used in the Initial Load file-to-database utility. How should you configure GoldenGate in order to accomplish this?

• A.Configure Extract with theFORMATSQL SQLLOADER OPTION.
• B.Configure Replicat with theFORMATXML OPTION.
• C.Configure Extract with theFORMATASCII SQLLOADER OPTION.
• D.Configure Replicat with theFORMATASCII SQLLOADER OPTION.

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

• A.when look-ups are needed against the source database
• B.when aNOPASSTHRUparameter is used
• C.when transformations, filtering, and mapping are required
• D.when aPASSTHRUparameter is used

By default which type of operations are captured by extract?

• A.Inserts, updates, and deletes
• B.Inserts, updates, deletes, and table operations such as ADD COLUMN
• C.Inserts, compresses, and updates
• D.Inserts, updates, deletes, and table operations such as CREATE TABLE
• E.Inserts only

Your Replicat performance seems slow. Which Replicat parameter can be used to improve performance?

• A.BATCHSQL
• B.ASSUMETARGETDEFS
• C.SPECIALRUN
• D.DEFERAPPLYINTERVAL

Which GLOBALS parameter is required to initially enable monitoring?

• A.ENABLEMONITORING
• B.ENABLEOEMMONITORING
• C.CHECKMONITORING
• D.JAGENTMONITORING