Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Google Professional Cloud Database Engineer Exam - Topic 10 Question 61 Discussion

You need to migrate existing databases from Microsoft SQL Server 2016 Standard Edition on a single Windows Server 2019 Datacenter Edition to a single Cloud SQL for SQL Server instance. During the discovery phase of your project, you notice that your on-premises server peaks at around 25,000 read IOPS. You need to ensure that your Cloud SQL instance is sized appropriately to maximize read performance. What should you do?
C) Create a SQL Server 2019 Standard on High Memory machine type with 16 vCPUs, 104 GB of RAM, and 4 TB of SSD.
A) Create a SQL Server 2019 Standard on Standard machine type with 4 vCPUs, 15 GB of RAM, and 800 GB of solid-state drive (SSD).
B) Create a SQL Server 2019 Standard on High Memory machine type with at least 16 vCPUs, 104 GB of RAM, and 200 GB of SSD.
D) Create a SQL Server 2019 Enterprise on High Memory machine type with 16 vCPUs, 104 GB of RAM, and 500 GB of SSD.

Google Professional Cloud Database Engineer Exam - Topic 10 Question 61 Discussion

Actual exam question for Google's Professional Cloud Database Engineer exam
Question #: 61
Topic #: 10
[All Professional Cloud Database Engineer Questions]

You need to migrate existing databases from Microsoft SQL Server 2016 Standard Edition on a single Windows Server 2019 Datacenter Edition to a single Cloud SQL for SQL Server instance. During the discovery phase of your project, you notice that your on-premises server peaks at around 25,000 read IOPS. You need to ensure that your Cloud SQL instance is sized appropriately to maximize read performance. What should you do?

Show Suggested Answer Hide Answer
Suggested Answer: C

Given that Google SSD performance is related to the size of the disk in an order of 30 IOPS for each GB, ti would require at least 833 GB to handle 25000 IOPS, the only answer that exceeds this value is C. https://cloud.google.com/compute/docs/disks/performance


by Lashawn at Aug 12, 2025, 07:50 AM

Limited Time Offer

25%

Off

Get Premium Professional Cloud Database Engineer Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Ria
7 months ago
A is definitely too low for those IOPS.
upvoted 0 times
...
Jules
7 months ago
I disagree, B has more RAM which could help with performance.
upvoted 0 times
...
Brinda
7 months ago
Option C seems like the best choice for high read performance.
upvoted 0 times
...
Deandrea
7 months ago
Wow, I didn't expect SSD sizes to vary so much!
upvoted 0 times
...
Anglea
7 months ago
I think D is overkill for this scenario.
upvoted 0 times
...
Paulina
8 months ago
I vaguely recall that SSD size can impact performance, but I’m not certain if 500 GB in option D would be enough for our needs.
upvoted 0 times
...
Luis
8 months ago
I'm a bit confused about the difference between Standard and High Memory machine types. Does the High Memory option really make that much of a difference for read performance?
upvoted 0 times
...
Mignon
8 months ago
I think we practiced a similar question where we had to choose between different machine types based on memory and storage. I feel like option C might be the best choice here.
upvoted 0 times
...
Annamae
8 months ago
I remember we discussed IOPS and how they relate to instance sizing, but I'm not sure which option would actually meet the 25,000 read IOPS requirement.
upvoted 0 times
...
Gerardo
9 months ago
I feel pretty confident about this one. The High Memory machine type with the higher CPU, RAM, and SSD capacity seems like the best choice to maximize the read performance for the given requirements.
upvoted 0 times
...
Scot
9 months ago
I'm a bit confused by the different options. I'm not sure if I fully understand the differences between the machine types and how they would impact the read performance.
upvoted 0 times
...
Geoffrey
9 months ago
Alright, I've got this. The High Memory machine type with 16 vCPUs, 104 GB of RAM, and 4 TB of SSD should be more than enough to handle the read IOPS requirement.
upvoted 0 times
...
Phil
9 months ago
Okay, let's see. The key seems to be ensuring the Cloud SQL instance can handle the 25,000 read IOPS. I think I'll need to do some research on the different machine types and their capabilities.
upvoted 0 times
...
Casie
9 months ago
Hmm, this looks like a tricky one. I'll need to carefully consider the requirements and the options provided.
upvoted 0 times
...

Save Cancel