New Questions 1

What is the key purpose of GoldenGate trail files?

A. They are a persistent storage area for captured transactions.

B. They are configuration files for the GoldenGate processes.

C. They are checkpoint files for the GoldenGate processes.

D. They are database auditing logs where GoldenGate captures changes.

New Questions 2

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

New Questions 3

Identify two correct statements regarding GoldenGate supported features.

A. GoldenGate supports network encryption and compression.

B. GoldenGate supports DML and DDL replication for all supported databases.

C. GoldenGate for Oracle supports Exadata Hybrid Columnar Compression as a source.

D. GoldenGate for SQLServer supports only SQLServer Standard Edition as a source.

New Questions 4

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 aPASSTHRUparameter is used

D. when aNOPASSTHRUparameter is used

New Questions 5

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

New Questions 6

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

A. Before or after image indicator

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

C. Relative byte address of the commit record

D. Time of the transaction

New Questions 7

When would you use the PASSTHRU parameter?

A. When using a data pump to distribute all of the trail data "as is" to a remote system.

B. When Extract is processing database transaction logs where you have a remote database connection.

C. For a SPECIALRUN one-time processing task that is doing an initial load.

D. When Extract is processing database transaction logs and writing to a local trial that will be read by a local Replicat.

New Questions 8

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

New Questions 9

Select four Oracle GoldenGate use cases.

A. real-time discovery

B. real-time data warehousing

C. offload reporting

D. zero downtime upgrades and migrations

E. backup and recovery

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

New Questions 10

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