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

Actual exam question for Google's Professional Cloud Database Engineer exam

Question #: 52
Topic #: 10

[All Professional Cloud Database Engineer Questions]

Your company uses the Cloud SQL out-of-disk recommender to analyze the storage utilization trends of production databases over the last 30 days. Your database operations team uses these recommendations to proactively monitor storage utilization and implement corrective actions. You receive a recommendation that the instance is likely to run out of disk space. What should you do to address this storage alert?

ANormalize the database to the third normal form.

BCompress the data using a different compression algorithm.

CManually or automatically increase the storage capacity.

DCreate another schema to load older data.

Show Suggested Answer

Suggested Answer: C

https://cloud.google.com/sql/docs/sqlserver/configure-ssl-instance#server-certs

by Bernardo at Feb 09, 2025, 04:22 PM

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

Jin

6 months ago

Wait, can we really just increase storage like that? Seems too easy!

upvoted 0 times

...

Tu

6 months ago

Compression (option B) could be useful, but it’s not a permanent solution.

upvoted 0 times

...

Clorinda

6 months ago

Normalizing to 3NF (option A) might not solve the space issue directly.

upvoted 0 times

...

Annabelle

7 months ago

I think D could help too, archiving old data is smart.

upvoted 0 times

...

Chauncey

7 months ago

Definitely go with option C, increasing storage is the quickest fix.

upvoted 0 times

...

Claudia

7 months ago

Creating another schema sounds like a workaround, but I feel like it might complicate things instead of solving the immediate storage problem.

upvoted 0 times

...

Celia

7 months ago

I practiced a similar question where compressing data was an option, but I wonder if that would be enough to address a storage alert in this case.

upvoted 0 times

...

Cathrine

7 months ago

I'm not entirely sure, but I think normalizing the database might help with efficiency, but it doesn't directly solve the storage issue, right?

upvoted 0 times

...

Stephaine

8 months ago

I remember discussing how increasing storage capacity is often the most straightforward solution when running low on disk space.

upvoted 0 times

...

Kendra

8 months ago

I'm a bit confused by the options here. Compressing the data or creating a new schema don't seem like they would directly address the storage issue. I'll need to re-read the question and think it through.

upvoted 0 times

...

Bea

8 months ago

I've got this! Increasing the storage capacity is definitely the way to go. It's the most direct solution to the problem at hand.

upvoted 0 times

...

Rosalyn

8 months ago

Ah, this is a tricky one. I'm not sure if normalizing the database or creating a new schema are the right approaches here. I'll need to think this through carefully.

upvoted 0 times

...

Irene

8 months ago

Okay, let me see here. Increasing the storage capacity seems like the most obvious choice, but I want to make sure I'm not missing any other potential solutions.

upvoted 0 times

...

Lorita

8 months ago

Hmm, this seems like a straightforward storage management question. I'll need to carefully consider the options and think about the most efficient and cost-effective solution.

upvoted 0 times

...

Larue

1 year ago

Hey, I heard the database is running out of space. Maybe we should try deleting all the cat memes, that should free up a ton of space!

upvoted 0 times

...

Julio

1 year ago

Creating another schema to load older data? That's like putting a bandaid on a broken leg. We need to address the root cause, which is the lack of storage space. C is the way to go, no doubt about it.

upvoted 0 times

Reuben

11 months ago

We need to address the root cause.

upvoted 0 times

...

Daren

11 months ago

Creating another schema won't solve the problem.

upvoted 0 times

...

Elfriede

12 months ago

C) Manually or automatically increase the storage capacity.

upvoted 0 times

...

Mary

1 year ago

Hold on, compressing the data might be a good idea too. It could buy us some time before we need to increase the storage. But of course, the safe bet is to just go with the automatic storage increase.

upvoted 0 times

Oren

12 months ago

Let's consider both options and decide which one is the best approach.

upvoted 0 times

...

Galen

12 months ago

I think we should just go with the automatic storage increase to be safe.

upvoted 0 times

...

Osvaldo

1 year ago

I agree, compressing the data could help buy us some time.

upvoted 0 times

...

Van

1 year ago

Normalizing the database won't help with storage utilization. That's a completely different issue. We need to focus on the immediate problem at hand and increase the storage capacity.

upvoted 0 times

Jodi

1 year ago

C) Manually or automatically increase the storage capacity.

upvoted 0 times

...

Callie

1 year ago

A) Normalize the database to the third normal form.

upvoted 0 times

...

Rory

1 year ago

I would go with compressing the data using a different compression algorithm to save space.

upvoted 0 times

...

Erick

1 year ago

I agree with Lashon, increasing storage capacity seems like the most practical solution.

upvoted 0 times

...

Lashon

1 year ago

I think we should manually or automatically increase the storage capacity.

upvoted 0 times

...

Margot

1 year ago

Increasing the storage capacity is the way to go here. The recommendation clearly states the instance is likely to run out of disk space, so we need to act quickly to prevent any downtime.

upvoted 0 times