Feb-2026 Pass Your 1Z0-947 Exam at the First Try with 100% Real Exam [Q38-Q60]

NO.38 What is a “trail” in GoldenGate?

A series of files that store captured data

A transport layer protocol

A type of error log

A link between Replicat and Extract

NO.39 What are the five main components of Oracle GoldenGate Microservices Architecture (MA)?

Extract, Pump, Replicat, Trail, Checkpoint

Service Manager, Administration Server, Distribution Server, Receiver Server, Performance Metrics Server

AdminClient, Logger, Trail Viewer, Deploy Agent, OGGBridge

Monitor Server, Extract Server, Replicat Server, Admin Console, Trail Manager

NO.40 Which of the following is not an initial load method in Oracle GoldenGate?

File to database utility

SQL*Net Load

Direct load

File to Replicat

NO.41 Which parameter gives more accurate timing for lag statistics?

CacheMgr

TCPSourceTimer

DynamicResolution

NO.42 You need to manually patch Oracle GoldenGate source and targets. How should you proceed?

Stop access to the source and target databases. Start applying the patch on the source. Stop the data pump and Replicat. Apply the patch on the target. Start the Oracle GoldenGate processes whenever you are ready to begin capturing user activity again.

Stop access to the source and target databases. Allow Extract to finish capturing the transaction data that remains in the transaction log and stop Extract. Start applying the patch on the source. Wait until the data pump (if used) and Replicat are finished processing the data in their respective trails. Stop the data pump and Replicat. Apply the patch on the target. Start the Oracle GoldenGate processes whenever you are ready to begin capturing user activity again.

Stop access to the source. Allow Extract to finish capturing the transaction data that remains in the transaction log and stop Extract. Start applying the patch on the source. Wait until the data pump/Replicat are finished processing the data in their respective trails. Stop the data pump/Replicat. Apply the patch on the target. If the patches changed table defs, run DEFGEN for the source tables to generate updated source defs, and then replace the old defs with the new ones in the existing source defs file on the target. Start GG processes when ready to begin capturing activity again.

Stop access to the source database. Allow Extract to finish capturing the transaction data that remains in the transaction log and stop Extract. Start applying the patch on the source and on the target. Start the Oracle GoldenGate processes whenever you are ready to begin capturing user activity again.

NO.43 What Oracle GoldenGate component sends trail files over the network to the Receiver Server?

The Trail File Server

The Distribution Server on the source

The GoldenGate source Data Pump

The Extract

NO.44 You have offloaded data from the source onto a file. What method would you use to perform your initial load onto the target database?

File to Replicat

GoldenGate Direct Load

Direct bulk load to SQL*Loader

File to database utility

NO.45 A database that requires replication contains sensitive data that is not required on the target. How should you prevent this sensitive data from being replicated?

Use the COLMAP option in the MAP parameter.

Use the COLS and COLSEXCEPT options in the TABLE parameter.

Use the FILTER option in the MAP parameter.

Do not specify those columns in the ADD TRANDATA command.

NO.46 What is the purpose of the GoldenGate Initial Load?

To stream change data to a target database

To create the target database objects

To carry out Performance Load Testing

To synchronize data in the source and target databases

NO.47 An Oracle GoldenGate topology is a representation of the databases in a GoldenGate environment, how the GoldenGate components are configured on each server, and the flow of data between the components. What topology describes a configuration of data flow from one source site to many target sites?

Broadcast

Integration

Multimaster

Cascading

NO.48 SQLEXEC can communicate only via SQL query.

TRUE

FALSE

NO.49 Which three are requirements to correctly configure an OGG trail file?

An Extract process

A Replicat process

Designation as local or remote

A trail file identifier

A maximum file size

NO.50 Using the built-in lightweight filtering facility, the Distribution Server allows you to operate simple transformations while dispatching trail files to the Receiver Server.

FALSE

TRUE

NO.51 You want to use coordinated Replicat mode instead of classic mode. Which three reasons should you consider for this?

Replicat is multi-threaded in coordinated mode.

Only one parameter file is required for a coordinated Replicat, regardless of the number of threads.

Coordinated Replicat allows for user-defined partitioning of the workload so as to apply high-volume transactions concurrently.

Multiple transactions on the target are executed with full synchronization.

Parent and child tables must not be processed by the same apply thread.

NO.52 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?

Include the USEDELTA command.

Include the UPDATAROWEXISTS command.

Include the OVERWRITE command.

Include the ADD TRANDATA command.

NO.53 When using CHECKPOINT BEFORE for EVENTACTIONS, what will an Extract do?

Extract will checkpoint on the starting boundary of the transaction.

Extract will stop at the end of the transaction.

Extract will Abend while processing the transaction.

Extract will checkpoint at the end of the transaction.

NO.54 Where can Oracle GoldenGate software be downloaded officially?

My Oracle Support

Oracle Database Utilities

Oracle Cloud Marketplace

OTN or http://edelivery.oracle.com

NO.55 Which three are the responsibilities of the MGR process?

Data movement

Trail file management

Receive or route requests from the UI

Process management

Trigger execution

NO.56 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?

Integrated Replicat does not need a checkpoint or a trace table for its operations.

Trail files contain data that must be in logical change records format.

Source must be configured as Integrated Extract.

Both source and target can be Oracle and non-Oracle databases.

NO.57 Cache and queue statistic drill-downs are available for both Extract and Replicat groups.

FALSE

TRUE

NO.58 Source and target tables have the same column order, data types, and column sizes, yet different table and column naming. Which Replicat parameter will handle this mapping?

ASSUMETARGETDEFS

SOURCEDEFS

COLMAP (TargetColumnName=SourceColumnName, …)

COLMAP (USEDEFAULTS)…

NO.59 You can connect to the Receiver Server to manage (start and stop) the configured data paths.

FALSE

TRUE

NO.60 You have an issue where all threads are waiting for a specific transaction to be executed first. What is this issue related to?

It is caused by barrier transactions in a Coordinated Replicat.

It is caused by the use of the MAXTRANSOPS parameter.

It is caused by the thread with the highest thread ID applying barrier transactions.

It is caused by THREAD and THREADRANGE being used with wildcard MAP statements.