Weekend Sale - Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: sntaclus

examout.co

If multiple GoldenGate processes are accessing a set of trial files which of the processes should include the PURGEOLDEXTRACTS parameter to trigger trail file clean up?

A.

Manager

B.

Extract

C.

Replicat

D.

Both Extract and Replicat

What is the default threshold for message compression in OGG?

A.

1000

B.

100

C.

O

D.

By default, messages are not compressed.

What file must be configured in order to use custom encryption keys?

A.

ENCKEYS

B.

ENCRYPT

C.

GLOBALS

D.

CUSTKEYS

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

Nicole is preparing initial data load Extract task EINI_HR using the parameter DBOPTIONS FECHBATCHSIZE 2000. What is likely to happen if one of her source tables includes LOB data?

A.

The Extract will revert to single-row fetch mode, and then resume array fetches afterwards.

B.

The Extract will revert to single-row fetch mode for all tables.

C.

The Extract will abend unless LOBMEMORY is increased.

D.

The Extract will perform poorly due to paging unless LOBMEMORY is increased.

What is the function of the GoldenGate JAgent?

A.

It performs connections via JDBC to run the Veridata comparisons.

B.

It enables communication between GoldenGate and Monitor, and Enterprise Manager Agent.

C.

It reads the database transaction logs.

D.

It integrates GoldenGate with Oracle Data Integrator.

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

Identify the correct statement regarding Trails.

A.

Extract and Pump are different OS level executable binary files.

B.

Extracts cannot perform filtering, mapping, and transformations.

C.

RMTTRAILis for remote trails andEXTTRAILis for local trails.

D.

Extract is typically used to produce local trail files over a TCP/IP connection.

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

Which statement correctly explains when you would use ASSUMETARGETDEFS?

A.

The target tables are already created.

B.

Only the fields in the target tables are mapped.

C.

The source and target tables have identical data structure.

D.

You have specified wildcards in either the TABLE or MAP parameters