Labour Day Special Limited Time Flat 70% Discount offer - Ends in 0d 00h 00m 00s - Coupon code: 70spcl

Activedumpsnet Logo
  1. Home
  2. Oracle
  3. GoldenGate
  4. 1z0-447 - Oracle GoldenGate 12c Implementation Essentials

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

Page: 1 / 7
Total 72 questions
Get 1z0-447 Full Access Download 1z0-447 PDF

Oracle GoldenGate 12c Implementation Essentials Questions and Answers

Question 1

What process is the recommended method to purge old GoldenGate trials?

Options:

A.

Extract r

B.

Replicat

C.

Manager

D.

Manager and Replica

Question 2

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 3

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 4

When is a Pump not required to connect to a source database?

Options:

A.

when transformations, filtering, and mapping are required

B.

when look-ups are needed against the source database

C.

when aPASSTHRUparameter is used

D.

when aNOPASSTHRUparameter is used

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

Which option is supported by GoldenGate DDL replication?

Options:

A.

CREATE ROLE

B.

ALTER SYSTEM

C.

ALTER DATABASE

D.

ALTER TABLE SYS

Question 7

Your Extract process, which is using an Oracle database, has stopped with uncommitted transactions. How should you guarantee an efficient recovery after Extract has stopped?

Options:

A.

Use theFORCETRANSandPURGEORPHANEDTRANSACTIONSparameters to control the bounded recovery feature of the general Extract checkpointing facility.

B.

Use theWARNLONGTRANSparameter to control the bounded recovery feature of the general Extract

checkpointing facility.

C.

Use theBRparameter to control the bounded recovery feature of the general Extract checkpointing facility.

D.

Use thePURGEORPHANEDTRANSACTIONSparameter to control the bounded recovery feature of the general Extract checkpointing facility.

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

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?

Options:

A.

Manager

B.

Extract

C.

Replicat

D.

Both Extract and Replicat

Question 10

What is the key purpose of GoldenGate trail files?

Options:

A.

They are a persistent storage area for captured transactions.

B.

They are configuration files for the GoldenGate processes.

C.

They are checkpoint files for the GoldenGate processes.

D.

They are database auditing logs where GoldenGate captures changes.

Load More 1z0-447 Questions 
Page: 1 / 7
Total 72 questions
Get 1z0-447 Full Access Download 1z0-447 PDF