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

• A. Run thechkpt_db_extracttrail.sqlscript.
• B. Run thechkpt_db_create.sqlscript.
• C. Use theADD Extract Trailcommand.
• D. Use theINFO REPLICATcommand with theSHOWCHoption.
• E. Use theADD CHECKPOINTTABLEcommand.

Answer: BE

NEW QUESTION 2
Which parameter for GoldenGate 12c enables DDL replication for a Replicat?

• A. TARGETDDL
• B. GETDDL
• C. DDL for Replicat is enabled by default.
• D. USEDDL

Answer: C

NEW QUESTION 3
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

Answer: C

NEW QUESTION 4
How does Replicate know the structure of the source tables when the target has a different layout?

• A. GoldenGate trail file contains the metadata of incoming data
• B. Replicat uses an ODBC connection to connect to the source system tables
• C. Parameter file contains table layouts
• D. Discard file contains table layouts
• E. Source Definitions file contains table layouts

Answer: E

NEW QUESTION 5
By default which type of operations are captured by extract?

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

Answer: E

NEW QUESTION 6
Which method in GoldenGate should you use to undo DML changes previously made to a target database?

• A. Run Extract and Replicat from the command line.
• B. Use Extract and Replicat with the GoldenGate Logdump utility.
• C. Run the Reverse Utility on the target database transaction logs.
• D. Use Extract and Replicat with the GoldenGate Reverse utility.

Answer: D

NEW QUESTION 7
What software is required prior to running Oracle GoldenGate in a Windows Server environment?

• A. Oracle Gateway software configured for that particular database platform
• B. JDBC drivers into the GoldenGate home directory
• C. Microsoft Visual C++ 2010 SP1 Redistributable Package
• D. Nothing, configure GoldenGate Jagent for that particular database platform.

Answer: C

NEW QUESTION 8
You must implement GoldenGate in a master-to-master configuration. What output from the profiling scripts should you look for to ensure that your implementation is correct?

• A. Tables set with nologging
• B. Tables with Large Object (LOB) data types
• C. Tables that have conflicts
• D. Triggers and sequences

Answer: C

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

• A. Before or after image indicator
• B. Data type (e.
• C. integer, alphanumeric)
• D. Relative byte address of the commit record
• E. Time of the transaction

Answer: ABC

NEW QUESTION 10
You have discovered that an OGG checkpoint table has become corrupted. What is you best strategy to recover From this?

• A. Use the CONVCHK utility on the target to restore the checkpoint table from checkpoint files.
• B. Restore the target DB from backup, reposition the Extract to a point prior to the corruption, Turn to HANDLECOLLISIONS in the Replicat.
• C. Use NODECHECKPONT to cause Replicat to use the checkpoint files as backup and regenerate the checkpoint table.
• D. Use the GENCHK utility on the source to restore the checkpoint table from checkpoint files.

Answer: A

NEW QUESTION 11
Ideally which process should be configured purge old trial files?

• A. Manager
• B. Extract
• C. Replicat
• D. Pump

Answer: A

NEW QUESTION 12
Which combination of DBMS, Extract, and GoldenGate version is required to avoid using a DDL trigger?

• A. Oracle Database 11.2.0.3 or greater, Integrated Extract, and GoldenGate 12.1 or greater
• B. any version of Oracle Database, Integrated Extract, and GoldenGate 11.2 or greater
• C. Oracle Database 11.2.0.4 or greater, Integrated Extract, and GoldenGate 12.1 or greater
• D. Oracle Database 12c or greater, Integrated Extract, and GoldenGate 11.2 or greater

Answer: C

NEW QUESTION 13
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 theFILTERoption in theMAPparameter.
• B. Use theCOLMAPoption in theMAPparameter.
• C. Do not specify those columns in theADD TRANDATAcommand.
• D. Use theCOLSandCOLSEXCEPToptions in theTABLEparameter.

Answer: B

NEW QUESTION 14
You must replicate to JMS Queues. Which product in the Oracle GoldenGate portfolio should be used?

• A. Oracle Goldengate for Big Data
• B. Oracle Goldengate Application Adapters
• C. Oracle Goldengate Veridata
• D. Oracle Data Integrator Adapters

Answer: B

NEW QUESTION 15
Which parameters) would be used for one-time initial replicat?

• A. PASSTHRU
• B. SOURCEISFILE
• C. CHECKMINUTES
• D. SOURCEISTABLE
• E. SPECIALRUN

Answer: E

NEW QUESTION 16
How should you configure Replicat to control how errors are handled in one-way replication?

• A. UseREPERRORin the Replicat parameter file.
• B. UseHANDLECOLLISIONin the Replicat parameter file.
• C. Use Conflict Detection and Resolution in the Replicat parameter file.
• D. UseMAPEXCEPTIONin the Replicat parameter file.

Answer: A

NEW QUESTION 17
You have configured and added the Extract and Replicat tasks by using the Direct Load method. What do you need to do to get the processes up and running?

• A. Start the Extract task.
• B. Start the Extract task, wait for it to stop, and then start the Replicat task.
• C. Start the Extract task and then start the Replicat task.
• D. Start the Replicat task.

Answer: C

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

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

Answer: B

NEW QUESTION 19
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 theCOMPCOLSwith theGETUPDATEBEFORESoption of the MAP parameter in the Replicatparameter file to specify columns that are to be used with before values in the ReplicatWHERE clause.
• B. Use theCOMPARECOLSoption of the MAP parameter in the Replicat parameter file to specify columns that are to be used with before values in the ReplicatWHEREclause.
• C. Use theGETUPDATEBEFORESoption of the MAP parameter in the Replicat parameter file to specify columns that are to be used with before values in the ReplicatWHEREclause.
• D. Use theGETBEFORECOLSoption of the MAP parameter in the Replicat parameter file to specify columns that are to be used with before values in the ReplicatWHEREclause.

Answer: B

NEW QUESTION 20
You must synchronize tables with Large Object data types. Which Initial Load method supports this process?

• A. File to Replicat
• B. GoldenGate Direct Load
• C. File to database utility
• D. Direct bulk load to SQL*Loader

Answer: D

NEW QUESTION 21
......