01. Which components are created during a typical OGG install using ZIP packages?
(Choose two.)
a) GoldenGate home directory
b) Trail subdirectories
c) Integrated Replicat apply engine
d) Database mining server binaries
02. Initial Load is a process of extracting data records from the source database and loading those records onto the target database. There are many advantages in using GoldenGate to obtain the data from the source and load the records onto the target.
What describes the advantage of continuing to make data changes on the source database while loading data onto the target database?
a) Enable data changes on source tables without locking tables.
b) Enable the LGWR to indicate in the transaction log when initial load commenced.
c) Enable Extract to indicate in the trail file when initial load commenced.
d) Enable change delivery to handle collisions with initial load.
03. Which two transformation functions are commonly used to convert data formats during Replicat processing?
(Choose two)
a) @TOKEN
b) @DATE
c) @STRCAT
d) @STRPAD
e) @GETENV
04. How is Integrated Capture different from Classic Capture?
a) Integrated Capture is different because it captures processes to integrate with an application server.
b) Integrated Capture is different because it receives Logical Change Records (LCRs) directly from a database logmining server.
c) Integrated Capture is different because it automatically configures the Capture process of GoldenGate.
d) Integrated Capture is different because it connects directly to the inbound server to apply transactions.
05. Which parameters must be included in an Extract configuration for non-Oracle databases?
(Select all that apply)
a) GETUPDATE
b) TARGETDB LIBFILE
c) SOURCEISFILE
d) TRANLOGOPTIONS DBLOGREADER
e) DBOPTIONS CONNECTIONRETRIES
06. In an Oracle-to-Oracle configuration with Integrated Extract, where does log mining actually occur?
a) Inside the operating system’s file system layer
b) Inside the Replicat apply engine on the target
c) Inside the source database log mining server
d) Inside the GoldenGate Manager process
07. What are the four Oracle GoldenGate use cases?
(Select all that apply)
a) Zero downtime upgrades and migrations
b) Real-time data warehousing
c) Backup and recovery
d) Offload reporting
d) Real-time discovery
f) Data center load balancing by using multimaster replication
08. You made changes to the GLOBALS parameter file using an editor on the OS. After saving your changes, you noticed the changes did not take effect. What would be the reason for this?
a) You did not restart GGSCI.
b) You did not make changes on the OS logged in as the GoldenGate Administrator user.
c) You did not stop all replication processes running in so the changes can take effect.
d) You did not MGR so the changes can take effect.
09. Which parameters help reduce data collisions during an active-active configuration?
(Choose two.)
a) HANDLECOLLISIONS
b) BATCHSQL
c) FILTERDUPLICATES
d) MAPEXCLUDE
e) GETUPDATE
10. Before configuring Capture, which prerequisite must be verified to ensure redo logs contain full row data?
a) Streams replication is enabled
b) Global names are disabled
c) Flashback logging is disabled
d) Supplemental logging is enabled
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.