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 Exam Professional Cloud Database Engineer Topic 3 Question 34 Discussion

Actual exam question for Google's Professional Cloud Database Engineer exam
Question #: 34
Topic #: 3
[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

by Sherman at Jun 03, 2024, 08:08 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel
Torie
1 months ago
True, the other options are like trying to use a tricycle to haul a freight train. Go big or go home, that's my motto for this exam!
upvoted 0 times
...
Berry
2 months ago
Hah, I bet the exam folks are trying to trick us with those other options. Who needs 4 vCPUs and 15 GB of RAM when you're dealing with 25,000 IOPS?
upvoted 0 times
Devora
3 days ago
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.
upvoted 0 times
...
Magda
13 days ago
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).
upvoted 0 times
...
...
Kyoko
2 months ago
I agree, C is the way to go. You need to future-proof the instance with plenty of resources to handle those peak read demands.
upvoted 0 times
...
Ora
2 months ago
The correct answer is C. The high read IOPS requirement calls for a high-performance Cloud SQL instance with ample CPU, memory, and solid-state storage capacity.
upvoted 0 times
Dewitt
9 days ago
Actually, the correct answer is option C for maximizing read performance.
upvoted 0 times
...
Anissa
13 days ago
No, I believe option B would be a better choice.
upvoted 0 times
...
Delmy
17 days ago
You're right, option C) would provide the high-performance Cloud SQL instance we need for the read IOPS requirement.
upvoted 0 times
...
Paz
23 days ago
I think we should go with option A.
upvoted 0 times
...
Tamar
26 days ago
I disagree, I believe option C) Create a SQL Server 2019 Standard on High Memory machine type with 16 vCPUs, 104 GB of RAM, and 4 TB of SSD would be better for maximizing read performance.
upvoted 0 times
...
Jaime
28 days ago
I think we should go with option A) Create a SQL Server 2019 Standard on Standard machine type with 4 vCPUs, 15 GB of RAM, and 800 GB of SSD.
upvoted 0 times
...
...
Mozell
3 months ago
That's a valid point, but option C also has a lot of RAM and SSD storage which could help with read performance.
upvoted 0 times
...
Johana
3 months ago
I disagree, I believe option B is better because it has more vCPUs and RAM which can handle the high read IOPS.
upvoted 0 times
...
Mozell
3 months ago
I think option A is the best choice because it has a good balance of resources for read performance.
upvoted 0 times
...

Save Cancel