exam questions

Exam 1z0-915-1 All Questions

View all questions & answers for the 1z0-915-1 exam

Exam 1z0-915-1 topic 1 question 11 discussion

Actual exam question from Oracle's 1z0-915-1
Question #: 11
Topic #: 1
[All 1z0-915-1 Questions]

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

  • A. updateGtidSet: off
  • B. showMetadata: false
  • C. skipBinlog: true
  • D. deferTableIndexes: all
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
pabg0922
5 months, 2 weeks ago
skipBinlog: true: This option prevents the operations performed during the load from being logged to the binary log. While it might reduce some overhead, it's primarily useful for situations where you don't need the load operations to be replicated. It doesn't directly speed up the load process as much as deferring index creation.
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago