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…

Question

Options

• AIncrease the virtual machine's memory to 64 GB.
• BCreate a new virtual machine running PostgreSQL.
• CDynamically resize the SSD persistent disk to 500 GB.
• DMigrate their performance metrics warehouse to BigQuery.
• EModify all of their batch jobs to use bulk inserts into the database.

• B
  4% (1)
• C
  83% (19)
• D
  9% (2)
• E
  4% (1)

Explanation

A is not correct because increasing the memory size will not improve persistent disk throughput. B is not correct because the DB administration team is requesting help with their MySQL instance Migration to a different product should not be the solution when other optimization techniques can still be applied first. C is correct 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 ns throughput and IOPS, which In turn improve the performance of MySQL. D is not correct because the DB administration team is requesting help with their MySQL instance Migration to a different product should not be the solution when other optimization techniques can still be applied first.

No community discussion yet for this question.