Google Cloud Professional Cloud Database Engineer PCDBE — Topic 1 Question 138

Question

You are planning to migrate a 10 TB relational database from an on-premises environment to Cloud SQL for PostgreSQL. The database contains sensitive customer information. You want to follow Google-recommended practices to keep data secure during the migration. What should you do? (Choose two.)

Accepted Answer

Correct answer: B, D. The correct answer is B, D. Option B: Establish a Private Service Connect connection between your on-premises environment and the Cloud SQL instance. Option D: Set up Identity and Access Management (IAM) roles to restrict access with Cloud SQL with an internal IP address. Cloud SQL is a managed relational database (MySQL/PostgreSQL/SQL Server) that handles patching, backups, and failover. Private Service Connect exposes and consumes services privately within VPCs without internet exposure. Cloud IAM grants fine-grained, least-privilege access to Google Cloud resources.

Google Cloud Professional Cloud Database Engineer PCDBE — Question 138