PDF Download Free of 1Z0-947 Valid Practice Test Questions
1Z0-947 Test Engine files, 1Z0-947 Dumps PDF
NEW QUESTION # 49
Add TranData enables supplemental logging of key values in the transaction logs whenever a row change occurs.
- A. TRUE
- B. FALSE
Answer: A
Explanation:
ADD TRANDATA logs key changes needed for replication.
NEW QUESTION # 50
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. The number of concurrent users
- C. The number of compound keys on the source tables
- D. System memory
Answer: D
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 # 51
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. Builder
- B. Reader
- C. Preparer
- D. Converter
Answer: D
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 # 52
Suppose your process stops immediately after verifying parameter syntax. What is the most likely reason?
- A. The group name is spelled wrong
- B. The database user has incorrect permissions
- C. The CheckParams parameter is enabled
- D. Oracle GoldenGate reports syntax problems
Answer: C
Explanation:
CheckParams halts after verifying parameter syntax.
NEW QUESTION # 53
You can create a macro library that contains one or more macros. By using a macro library, you can define a macro once and use it again and again. What is true about macro libraries?
- A. You can share the macros across parameter files.
- B. You can either have the Extract or the Replicat in the same GoldenGate Home invoke the macros in the library but not from with both Extract and Replicat.
- C. You can invoke the macros in a library only one time in COLMAP in the Replicat parameter file.
- D. If a macro is defined in a macro library, you may only call that macro once in a parameter file.
Answer: A
Explanation:
Macro libraries in Oracle GoldenGate allow you to define reusable macros and share them across multiple parameter files, improving consistency and reducing duplication in Extract and Replicat configurations.
NEW QUESTION # 54
Cache and queue statistic drill-downs are available for both Extract and Replicat groups.
- A. TRUE
- B. FALSE
Answer: B
Explanation:
Drill-downs are available only for Extract groups.
NEW QUESTION # 55
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 Include All, Exclude ObjName <objectname>
- B. DDL <objectname>
- C. DDL Exclude All, Include ObjName <objectname>
- D. DDL Include. <objectname>
Answer: C
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 # 56
User ______ are a set of variables.
- A. Exits
- B. Procedures
- C. Tokens
- D. Macros
Answer: C
Explanation:
Tokens are variable sets used in parameter files.
NEW QUESTION # 57
What is a DiscardFile not used for?
- A. File for rejected Extract data
- B. File for rejected Replicat 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 # 58
Which valid Extract or Replicat statements using the @RANGE function for an Acct table with a Primary Key on the AccountID column?
- A. MAP sales.acct, TARGET sales.acct, FILTER (@RANGE (1, 3, ID));
- B. MAP sales.acct, TARGET sales.acct, FILTER (@RANGE (2, 3, AccountID));
- C. FILTER (@RANGE (2, 2, AccountID));
- D. TABLE fin.Sales, FILTER (@RANGE (1, 2));
- E. FILTER (@RANGE 2, 2, ID);
Answer: B
Explanation:
This option is the only one that follows correct syntax and uses:
* The MAP clause (required)
* A valid FILTER(@RANGE(...)) expression
* Correct number of arguments: @RANGE(start, mod, column)
* A proper column name: AccountID (primary key)
NEW QUESTION # 59
What type of multithreaded Oracle GoldenGate Extract uses Oracle's internal log parsing and supports downstream topologies?
- A. Coordinated Extract
- B. Classic Extract
- C. Parallel Extract
- D. Integrated Extract
Answer: D
Explanation:
Integrated Extract is a multithreaded Oracle GoldenGate Extract process that uses Oracle's internal LogMiner server to parse redo logs and supports advanced features like downstream capture, compressed data, and multitenant databases.
NEW QUESTION # 60
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. DBA$TRANSACTION
- B. V$TRANSACTION
- C. GV$TRANSACTION
- D. GG$TRANSACTION
Answer: B,C
Explanation:
GV$TRANSACTION - shows active transactions across all RAC instances
EXCLUDEHIDDENCOLUMNS
NEW QUESTION # 61
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 # 62
How is Integrated Capture different from Classic Capture?
- A. Integrated Capture is different because it automatically configures the Capture process of GoldenGate.
- B. Integrated Capture is different because it connects directly to the inbound server to apply transactions.
- C. Integrated Capture is different because it captures processes to integrate with an application server.
- D. Integrated Capture is different because it receives Logical Change Records (LCRs) directly from a database logmining server.
Answer: D
Explanation:
The main difference between Integrated and Classic Capture in Oracle GoldenGate lies in how changes are captured from the database. Integrated Capture uses a database logmining server to receive Logical Change Records (LCRs) directly, while Classic Capture directly reads redo log files.
NEW QUESTION # 63
Where can you view Oracle GoldenGate command syntax?
- A. Data Dictionary Views
- B. Command Line Interface Reference
- C. SQL*Plus Guide
- D. AWR Report
Answer: B
Explanation:
Help or Command Line Interface Reference for Oracle GoldenGate
NEW QUESTION # 64
Which Oracle GoldenGate parameter manages conflicts between initial load and change replication?
- A. PASSTHRU
- B. HandleCollisions
- C. DiscardFile
- D. CheckpointTable
Answer: B
Explanation:
HandleCollisions, specified in the Replicat parameter file. Should be turned off after initial load is complete.
NEW QUESTION # 65
What is not a role used in a Microservices architecture deployment?
- A. User
- B. Security
- C. Manager
- D. Administrator
Answer: C
Explanation:
In Oracle GoldenGate Microservices Architecture (MA), roles refer to user roles that define access control and authorization across the different services. Common roles include:
NEW QUESTION # 66
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 can reuse a group of parameters in commands and functions by using a macro.
- B. Macros can only be defined at the source site in the Extract parameter file.
- C. The parameters in a macro cannot be dynamic parameters.
- D. You cannot have macros in a GLOBALS parameter file.
Answer: A
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 # 67
......
Pass Your Oracle GoldenGate 1Z0-947 Exam on Mar 26, 2026 with 147 Questions: https://www.exams4sures.com/Oracle/1Z0-947-practice-exam-dumps.html
Latest Oracle 1Z0-947 PDF and Dumps (2026) Free Exam Questions Answers: https://drive.google.com/open?id=1YWw9U7EvfGH0zqoYeik77_400NEgRsnX