Free Oracle 1Z0-947 Exam Questions and Answer from Training Expert ActualVCE
Top Oracle 1Z0-947 Courses Online
NEW QUESTION # 83
Which parameter gives more accurate timing for lag statistics?
- A. DynamicResolution
- B. CacheMgr
- C. TCPSourceTimer
Answer: C
Explanation:
TCPSourceTimer improves lag timing accuracy.
NEW QUESTION # 84
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 # 85
Which parameter is used to identify the remote target system in Oracle GoldenGate?
- A. TargetTrail
- B. RmtHost
- C. HostName
- D. Map
Answer: B
NEW QUESTION # 86
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. EXCLUDEHIDDENCOLUMNS
- C. NOHIDDENCOLUMNS
Answer: B
Explanation:
"Oracle GoldenGate supports replication of invisible columns in Extract.
If you want to exclude them, use the EXCLUDEHIDDENCOLUMNS parameter."
NEW QUESTION # 87
Which of the following is a typical Oracle GoldenGate Manager parameter?
- A. RmtHost
- B. DiscardFile
- C. ExtTrail
- D. Port
Answer: D
Explanation:
Port, DynamicPortList, Autostart, AutoRestart, Lag parameters, PurgeOldExtracts, and others. These can be found in the section titled "Manager Parameter Categories."
NEW QUESTION # 88
Which components have been made redundant in Oracle GoldenGate 12.2 and later?
- A. SOURCEDEFS
- B. Replicat
- C. ASSUMETARGETDEFS
- D. Extract
Answer: A,C
Explanation:
From 12.2, ASSUMETARGETDEFS and SOURCEDEFS are no longer needed.
NEW QUESTION # 89
Connection errors can indicate security violations, full file system errors, or system misconfigurations. What should you use to troubleshoot?
- A. All of the above
- B. Execute the View GGSEVT command
- C. Enable the Trace parameter
- D. Execute the Info Mgr command
Answer: B
Explanation:
View GGSEVT is used for diagnosing connection/system issues.
NEW QUESTION # 90
To identify a bottleneck, where should monitoring begin?
- A. From the source to the target
- B. From the target back to the source
Answer: B
Explanation:
Start lag analysis from the target to trace bottlenecks.
NEW QUESTION # 91
What is the purpose of the GoldenGate Initial Load?
- A. To synchronize data in the source and target databases
- B. To carry out Performance Load Testing
- C. To stream change data to a target database
- D. To create the target database objects
Answer: A
Explanation:
The Initial Load in Oracle GoldenGate is used to: Populate the target database with a baseline copy of data from the source Ensure that both source and target are in sync before real-time replication begins After this load, GoldenGate can start streaming only ongoing changes
NEW QUESTION # 92
Which is an invalid combination for EVENTACTIONS with options?
- A. EVENTACTIONS (CHECKPOINT BEFORE, ABORT)
- B. EVENTACTIONS (CHECKPOINT AFTER, 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 # 93
What is the adminclient in GoldenGate MA?
- A. A browser-based management tool
- B. A background replication daemon
- C. A GUI for performance metrics visualization
- D. A CLI tool that uses REST APIs to manage deployments
Answer: D
Explanation:
Command-line utility (like GGSCI) using REST API for Microservices Architecture control/config.
NEW QUESTION # 94
Which of these is a valid Replicat parameter in Oracle GoldenGate?
- A. DynamicPortList
- B. RmtHost
- C. SourceDefs
- D. PASSTHRU
Answer: C
Explanation:
Replicat with group name, database login parameters; SourceDefs or AssumeTargetDefs, DiscardFile, Map, and others. These can be found in the section titled "Replicat Parameter Categories."
NEW QUESTION # 95
What is the purpose of an Obey file in Oracle GoldenGate?
- A. An ASCII file
- B. Debugging configuration
- C. Encryption key store
- D. Temporary trail storage
Answer: A
Explanation:
An ASCII file containing command sequences for reuse (similar to a script)
NEW QUESTION # 96
With BATCHSQL enabled, what causes a Replicat to use normal mode operation?
- A. Statements with rows between 8k and 24k in length
- B. Statements that cause errors
- C. When server memory < 8 GB
- D. When BATCHSQL and GROUPTRANSOPS coexist
Answer: A
Explanation:
When BATCHSQL is enabled in Oracle GoldenGate Replicat, it tries to optimize performance by grouping multiple SQL statements and applying them in batches using array operations. However, if an error occurs during the execution of a batched group of statements, GoldenGate automatically switches the Replicat into "normal mode" (i.e., one-by-one row apply) for that transaction to allow better error handling and diagnostics.
NEW QUESTION # 97
Initial Load is a process of extracting data records from the source database and loading those records onto the target database. There are many advantages in using GoldenGate to obtain the data from the source and load the records onto the target. What describes the advantage of continuing to make data changes on the source database while loading data onto the target database?
- A. Enable the LGWR to indicate in the transaction log when initial load commenced.
- B. Enable change delivery to handle collisions with initial load.
- C. Enable data changes on source tables without locking tables.
- D. Enable Extract to indicate in the trail file when initial load commenced.
Answer: C
Explanation:
"Oracle GoldenGate can perform a one-time initial load while the source tables remain online and active. You do not need to lock the source tables during the load. Oracle GoldenGate tracks ongoing changes with Change Data Capture (CDC) and applies them after the load completes."
NEW QUESTION # 98
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. Integration
- C. Broadcast
- D. Multimaster
Answer: C
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 # 99
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. The parameters in a macro cannot be dynamic parameters.
- B. You cannot have macros in a GLOBALS parameter file.
- C. Macros can only be defined at the source site in the Extract parameter file.
- D. You can reuse a group of parameters in commands and functions by using a macro.
Answer: D
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 # 100
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 # 101
Which capability does GoldenGate support?
- A. Asynchronous Capture and Delivery of committed DML transactions
- B. File-based Capture
- C. Synchronous transaction Capture from application interfaces
- D. Two-phase commit operations from application interfaces
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 # 102
Which mechanism is used by Extract to ensure that data integrity and fault tolerance are maintained in the data source and trail?
- A. Manager process
- B. Logical change records
- C. Checkpoints
- D. Commit sequence order
Answer: C
NEW QUESTION # 103
Which is an incorrect option to use with the DBOPTIONS parameter for a Replicat?
- A. USEREPLICATIONUSER
- B. NOCATALOGCONNECT
- C. BATCHSQL
- D. USEODBC
Answer: C
Explanation:
BATCHSQL is the incorrect option to use with the DBOPTIONS parameter, because it is not a DBOPTIONS sub-option at all - it's a standalone parameter.
NEW QUESTION # 104
......
New (2026) Oracle 1Z0-947 Exam Dumps: https://www.actualvce.com/Oracle/1Z0-947-valid-vce-dumps.html
1Z0-947 Practice Dumps - Verified By ActualVCE Updated 147 Questions: https://drive.google.com/open?id=1syrnd2vm1gfwOG5gA94aWziR2Ay2h_Jh