nerdexam
Oracle

1Z0-888 · Question #69

1Z0-888 Question #69: Real Exam Question with Answer & Explanation

Sign in or unlock 1Z0-888 to reveal the answer and full explanation for question #69. The question stem and answer options stay visible for context.

Performance Tuning

Question

You have successfully provisioned the latest MySQL 5.7 database instance on a physical host, to be added to an existing farm for use in a modern, high volume, ACID-compliant, OLTP website, which serves hundreds of DML transactions per second. The default values of which two key variables do you change to ensure seamless operation of the database? (Choose two.)

Options

  • AKey Buffer Size
  • BInnodb Redo Log Size
  • CBinary Log Size
  • DBuffer Pool Size
  • ESort Buffer Size
  • FQuery Cache Size

Unlock 1Z0-888 to see the answer

You've previewed enough free 1Z0-888 questions. Unlock 1Z0-888 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Topics

#Buffer Pool Configuration#InnoDB Tuning#OLTP Memory Allocation#MySQL 5.7 Architecture
Full 1Z0-888 Practice