The latest Google Professional Cloud Database Engineer certification actual real practice exam question and answer (Q&A) dumps are available free, which are helpful for you to pass the Google Professional Cloud Database Engineer exam and earn Google Professional Cloud Database Engineer certification.
Table of Contents
Question 121
Exam Question
You are choosing a new database backend for an existing application. The current database is running PostgreSQL on an on-premises VM and is managed by a database administrator and operations team. The application data is relational and has light traffic. You want to minimize costs and the migration effort for this application. What should you do?
A. Migrate the existing database to Cloud SQL for PostgreSQL.
B. Migrate the existing database to Cloud Spanner.
C. Migrate the existing database to PostgreSQL running on Compute Engine.
D. Migrate the existing database to Firestore.
Correct Answer
A. Migrate the existing database to Cloud SQL for PostgreSQL.
Question 122
Exam Question
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, create a new persistent disk attached to the VM, and configure the database service to move the files to the new disk.
B. In the Google Cloud Console, increase the size of the persistent disk, and use the resize2fs command to extend the disk.
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, increase the size of the persistent disk, and use the fdisk command to verify that the new space is ready to use
Correct Answer
B. In the Google Cloud Console, increase the size of the persistent disk, and use the resize2fs command to extend the disk.
Question 123
Exam Question
You are designing a database strategy for a new web application in one region. You need to minimize write latency. What should you do?
A. Use Cloud Spanner in a regional configuration.
B. Use zonal Cloud SQL without high availability (HA).
C. Use Cloud SQL with cross-region replicas.
D. Use high availability (HA) Cloud SQL with multiple zones.
Correct Answer
B. Use zonal Cloud SQL without high availability (HA).
Question 124
Exam Question
You are designing a highly available (HA) Cloud SQL for PostgreSQL instance that will be used by 100 databases. Each database contains 80 tables that were migrated from your on-premises environment to Google Cloud. The applications that use these databases are located in multiple regions in the US, and you need to ensure that read and write operations have low latency. What should you do?
A. Deploy 2 Cloud SQL instances in the us-central1 region with HA enabled, and create read replicas in us-east1 and us-west1.
B. Deploy 2 Cloud SQL instances in the us-central1 region, and create read replicas in us-east1 and us-west1.
C. Deploy 4 Cloud SQL instances in the us-central1 region with HA enabled, and create read replicas in us-central1, us-east1, and us-west1.
D. Deploy 4 Cloud SQL instances in the us-central1 region, and create read replicas in us-central1, us-east1 and us-west1.
Correct Answer
B. Deploy 2 Cloud SQL instances in the us-central1 region, and create read replicas in us-east1 and us-west1.
Question 125
Exam Question
You are running a transactional application on Cloud SQL for PostgreSQL in Google Cloud. The database is running in a high availability configuration within one region. You have encountered issues with data and want to restore to the last known pristine version of the database. What should you do?
A. Create a clone database from a read replica database, and restore the clone in the same region.
B. Create a clone database from a read replica database, and restore the clone into a different zone.
C. Use the Cloud SQL point-in-time recovery (PITR) feature. Restore the copy from two hours ago to a new database instance.
D. Use the Cloud SQL database import feature. Import last week’s dump file from Cloud Storage.
Correct Answer
C. Use the Cloud SQL point-in-time recovery (PITR) feature. Restore the copy from two hours ago to a new database instance.