Exam Professional Cloud Database Engineer topic 1 question 63 discussion

Actual exam question from Google's Professional Cloud Database Engineer

Question #: 63
Topic #: 1

[All Professional Cloud Database Engineer Questions]

Your organization has an existing app that just went viral. The app uses a Cloud SQL for MySQL backend database that is experiencing slow disk performance while using hard disk drives (HDDs). You need to improve performance and reduce disk I/O wait times. What should you do?

A. Export the data from the existing instance, and import the data into a new instance with solid-state drives (SSDs).
B. Edit the instance to change the storage type from HDD to SSD.
C. Create a high availability (HA) failover instance with SSDs, and perform a failover to the new instance.
D. Create a read replica of the instance with SSDs, and perform a failover to the new instance

Show Suggested Answer

Suggested Answer: A 🗳️

by pk349 at Dec. 25, 2022, 12:06 a.m.

Comments

Submit Cancel

chelbsik

Highly Voted 2 years, 1 month ago

Selected Answer: A

You can't edit disk time, this setting is permanent. https://stackoverflow.com/questions/72034607/can-i-change-storage-type-from-hdd-to-ssd-on-cloud-sql-after-creating-an-instanc You also can't choose disk type for read replica.

upvoted 9 times

...

dynamic_dba

Highly Voted 1 year, 10 months ago

A. B would not work. You cannot change the disk type of the instance after it’s created. C is wrong for the same reason. Adding HA would create a failover replica with the same disk type as the primary. The same is true for a read replica, so D is wrong as well. Leaves A.

upvoted 5 times

...

Pime13

Most Recent 9 months, 1 week ago

Selected Answer: A

https://cloud.google.com/sql/docs/mysql/choosing-ssd-hdd#switching

upvoted 2 times

...

Nirca

1 year, 11 months ago

Selected Answer: A

The choice of SSD or HDD storage for the instance is not available. It should be is done manually.

upvoted 2 times

...

PrtkKA

1 year, 11 months ago

Selected Answer: A

Switch between SSD and HDD storage When you create a Cloud SQL instance, your choice of SSD or HDD storage for the instance is permanent. If you need to convert an existing HDD instance to SSD, or conversely, you can export the data from the existing instance and import the data into a new instance. Keep in mind that migrating an entire instance takes time. https://cloud.google.com/sql/docs/mysql/choosing-ssd-hdd

upvoted 2 times

...

ssaporylo

2 years, 1 month ago

Why not D?

upvoted 1 times

csrazdan

2 years ago

When a read replica is created you do not configure the disk type and it is used as it is on primary to avoid replication errors. That is the reason A is the correct answer. See link --> https://cloud.google.com/sql/docs/mysql/replication/create-replica

upvoted 2 times

...

pk349

2 years, 1 month ago

C: Create a high availability (HA) failover instance with SSDs, *** and perform a failover to the new instance.

upvoted 3 times

...