Google Exam Professional Cloud Database Engineer Topic 2 Question 46 Discussion

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

Question #: 46
Topic #: 2

[All Professional Cloud Database Engineer Questions]

Your organization is running a critical production database on a virtual machine (VM) on Compute Engine. The VM has an ext4-formatted persistent disk for data files. The database will soon run out of storage space. You need to implement a solution that avoids downtime. What should you do?

AIn the Google Cloud Console, increase the size of the persistent disk, and use the resize2fs command to extend the disk.

BIn the Google Cloud Console, increase the size of the persistent disk, and use the fdisk command to verify that the new space is ready to use

CIn the Google Cloud Console, create a snapshot of the persistent disk, restore the snapshot to a new larger disk, unmount the old disk, mount the new disk, and restart the database service.

DIn the Google Cloud Console, create a new persistent disk attached to the VM, and configure the database service to move the files to the new disk.

Show Suggested Answer

Suggested Answer: A

https://cloud.google.com/sql/docs/mysql/backup-recovery/backing-up#locationbackups You can use a custom location for on-demand and automatic backups. For a complete list of valid location values, see the Instance locations.

by Wilson at Sep 18, 2024, 12:00 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

Sheron

13 days ago

Maybe the database is running out of space because it's storing all the memes the IT team has been sharing. Gotta love those cloud-based comedy clubs!

upvoted 0 times

...

Ruthann

15 days ago

Option B? Really? Verifying the new space with fdisk? That's so 90s. This is the cloud, folks, let's live in the present!

upvoted 0 times

...

Malinda

17 days ago

Option A is the way to go! Resizing the disk and extending the file system is a simple one-step solution. No need to complicate things.

upvoted 0 times

Tawanna

5 days ago

User 2: I agree, it's the simplest solution.

upvoted 0 times

...

Edison

8 days ago

User 1: Option A is definitely the best choice.

upvoted 0 times

...

Gracie

23 days ago

I'd go with option D. Creating a new disk and moving the files over seems like the safest and most straightforward approach.

upvoted 0 times

...

Fernanda

1 months ago

Option C looks like the best choice to me. Avoiding downtime is the key requirement, and that's exactly what the snapshot and restore process does.

upvoted 0 times

Brande

8 days ago

Option C looks like the best choice to me.

upvoted 0 times

...

Mi

1 months ago

I'm not sure about option A. I think option C might be a safer choice as it involves creating a snapshot and restoring it to a new larger disk to avoid any potential issues.

upvoted 0 times

...

Johnna

2 months ago

I agree with Jacki. Option A seems like the most efficient solution to avoid any downtime for our critical production database.

upvoted 0 times

...

Jacki

2 months ago

I think option A is the best choice because it allows us to increase the size of the persistent disk and extend the disk without any downtime.

upvoted 0 times

...