Online Access Free Google.Professional-Cloud-Database-Engineer.v2023-02-07.q47 Practice Test (Page 3)

Professional-Cloud-Database-Engineer Exam Question 6

An analytics team needs to read data out of Cloud SQL for SQL Server and update a table in Cloud Spanner. You need to create a service account and grant least privilege access using predefined roles. What roles should you assign to the service account?

A.roles/cloudsql.viewer and roles/spanner.databaseUser

B.roles/cloudsql.client and roles/spanner.databaseReader

C.roles/cloudsql.instanceUser and roles/spanner.databaseUser

D.roles/cloudsql.editor and roles/spanner.admin

Professional-Cloud-Database-Engineer Exam Question 7

You have a Cloud SQL instance (DB-1) with two cross-region read replicas (DB-2 and DB-3). During a business continuity test, the primary instance (DB-1) was taken offline and a replica (DB-2) was promoted. The test has concluded and you want to return to the pre-test configuration. What should you do?

A.Create DB-4 as a read replica in the same region as DB-1, and promote DB-4 to primary.

B.Bring DB-1 back online.

C.Delete DB-2 so that DB-1 automatically reverts to the primary instance.

D.Delete DB-1, and re-create DB-1 as a read replica in the same region as DB-1.

Professional-Cloud-Database-Engineer Exam Question 8

Your organization needs to migrate a critical, on-premises MySQL database to Cloud SQL for MySQL. The on-premises database is on a version of MySQL that is supported by Cloud SQL and uses the InnoDB storage engine. You need to migrate the database while preserving transactions and minimizing downtime. What should you do?

A.Use Database Migration Service to connect to your on-premises database, and choose continuous replication.
After the on-premises database is migrated, promote the Cloud SQL for MySQL instance, and connect applications to your Cloud SQL instance.

B.Build a Cloud Data Fusion pipeline for each table to migrate data from the on-premises MySQL database to Cloud SQL for MySQL.
Schedule downtime to run each Cloud Data Fusion pipeline.
Verify that the migration was successful.
Re-point the applications to the Cloud SQL for MySQL instance.

C.Pause the on-premises applications.
Use the mysqldump utility to dump the database content in compressed format.
Run gsutil -m to move the dump file to Cloud Storage.
Use the Cloud SQL for MySQL import option.
After the import operation is complete, re-point the applications to the Cloud SQL for MySQL instance.

D.Pause the on-premises applications.
Use the mysqldump utility to dump the database content in CSV format.
Run gsutil -m to move the dump file to Cloud Storage.
Use the Cloud SQL for MySQL import option.
After the import operation is complete, re-point the applications to the Cloud SQL for MySQL instance.

Professional-Cloud-Database-Engineer Exam Question 9

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 HTTP(S) Load Balancing for 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 PgBouncer to set up database connection pooling between the Cloud SQL primary and read replica instances.

Professional-Cloud-Database-Engineer Exam Question 10

Your digital-native business runs its database workloads on Cloud SQL. Your website must be globally accessible 24/7. You need to prepare your Cloud SQL instance for high availability (HA). You want to follow Google-recommended practices. What should you do? (Choose two.)

A.Schedule automated backups.

B.Create a PostgreSQL database on-premises as the HA option.

C.Set up manual backups.

D.Enable point-in-time recovery.

E.Configure single zone availability for automated backups.

Premium Bundle

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

Access Professional-Cloud-Database-Engineer Premium Version

(144 Q&As Dumps, 30%OFF Special Discount: Freepdfdumps)

Latest Upload: 218ISACA.CGEIT.v2025-09-19.q537; 152Fortinet.FCP_FWF_AD-7.4.v2025-09-18.q62; 153Scrum.SAFe-Practitioner.v2025-09-18.q63; 141Workday.Workday-Prism-Analytics.v2025-09-17.q17; 131Oracle.1Z0-1055-24.v2025-09-17.q28; 128Oracle.1Z1-182.v2025-09-17.q32; 234Nutanix.NCP-US-6.5.v2025-09-16.q73; 255Oracle.1z0-071.v2025-09-16.q232; 195Oracle.1Z1-922.v2025-09-16.q125; 314CyberArk.PAM-CDE-RECERT.v2025-09-15.q100