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?

ACreate a SQL Server 2019 Standard on Standard machine type with 4 vCPUs, 15 GB of RAM, and 800 GB of solid-state drive (SSD).

BCreate a SQL Server 2019 Standard on High Memory machine type with at least 16 vCPUs, 104 GB of RAM, and 200 GB of SSD.

CCreate a SQL Server 2019 Standard on High Memory machine type with 16 vCPUs, 104 GB of RAM, and 4 TB of SSD.

DCreate a SQL Server 2019 Enterprise on High Memory machine type with 16 vCPUs, 104 GB of RAM, and 500 GB of SSD.

Show Suggested 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

1 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

Magda

1 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

1 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

1 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

Anissa

1 days ago

No, I believe option B would be a better choice.

upvoted 0 times

...

Delmy

5 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

11 days ago

I think we should go with option A.

upvoted 0 times

...

Tamar

14 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

16 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

...