01. During a controlled resynchronisation, updates arrive for rows that are absent from the target. The business wants those rows created rather than reported as errors.
Which behaviour is being asked for?
a) Grouping more operations into each applied transaction to reduce the failures
b) Treating an update with no matching target row as an insert
c) Discarding the operation and continuing, so the run finishes and the gap is reviewed
d) Deferring constraint checks until the applied transaction commits
02. Which of these commands create something that persists in a database rather than only in Oracle GoldenGate’s own files?
(Choose two.)
a) The command that adds a trail to a group
b) The command that adds supplemental logging for a table
c) The command that opens a parameter file for editing
d) The command that adds a checkpoint table
e) The command that adds an Extract group
03. Object names in a mapping are written without a catalog qualifier, and the source is a container database.
What supplies the missing qualifier?
a) The trail record carrying the catalog each operation was captured from
b) The database connection, which fixes the catalog for everything the process handles
c) The target mapping, which supplies the qualifier the source name has omitted
d) A parameter that states the catalog to assume for names given without one
04. Which file does the parameter-editing command of the command interface open?
a) The parameter file belonging to the named proces
b) The discard file holding records that failed to apply
c) The report file the process writes as it runs
d) The installation-wide file read by every process at start-up
05. How is the workload divided across the threads of a Coordinated Replicat?
a) The target database distributes it, using the same rules it applies to any other parallel work
b) Each thread reads its own trail, so the split is decided when the trails are written
c) The mapping statements assign work to threads, with barrier transactions where they interact
d) Oracle GoldenGate computes the dependencies, then spreads transactions over the threads
06. The link between a source site and its target is lost for several hours. When it returns, no captured change has been lost and delivery resumes where it left off.
Which combination accounts for that?
a) The apply process rolled back its work, and the source re-sent every transaction from the start
b) The target buffered the incoming stream in memory, and replayed it once the link returned
c) The source database retained the redo, and capture re-read it from the point of the outage
d) The local trail retained the captured data, and the sender resumed from its checkpoint
07. Why is a dedicated database account created for Oracle GoldenGate rather than reusing an application account?
a) It carries the privileges the processes require rather than those an application holds
b) It allows the schema check script to run without a connection to the database
c) It is the only account permitted to hold the credential store the processes connect with
d) It causes the database to write supplemental log data for every table it owns
08. What does the statistics option of a process parameter file govern?
a) How often the process writes its position, so a restart repeats less
b) What the process includes when it reports the operations it has processed
c) How long the process retains the trail files it has already read
d) Which operations the process handles, and which it passes over
09. After a host reboot, the replication processes are running again without anyone starting them. Separately, a process that fails during the day comes back on its own.
Which two Manager behaviours are at work?
a) One brings processes up when Manager starts; the other restarts Manager if it fails
b) One starts the processes in order; the other restarts them all if any one of them stops
c) One restarts a failed process; the other retries the database connection it lost
d) One brings processes up when Manager starts; the other brings a failed process back
10. Where are transaction dependencies worked out when a Parallel Replicat applies changes?
a) In Oracle GoldenGate, which computes them before handing work to the apply threads
b) In the configuration, which assigns each table to a numbered thread in advance
c) In the target database’s inbound server, which resolves them as the changes are applied
d) In the source Extract, which marks each transaction before it reaches the trail
The Oracle GoldenGate Implementation Professional (1Z0-947) Sample Question Set is designed to help you prepare for the Oracle GoldenGate 19c Implementation Certified Professional certification exam. To become familiar with the actual Oracle Certification exam environment, we suggest you try our Sample Oracle 1Z0-947 Certification Practice Exam.
