MySQL 8.0 Database Administrator — Question 83

Which three actions are effective in capacity planning? (Choose three.)

Answer options

• A. buying more RAM
• B. monitoring OS resources for patterns
• C. adding circular replication nodes for increased DML capability
• D. buying more CPU
• E. buying more disk
• F. basing expected growth on an average of the last 3 years
• G. consulting the application team about any future projects and use
• H. upgrading to the latest application version

Correct answer: B, F, G

Explanation

The correct actions for effective capacity planning include monitoring OS resources for patterns, which helps identify trends in resource usage, basing expected growth on historical data, providing a realistic foundation for future needs, and consulting with the application team to understand upcoming projects that may impact capacity. The other options, while related to resource management, do not directly contribute to strategic capacity planning.