1z0-447 GoldenGate 12c Implementation Practice Questions
Prepare for 1z0-447 with more than an answer.
- Level
- Specialist
- Valid for
- Does not expire (lifetime certification)
Domains covered on the exam 7
- Oracle GoldenGate (OGG) Overview14%
- Architecture Overview18%
- Install and Configure OGG25%
- Parameters15%
- Mapping and Transformation Overview10%
- Configuration Options12%
- Managing and Monitoring Oracle GoldenGate16%
- 1
You want to use multiple concurrent Extract process groups. What is the key factor in determining how many can be running at the same time?
Show answer details
Correct answer: C
Reference: https://docs.oracle.eom/goldengate/1212/gg-winux/GWUAD/wu performance.htm#GWUAD1131
- 2
Which parameter for GoldenGate 12c enables DDL replication for a Replicat?
Show answer details
- 3
Veridata has completed the initial comparison and you want to view the rows that appear to be out-of-sync. How can you do this?
Show answer details
Correct answer: A
Reference: https://docs.oracle.eom/goldengate/v1221/gg-veridata/GVDUG/get started.htm#GVDUG107
- 4
Which combination of DBMS, Extract, and GoldenGate version is required to avoid using a DDL trigger?
Show answer details
Correct answer: C
C
- 5
An administrator is troubleshooting a Data Pump (PMP01) that is failing to send data to a remote Collector process. The topology is as follows:
- Source Server: Primary Extract (EXT01) -> Local Trail (lt)
- Source Server: Data Pump (PMP01) reads Local Trail (lt)
- Target Server: Manager listens on port 7809, starts Collector
A
telnet 7809command from the source server fails to connect, but apingis successful. Anetstat -an | grep 7809on the target server shows the Manager is listening. What is the most likely issue based on the diagram and symptoms?sequenceDiagram participant PMP01 as Data Pump (Source) participant FW as Firewall participant MGR as Manager (Target) PMP01->>+FW: Attempt connect on port 7809 Note right of FW: Port 7809 is blocked FW-->>-PMP01: Connection Timeout / No ResponseShow answer details
Correct answer: B
The symptoms point directly to a network connectivity issue at the TCP layer.
pingworking confirms basic IP reachability (ICMP protocol).telnetfailing confirms that the specific TCP port (7809) is not accessible. Sincenetstaton the target proves the Manager is listening on that port, the connection must be getting blocked somewhere between the source and target. This is a classic symptom of a network firewall rule preventing traffic on the required port, as depicted in the diagram. - 6
You are running multiple installations of Oracle GoldenGate on the same Windows server. How can you differentiate the different Manager services?
Show answer details
Correct answer: A
Reference: http://www.dba-oracle.com/t goldengate parameter files.htm
- 7
You must replicate to JMS Queues. Which product in the Oracle GoldenGate portfolio should be used?
Show answer details
Correct answer: B
Reference: http://www.oracle.eom/webfolder/technetwork/tutorials/obe/fmw/goldengate/11 g/GGS Sect Confiq from WinUX ORA to AMQ_JMS.pdf
- 8
What software is required prior to running Oracle GoldenGate in a Windows Server environment?
Show answer details
Correct answer: C
Reference: https://docs.oracle.eom/goldengate/1212/gg-winux/GIMSS/system requirements.htm#GIMSS182
- 9
Which statement regarding the GoldenGate Data Pump is incorrect?
Show answer details
Correct answer: A
A
- 10
You must implement GoldenGate in a secure environment. How should you proceed in order to protect GoldenGate data from theft?
Show answer details
Correct answer: D
