UUS Practice Tests⌕ Search
IT Certifications · 1Z0-947

Oracle GoldenGate 19c Implementation Certified Professional Exam Practice Test

The Oracle GoldenGate 19c Implementation Certified Professional Exam (1Z0-947) concerns configuring and operating change-data capture and replication between databases. Its practice material samples implementation vocabulary such as Extract and Replicat groups, parameter files, trail files, checkpoints, and GGSCI process monitoring, with attention to how transaction changes move through a GoldenGate deployment.

Exam overview

Exam providerOracle
Exam code1Z0-947
CategoryIT Certifications

About the Oracle GoldenGate 19c Implementation Certified Professional Exam

Implementation work involves configuring Extract to capture database changes from redo or archived logs, then writing records to trail files for delivery and processing. A data pump Extract can forward trails between systems, while Replicat maps trail records to target tables and applies them. Parameter-file rules such as MAP, TABLEEXCLUDE, and error-handling directives affect which data is processed and how target-side conflicts are managed. Checkpoint tables help preserve processing progress across restarts, and coordination with database recovery and retention policies supports continued access to required log data. Operational tasks also include using GGSCI to inspect process-group status and using Logdump to examine trail contents. These concepts connect configuration choices to replication continuity, troubleshooting, and the consistency of target data.

Sample Practice Questions

Review a selection from this exam's published US Practice Tests practice bank.

Question 1

During a deployment review, an administrator needs to confirm whether a GoldenGate process is currently running. Which GGSCI command is designed to show the current status of a process group?

  1. ASTATUS
  2. BDESCRIBE
  3. CVALIDATE
  4. DLISTEN
Show answerCorrect answer: A

STATUS reports the current state of a GoldenGate process group. DESCRIBE is not the standard status command, and VALIDATE and LISTEN do not serve this process-status purpose.

Question 2

What is a key reason to coordinate GoldenGate replication with a database's recovery and retention policies?

  1. AGoldenGate may need source transaction-log data to remain available until capture has processed it
  2. BGoldenGate automatically replaces the database's backup strategy
  3. CTarget table indexes are required to contain transaction logs
  4. DThe retention policy controls the spelling of trail-file names
Show answerCorrect answer: A

Capture processes depend on transaction-log records to identify and extract changes. Log retention and recovery practices should ensure required logs are not removed before GoldenGate has processed them, while remaining consistent with the database's recovery requirements.

Question 3

When a GoldenGate group is configured with a checkpoint table, what is a principal benefit of that table?

  1. AIt stores checkpoint information in the database to support tracking of processing progress
  2. BIt stores a full copy of all replicated table data
  3. CIt replaces the need for trail files
  4. DIt provides automatic conflict resolution for all concurrent updates
Show answerCorrect answer: A

A checkpoint table provides a database-based location for checkpoint metadata. This helps track processing progress and can support recovery and coordination behavior, depending on the configuration.

Question 4

Which statement best describes the role of a GoldenGate Extract parameter file?

  1. AIt defines configuration options and capture rules used by an Extract group
  2. BIt stores the database password in clear text for every process
  3. CIt contains the target database's data dictionary
  4. DIt is a binary copy of the Extract checkpoint
Show answerCorrect answer: A

A parameter file supplies the configuration for a process, including applicable settings and object-selection or capture directives. Credentials are normally handled through supported credential mechanisms rather than being treated as the parameter file's purpose.

Question 5

Which GoldenGate utility is commonly used to inspect or edit records in trail files?

  1. ALOGDUMP
  2. BDEFGEN
  3. CGGCHECK
  4. DTRAILFIX
Show answerCorrect answer: A

LOGDUMP is the GoldenGate utility for examining trail records and related metadata. It is useful for troubleshooting what was written to a trail.

Question 6

An Extract must read changes from Oracle redo logs that are stored in an archived form rather than relying only on online logs. What is the relevant log source called?

  1. AArchived redo logs
  2. BDatabase control files
  3. CGoldenGate report files
  4. DReplicat checkpoint tables
Show answerCorrect answer: A

Archived redo logs preserve redo generated by the Oracle database and can be a source of changes for Extract when the required log records are available. Control files, report files, and checkpoint tables are not redo-log sources.

Question 7

What is the primary function of a GoldenGate data pump Extract group?

  1. ATo apply source changes to target tables
  2. BTo read a local trail and send its records onward, commonly to a remote system
  3. CTo perform database backup and recovery
  4. DTo generate target database redo logs
Show answerCorrect answer: B

A data pump is a secondary Extract that reads records from a local trail and can route them to a remote trail or otherwise process and distribute them. It does not apply changes to target tables.

How to use this practice test

The free practice session draws up to 20 random questions from the 50-question bank and displays results when the session ends. Use missed items to identify whether you need to revisit process status commands, capture and delivery flow, parameter directives, checkpoints, or trail inspection; then explain the relevant configuration behavior before retrying.

Preparation tips

  • Trace a transaction from redo capture through Extract, trail routing, and Replicat application; distinguish the roles of a primary Extract and a data pump.
  • Practice interpreting parameter-file directives, including how MAP and exclusion rules affect table selection and how error-handling rules respond to target database errors.
  • Review how checkpoint tables record processing progress and how archived redo availability relates to database recovery and retention settings.
  • Use GGSCI status commands and Logdump inspection together in troubleshooting scenarios: first check whether a process is running, then examine trail records when needed.
Official sourceOfficial exam page ↗