A MySQL warehouse runs on Debian in an n1-standard-8 with an 80 GB SSD persistent disk and needs better I/O performance. Which change will improve performance?
Choose an answer
Tap an option to check your answer.
Correct answer: Dynamically resize the SSD persistent disk to 500 GB.
Why this is the answer
Increasing the SSD persistent disk size to 500 GB will improve I/O performance. For Persistent Disks on Google Cloud, both IOPS (Input/Output Operations Per Second) and throughput scale with disk size. A larger disk provides a higher maximum IOPS and throughput, directly addressing the need for better I/O performance. Increasing the VM's memory might help with caching but doesn't directly improve disk I/O limits. Creating a new VM with PostgreSQL or migrating to BigQuery are significant architectural changes, not simple performance improvements for the existing MySQL instance. Modifying batch jobs for bulk inserts is an application-level optimization, which can help, but doesn't address the underlying disk I/O bottleneck.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed