Google Cloud Professional Cloud Architect — Question 50

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 for importing and normalizing their performance statistics and is built with MySQL running on Debian Linux. They have an n1-standard-8 virtual machine with 80 GB of SSD persistent disk.
What should they change to get better performance from this system?

Answer options

• 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

Correct answer: C

Explanation

Increasing the size of the SSD persistent disk to 500 GB (Option C) can significantly enhance performance by providing more space for data storage and improving I/O operations. Options A, B, and D suggest alternatives that do not directly address the current performance limitations of the existing setup. Option E, while beneficial for efficiency, may not resolve the underlying performance issues related to the disk capacity.