Practice Test 2 | Google Cloud Certified Professional Cloud Architect | Dumps | Mock Test
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?
A. Create a new virtual machine running PostgreSQL.
B. Migrate their performance metrics warehouse to BigQuery.
C. Increase the virtual machine’s memory to 64 GB.
D. Modify all of their batch jobs to use bulk inserts into the database.
E. Dynamically resize the SSD persistent disk to 500 GB.
Correct Answer E
All of other answers are either not applicable or not specified by the question scenarios.
The following console screenshot show the effect to IO performance by changing memory or disk – it’s self-explained (please enlarge to see the details). Answer E is a clear straightforward winner over answer C as well as others.
 |
 |
 |
Increase disk size to 500GB take significant effect on IO performance than original configuration and higher memory configuration.
Taking IOPS for read as example, all instances are configure with 8vCPU:
80G DISK/30G MEM = 2400 IOPS; 500G DISK/30G MEM = 15000 IOPS; 80G Disk/52G MEM=2400 IOPS
And here is how to dynamically resize disk:
https://cloud.google.com/compute/docs/disks/add-persistent-disk Adding or Resizing Persistent Disks
Comments are closed, but trackbacks and pingbacks are open.