1Z0-947 100% Guarantee Download 1Z0-947 Exam PDF Q&A [May 15, 2026]
Get 1Z0-947 Actual Free Exam Q&As to Prepare for Your Oracle Certification
NEW QUESTION # 32
Which of the following statements is true?
- A. The CKPT background process records the Oracle GoldenGate checkpoint.
- B. There is likely to be only one Oracle GoldenGate checkpoint file.
- C. Oracle GoldenGate checkpoints are stored in an Oracle control file.
- D. The Oracle GoldenGate checkpoint supports Oracle GoldenGate recovery.
Answer: D
Explanation:
Checkpoints support recovery, not stored in Oracle control files.
NEW QUESTION # 33
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. TRUE
- B. FALSE
Answer: B
Explanation:
Distribution Server only routes data; no transformations.
NEW QUESTION # 34
You want to use coordinated Replicat mode instead of classic mode. Which three reasons should you consider for this?
- A. Coordinated Replicat allows for user-defined partitioning of the workload so as to apply high-volume transactions concurrently.
- B. Parent and child tables must not be processed by the same apply thread.
- C. Multiple transactions on the target are executed with full synchronization.
- D. Replicat is multi-threaded in coordinated mode.
- E. Only one parameter file is required for a coordinated Replicat, regardless of the number of threads.
Answer: A,D,E
NEW QUESTION # 35
What is not a role used in a Microservices architecture deployment?
- A. Security
- B. User
- 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 # 36
A Pump can push data to:
- A. Only one target system
- B. A target database directly
- C. Multiple target systems
- D. Only a source system
Answer: C
Explanation:
In Oracle GoldenGate, a Data Pump (secondary Extract) can be configured with multiple RMTHOST and RMTTRAIL pairs, allowing it to push data to multiple target systems or trail files, enhancing flexibility in multi-target replication setups.
NEW QUESTION # 37
A Distribution Path sends the transaction of data from Extract to Replicat. How can you create a Distribution Path?
- A. In GGSCI with GoldenGate commands
- B. From the Service Manager home page
- C. At OS prompt with run preceding the GoldenGate commands
- D. From Cloud Shell with REST APIs
Answer: B
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 # 38
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 # 39
Which is an incorrect option to use with the DBOPTIONS parameter for a Replicat?
- A. USEODBC
- B. USEREPLICATIONUSER
- C. NOCATALOGCONNECT
- D. BATCHSQL
Answer: D
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 # 40
Which file is required if you're doing column mapping on the source system only?
- A. Target-definitions file
- B. Source-definitions file
- C. Extract parameter file
- D. Replicat parameter file
Answer: B
Explanation:
Use a source definition file when doing mapping at source.
NEW QUESTION # 41
Which of these can you not do from the main page of the MA Administration Server web page?
- A. Create an Extract or Replicat.
- B. Restart configured Extracts and Replicats.
- C. Fix the situation of what caused the Extract or Replicat to be down from the Critical Event box.
- D. See the lag time of currently configured Extracts and Replicats.
Answer: C
Explanation:
From the main page of the Oracle GoldenGate 19c Microservices Architecture (MA) Administration Server web interface, you can do the following: ? Restart configured Extracts and Replicats ? Create Extract or Replicat processes ? View lag time and status of running processes ? But you cannot directly "fix" the underlying issue causing an Extract or Replicat to fail from the Critical Event box. You may be alerted to the issue there, but resolving it typically requires additional diagnosis or configuration changes via other tools or pages.
NEW QUESTION # 42
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 # 43
The Healthcheck (ICRHC) script is shipped with Oracle DB and found in
- A. TRUE
- B. FALSE
Answer: B
Explanation:
ICRHC script is not shipped by default with Oracle DB.
NEW QUESTION # 44
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 # 45
Which parameter is typically associated with an Extract group in Oracle GoldenGate?
- A. ExtTrail
- B. DiscardFile
- C. Obey
- D. Map
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 # 46
What are the five main components of Oracle GoldenGate Microservices Architecture (MA)?
- A. Monitor Server, Extract Server, Replicat Server, Admin Console, Trail Manager
- B. AdminClient, Logger, Trail Viewer, Deploy Agent, OGGBridge
- C. Extract, Pump, Replicat, Trail, Checkpoint
- D. Service Manager, Administration Server, Distribution Server, Receiver Server, Performance Metrics Server
Answer: D
Explanation:
These are the key microservices in GoldenGate MA used for deployment, management, data distribution, and monitoring.
NEW QUESTION # 47
How should you specify the data source for a secondary Extract functioning as a Data Pump?
- A. LOCTRAILSOURCE
- B. SOURCEISSTABLE
- C. SOURCEISTRAIL
- D. EXTTRAILSOURCE
Answer: D
Explanation:
For a secondary Extract functioning as a Data Pump, you should specify the data source using EXTTRAILSOURCE. This parameter tells GoldenGate to use the local trail file (created by the primary Extract) as the source for the data pump.
NEW QUESTION # 48
Which parameter for GoldenGate 19c enables DDL replication for a Replicat?
- A. USEDDL
- B. TARGETDDL
- C. GETDDL
- D. Enabled by default
Answer: D
Explanation:
In Oracle GoldenGate 19c, Replicat is indeed configured to process DDL by default. So, if DDL statements are captured by Extract and passed in the trail files, Replicat will apply them without needing extra configuration.
NEW QUESTION # 49
What command is used to create the checkpoint table on the target database?
- A. INIT CHECKPOINTTABLE
- B. CONFIGURE CHECKPOINT TABLE
- C. ADD CHECKPOINTTABLE
- D. CREATE TABLE CHECKPOINT
Answer: C
Explanation:
This command creates a table that tracks Replicat's checkpointing data.
NEW QUESTION # 50
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 (2, 3, AccountID));
- B. FILTER (@RANGE (2, 2, AccountID));
- C. MAP sales.acct, TARGET sales.acct, FILTER (@RANGE (1, 3, ID));
- D. FILTER (@RANGE 2, 2, ID);
- E. TABLE fin.Sales, FILTER (@RANGE (1, 2));
Answer: A
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 # 51
What is the main advantage of using a data pump Extract?
- A. Faster row compression
- B. Secure REST access
- C. Enables load balancing
- D. Trail retention at source for recovery
Answer: D
Explanation:
It allows recovery if the network or target system fails by maintaining a local trail.
NEW QUESTION # 52
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. Extract is typically used to produce local trail files over a TCP/IP connection.
- D. Trail files are used to show the order GoldenGate files are accessed to perform replication.
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 # 53
......
1Z0-947 Questions Truly Valid For Your Oracle Exam: https://www.pass4sures.top/Oracle-GoldenGate/1Z0-947-testking-braindumps.html
Oracle Actual Free Exam Questions And Answers: https://drive.google.com/open?id=1qVt7UxGkRAUPoqCSnyIxBY-4k4xGoXlM