Topic 1 Question 19

Professional Cloud Architect

Topic 1 Question 19
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?
- Increase the virtual machine's memory to 64 GB
- Create a new virtual machine running PostgreSQL
- Dynamically resize the SSD persistent disk to 500 GB
- Migrate their performance metrics warehouse to BigQuery
- Modify all of their batch jobs to use bulk inserts into the database
ユーザの投票
コメント(17)
- Answer is C because persistent disk performance is based on the total persistent disk capacity attached to an instance and the number of vCPUs that the instance has. Incrementing the persistent disk capacity will increment its throughput and IOPS, which in turn improve the performance of MySQL.
  
  👍 54
  shandy2019/11/26
- Assuming that the database is approaching its hardware limits... both options A and C would improve performance, A would increase number of CPUs and memory, but C would increase memory by more. If it a software problem, it is likly it is a hashing problem (the search and sort algorithms are not specific enough to search within the database). This problem would not be fixed just by migrating to PostgreSQL or BigQuery but modifying the inserts would help the situation because it would entail specifications of data lookups. However, it wouldn't help with search performance just inserts and it doesn't help in normalization. So B, D, and E are eliminated. Since statistics is based on sets, the larger the number of sets the better the predictions. This means that the largest amount of memory would not only increase computer performance but also knowledge enhancements. So C beats A.
  
  👍 30
  Eroc2019/10/24
- 正解だと思う選択肢: C
  C, because... N1 8cpu max IOPS = 15,000 https://cloud.google.com/compute/docs/disks/performance#n1_vms
  
  SSD persistent disks can reach up to 30 IOPS per GB of disk. https://cloud.google.com/compute/docs/disks/performance#example 80 GB X 30 IOPS = 2,400 IOPS 500 GB (answer C) X 30 IOPS = 15,000 IOPS = N1 8 cpu max IOPS
  
  👍 7
  BobLoblawsLawBlog2022/10/22
シャッフルモード

ユーザの投票

コメント(17)