March Sale Special - Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: top65certs

Oracle 1z0-447 Dumps

Page: 1 / 3
Total 72 questions

Oracle GoldenGate 12c Implementation Essentials Questions and Answers

Question 1

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?

Options:

A.

Use theCOMPCOLSwith theGETUPDATEBEFORESoption of the MAP parameter in the Replicat parameter 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.

Question 2

Which could be used to map a value stored in a user token to a target column?

Options:

A.

@GETENV

B.

GGHEADER

C.

GGENVIRONMENT

D.

©TOKEN

Question 3

Which three describe a valid OGG Event Action?

Options:

A.

Stop the process

B.

Write a checkpoint before and/or after writing the record to the trail.

C.

Run a shell command

D.

Purge old trail files

Question 4

Veridata has completed the initial comparison and you want to view the rows that appear to be out-of-sync. How can you do this?

Options:

A.

View the maybe out-of-sync (MOOS) queue.

B.

View the Veridata log file.

C.

View the confirm-out-of-sync (COOS) queue.

D.

View the Veridata Agent repository.

Question 5

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?

Options:

A.

Tables set with nologging

B.

Tables with Large Object (LOB) data types

C.

Tables that have conflicts

D.

Triggers and sequences

Question 6

When would you use the PASSTHRU parameter?

Options:

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.

Question 7

Which three are types of encryption supported by OGG?

Options:

A.

Parameter file encryption

B.

Password

C.

Trial file encryption

D.

Message encryption

Question 8

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

Options:

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

Question 9

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

Options:

A.

File to Replicat

B.

GoldenGate Direct Load

C.

File to database utility

D.

Direct bulk load to SQL*Loader

Question 10

Which three are required to correctly configure an OGG?

Options:

A.

A maximum file size

B.

An extract process

C.

A trail file identifier

D.

Designation as local or remote

Page: 1 / 3
Total 72 questions