Dumps Moneyack Guarantee - 1Z0-947 Dumps UpTo 50% Off
Updated Dec-2025 Pass 1Z0-947 Exam - Real Practice Test Questions
NEW QUESTION # 17
You made changes to the GLOBALS parameter file using an editor on the OS. After saving your changes, you noticed the changes did not take effect. What would be the reason for this?
- A. You did not stop all replication processes running in so the changes can take effect.
- B. You did not MGR so the changes can take effect.
- C. You did not restart GGSCI.
- D. You did not make changes on the OS logged in as the GoldenGate Administrator user.
Answer: C
Explanation:
This is because GLOBALS parameters are read only at GGSCI startup, unlike other dynamic parameter files (e.g., Extract or Replicat configs). ?? So without restarting GGSCI, your changes won't be recognized.
NEW QUESTION # 18
Which is an invalid combination for EVENTACTIONS with options?
- A. EVENTACTIONS (CHECKPOINT AFTER, ABORT)
- B. EVENTACTIONS (CHECKPOINT BEFORE, ABORT)
- C. EVENTACTIONS (CHECKPOINT BOTH, STOP)
- D. EVENTACTIONS (CHECKPOINT BOTH, IGNORE)
Answer: D
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 # 19
Oracle GoldenGate writes OS-level errors to:
- A. Process report
- B. Discard file
- C. System log
- D. Event log
Answer: C
Explanation:
System log is where OS-level errors are recorded.
NEW QUESTION # 20
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 # 21
Which commands are used to create and start a Replicat group?
- A. CREATE REPLICAT, RUN REPLICAT
- B. INIT REPLICAT, BEGIN APPLY
- C. ADD REPLICAT, START REPLICAT, EDIT PARAMS
- D. BUILD REPLICAT, LAUNCH APPLY
Answer: C
Explanation:
These are the standard commands used to define and activate a Replicat group.
NEW QUESTION # 22
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 USEDELTA 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 # 23
Which three statements are true about Oracle GoldenGate?
- A. Oracle GoldenGate can support high availability.
- B. Oracle GoldenGate is a middleware product that does not require an Oracle database.
- C. Oracle GoldenGate is an Oracle Database product that supports other Oracle products.
- D. Oracle GoldenGate captures changes from Oracle Redo logs or non-Oracle transaction logs and moves them to another database.
Answer: A,B,D
Explanation:
GoldenGate does not need Oracle DB, reads logs, and supports HA.
NEW QUESTION # 24
Identify the scenario in which you cannot configure GoldenGate.
- A. Initial Load synchronization
- B. Batch Data Transfer from table data
- C. Snapshot database backups
- D. Real-time Change Data Capture from transaction logs
Answer: C
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 # 25
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?
- A. Use the HANDLECOLLISIONS feature to handle errors and resolve the conflict.
- B. Use the SQLEXEC feature to handle errors and resolve the conflict.
- C. Use the RESOLVECONFLICT feature to handle errors and resolve the conflict.
- D. Add unique indexes to the table to resolve the conflict.
Answer: D
Explanation:
Oracle GoldenGate must consistently identify rows during replication using a primary or unique key. If row identification fails, adding or enforcing a unique index is the correct way to resolve the issue-not relying on collision or conflict-handling features.
NEW QUESTION # 26
You have configured and added the Extract and Replicat tasks by using the Direct Load method. What do you need to do to get the processes up and running?
- A. Start the Extract task, wait for it to stop, and then start the Replicat task
- B. Start the Replicat task
- C. Start the Extract task
- D. Start the Extract task and then start the Replicat task
Answer: A
Explanation:
In the Direct Load method, the Extract performs a one-time data load and then stops. Only after that should the Replicat be started to apply the loaded data. Starting both simultaneously is not valid for this method.
NEW QUESTION # 27
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?
- A. Disk space
- B. System memory
- C. The number of compound keys on the source tables
- D. The number of concurrent users
Answer: B
Explanation:
System memory is the most critical factor for determining how many Extract processes can run concurrently. Each process consumes memory, and insufficient memory may lead to performance degradation or process failure.
NEW QUESTION # 28
Integrated delivery works only with trail files from integrated capture.
- A. FALSE
- B. TRUE
Answer: A
Explanation:
Integrated delivery can use trail files from classic or integrated capture.
NEW QUESTION # 29
If multiple GoldenGate processes are accessing a set of trail files, which process should include the PURGEOLDEXTRACTS parameter to trigger trail file clean-up?
- A. Extract
- B. Extract and Replicat
- C. Manager
- D. Replicat
Answer: C
Explanation:
The PURGEOLDEXTRACTS parameter should be configured in the Manager (MGR) process, as it is responsible for monitoring trail file usage across GoldenGate processes and safely deleting files no longer needed by any Extract or Replicat.
NEW QUESTION # 30
Which parameter is typically used with data pumps unless transformation is needed?
- A. ASSUMETARGETDEFS
- B. PASSTHRU
- C. Map
- D. TrailFile
Answer: B
Explanation:
PASSTHRU (used unless transformation or exit processing is needed)
NEW QUESTION # 31
Why might you use multiple data pumps for one source trail?
- A. Encrypt extract data
- B. Send to multiple targets and improve parallelism
- C. Reduce redo generation
- D. Minimize CPU usage
Answer: B
Explanation:
To support multiple target systems, table separation, and parallel processing.
NEW QUESTION # 32
To display SQL DML statements before execution using a classic Replicat, what should you do?
- A. Execute ScanForRBA
- B. Enable the ShowSyntax parameter
- C. None of the above
- D. Execute Detail On
Answer: B
Explanation:
ShowSyntax displays SQL before execution.
NEW QUESTION # 33
Oracle GoldenGate Software Command Interface (GGSCI) is the Oracle GoldenGate command-line utility. You use GGSCI commands to configure, control, and monitor Oracle GoldenGate. GGSCI commands can be collected in a text script called an Obey (.oby) file. How can it be run in Obey scripts and also used in Microservices architecture?
- A. Run it on the OS logged in as user oggadmin.
- B. Log into source or target database as user oggadmin and run script at SQL prompt.
- C. Launch GGSCI and run from the GGSCI prompt.
- D. Run scripts from adminclient.
Answer: D
Explanation:
For Microservices Architecture, run Obey scripts using the adminclient.
NEW QUESTION # 34
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 # 35
What is the purpose of the DiscardFile?
- A. To backup configuration changes
- B. To log failed operations Replicat couldn't process
- C. To store Replicat cache
- D. To discard unused trail files
Answer: B
Explanation:
It identifies operations that could not be processed by Replicat.
NEW QUESTION # 36
GGSCI commands can display:
- A. Statistics (operations processed)
- B. Lag in the system
- C. Processing status
- D. All of the above
Answer: D
Explanation:
GGSCI provides status, statistics, and lag details
NEW QUESTION # 37
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?
- A. UserIDAlias
- B. Single Sign On
- C. UserReplicationUser
- D. Oracle SID
Answer: A
Explanation:
You can use UserIDAlias in the parameter file to reference credentials securely stored in the Oracle GoldenGate credential store, avoiding plain-text usernames and passwords.
NEW QUESTION # 38
User ______ are a set of variables.
- A. Procedures
- B. Exits
- C. Macros
- D. Tokens
Answer: D
Explanation:
Tokens are variable sets used in parameter files.
NEW QUESTION # 39
......
Download Free Oracle 1Z0-947 Real Exam Questions: https://www.itcertmagic.com/Oracle/real-1Z0-947-exam-prep-dumps.html
Pass Your Exam With 100% Verified 1Z0-947 Exam Questions: https://drive.google.com/open?id=1vNCA2rGrD9sxKtQh7byPFbiX10mzDnz9