New Year Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 70special

Oracle 1z0-447 Oracle GoldenGate 12c Implementation Essentials Exam Practice Test

Page: 1 / 7
Total 72 questions

Oracle GoldenGate 12c Implementation Essentials Questions and Answers

Testing Engine

  • Product Type: Testing Engine
$37.5  $124.99

PDF Study Guide

  • Product Type: PDF Study Guide
$33  $109.99
Question 1

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

Options:

A.

TARGETDDL

B.

GETDDL

C.

DDL for Replicat is enabled by default.

D.

USEDDL

Question 2

Which database setting for the Oracle 11.2.0.4 database is required to enable Oracle GoldenGate?

Options:

A.

ENABLE_GOLDENGATE_REPLICATION=true

B.

ENABLE_STREAMS_REPLICATION=true

C.

Configure theSTREAMS_POOL_SIZEdatabase parameter

D.

ENABLE_DATABASE_REPLICATION=true

Question 3

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?

Options:

A.

Use theFILTERoption in theMAPparameter.

B.

Use theCOLMAPoption in theMAPparameter.

C.

Do not specify those columns in theADD TRANDATAcommand.

D.

Use theCOLSandCOLSEXCEPToptions in theTABLEparameter.

Question 4

You want to eliminate the reporting output from processing a Macro. How should you proceed?

Options:

A.

Use the optional parameterNOLIST.

B.

Use the optional parameterUNLIST.

C.

Use the optional parameterNOREPORT.

D.

Use the optional parameterNOMACROOUTPUT.

Question 5

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 6

Which Logdump command is used to check how many change records are in the trail file?

Options:

A.

STATS

B.

REPORT

C.

REPORTCOUNT

D.

COUNT

Question 7

You need to configure the source database, target database, and Oracle GoldenGate for conflict detection and resolution (CDR). You want the full before image of each record, but your database does not provide a before image in the log record and must be configured to do so with supplemental logging.

How should you proceed?

Options:

A.

Include theOVERWRITEcommand.

B.

Include theUSEDELTAcommand.

C.

Include theADD TRANDATAcommand.

D.

Include theUPDATAROWEXISTScommand.

Question 8

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

Options:

A.

PASSTHRU

B.

SOURCEISFILE

C.

CHECKMINUTES

D.

SOURCEISTABLE

E.

SPECIALRUN

Question 9

Ideally which process should be configured purge old trial files?

Options:

A.

Manager

B.

Extract

C.

Replicat

D.

Pump

Question 10

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

Options:

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.

Page: 1 / 7
Total 72 questions