Question-47: Because of the recent uproar around data centers, your organization has made the decision to relocate all of your on-premises databases to Google Cloud. You have an application that is operating on premise, and this application includes a database. The database administration team has entrusted you with the mission of assisting them in enhancing the functionality of their brand-new database server that is hosted on Google Compute Engine. MySQL, an open-source database management system, powers the database, which was constructed for the purpose of importing and standardizing the company's performance information. They use a n1-standard-8 virtual machine that has an SSD persistent drive that is 80 gigabytes in size. What should they alter so that the system can function more effectively?
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
Get All 340 Questions and Answer for Google Professional Cloud Architect
: 3 Explanation: Option-3: Because the performance of a persistent disc is determined by the overall capacity of a persistent disc that is associated to an instance as well as the number of virtual CPUs that the instance has. Increasing the capacity of the persistent disc will result in increased throughput and IOPS, which will ultimately lead to an improvement in MySQL's overall performance. Assuming that the database is getting close to reaching the limitations of its hardware The performance might be improved with either option 1 or option 3, with option 1 increasing the number of CPUs and memory, while option 3 would increase memory by a greater amount. If there is an issue with the programme, then it is most likely a hashing problem (the search and sort algorithms are not specific enough to search within the database). Changing the database management system to PostgreSQL or BigQuery would not be enough to solve this issue on its own; however, altering the inserts would be beneficial since it would require the definition of data lookups. However, it would not assist with the performance of searches, just insertion, and it would not help with the normalisation of the data. Therefore, Options 2, 4, and 5 are no longer viable alternatives. Because statistics is based on sets, the higher the total number of sets, the more accurate the forecasts will be. Because of this, having a larger quantity of memory will not only boost the speed of the computer but also contribute to improvements in one's knowledge.