Summer Certification Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code = getmirror

Home
Oracle
GoldenGate
1z0-447
Oracle GoldenGate 12c Implementation Essentials Questions and Answers

Pass the Oracle GoldenGate 1z0-447 Questions and answers with ExamsMirror

Practice at least 50% of the questions to maximize your chances of passing.

Exam 1z0-447 Premium Access

View all detail and faqs for the 1z0-447 exam

Go to Exam

656 Students Passed

84% Average Score

90% Same Questions

Viewing page 2 out of 3 pages

Viewing questions 11-20 out of questions

Questions # 11:

What is the function of the GoldenGate JAgent?

Options:

It performs connections via JDBC to run the Veridata comparisons.

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

It reads the database transaction logs.

It integrates GoldenGate with Oracle Data Integrator.

Answer

Questions # 12:

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

Options:

STATS

REPORT

REPORTCOUNT

COUNT

Answer

Explanation

[Reference:https://docs.oracle.com/goldengate/1212/gg-winux/GLOGD/wu_logdump.htm#GLOGD121]

Questions # 13:

What is the name and the location of the file that lists the key values used by extract for encryptions and Server Collector for decryption?

Options:

KEYGEN file in the GoldenGate data location

COBGEN file in the GoldenGate installation location

GGSKEY file in the GoldenGate data location

GGSKEY file in the GoldenGate installation location

ENCKEYS file in the GoldenGate installation location

Answer

Explanation

[Reference:, http://download.oracle.com/docs/cd/E15881_01/doc.104/gg_wux_ref_v104.pdf, ]

Questions # 14:

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

Options:

File to Replicat

GoldenGate Direct Load

File to database utility

Direct bulk load to SQL*Loader

Answer

Questions # 15:

You need to locate the position of the oldest unprocessed transaction by using the command INFO EXTRACT SHOWCH. How should you proceed?

Options:

Use the Read Startup Checkpoint.

Use the Read Recovery Checkpoint.

Use the Write Startup Checkpoint.

Use the Read Current Checkpoint.

Answer

Explanation

[Reference:https://docs.oracle.com/goldengate/1212/gg-winux/GWUAD/wu_ogg_checkpts.htm#GWUAD968]

Questions # 16:

Which is an incorrect syntax for connecting to a source or target database by an Extract or Replicat?

Options:

TARGETDB TargetDSN USERID sampleID PASSWORD samplepword

SOURCEDB SourceDSN

SOURCEDB sampleDB USERID sampleID PASSWORD samplepword

TARGETDB sampleID samplepword

Answer

Questions # 17:

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:

Include theOVERWRITEcommand.

Include theUSEDELTAcommand.

Include theADD TRANDATAcommand.

Include theUPDATAROWEXISTScommand.

Answer

Explanation

[Reference:https://docs.oracle.com/goldengate/1212/gg-winux/GWUAD/conflict_resolution.htm#GWUAD316]

Questions # 18:

Identify the correct statement regarding Trails.

Options:

Extract and Pump are different OS level executable binary files.

Extracts cannot perform filtering, mapping, and transformations.

RMTTRAILis for remote trails andEXTTRAILis for local trails.

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

Answer

Questions # 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?

Options:

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.

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.

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.

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

Explanation

[Reference:https://docs.oracle.com/goldengate/1212/gg-winux/GWUAD/conflict_resolution.htm#GWUAD317]

Questions # 20:

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?