1Z0-947 Exam Questions Dumps, Selling Oracle Products
1Z0-947 Cert Guide PDF 100% Cover Real Exam Questions
NEW QUESTION # 45
What is a DiscardFile not used for?
- A. File for rejected Replicat data
- B. File for rejected Extract data
- C. Replacing a trail file on the target system
Answer: C
Explanation:
DiscardFile does not replace trail files; it logs rejected records.
NEW QUESTION # 46
What is the adminclient in GoldenGate MA?
- A. A CLI tool that uses REST APIs to manage deployments
- B. A background replication daemon
- C. A GUI for performance metrics visualization
- D. A browser-based management tool
Answer: A
Explanation:
Command-line utility (like GGSCI) using REST API for Microservices Architecture control/config.
NEW QUESTION # 47
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 # 48
You want to increase parallelism for greater integrated Replicat throughput while preserving the original transaction atomicity. How can you achieve this?
- A. You can configure integrated Replicat ASSUMETARGETDEFS and SPECIALRUN parameters.
- B. You can configure integrated Replicat with SPECIALRUN parameter.
- C. You can configure integrated Replicat with two parallel apply servers.
- D. You can configure integrated Replicat with two parallel child servers.
Answer: C
Explanation:
To increase parallelism and still preserve transaction atomicity, configure Integrated Replicat with multiple parallel apply servers (e.g., 2 or more). This allows Oracle GoldenGate to apply multiple transactions concurrently while maintaining their integrity.
NEW QUESTION # 49
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 # 50
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. Broadcast
- B. Multimaster
- C. Cascading
- D. Integration
Answer: A
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 # 51
Which parameter is used to identify the remote target system in Oracle GoldenGate?
- A. TargetTrail
- B. Map
- C. HostName
- D. RmtHost
Answer: D
NEW QUESTION # 52
Proper prerequisite planning will ensure a successful Initial Load. To ensure not to miss any data, before starting any instantiation method, it is important you verify that all open transactions that existed when Extract was started are completed. Which two sources do you use to see that transactions no longer exist before beginning instantiation?
- A. GV$TRANSACTION
- B. V$TRANSACTION
- C. DBA$TRANSACTION
- D. GG$TRANSACTION
Answer: A,B
Explanation:
GV$TRANSACTION - shows active transactions across all RAC instances
EXCLUDEHIDDENCOLUMNS
NEW QUESTION # 53
Replicat makes checkpoints in the trail file to mark its last read position. How can you create a checkpoint table?
- A. Use the INFO REPLICAT command with the SHOWCH option.
- B. Run the chkpt_db_extracttrail.sql script.
- C. Use the ADD CHECKPOINTTABLE command.
- D. Use the ADD Extract Trail command.
Answer: C
Explanation:
A checkpoint table is used by Replicat (especially in coordinated or integrated mode) to store its checkpoint information inside the target database - rather than just in the local trail files. This improves visibility and manageability, especially in HA/DR setups.
NEW QUESTION # 54
Identify the scenario in which you cannot configure GoldenGate.
- A. Batch Data Transfer from table data
- B. Real-time Change Data Capture from transaction logs
- C. Initial Load synchronization
- 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 # 55
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. Add unique indexes to the table to resolve the conflict.
- B. Use the SQLEXEC feature to handle errors and resolve the conflict.
- C. Use the HANDLECOLLISIONS feature to handle errors and resolve the conflict.
- D. Use the RESOLVECONFLICT feature to handle errors and resolve the conflict.
Answer: A
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 # 56
Which parameter is typically used with data pumps unless transformation is needed?
- A. PASSTHRU
- B. TrailFile
- C. ASSUMETARGETDEFS
- D. Map
Answer: A
Explanation:
PASSTHRU (used unless transformation or exit processing is needed)
NEW QUESTION # 57
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. Converter
- B. Builder
- C. Preparer
- D. Reader
Answer: A
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 # 58
Which statement about trails is correct?
- A. RMTTRAIL is for remote trails and EXTTRAIL is for local trails.
- B. Trail files are used to show how many records your Distribution Path is trailing behind the Extract.
- C. Trail files are used to show the order GoldenGate files are accessed to perform replication.
- D. Extract is typically used to produce local trail files over a TCP/IP connection.
Answer: A
Explanation:
In Oracle GoldenGate, EXTTRAIL is used to define local trail files written by a primary Extract, while RMTTRAIL defines remote trail files that are sent over the network (via TCP/IP) by a Data Pump or Distribution Server to a remote target.
NEW QUESTION # 59
Where are the Oracle GoldenGate parameters officially documented?
- A. GoldenGate GGSCI Command Reference
- B. Oracle Fusion Middleware Reference for Oracle GoldenGate 19c
- C. Oracle Database Concepts Guide
- D. Oracle GoldenGate AdminClient Manual
Answer: B
Explanation:
Oracle Fusion Middleware Reference for Oracle GoldenGate 19c
NEW QUESTION # 60
You have an issue where all threads are waiting for a specific transaction to be executed first. What is this issue related to?
- A. It is caused by the thread with the highest thread ID applying barrier transactions.
- B. It is caused by the use of the MAXTRANSOPS parameter.
- C. It is caused by THREAD and THREADRANGE being used with wildcard MAP statements.
- D. It is caused by barrier transactions in a Coordinated Replicat.
Answer: D
Explanation:
In Coordinated Replicat, a barrier transaction is a transaction that must be applied in commit order, causing all threads to pause until that transaction is completed - leading to the situation where all threads wait for one.
NEW QUESTION # 61
Which tools would you use to determine if all Oracle GoldenGate processes are up and running?
- A. tcpers
- B. CMDSEC
- C. GGSCI
- D. Process report
- E. Oracle GoldenGate Monitor
Answer: C,D,E
Explanation:
Use GGSCI, process reports, or Monitor to check running processes.
NEW QUESTION # 62
Which capability does GoldenGate support?
- A. Asynchronous Capture and Delivery of committed DML transactions
- B. Synchronous transaction Capture from application interfaces
- C. Two-phase commit operations from application interfaces
- D. File-based Capture
Answer: A
Explanation:
Oracle GoldenGate captures committed DML changes asynchronously from database redo or transaction logs and delivers them to the target system asynchronously. This minimizes overhead and avoids interfering with live transactions.
NEW QUESTION # 63
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?
- A. NOINVISIBLECOLUMNS
- B. NOHIDDENCOLUMNS
- C. EXCLUDEHIDDENCOLUMNS
Answer: C
Explanation:
"Oracle GoldenGate supports replication of invisible columns in Extract.
If you want to exclude them, use the EXCLUDEHIDDENCOLUMNS parameter."
NEW QUESTION # 64
Which of the following statements is true?
- A. Oracle GoldenGate checkpoints are stored in an Oracle control file.
- B. There is likely to be only one Oracle GoldenGate checkpoint file.
- C. The CKPT background process records the Oracle GoldenGate checkpoint.
- D. The Oracle GoldenGate checkpoint supports Oracle GoldenGate recovery.
Answer: D
Explanation:
Checkpoints support recovery, not stored in Oracle control files.
NEW QUESTION # 65
What Oracle GoldenGate microservices component is used to handle all incoming trail files?
- A. Service Manager
- B. Receiver server
- C. Trail File server
- D. Administration server
Answer: B
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 # 66
Which of the following is a typical Oracle GoldenGate Manager parameter?
- A. ExtTrail
- B. Port
- C. DiscardFile
- D. RmtHost
Answer: B
Explanation:
Port, DynamicPortList, Autostart, AutoRestart, Lag parameters, PurgeOldExtracts, and others. These can be found in the section titled "Manager Parameter Categories."
NEW QUESTION # 67
You need to manually patch Oracle GoldenGate source and targets. How should you proceed?
- A. 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.
- B. 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.
- 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 # 68
......
Pass 1Z0-947 Exam - Real Questions and Answers: https://vcecollection.trainingdumps.com/1Z0-947-valid-vce-dumps.html
