Some questions about OGG

QUESTION: 5

Which combination of DBMS, Extract, and GoldenGate version is required to avoid

using a DDL trigger?

1. A. Oracle Database 11.2.0.3 or greater, Integrated Extract, and GoldenGate 12.1 or

greater

1. B. any version of Oracle Database, Integrated Extract, and GoldenGate 11.2 or greater
2. C. Oracle Database 11.2.0.4 or greater, Integrated Extract, and GoldenGate 12.1 or

greater

1. D. Oracle Database 12c or greater, Integrated Extract, and GoldenGate 11.2 or greater

Answer that i put on exam: C

Answer is A, 11.2.0.3 works with a patch for IE to work.

QUESTION: 28

What is the default threshold for message compression in OGG?

1. A. 1000
2. B. 100
3. C. O
4. D. By default, messages are not compressed.

Answer that i put on exam: A

Answer is D, looks like the question is asking about RMTHOST COMPRESS.

QUESTION: 31

You are migrating from a legacy database server to Exadata, which requires you to use different versions of GoldenGate.
What do you need to configure to ensure that backwards replication works?
A. The Replicat with the FORMAT RELEASE parameter.
B. The Extract with the FORMAT RELEASE parameter.
C. The Extract to write directly to the remote trail.
D. The collector with the FORMAT RELEASE parameter.

Answer that i put on exam: A

Answer is B. It is an exttrail rmttrail option.

Rest is ok. You didn't pass? What is the score required?

Cheers

Kee Gan

Hey Rodrigo,

The question is little tricky. As per the note, default threshold is 1000, but by default messages are not compressed. You need to use the COMPRESS option in the RMTHOST.

Regards,

Veera

Blame the documentation. So is it default or not! If you specify compress then the threshold is 1000. But I know it is uncompressed by default.

COMPRESS

This option is valid for online or batch Extract processes and any Oracle GoldenGate initial-load method that uses trails. Compresses outgoing blocks of records to reduce bandwidth requirements. Oracle GoldenGate decompresses the data before writing it to the trail. COMPRESS typically results in compression ratios of at least 4:1 and sometimes better. However, compressing data can consume CPU resources.

COMPRESSTHRESHOLD

This option is valid for online or batch Extract processes and any Oracle GoldenGate initial-load method that uses trails. Sets the minimum block size for which compression is to occur. Valid values are from 0 and through 28000. The default is 1,000 bytes.

You are at the mercy of President Coriolanus Snow!

Good luck

Kee Gan

All of them looks correct

Kee