Google Professional-Cloud-Database-Engineer Exam Practice Test Instant Access

Question 1

You want to migrate an on-premises mission-critical PostgreSQL database to Cloud SQL. The database must be able to withstand a zonal failure with less than five minutes of downtime and still not lose any transactions. You want to follow Google-recommended practices for the migration. What should you do?

ATake nightly snapshots of the primary database instance, and restore them in a secondary zone.

BBuild a change data capture (CDC) pipeline to read transactions from the primary instance, and replicate them to a secondary instance.

CCreate a read replica in another region, and promote the read replica if a failure occurs.

DEnable high availability (HA) for the database to make it regional.

Answer : D

Question 2

Your DevOps team is using Terraform to deploy applications and Cloud SQL databases. After every new application change is rolled out, the environment is torn down and recreated, and the persistent database layer is lost. You need to prevent the database from being dropped. What should you do?

ASet Terraform deletion_protection to true.

BRerun terraform apply.

CCreate a read replica.

DUse point-in-time-recovery (PITR) to recover the database.

Answer : A

. From Google's documentation, 'For stateful resources, such as databases, ensure that deletion protection is enabled. The syntax is: lifecycle { prevent_destroy = true } https://cloud.google.com/docs/terraform/best-practices-for-terraform#stateful-resources

Question 3

You are the DBA of an online tutoring application that runs on a Cloud SQL for PostgreSQL database. You are testing the implementation of the cross-regional failover configuration. The database in region R1 fails over successfully to region R2, and the database becomes available for the application to process dat

a. During testing, certain scenarios of the application work as expected in region R2, but a few scenarios fail with database errors. The application-related database queries, when executed in isolation from Cloud SQL for PostgreSQL in region R2, work as expected. The application performs completely as expected when the database fails back to region R1. You need to identify the cause of the database errors in region R2. What should you do?

ADetermine whether the versions of Cloud SQL for PostgreSQL in regions R1 and R2 are different.

BDetermine whether the database patches of Cloud SQI for PostgreSQL in regions R1 and R2 are different.

CDetermine whether the failover of Cloud SQL for PostgreSQL from region R1 to region R2 is in progress or has completed successfully.

DDetermine whether Cloud SQL for PostgreSQL in region R2 is a near-real-time copy of region R1 but not an exact copy.

Answer : D

Verify that the replica has processed all the transactions it has received from the primary. This ensures that when promoted, the replica reflects all transactions that were received before the primary became unavailable. https://cloud.google.com/sql/docs/postgres/replication/cross-region-replicas#verify_failover_criteria

Question 4

Your organization works with sensitive data that requires you to manage your own encryption keys. You are working on a project that stores that data in a Cloud SQL database. You need to ensure that stored data is encrypted with your keys. What should you do?

AExport data periodically to a Cloud Storage bucket protected by Customer-Supplied Encryption Keys.

BUse Cloud SQL Auth proxy.

CConnect to Cloud SQL using a connection that has SSL encryption.

DUse customer-managed encryption keys with Cloud SQL.

Answer : D

Question 5

You are managing a set of Cloud SQL databases in Google Cloud. Regulations require that database backups reside in the region where the database is created. You want to minimize operational costs and administrative effort. What should you do?

AConfigure the automated backups to use a regional Cloud Storage bucket as a custom location.

BUse the default configuration for the automated backups location.

CDisable automated backups, and create an on-demand backup routine to a regional Cloud Storage bucket.

DDisable automated backups, and configure serverless exports to a regional Cloud Storage bucket.

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.

Question 6

You use Python scripts to generate weekly SQL reports to assess the state of your databases and determine whether you need to reorganize tables or run statistics. You want to automate this report but need to minimize operational costs and overhead. What should you do?

ACreate a VM in Compute Engine, and run a cron job.

BCreate a Cloud Composer instance, and create a directed acyclic graph (DAG).

CCreate a Cloud Function, and call the Cloud Function using Cloud Scheduler.

DCreate a Cloud Function, and call the Cloud Function from a Cloud Tasks queue.

Answer : C

Cloud Scheduler triggers actions at regular fixed intervals, whereas Cloud Tasks triggers actions based on how the individual task object is configured. Reference: https://cloud.google.com/tasks/docs/comp-tasks-sched

Question 7

You are managing a Cloud SQL for PostgreSQL instance in Google Cloud. You need to test the high availability of your Cloud SQL instance by performing a failover. You want to use the cloud command.

What should you do?

AUse gcloud sql instances failover <PrimaryInstanceName>.

BUse gcloud sql instances failover <ReplicaInstanceName>.

CUse gcloud sql instances promote-replica <PrimaryInstanceName>.

DUse gcloud sql instances promote-replica <ReplicaInstanceName>.

Answer : A

Google Professional Cloud Database Engineer Exam Practice Test