Online Access Free 1Z1-947 Practice Test

Which tools would you use to determine if all Oracle GoldenGate processes are up and running?

• A.CMDSEC
• B.tcpers
• C.GGSCI
• D.Process report
• E.Oracle GoldenGate Monitor

The Integrated Replicat reads the trail, constructs logical change records that represent source DML or DDL transactions, and transmits these records to an inbound server in the Oracle target database. What statement is true about Integrated Replicat?

• A.Source must be configured as Integrated Extract.
• B.Integrated Replicat does not need a checkpoint or a trace table for its operations.
• C.Both source and target can be Oracle and non-Oracle databases.
• D.Trail files contain data that must be in logical change records format.

Identify the scenario in which you cannot configure GoldenGate.

• A.Initial Load synchronization
• B.Snapshot database backups
• C.Batch Data Transfer from table data
• D.Real-time Change Data Capture from transaction logs

You must locate the next good record header in a Logdump file. How should you do this?

• A.Logdump > GHDR ON
• B.Logdump > SCANFORHEADER
• C.Logdump > SCANFORGHDR
• D.Logdump > SCANFORENDTRANS

Initial Load is a process of extracting data records from the source database and loading those records onto the target database. There are many advantages in using GoldenGate to obtain the data from the source and load the records onto the target. What describes the advantage of continuing to make data changes on the source database while loading data onto the target database?

• A.Enable change delivery to handle collisions with initial load.
• B.Enable data changes on source tables without locking tables.
• C.Enable Extract to indicate in the trail file when initial load commenced.
• D.Enable the LGWR to indicate in the transaction log when initial load commenced.