Free Access Google.Professional-Cloud-Database-Engineer.v2026-06-22.q177 Practice Test (Page 3)

Question 6

You released a popular mobile game and are using a 50 TB Cloud Spanner instance to store game data in a PITR-enabled production environment. When you analyzed the game statistics, you realized that some players are exploiting a loophole to gather more points to get on the leaderboard. Another DBA accidentally ran an emergency bugfix script that corrupted some of the data in the production environment. You need to determine the extent of the data corruption and restore the production environment. What should you do? (Choose two.)

A.If the corruption is significant, use backup and restore, and specify a recovery timestamp.

B.If the corruption is significant, perform a stale read and specify a recovery timestamp. Write the results back.

C.If the corruption is significant, use import and export.

D.If the corruption is insignificant, use backup and restore, and specify a recovery timestamp.

E.If the corruption is insignificant, perform a stale read and specify a recovery timestamp. Write the results back.

Question 7

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?

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

B.In 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

C.In 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.

D.In 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.

Question 8

Your company is migrating their MySQL database to Cloud SQL and cannot afford any planned downtime during the month of December. The company is also concerned with cost, so you need the most cost-effective solution. What should you do?

A.Use Cloud SQL maintenance settings to prevent any maintenance during the month of December.

B.Create MySQL read replicas in different zones so that, if any downtime occurs, the read replicas will act as the primary instance during the month of December.

C.Create a MySQL regional instance so that, if any downtime occurs, the standby instance will act as the primary instance during the month of December.

D.Open a support ticket in Google Cloud to prevent any maintenance in that MySQL instance during the month of December.

Question 9

A.Open a support ticket in Google Cloud to prevent any maintenance in that MySQL instance during the month of December.

B.Use Cloud SQL maintenance settings to prevent any maintenance during the month of December.

C.Create MySQL read replicas in different zones so that, if any downtime occurs, the read replicas will act as the primary instance during the month of December.

D.Create a MySQL regional instance so that, if any downtime occurs, the standby instance will act as the primary instance during the month of December.

Question 10

Larkspur Systems is building a browser based workspace where teams coauthor very large documents in real time. Each document can reach 25 MB and the system must handle about
60,000 edits per minute from users spread across three regions and it must keep a complete version timeline for every file with strong consistency. Which managed database on Google Cloud best satisfies these requirements?

A.Cloud Bigtable

B.Cloud Spanner

C.Cloud SQL with read replicas

D.Firestore in Datastore mode

Other Version: 1373Google.Professional-Cloud-Database-Engineer.v2024-04-26.q86

Latest Upload: 129Databricks.Databricks-Generative-AI-Engineer-Associate.v2026-08-18.q40; 135SAP.C_CR125_2601.v2026-08-17.q28; 179Salesforce.Field-Service-Consultant.v2026-08-17.q134; 150Oracle.1Z0-1170.v2026-08-16.q64; 156Oracle.1Z1-1170.v2026-08-16.q64; 193Juniper.JN0-336.v2026-08-13.q60; 327EMC.NCP-AII.v2026-08-13.q200; 205CIRO.RSE.v2026-08-12.q41; 175CrowdStrike.CCSE-204.v2026-08-12.q50; 162ISQI.CT-GenAI.v2026-08-11.q14

Question 6

Question 7

Question 8

Question 9

Question 10

Download PDF File