1. Home
  2. Oracle
  3. GoldenGate
  4. 1z0-447
  5. Oracle GoldenGate 12c Implementation Essentials Questions and Answers

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

 Oracle Exams      Go to Exam Detail      Get Premium Access
Viewing page 2 out of 3 pages
Viewing questions 11-20 out of questions
Questions # 11:

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:
A.

KEYGEN file in the GoldenGate data location

B.

COBGEN file in the GoldenGate installation location

C.

GGSKEY file in the GoldenGate data location

D.

GGSKEY file in the GoldenGate installation location

E.

ENCKEYS file in the GoldenGate installation location

Questions # 12:

Your Replicat performance seems slow. Which Replicat parameter can be used to improve performance?

Options:
A.

DEFERAPPLYINTERVAL

B.

BATCHSQL

C.

ASSUMETARGETDEFS

D.

SPECIALRUN

Questions # 13:

Your Goldengate deployment is using a shared wallet, and older versions of the master key should be retained after the master key is renewed until all processes are using the newest version.

How should you determine whether all of the processes are using the newest version so that you can delete older versions of the master key?

Options:
A.

GoldenGate deployments cannot use a shared wallet.

B.

View the GoldenGate log files to monitor Replicat report files to verify that the SCN was applied by all

Replicat groups.

C.

View the report file of the newest Extract after renewing the master key to confirm the last SCN that was mined with old key.

D.

View the report file of each Extract immediately after renewing the master key to confirm the last SCN that was mined with the old key. Then, monitor the Replicat report files to verify that this SCN was applied by all Replicat groups.

Questions # 14:

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

Questions # 15:

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?

Options:
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.

Questions # 16:

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

Questions # 17:

Replicat makes checkpoints in the trail file to mark its last read position. Select two ways to create checkpoint tables.

Options:
A.

Run thechkpt_db_extracttrail.sqlscript.

B.

Run thechkpt_db_create.sqlscript.

C.

Use theADD Extract Trailcommand.

D.

Use theINFO REPLICATcommand with theSHOWCHoption.

E.

Use theADD CHECKPOINTTABLEcommand.

Questions # 18:

You must synchronize the starting point for Replicat with the restore point of the target database. How should you accomplish this?

Options:
A.

Use the command optionAFTERCSN.

B.

Use the command optionATCSN.

C.

Use the command optionUNTIL CANCEL.

D.

Use the command optionRESUME.

Questions # 19:

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

Options:
A.

ENCKEYS

B.

ENCRYPT

C.

GLOBALS

D.

CUSTKEYS

Questions # 20:

You are running multiple installations of Oracle GoldenGate on the same Windows server. How can you

differentiate the different Manager services?

Options:
A.

Create aGLOBALSfile for each installation and use theMGRSERVNAMEparameter, with a unique name.

B.

Include the parameterSERVICENAMEin each Manager, with a unique name.

C.

Accept the default service name and manually edit within the Services applet.

D.

Multiple Manager services are not allowed on the same Windows server.

Viewing page 2 out of 3 pages
Viewing questions 11-20 out of questions