Enhance your career with 1Z1-947 PDF Dumps - True Oracle Exam Questions
New (2025) Download free 1Z1-947 PDF for Oracle Practice Tests
NEW QUESTION # 74
Which three statements are true about Oracle GoldenGate?
- A. Oracle GoldenGate is an Oracle Database product that supports other Oracle products.
- B. Oracle GoldenGate captures changes from Oracle Redo logs or non-Oracle transaction logs and moves them to another database.
- C. Oracle GoldenGate can support high availability.
- D. Oracle GoldenGate is a middleware product that does not require an Oracle database.
Answer: B,C,D
Explanation:
GoldenGate does not need Oracle DB, reads logs, and supports HA.
NEW QUESTION # 75
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 ADD TRANDATA command.
- C. Include the UPDATAROWEXISTS command.
- D. Include the OVERWRITE command.
Answer: B
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 # 76
A macro is a built-in automation tool that enables you to call a stored set of processing steps. It can consist of a set of parameters that can be referenced from within a parameter file. What is true about the parameters of a macro?
- A. You cannot have macros in a GLOBALS parameter file.
- B. The parameters in a macro cannot be dynamic parameters.
- C. You can reuse a group of parameters in commands and functions by using a macro.
- D. Macros can only be defined at the source site in the Extract parameter file.
Answer: C
Explanation:
A macro in Oracle GoldenGate lets you define a reusable set of parameters that can be inserted into multiple parameter files or locations, promoting consistency and efficiency in Extract or Replicat configurations.
NEW QUESTION # 77
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. System memory
- B. Disk space
- C. The number of concurrent users
- D. The number of compound keys on the source tables
Answer: A
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 # 78
You must view more than just the operation type and hex value of the data in a trail. Which setting in Logdump allows you to view the token data, LOGCSN, and TRANID in the trail?
- A. fileheader on
- B. ghdr on
- C. ggstoken detail
- D. detail data
Answer: D
Explanation:
The detail data command in Logdump provides complete visibility into the data area of trail records, including tokens, LOGCSN, TRANID, and column-level changes. It is the official way to see in-depth record details per Oracle documentation.
NEW QUESTION # 79
Which database setting for the Oracle 19c database is required to enable Oracle GoldenGate?
- A. ENABLE_STREAMS_REPLICATION=true
- B. ENABLE_DATABASE_REPLICATION=true
- C. Configure the STREAMS_POOL_SIZE database parameter
- D. ENABLE_GOLDENGATE_REPLICATION=true
Answer: D
Explanation:
To enable Oracle GoldenGate in Oracle 19c, set ENABLE_GOLDENGATE_REPLICATION=TRUE, which allows the database to support GoldenGate features like Integrated Extract and Replicat.
NEW QUESTION # 80
Which parameter is typically associated with an Extract group in Oracle GoldenGate?
- A. ExtTrail
- B. Map
- C. Obey
- D. DiscardFile
Answer: A
Explanation:
Extract with group name, database login parameters; ExtTrail or RmtHost and RmtTrail; Table, and others. These can be found in the section titled "Extract Parameter Categories."
NEW QUESTION # 81
A Distribution Path sends the transaction of data from Extract to Replicat. How can you create a Distribution Path?
- A. From Cloud Shell with REST APIs
- B. At OS prompt with run preceding the GoldenGate commands
- C. From the Service Manager home page
- D. In GGSCI with GoldenGate commands
Answer: C
Explanation:
In Oracle GoldenGate Microservices Architecture, the Service Manager UI is the recommended and primary interface to create a Distribution Path using the Distribution Server. This method is officially documented and intended for simplified management.
NEW QUESTION # 82
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 # 83
Which is an invalid combination for EVENTACTIONS with options?
- A. EVENTACTIONS (CHECKPOINT BEFORE, ABORT)
- B. EVENTACTIONS (CHECKPOINT BOTH, STOP)
- C. EVENTACTIONS (CHECKPOINT AFTER, ABORT)
- D. EVENTACTIONS (CHECKPOINT BOTH, IGNORE)
Answer: D
Explanation:
The combination CHECKPOINT BOTH with IGNORE is invalid because IGNORE tells Replicat to skip the transaction, while CHECKPOINT BOTH implies a complete apply and checkpoint - which contradicts the action of ignoring the transaction.
NEW QUESTION # 84
GGSCI commands can display:
- A. Lag in the system
- B. Processing status
- C. All of the above
- D. Statistics (operations processed)
Answer: C
Explanation:
GGSCI provides status, statistics, and lag details
NEW QUESTION # 85
What is the adminclient in GoldenGate MA?
- A. A CLI tool that uses REST APIs to manage deployments
- B. A browser-based management tool
- C. A background replication daemon
- D. A GUI for performance metrics visualization
Answer: A
Explanation:
Command-line utility (like GGSCI) using REST API for Microservices Architecture control/config.
NEW QUESTION # 86
Where can Oracle GoldenGate software be downloaded officially?
- A. Oracle Cloud Marketplace
- B. My Oracle Support
- C. OTN or http://edelivery.oracle.com
- D. Oracle Database Utilities
Answer: C
NEW QUESTION # 87
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. Single Sign On
- B. UserIDAlias
- C. UserReplicationUser
- D. Oracle SID
Answer: B
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 # 88
When using CHECKPOINT BEFORE for EVENTACTIONS, what will an Extract do?
- A. Extract will checkpoint at the end of the transaction.
- B. Extract will stop at the end of the transaction.
- C. Extract will checkpoint on the starting boundary of the transaction.
- D. Extract will Abend while processing the transaction.
Answer: C
Explanation:
The CHECKPOINT BEFORE clause in EVENTACTIONS causes the Extract to record a checkpoint at the beginning of the transaction, ensuring any triggered action can safely be retried if needed.
NEW QUESTION # 89
......
100% Free 1Z1-947 Files For passing the exam Quickly: https://www.dumpsking.com/1Z1-947-testking-dumps.html
1Z1-947 Dumps Questions Study Exam Guide : https://drive.google.com/open?id=1A-EXPd_ukfSSs7zi_SG29Dl20DxNKFyO
