Oracle GoldenGate 23ai Implementation Associate - 1Z1-948 Exam Questions [2026]

QUESTION NO: 1
Which clause is used to rename columns during data replication?

A. MAP B. TARGET C. TABLE D. COLMAP

Correct Answer: D

QUESTION NO: 2
Which clause allows conditional data mapping based on column values?

A. FILTER B. @IF C. MAP D. WHERE

Correct Answer: B

QUESTION NO: 3
Which two tasks are typically required to configure Oracle GoldenGate Microservices Architecture after software installation?
Select all that apply

A. Configure Services Manager endpoints and ports B. Disable Receiver Service to allow direct Replicat reads C. Create a local trail and start Extract from GGSCI only D. Register Extract using only the DBMS_SCHEDULER package E. Deploy Admin Server and create a deployment home

Correct Answer: A,E

QUESTION NO: 4
Which GoldenGate feature ensures that DDL changes are replicated automatically?

A. DDL CONTROL B. DDL INCLUDE ALL C. DDL ENABLE D. DDL REPLICATION

Correct Answer: B

QUESTION NO: 5
A team is performing an initial load and must ensure ongoing source changes are captured without blocking application transactions. Which approach supports this requirement?

A. Disable redo logging during the initial load B. Run initial load while Extract captures changes in trails C. Enable table locks during initial load D. Start Replicat before initial load completes

Correct Answer: B

QUESTION NO: 6
Which parameter is used to suppress duplicate record errors during initial synchronization?

A. FILTERDUPLICATES B. REPERROR C. IGNORETRUNCATES D. HANDLECOLLISIONS

Correct Answer: D

QUESTION NO: 7
Which statement best describes Oracle GoldenGate's impact on source database availability?

A. Requires scheduled downtime B. Requires exclusive database access C. Locks tables during data capture D. Operates with minimal impact and no downtime

Correct Answer: D

QUESTION NO: 8
Which two tasks are required before starting an Initial Load using Oracle GoldenGate?
(Choose two)

A. Enable database archivelog mode B. Create checkpoint tables C. Stop database listener D. Disable Replicat processes E. Configure Extract parameter files

Correct Answer: A,E

QUESTION NO: 9
Which two parameters are valid for non-Oracle database replication?
select all that apply

A. TRANLOGOPTIONS B. SOURCEDEFS C. LOGALLSUPCOLS D. DBOPTIONS E. ASSUMETARGETDEFS

Correct Answer: B,E