MENU
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?
Suggested Answer: C
Get Premium Professional Cloud Database Engineer Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
34 comments · newest first
JI
Jin
11 months ago
Wait, can we really just increase storage like that? Seems too easy!
TU
Tu
11 months ago
Compression (option B) could be useful, but it’s not a permanent solution.
CL
Clorinda
11 months ago
Normalizing to 3NF (option A) might not solve the space issue directly.
AN
Annabelle
11 months ago
I think D could help too, archiving old data is smart.
CH
Chauncey
12 months ago
Definitely go with option C, increasing storage is the quickest fix.
CL
Claudia
12 months ago
Creating another schema sounds like a workaround, but I feel like it might complicate things instead of solving the immediate storage problem.
CE
Celia
1 year 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.
CA
Cathrine
1 year 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?
ST
Stephaine
1 year ago
I remember discussing how increasing storage capacity is often the most straightforward solution when running low on disk space.
KE
Kendra
1 year 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.
BE
Bea
1 year 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.
RO
Rosalyn
1 year 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.
IR
Irene
1 year 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.
LO
Lorita
1 year 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.
LA
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!
JU
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.
RE
Reuben
1 year ago
We need to address the root cause.
DA
Daren
1 year ago
Creating another schema won't solve the problem.
EL
Elfriede
1 year ago
C) Manually or automatically increase the storage capacity.
MA
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.
OR
Oren
1 year ago
Let's consider both options and decide which one is the best approach.
GA
Galen
1 year ago
I think we should just go with the automatic storage increase to be safe.
OS
Osvaldo
1 year ago
I agree, compressing the data could help buy us some time.
VA
Van
2 years 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.
JO
Jodi
1 year ago
C) Manually or automatically increase the storage capacity.
CA
Callie
1 year ago
A) Normalize the database to the third normal form.
RO
Rory
2 years ago
I would go with compressing the data using a different compression algorithm to save space.
ER
Erick
2 years ago
I agree with Lashon, increasing storage capacity seems like the most practical solution.
LA
Lashon
2 years ago
I think we should manually or automatically increase the storage capacity.
MA
Margot
2 years 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.
AL
Alyce
1 year ago
Agreed, it's better to be proactive and address the alert before it becomes a problem.
NA
Nancey
1 year ago
C) Manually or automatically increase the storage capacity.
KA
Katina
1 year ago
That's right, we need to make sure we have enough space to avoid any issues.
LO
Lonna
1 year ago
C) Manually or automatically increase the storage capacity.