NEW QUESTION NO: 5
Which combination of DBMS, Extract, and GoldenGate version is required to avoid using a DDL trigger?
A. Oracle Database 11.2.0.3 or greater, Integrated Extract, and GoldenGate 12.1 or greater
B. Oracle Database 11.2.0.4 or greater, Integrated Extract, and GoldenGate 12.1 or greater
C. Oracle Database 12c or greater, Integrated Extract, and GoldenGate 11.2 or greater
D. any version of Oracle Database, Integrated Extract, and GoldenGate 11.2 or greater
Answer: B

NEW QUESTION NO: 6
Which Logdump command is used to check how many change records are in the trail file?
A. STATS
B. REPORT
C. REPORTCOUNT
D. COUNT
Answer: D
Explanation/Reference:
Reference: https://docs.oracle.com/goldengate/1212/gg-winux/GLOGD/wu_logdump.htm#GLOGD121

NEW QUESTION NO: 7
You must implement GoldenGate in a secure environment. How should you proceed in order to protect GoldenGate data from theft?
A. Implement trail file encryption.
B. Ensure that passwords are encrypted.
C. Ensure that network communications are encrypted.
D. Ensure that table-level Transparent Data Encryption is implemented.
Answer: D
Explanation/Reference:
Reference: http://www.oracle.com/technetwork/database/security/esi/ds-database-security-golden-gate-
1438944.pdf

NEW QUESTION NO: 8
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?
A. View the maybe out-of-sync (MOOS) queue.
B. View the Veridata log file.
C. View the confirm-out-of-sync (COOS) queue.
D. View the Veridata Agent repository.
Answer: A
Explanation/Reference:
Reference: https://docs.oracle.com/goldengate/v1221/gg-veridata/GVDUG/get_started.htm#GVDUG107

NEW QUESTION NO: 9
You need to look up table definitions in a file. Which Replicat parameter should you use?
A. MAP
B. ASSUMETARGETDEFS
C. COLMATCH
D. SOURCEDEFS
Answer: D

NEW QUESTION NO: 10
What is the key purpose of GoldenGate trail files?
A. They are configuration files for the GoldenGate processes.
B. They are database auditing logs where GoldenGate captures changes.
C. They are a persistent storage area for captured transactions.
D. They are checkpoint files for the GoldenGate processes.
Answer: D

NEW QUESTION NO: 11
Which GLOBALS parameter is required to initially enable monitoring?
A. JAGENTMONITORING
B. ENABLEMONITORING
C. ENABLEOEMMONITORING
D. CHECKMONITORING
Answer: B
Explanation/Reference:
Reference: https://docs.oracle.com/goldengate/1212/gg-winux/GWURF/
gg_parameters053.htm#GWURF474

NEW QUESTION NO: 12
Which statement is valid for DDL replication?
A. Target objects can be different from source when using SOURCEDEFSin Replicat.
B. Source and target objects can be different.
C. GoldenGate User Exits are not supported for DDL.
D. It can use WILDCARDRESOLVE IMMEDIATE.
Answer: B

NEW QUESTION NO: 13
You want to generate an extract file or trail in a non-GoldenGate canonical format like those used in the Initial Load file-to-database utility. How should you configure GoldenGate in order to accomplish this?
A. Configure Replicat with the FORMATASCII SQLLOADER OPTION.
B. Configure Extract with the FORMATSQL SQLLOADER OPTION.
C. Configure Extract with the FORMATASCII SQLLOADER OPTION.
D. Configure Replicat with the FORMATXML OPTION.
Answer: C
Explanation/Reference:
Reference: https://docs.oracle.com/goldengate/1212/gg-winux/GWUAD/wu_initsync.htm#GWUAD546

NEW QUESTION NO: 14
You are running multiple installations of Oracle GoldenGate on the same Windows server. How can you differentiate the different Manager services?
A. Create a GLOBALSfile for each installation and use the MGRSERVNAMEparameter, with a unique name.
B. Include the parameter SERVICENAME in each Manager, with a unique name.
C. Accept the default service name and manually edit within the Services applet.
D. Multiple Manager services are not allowed on the same Windows server.
Answer: A
Explanation/Reference:
Reference: http://www.dba-oracle.com/t_goldengate_parameter_files.htm

NEW QUESTION NO: 15
GoldenGate has cached long-running open transactions to disk for an Oracle database. Where can you locate them?
A. in the bounded recovery area
B. in the trail files area
C. in the checkpoint file area
D. in the server temporary file system
Answer: D