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

Question 161

HelioBank is deploying Cloud SQL for MySQL in europe-west1 to support payment processing for example.com. The compliance team requires that data at rest be encrypted with a key that they own and manage in a specific European location, and they must control the key lifecycle including rotation and disablement. They also need all client connections to be encrypted from end to end.
What should they configure?

A.Create the Cloud SQL for MySQL instance with Google managed encryption keys and secure access using VPC Service Controls

B.Create the Cloud SQL for MySQL instance using customer managed encryption keys and place it behind Cloud VPN for all client connectivity

C.Create the Cloud SQL for MySQL instance using customer managed encryption keys from Cloud KMS in the required region and require SSL or TLS for client connections

D.Create the Cloud SQL for MySQL instance with Google managed encryption keys and require SSL or TLS

Question 162

You are deploying a new Cloud SQL instance on Google Cloud using the Cloud SQL Auth proxy. You have identified snippets of application code that need to access the new Cloud SQL instance. The snippets reside and execute on an application server running on a Compute Engine machine. You want to follow Google-recommended practices to set up Identity and Access Management (IAM) as quickly and securely as possible. What should you do?

A.For each application code, set up a common shared user account.

B.For each application code, set up a dedicated user account.

C.For the application server, set up a service account.

D.For the application server, set up a common shared user account.

Question 163

You are running a mission-critical application on a Cloud SQL for PostgreSQL database with a multi-zonal setup. The primary and read replica instances are in the same region but in different zones. You need to ensure that you split the application load between both instances. What should you do?

A.Use Cloud Load Balancing for load balancing between the Cloud SQL primary and read replica instances.

B.Use PgBouncer to set up database connection pooling between the Cloud SQL primary and read replica instances.

C.Use the Cloud SQL Auth proxy for database connection pooling between the Cloud SQL primary and read replica instances.

D.Use HTTP(S) Load Balancing for database connection pooling between the Cloud SQL primary and read replica instances.

Question 164

Your company is migrating the existing infrastructure for a highly transactional application to Google Cloud. You have several databases in a MySQL database instance and need to decide how to transfer the data to Cloud SQL. You need to minimize the downtime for the migration of your 500 GB instance. What should you do?

A.Create a Cloud SQL for MySQL instance for your databases, and configure Datastream to stream your database changes to Cloud SQL.
Select the Backfill historical data check box on your stream configuration to initiate Datastream to backfill any data that is out of sync between the source and destination.
Delete your stream when all changes are moved to Cloud SQL for MySQL, and update your application to use the new instance.

B.Create migration job using Database Migration Service.
Set the migration job type to Continuous, and allow the databases to complete the full dump phase and start sending data in change data capture (CDC) mode.
Wait for the replication delay to minimize, initiate a promotion of the new Cloud SQL instance, and wait for the migration job to complete.
Update your application connections to the new instance.

C.Create migration job using Database Migration Service.
Set the migration job type to One-time, and perform this migration during a maintenance window.
Stop all write workloads to the source database and initiate the dump. Wait for the dump to be loaded into the Cloud SQL destination database and the destination database to be promoted to the primary database.
Update your application connections to the new instance.

D.Use the mysqldump utility to manually initiate a backup of MySQL during the application maintenance window.
Move the files to Cloud Storage, and import each database into your Cloud SQL instance.
Continue to dump each database until all the databases are migrated.
Update your application connections to the new instance.

Question 165

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 zonal Cloud SQL without high availability (HA).

B.Use Cloud SQL with cross-region replicas.

C.Use Cloud Spanner in a regional configuration.

D.Use high availability (HA) Cloud SQL with multiple zones.

Premium Bundle

Newest Professional-Cloud-Database-Engineer Exam PDF Dumps shared by BraindumpsPass.com for Helping Passing Professional-Cloud-Database-Engineer Exam! BraindumpsPass.com now offer the updated Professional-Cloud-Database-Engineer exam dumps, the BraindumpsPass.com Professional-Cloud-Database-Engineer exam questions have been updated and answers have been corrected get the latest BraindumpsPass.com Professional-Cloud-Database-Engineer pdf dumps with Exam Engine here:

Access Professional-Cloud-Database-Engineer Premium Version

(220 Q&As Dumps, 40%OFF Special Discount: Exam-Tests)

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

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