2026 Latest 1Z0-947 dumps Exam Material with 147 Questions
Oracle 1Z0-947 Questions and Answers Guarantee you Oass the Test Easily
NEW QUESTION # 10
Which mechanism is used by Extract to ensure that data integrity and fault tolerance are maintained in the data source and trail?
- A. Checkpoints
- B. Commit sequence order
- C. Logical change records
- D. Manager process
Answer: A
NEW QUESTION # 11
What is the adminclient in GoldenGate MA?
- A. A background replication daemon
- B. A browser-based management tool
- C. A CLI tool that uses REST APIs to manage deployments
- D. A GUI for performance metrics visualization
Answer: C
Explanation:
Command-line utility (like GGSCI) using REST API for Microservices Architecture control/config.
NEW QUESTION # 12
Only the EncryptTrail Extract parameter should be used to encrypt/decrypt trail file records.
- A. FALSE
- B. TRUE
Answer: A
Explanation:
EncryptTrail is not the only way to encrypt trail files.
NEW QUESTION # 13
What is the purpose of checkpointing in GoldenGate?
- A. To view replication progress
- B. To enable recovery of processes in case of failure
- C. To configure system parameters
- D. To clean trail files
Answer: B
Explanation:
To enable recovery if a GoldenGate process, system, or network fails.
NEW QUESTION # 14
When should the KeyCols parameter be used?
- A. In addition to the primary key
- B. To define a substitute primary key
- C. In addition to the unique index
Answer: B
Explanation:
Use KEYCOLS when no primary key exists.
NEW QUESTION # 15
What is a valid net result for an Extract configured with the parameters in this order: GETINSERTS, GETUPDATEBEFORES, IGNOREDELETES, IGNOREUPDATES?
- A. Before and after images of updates will be captured.
- B. Inserts and deletes will be captured.
- C. Before and after images of updates will be ignored.
- D. Inserts, updates, and deletes will be captured.
Answer: C
NEW QUESTION # 16
Why might you use multiple data pumps for one source trail?
- A. Minimize CPU usage
- B. Send to multiple targets and improve parallelism
- C. Encrypt extract data
- D. Reduce redo generation
Answer: B
Explanation:
To support multiple target systems, table separation, and parallel processing.
NEW QUESTION # 17
You are receiving data errors involving invalid column mappings. Which two types of files can you use to identify the issue?
- A. Use the error log because it captures information on failed GoldenGate operations.
- B. Use the discard file because it captures information on failed GoldenGate operations.
- C. Use the DIST command in the GLOBALS file because it captures information on failed GoldenGate operations.
- D. Use the STATS command in the GLOBALS file because it captures information on failed GoldenGate operations.
Answer: A,B
NEW QUESTION # 18
In Oracle RDBMS sharding architecture, shardgroups checkpoint their data on a shared disk to ensure data integrity.
- A. FALSE
- B. TRUE
Answer: A
Explanation:
Shards are independent and don't checkpoint to shared disks.
NEW QUESTION # 19
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 # 20
Which Oracle GoldenGate utility helps troubleshoot OGG-02191 Incompatible Record errors?
- A. The logdump utility
- B. The reverse utility
- C. The CONVCHK utility
Answer: A
Explanation:
logdump is used to inspect trail file record structure.
NEW QUESTION # 21
What must be done when adding a new table after GoldenGate has been implemented?
- A. Restart the database
- B. Run Add TranData or AddSchemaTranData
- C. Nothing, it auto-detects
- D. Restart Oracle GoldenGate
Answer: B
Explanation:
ADD TRANDATA must be run when adding new tables.
NEW QUESTION # 22
What is the purpose of the DiscardFile?
- A. To backup configuration changes
- B. To store Replicat cache
- C. To discard unused trail files
- D. To log failed operations Replicat couldn't process
Answer: D
Explanation:
It identifies operations that could not be processed by Replicat.
NEW QUESTION # 23
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 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.
- 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. 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.
Answer: D
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 # 24
What Oracle GoldenGate microservices component is used to handle all incoming trail files?
- A. Service Manager
- B. Administration server
- C. Receiver server
- D. Trail File server
Answer: C
Explanation:
In Oracle GoldenGate's Microservices Architecture, the Receiver Server is the component responsible for handling all incoming trail files.
NEW QUESTION # 25
You must synchronize the starting point for Replicat with the restore point of the target database. How should you accomplish this?
- A. Use the command option RESUME.
- B. Use the command option UNTIL CANCEL.
- C. Use the command option ATCSN.
- D. Use the command option AFTERCSN.
Answer: D
Explanation:
"AFTERCSN causes Replicat to start processing at the transaction that occurred after the one with the specified CSN. Any transactions in the trail that have CSN values that are less than, or equal to, the specified one are skipped."
NEW QUESTION # 26
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 # 27
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?
- A. Use the COLMAP option in the MAP parameter.
- B. Do not specify those columns in the ADD TRANDATA command.
- C. Use the FILTER option in the MAP parameter.
- D. Use the COLS and COLSEXCEPT options in the TABLE parameter.
Answer: D
Explanation:
To prevent sensitive data from being replicated, you should use the COLS and COLSEXCEPT options in the TABLE parameter. These options allow you to explicitly include or exclude specific columns from the replication process, ensuring that sensitive data is not transferred to the target database.
NEW QUESTION # 28
Where can Oracle GoldenGate software be downloaded officially?
- A. Oracle Cloud Marketplace
- B. OTN or http://edelivery.oracle.com
- C. Oracle Database Utilities
- D. My Oracle Support
Answer: B
NEW QUESTION # 29
What Oracle GoldenGate component sends trail files over the network to the Receiver Server?
- A. The Trail File Server
- B. The Distribution Server on the source
- C. The GoldenGate source Data Pump
- D. The Extract
Answer: B
Explanation:
"A Distribution Service process will read the trail file and send it across the network to a waiting Receiver Service process..."
NEW QUESTION # 30
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?
- A. Integrated Replicat does not need a checkpoint or a trace table for its operations.
- B. Trail files contain data that must be in logical change records format.
- C. Both source and target can be Oracle and non-Oracle databases.
- D. Source must be configured as Integrated Extract.
Answer: B
Explanation:
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.
NEW QUESTION # 31
......
Share Latest 1Z0-947 DUMP Questions and Answers: https://www.prep4pass.com/1Z0-947_exam-braindumps.html
PDF Dumps 2026 Exam Questions with Practice Test: https://drive.google.com/open?id=1iQn6oi_FEUUSfvLw60WSWte1s70mb1E_
