ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 105 - 312-40 discussion

Report
Export

Stephen Cyrus has been working as a cloud security engineer in an MNC over the past 7 years. The database administration team requested Stephen to configure a server instance that can enhance the performance of their new database server running on Compute Engine. The database is built on MySQL running on Debian Linux and it is used to import and normalize the company's performance statistics. They have an n2-standard-8 virtual machine with 80 GB of SSD zonal persistent disk, which cannot be restarted until the next maintenance event. Which of the following can help Stephen to enhance the performance of this VM quickly and in a cost-effective manner?

A.
Dynamically resize the SSD persistent disk to 500 GB
Answers
A.
Dynamically resize the SSD persistent disk to 500 GB
B.
Enhance the VM memory to 60 GB
Answers
B.
Enhance the VM memory to 60 GB
C.
Migrate their performance metrics warehouse to BigQuery
Answers
C.
Migrate their performance metrics warehouse to BigQuery
D.
Create a new VM that runs on PostgreSQL
Answers
D.
Create a new VM that runs on PostgreSQL
Suggested answer: A

Explanation:

To enhance the performance of a MySQL database running on Compute Engine quickly and in a cost-effective manner, Stephen can dynamically resize the SSD persistent disk to 500 GB. Here's why this option is effective:

1.Increased IOPS and Throughput: SSDs provide higher input/output operations per second (IOPS) and throughput compared to traditional hard drives. By increasing the size of the SSD persistent disk, Stephen can benefit from increased IOPS and throughput, which are crucial for database performance, especially when dealing with large volumes of data imports and normalization processes1.

1.No Downtime Required: Dynamically resizing the SSD persistent disk can be done without stopping the virtual machine, which aligns with the requirement that the VM cannot be restarted until the next maintenance event1.

1.Cost-Effectiveness: Resizing the disk is a cost-effective solution because it does not require provisioning additional compute resources or migrating to a different database service, which could incur higher costs and complexity1.

1.Immediate Performance Boost: The performance improvement is immediate after the disk resize, as the database can utilize the additional space for better disk I/O performance, which is often a bottleneck in database operations1.

LogRocket Blog: 5 ways to rapidly improve MySQL database performance1.

Google Cloud Documentation: Architectures for high availability of MySQL clusters on Compute Engine2.

Percona Blog: MySQL Performance Tuning 101: Key Tips to Improve MySQL Database Performance3.

asked 18/09/2024
Maria Lilian Tongson
41 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first