A Fully Updated 2026 1Z1-947 Exam Dumps - PDF Questions and Testing Engine
Easy Success Oracle 1Z1-947 Exam in First Try
NEW QUESTION # 86
Identify the scenario in which you cannot configure GoldenGate.
- A. Snapshot database backups
- B. Batch Data Transfer from table data
- C. Real-time Change Data Capture from transaction logs
- D. Initial Load synchronization
Answer: A
Explanation:
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.
NEW QUESTION # 87
Which is an invalid combination for EVENTACTIONS with options?
- A. EVENTACTIONS (CHECKPOINT AFTER, ABORT)
- B. EVENTACTIONS (CHECKPOINT BEFORE, ABORT)
- C. EVENTACTIONS (CHECKPOINT BOTH, IGNORE)
- D. EVENTACTIONS (CHECKPOINT BOTH, STOP)
Answer: C
Explanation:
According to Oracle GoldenGate documentation, IGNORE cannot be combined with any CHECKPOINT option. CHECKPOINT implies data consistency, while IGNORE skips the transaction entirely-creating a logical conflict.
NEW QUESTION # 88
Which formats can extract trails be written in?
- A. Only Canonical and SQL
- B. LOB, RAW, JSON
- C. Binary, CSV, JSON
- D. Canonical, LCR, Text (ASCII/UTF), SQL, XML
Answer: D
Explanation:
Oracle GoldenGate trail format: canonical, LCR, Text (ASCII or UTF), SQL, XML
NEW QUESTION # 89
How can you tell if GoldenGate has been configured for batch processing?
- A. There is a dedicated GoldenGate process called SPECIALRUN
- B. The SPECIALRUN parameter is in the GLOBALS parameter file
- C. The SPECIALRUN parameter is in the Replicat parameter file
- D. The SPECIALRUN parameter is in the Extract parameter file
Answer: C
Explanation:
The SPECIALRUN parameter is used in the Replicat parameter file to configure batch-mode processing such as for initial loads or one-time replication. It disables checkpointing and allows processing of a specific data set without ongoing synchronization.
NEW QUESTION # 90
Using the built-in lightweight filtering facility, the Distribution Server allows you to operate simple transformations while dispatching trail files to the Receiver Server.
- A. FALSE
- B. TRUE
Answer: A
Explanation:
Distribution Server only routes data; no transformations.
NEW QUESTION # 91
Using adminclient, you can add a data pump Extract using the command: "ADD EXTRACT <ext name>, EXTTRAILSOURCE <trail file>"
- A. FALSE
- B. TRUE
Answer: A
Explanation:
adminclient doesn't support EXTTRAILSOURCE; it's not used in Extract setup.
NEW QUESTION # 92
When should the KeyCols parameter be used?
- A. To define a substitute primary key
- B. In addition to the unique index
- C. In addition to the primary key
Answer: A
Explanation:
Use KEYCOLS when no primary key exists.
NEW QUESTION # 93
Which Oracle GoldenGate utility helps troubleshoot OGG-02191 Incompatible Record errors?
- A. The reverse utility
- B. The CONVCHK utility
- C. The logdump utility
Answer: C
Explanation:
logdump is used to inspect trail file record structure.
NEW QUESTION # 94
Which of the following is not an initial load method in Oracle GoldenGate?
- A. SQL*Net Load
- B. File to Replicat
- C. Direct load
- D. File to database utility
Answer: A
Explanation:
File to Replicat, File to database utility, Direct load & Direct bulk load (via SQL*Loader API)
NEW QUESTION # 95
The Integrated Extract can use the LogMiner components to collectively read and format the logical change records and create trail entries in the trail file. Which of the following is not a component of the LogMiner?
- A. Reader
- B. Converter
- C. Builder
- D. Preparer
Answer: B
Explanation:
In Oracle LogMiner (used by Integrated Extract), the core components are Reader, Preparer, and Builder - they work together to read redo logs, extract change records, and prepare them for trail file writing. Converter is not a valid LogMiner component.
NEW QUESTION # 96
User ______ are a set of variables.
- A. Exits
- B. Tokens
- C. Procedures
- D. Macros
Answer: B
Explanation:
Tokens are variable sets used in parameter files.
NEW QUESTION # 97
You need to manually patch Oracle GoldenGate source and targets. How should you proceed?
- A. 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.
- B. 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.
- C. 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.
- D. 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.
Answer: B
Explanation:
This is the only option that:
* Waits for Extract to finish capturing remaining redo/transaction log data ✅
* Waits for Data Pump and Replicat to reach EOF ✅
* Properly stops components in sequence ✅
* Accounts for definition file updates (DEFGEN) if metadata changes ✅
NEW QUESTION # 98
You want to build a history of the operations that Replicat performed on the replicated dat a. What function will cause the Replicat to insert a new record for every change operation performed on a record in a database table?
- A. InsertAllRecords
- B. InsertOpRecords
- C. InsertChangedRecords
- D. InsertRecords
Answer: A
Explanation:
To log a history of all changes (INSERT, UPDATE, DELETE) as new rows in a target history table, Oracle GoldenGate provides the INSERTALLRECORDS parameter.
NEW QUESTION # 99
How is Oracle GoldenGate different from simple replication?
- A. It uses trigger-based data capture
- B. It supports only batch-based replication
- C. It uses log-based CDC and supports real-time, heterogeneous replication
- D. It only supports homogeneous databases
Answer: C
Explanation:
GoldenGate captures changes directly from redo/transaction logs and supports various databases in real-time.
NEW QUESTION # 100
What Oracle GoldenGate microservices component is used to handle all incoming trail files?
- A. Administration server
- B. Trail File server
- C. Service Manager
- D. Receiver server
Answer: D
Explanation:
In Oracle GoldenGate's Microservices Architecture, the Receiver Server is the component responsible for handling all incoming trail files.
NEW QUESTION # 101
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?
- A. Include the USEDELTA command.
- B. Include the UPDATAROWEXISTS command.
- C. Include the OVERWRITE command.
- D. Include the ADD TRANDATA command.
Answer: D
Explanation:
To enable full before images for Conflict Detection and Resolution (CDR), use the ADD TRANDATA command to enable supplemental logging on the source table, ensuring key and changed column data is captured in the redo logs.
NEW QUESTION # 102
What parameter manages conflicts between initial load and replication?
- A. IGNORE_ERRORS
- B. HANDLECOLLISIONS
- C. RESOLVE_INIT_LOAD
- D. CONFLICT_RESOLVER
Answer: B
Explanation:
It allows GoldenGate to resolve conflicts during overlapping load and replication.
NEW QUESTION # 103
......
1Z1-947 Study Material, Preparation Guide and PDF Download: https://passguide.dumpexams.com/1Z1-947-vce-torrent.html