Get 2026 Most Reliable Oracle 1Z0-947 Training Materials
The Realest Study Materials 1Z0-947 Dumps
NEW QUESTION # 62
Add TranData enables supplemental logging of key values in the transaction logs whenever a row change occurs.
- A. FALSE
- B. TRUE
Answer: B
Explanation:
ADD TRANDATA logs key changes needed for replication.
NEW QUESTION # 63
What is a "trail" in GoldenGate?
- A. A link between Replicat and Extract
- B. A transport layer protocol
- C. A type of error log
- D. A series of files that store captured data
Answer: D
Explanation:
A trail is a series of files on disk where Oracle GoldenGate stores data for further processing.
NEW QUESTION # 64
A process group in GoldenGate is a collection of things associated with a specific GoldenGate Extract or Replicat process. Which of these is not an item in a GoldenGate process group?
- A. The Extract processes
- B. A checkpoint table for the Extract
- C. A checkpoint file
- D. A parameter file
Answer: B
Explanation:
? Checkpoint tables are used only for Integrated Replicat, not Extract. Extract uses checkpoint files, not tables. So, "A checkpoint table for the Extract" is not part of an Extract process group.
NEW QUESTION # 65
How can you tell if GoldenGate has been configured for batch processing?
- A. The SPECIALRUN parameter is in the Extract parameter file
- B. There is a dedicated GoldenGate process called SPECIALRUN
- C. The SPECIALRUN parameter is in the GLOBALS parameter file
- D. The SPECIALRUN parameter is in the Replicat parameter file
Answer: D
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 # 66
Identify the scenario in which you cannot configure GoldenGate.
- A. Initial Load synchronization
- B. Batch Data Transfer from table data
- C. Real-time Change Data Capture from transaction logs
- D. Snapshot database backups
Answer: D
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 # 67
Which parameter gives more accurate timing for lag statistics?
- A. TCPSourceTimer
- B. DynamicResolution
- C. CacheMgr
Answer: A
Explanation:
TCPSourceTimer improves lag timing accuracy.
NEW QUESTION # 68
DDL can be used in conjunction with filter options. What would be the correct DDL parameter if you need DDL for specific objects?
- A. DDL <objectname>
- B. DDL Exclude All, Include ObjName <objectname>
- C. DDL Include All, Exclude ObjName <objectname>
- D. DDL Include. <objectname>
Answer: B
Explanation:
This configuration first excludes all DDL operations (EXCLUDE ALL) and then selectively includes DDL for specific objects using INCLUDE OBJNAME. This approach ensures that only the desired DDL operations are replicated, providing precise control over DDL replication.
NEW QUESTION # 69
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 UPDATAROWEXISTS command.
- B. Include the OVERWRITE command.
- C. Include the ADD TRANDATA command.
- D. Include the USEDELTA command.
Answer: C
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 # 70
What is the purpose of an Obey file in Oracle GoldenGate?
- A. Encryption key store
- B. Temporary trail storage
- C. An ASCII file
- D. Debugging configuration
Answer: C
Explanation:
An ASCII file containing command sequences for reuse (similar to a script)
NEW QUESTION # 71
Which parameter is typically used with data pumps unless transformation is needed?
- A. Map
- B. PASSTHRU
- C. ASSUMETARGETDEFS
- D. TrailFile
Answer: B
Explanation:
PASSTHRU (used unless transformation or exit processing is needed)
NEW QUESTION # 72
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?
- A. Cascading
- B. Broadcast
- C. Multimaster
- D. Integration
Answer: B
Explanation:
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
NEW QUESTION # 73
What is a valid net result for an Extract configured with the parameters in this order: GETINSERTS, GETUPDATEBEFORES, IGNOREDELETES, IGNOREUPDATES?
- A. Inserts, updates, and deletes will be captured.
- B. Before and after images of updates will be captured.
- C. Before and after images of updates will be ignored.
- D. Inserts and deletes will be captured.
Answer: C
NEW QUESTION # 74
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)
- A. Data processing will include rows for delete if (PRODUCT_PRICE * PRODUCT_AMOUNT) is not greater than 10000
- B. Data processing will exclude rows for update if (PRODUCT_PRICE * PRODUCT_AMOUNT) is not greater than 10000
- C. Data processing will exclude rows for delete if (PRODUCT_PRICE * PRODUCT_AMOUNT) is not greater than 10000
- D. Data processing will include rows for insert if (PRODUCT_PRICE * PRODUCT_AMOUNT) is not greater than 10000
Answer: B
Explanation:
The FILTER clause with @Compute and ON UPDATE, ON DELETE includes only those rows where the computed value is greater than 10000. If not, the row is excluded from processing - specifically for UPDATE and DELETE operations.
NEW QUESTION # 75
What is the purpose of checkpointing in GoldenGate?
- A. To view replication progress
- B. To configure system parameters
- C. To clean trail files
- D. To enable recovery of processes in case of failure
Answer: D
Explanation:
To enable recovery if a GoldenGate process, system, or network fails.
NEW QUESTION # 76
What Oracle GoldenGate microservices component is used to handle all incoming trail files?
- A. Service Manager
- B. Trail File server
- C. Administration server
- D. Receiver server
Answer: D
Explanation:
The Receiver Server is the GoldenGate Microservices component that handles all incoming trail files, replacing the need for multiple Collectors on the target side. It supports WebSockets and other protocols to securely receive data from the Distribution Server
NEW QUESTION # 77
......
LATEST 1Z0-947 Exam Practice Material: https://pass4sure.guidetorrent.com/1Z0-947-dumps-questions.html