You want to issue GoldenGate commands from a script. What sequence of steps should you follow to accomplish this?

A. Create a text file that contains the commands that you want to issue, in the order they are to be issued. Run GGSCI ./ input_file, where the file name is the script file.

B. Create a text file that contains the commands that you want to issue, in the order they are to be issued. Enter ggsci < input_file from the command line of the operating system, where the input_file is an OBAY text file.

C. Create a text file that contains the commands that you want to issue, in the order they are to be issued. Run GGSCI < input_file, where the file name is an OBEY file.

D. Create a text file that contains the commands that you want to issue, in the order they are to be issued. Enter ggsci ./ input_file from the command line of the operating system, where the file name is the script file.

You must replicate to JMS Queues. Which product in the Oracle GoldenGate portfolio should be used?

A. Oracle Goldengate for Big Data

B. Oracle Goldengate Application Adapters

C. Oracle Goldengate Veridata

D. Oracle Data Integrator Adapters

You have an issue where all threads are waiting for a specific transaction to be executed first. What is this issue related to?

A. It is caused by THREAD andTHREADRANGE being used with wildcard MAP statements.

B. It is caused by the thread with the highest thread ID applying barrier transactions.

C. It is caused by the use of the MAXTRANSOPSparameter.

D. It is caused by barrier transactions in a Coordinated Replicat.

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.

What is the key purpose of GoldenGate trail files?

A. They are a persistent storage area for captured transactions.

B. They are configuration files for the GoldenGate processes.

C. They are checkpoint files for the GoldenGate processes.

D. They are database auditing logs where GoldenGate captures changes.

Identify two correct statements regarding GoldenGate supported features.

A. GoldenGate supports network encryption and compression.

B. GoldenGate supports DML and DDL replication for all supported databases.

C. GoldenGate for Oracle supports Exadata Hybrid Columnar Compression as a source.

D. GoldenGate for SQLServer supports only SQLServer Standard Edition as a source.

Which Logdump command is used to check how many change records are in the trail file?

A. STATS

B. REPORT

C. REPORTCOUNT

D. COUNT

How can you tell if GoldenGate has been configured for batch processing?

A. The SPECIALRUNparameter is in the Replicat parameter file.

B. Replicat is started with the INITIALLOADtask.

C. There is a dedicated GoldenGate process called SPECIALRUN.

D. The SPECIALRUNparameter is in the GLOBALS parameter file.

Your GLOBALS file contains the parameter SYSLOG NONE, but the system logs contain warnings from the Manager. What could be causing this to occur?

A. The GGSCI session was configured incorrectly.

B. The Manager parameter file contains SYSLOG ALL.

C. An Extract or Replicat is overriding GLOBALS with SYSLOG WARN.

D. The user session running Manager is set to log all messages.

Which three are requirements to correctly configure an OGG trail file? (Choose three.)

A. a trail file identifier

B. designation as local or remote

C. a maximum file size

D. an Extract process

E. a Replicat process