Answer-first summary for fast verification
Answer: Dynamically resize the SSD persistent disk to 500 GB
The correct answer is C: Dynamically resize the SSD persistent disk to 500 GB. Persistent disk performance in Google Cloud is influenced by the total disk capacity attached to a virtual machine and the number of vCPUs. By increasing the size of the SSD persistent disk from 80 GB to 500 GB, the IOPS (input/output operations per second) and throughput can be significantly enhanced, leading to better overall performance of the MySQL database.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
The database administration team has asked you to help them improve the performance of their new database server running on Google Compute Engine. The database is used for importing and normalizing their performance statistics and is built with MySQL running on Debian Linux. Currently, they use an n1-standard-8 virtual machine that comes with 8 vCPUs and 30 GB of memory, along with an 80 GB SSD persistent disk. Considering both hardware and software optimizations, what should they change to get better performance from this system?
A
Increase the virtual machine's memory to 64 GB
B
Create a new virtual machine running PostgreSQL
C
Dynamically resize the SSD persistent disk to 500 GB
D
Migrate their performance metrics warehouse to BigQuery
E
Modify all of their batch jobs to use bulk inserts into the database
No comments yet.