Oracle 1Z0-947 Cert Guide PDF 100% Cover Real Exam Questions [Q69-Q92]

5/5 - (1 vote)

Oracle 1Z0-947 Cert Guide PDF 100% Cover Real Exam Questions

Pass 1Z0-947 Exam – Real Questions and Answers

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

The CHECKPOINT BEFORE clause in EVENTACTIONS causes the Extract to record a checkpoint at the beginning of the transaction, ensuring any triggered action can safely be retried if needed.

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

“A Distribution Service process will read the trail file and send it across the network to a waiting Receiver Service process…”

Q71. Which parameter gives more accurate timing for lag statistics?

CacheMgr

TCPSourceTimer

DynamicResolution

TCPSourceTimer improves lag timing accuracy.

Q72. What is GGSCI in Oracle GoldenGate?

Report generation engine

GUI-based replicat monitor

Command interpreter for managing GG processes

Extract checkpoint viewer

Oracle GoldenGate Software Command Interpreter (text-based interface)

Q73. What is the adminclient in GoldenGate MA?

A background replication daemon

A CLI tool that uses REST APIs to manage deployments

A GUI for performance metrics visualization

A browser-based management tool

Command-line utility (like GGSCI) using REST API for Microservices Architecture control/config.

Q74. You are receiving data errors involving invalid column mappings. Which two types of files can you use to identify the issue?

Use the error log because it captures information on failed GoldenGate operations.

Use the DIST command in the GLOBALS file because it captures information on failed GoldenGate operations.

Use the STATS command in the GLOBALS file because it captures information on failed GoldenGate operations.

Use the discard file because it captures information on failed GoldenGate operations.

Q75. GGSCI commands can display:

Processing status

All of the above

Statistics (operations processed)

Lag in the system

GGSCI provides status, statistics, and lag details

Q76. Which parameter is used to identify the remote target system in Oracle GoldenGate?

RmtHost

Map

TargetTrail

HostName

Q77. What parameter manages conflicts between initial load and replication?

RESOLVE_INIT_LOAD

HANDLECOLLISIONS

IGNORE_ERRORS

CONFLICT_RESOLVER

It allows GoldenGate to resolve conflicts during overlapping load and replication.

Q78. Identify the scenario in which you cannot configure GoldenGate.

Real-time Change Data Capture from transaction logs

Batch Data Transfer from table data

Snapshot database backups

Initial Load synchronization

Snapshot database backups are not a replication scenario – GoldenGate does not operate on backups. It’s designed for live, transactional, and log-based data movement, not static snapshots.

Q79. Oracle GoldenGate is a middleware software and can be used for business intelligence to support a heterogeneous database environment.

FALSE

TRUE

GoldenGate is middleware supporting business intelligence across different databases.

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

Oracle GoldenGate Monitor

CMDSEC

GGSCI

Process report

tcpers

Use GGSCI, process reports, or Monitor to check running processes.

Q81. Which option is an invalid GLOBALS parameter?

GGSCHEMA

CHECKPOINTTABLE

DISCARDFILE

MGRSERVNAME

The invalid GLOBALS parameter option is DISCARDFILE.

Q82. How should you specify the data source for a secondary Extract functioning as a Data Pump?

SOURCEISTRAIL

EXTTRAILSOURCE

SOURCEISSTABLE

LOCTRAILSOURCE

For a secondary Extract functioning as a Data Pump, you should specify the data source using EXTTRAILSOURCE. This parameter tells GoldenGate to use the local trail file (created by the primary Extract) as the source for the data pump.

Q83. SQLEXEC can communicate only via SQL query.

TRUE

FALSE

SQLEXEC can run scripts, not just SQL queries.

Q84. What is the purpose of the DiscardFile?

To backup configuration changes

To discard unused trail files

To log failed operations Replicat couldn’t process

To store Replicat cache

It identifies operations that could not be processed by Replicat.

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

Integrated Replicat processes Logical Change Records (LCRs). These LCRs are read from trail files and passed to the Inbound Server. It supports parallel apply and uses Oracle Streams APIs internally.

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

FALSE

TRUE

Drill-downs are available only for Extract groups.

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

When the difference between the oldest open transaction’s start and the current read position is large, Extract must scan more log data, increasing recovery time.

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

Broadcast topology describes a one-to-many data replication model: A single source sends data to multiple target sites Targets often receive the same set of replicated changes

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

TRUE

FALSE

Full DBA role is not mandatory for Extract or Replicat.

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

File to Replicat, File to database utility, Direct load & Direct bulk load (via SQL*Loader API)

Q91. Invisible columns are columns that are part of a table but not part of the results in a select. When Data Definition Language (DDL) replication is enabled, invisible and virtual columns created in the source environment are replicated in the target environment. What parameter in Extract will exclude invisible columns from replication when using the Integrated Extract?

NOINVISIBLECOLUMNS

EXCLUDEHIDDENCOLUMNS

NOHIDDENCOLUMNS

“Oracle GoldenGate supports replication of invisible columns in Extract.
If you want to exclude them, use the EXCLUDEHIDDENCOLUMNS parameter.”

Q92. What command is used to create the checkpoint table on the target database?

INIT CHECKPOINTTABLE

CREATE TABLE CHECKPOINT

ADD CHECKPOINTTABLE

CONFIGURE CHECKPOINT TABLE

This command creates a table that tracks Replicat’s checkpointing data.

Loading …