ExamTopics Logo
Mail Us[email protected]
Menu
Google Discussions
exam questions

Exam Professional Cloud Database Engineer All Questions

View all questions & answers for the Professional Cloud Database Engineer exam
Go to Exam

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 Hide Answer
Suggested Answer: A 🗳️
by pk349 at Dec. 25, 2022, 12:06 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
chelbsik
Highly Voted 1 year, 10 months 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, 7 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 5 months, 3 weeks ago
Selected Answer: A
https://cloud.google.com/sql/docs/mysql/choosing-ssd-hdd#switching
upvoted 2 times
...
Nirca
1 year, 7 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, 7 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
1 year, 9 months ago
Why not D?
upvoted 1 times
csrazdan
1 year, 9 months 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
1 year, 10 months ago
C: Create a high availability (HA) failover instance with SSDs, *** and perform a failover to the new instance.
upvoted 3 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago