Oracle Cloud Infrastructure 2021 Architect Professional — Question 1

You want to import data into a DB system with MySQL Shell util.loadDump().
Which option can speed up the load?

Answer options

• A. updateGtidSet: off
• B. showMetadata: false
• C. skipBinlog: true
• D. deferTableIndexes: all

Correct answer: C

Explanation

The correct answer is C, as setting skipBinlog: true prevents the binary logging of the import process, which significantly speeds up the load. Options A, B, and D do not provide the same level of performance improvement during data importation.