1z0-447 Exam Dumps - Oracle GoldenGate 12c Implementation Essentials

Question # 4

Which combination of DBMS, Extract, and GoldenGate version is required to avoid using a DDL trigger?

Oracle Database 11.2.0.3 or greater, Integrated Extract, and GoldenGate 12.1 or greater

any version of Oracle Database, Integrated Extract, and GoldenGate 11.2 or greater

Oracle Database 11.2.0.4 or greater, Integrated Extract, and GoldenGate 12.1 or greater

Oracle Database 12c or greater, Integrated Extract, and GoldenGate 11.2 or greater

Full Access

Question # 5

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?

GoldenGate deployments cannot use a shared wallet.

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

Replicat groups.

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

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.

Full Access

Question # 6

Which statement correctly explains when you would use ASSUMETARGETDEFS?

The target tables are already created.

Only the fields in the target tables are mapped.

The source and target tables have identical data structure.

You have specified wildcards in either the TABLE or MAP parameters

Full Access

Question # 7

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

PASSTHRU

SOURCEISFILE

CHECKMINUTES

SOURCEISTABLE

SPECIALRUN

Full Access

Question # 8

Which GLOBALS parameter is required to initially enable monitoring?

JAGENTMONITORING

ENABLEMONITORING

ENABLEOEMMONITORING

CHECKMONITORING

Full Access

Question # 9

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

GoldenGate trail file contains the metadata of incoming data

Replicat uses an ODBC connection to connect to the source system tables

Parameter file contains table layouts

Discard file contains table layouts

Source Definitions file contains table layouts

Full Access

Question # 10

You have configured and added the Extract and Replicat tasks by using the Direct Load method. What do you need to do to get the processes up and running?

Start the Extract task.

Start the Extract task, wait for it to stop, and then start the Replicat task.

Start the Extract task and then start the Replicat task.

Start the Replicat task.

Full Access