[2025] 1Z0-947 PDF Questions – Perfect Prospect To Go With ValidBraindumps Practice Exam [Q70-Q94]

Q70. Which statement about trails is correct?

Trail files are used to show the order GoldenGate files are accessed to perform replication.

RMTTRAIL is for remote trails and EXTTRAIL is for local trails.

Trail files are used to show how many records your Distribution Path is trailing behind the Extract.

Extract is typically used to produce local trail files over a TCP/IP connection.

Q71. You want to increase parallelism for greater integrated Replicat throughput while preserving the original transaction atomicity. How can you achieve this?

You can configure integrated Replicat with two parallel apply servers.

You can configure integrated Replicat with two parallel child servers.

You can configure integrated Replicat ASSUMETARGETDEFS and SPECIALRUN parameters.

You can configure integrated Replicat with SPECIALRUN parameter.

Q72. You are concerned that the process report generation in your production environment will become too large and not contain useful statistics.

Use the parameter REPORT.

Use the parameter REPORTROLLOVER.

Use the ADD EXTTRAIL command option MEGABYTES.

GoldenGate automatically generates a new report when the processes start.

Q73. Suppose your process stops immediately after verifying parameter syntax. What is the most likely reason?

Oracle GoldenGate reports syntax problems

The group name is spelled wrong

The database user has incorrect permissions

The CheckParams parameter is enabled

Q74. Users of both Extract and Replicat require the DBA role for the database.

FALSE

TRUE

Q75. What Oracle GoldenGate microservices component is used to allow administrators to create and manage one or multiple Oracle GoldenGate deployments on a local host?

Distribution server

Administration server

Extract and Replicat server

Service Manager

Q76. 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.

Q77. You want to use multiple concurrent Extract process groups. What is the key factor in determining how many can be running at the same time?

Disk space

The number of compound keys on the source tables

System memory

The number of concurrent users

Q78. Which of these is a valid Replicat parameter in Oracle GoldenGate?

PASSTHRU

DynamicPortList

RmtHost

SourceDefs

Q79. What is a valid net result for an Extract configured with the parameters in this order: GETINSERTS, GETUPDATEBEFORES, IGNOREDELETES, IGNOREUPDATES?

Inserts, updates, and deletes will be captured.

Before and after images of updates will be captured.

Before and after images of updates will be ignored.

Inserts and deletes will be captured.

Q80. Which transactions are captured if you ADD EXTRACT with BEGIN NOW at 1:00 PM, but START EXTRACT at 2:00 PM?

Only transactions that started at or after 2:00 PM

Transactions that started before 1:00 PM and committed after 2:00 PM

Transactions that started at or after 1:00 PM

Only transactions that started before 1:00 PM and committed after 1:00 PM

Q81. Only the EncryptTrail Extract parameter should be used to encrypt/decrypt trail file records.

TRUE

FALSE

Q82. You must provide credentials, like a username and password, to access the database credentials store where the actual user credentials are stored. The credential store is preferable to using the database username and password in the commands or the parameter file. What may you use rather than a user ID and password, in the parameter file, for the Extract or Replicat to provide credentials for access to the source or target database?

UserIDAlias

UserReplicationUser

Oracle SID

Single Sign On

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

GGSCI

Oracle GoldenGate Monitor

Process report

CMDSEC

tcpers

Q84. In integrated mode, the Replicat process leverages the apply processing functionality that is available within the Oracle database. How does it operate?

It reads the Oracle GoldenGate trail, performs data filtering, mapping, and conversion. Then, it constructs logical change records (LCRs) from source database DML transactions. DDL is applied directly by Replicat. Finally, it transmits the LCRs to the inbound server, which applies the data to the target database.

It reads the Oracle GoldenGate trail, performs data filtering, mapping, and conversion. Then, it constructs logical change records (LCRs) from source database DML transactions. Then it is attached to a background process in the target database by means of lightweight streaming mechanism, which transmits the LCRs to the inbound server, which applies the data to the target database.

It reads the Oracle GoldenGate trail, performs data filtering, mapping and conversion. Then, it transmits the regular change records to the inbound server, which applies the data to the target database.

It reads the Oracle GoldenGate trail, performs data filtering, mapping and conversion. Then, it constructs logical change records from source database DML transactions. Next, it uses standard SQL to apply data directly to the target tables.

Q85. The filter clause provides the ability to include or exclude data to process. What is true with this filter clause FILTER (ON UPDATE, ON DELETE, @COMPUTE(PRODUCT_PRICE * PRODUCT_AMOUNT) > 10000);?

Data processing will exclude rows for update if (PRODUCT_PRICE * PRODUCT_AMOUNT) is not greater than 10000.

Data processing will include rows for delete if (PRODUCT_PRICE * PRODUCT_AMOUNT) is not greater than 10000.

Data processing will include rows for insert if (PRODUCT_PRICE * PRODUCT_AMOUNT) is not greater than 10000.

Data processing will exclude rows for delete if (PRODUCT_PRICE * PRODUCT_AMOUNT) is not greater than 10000.

Q86. A macro is a built-in automation tool that enables you to call a stored set of processing steps. It can consist of a set of parameters that can be referenced from within a parameter file. What is true about the parameters of a macro?

The parameters in a macro cannot be dynamic parameters.

Macros can only be defined at the source site in the Extract parameter file.

You cannot have macros in a GLOBALS parameter file.

You can reuse a group of parameters in commands and functions by using a macro.

Q87. Which formats can extract trails be written in?

Only Canonical and SQL

LOB, RAW, JSON

Canonical, LCR, Text (ASCII/UTF), SQL, XML

Binary, CSV, JSON

Q88. A Distribution Path sends the transaction of data from Extract to Replicat. How can you create a Distribution Path?

In GGSCI with GoldenGate commands

From the Service Manager home page

At OS prompt with run preceding the GoldenGate commands

From Cloud Shell with REST APIs

Q89. Replicat makes checkpoints in the trail file to mark its last read position. How can you create a checkpoint table?

Use the ADD CHECKPOINTTABLE command.

Use the INFO REPLICAT command with the SHOWCH option.

Use the ADD Extract Trail command.

Run the chkpt_db_extracttrail.sql script.

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

FALSE

TRUE

Q91. You have a table that has a primary key as well as an additional unique key. Failing to consistently identify a row will result in an error during conflict resolution. Which option solves this?

Add unique indexes to the table to resolve the conflict.

Use the RESOLVECONFLICT feature to handle errors and resolve the conflict.

Use the SQLEXEC feature to handle errors and resolve the conflict.

Use the HANDLECOLLISIONS feature to handle errors and resolve the conflict.

Q92. You find that an Extract’s recovery time increases. What caused it?

The current read position (RBA) is less than the oldest open (uncommitted) transaction position.

The difference between the start of the oldest open (uncommitted) transaction and current read position in the transaction log stored in the checkpoint file is large.

The oldest open (uncommitted) transaction is small.

There is no oldest open (uncommitted) transaction.

Q93. Which utility is used to view the contents of trail files?

trailreader

datapump

ggconsole

logdump

Q94. When should the KeyCols parameter be used?

In addition to the primary key

In addition to the unique index

To define a substitute primary key