Google Cloud Professional Cloud Database Engineer — Question 73

You are migrating a telehealth care company's on-premises data center to Google Cloud. The migration plan specifies:
PostgreSQL databases must be migrated to a multi-region backup configuration with cross-region replicas to allow restore and failover in multiple scenarios.
MySQL databases handle personally identifiable information (PII) and require data residency compliance at the regional level.
You want to set up the environment with minimal administrative effort. What should you do?

Answer options

• A. Set up Cloud Logging and Cloud Monitoring with Cloud Functions to send an alert every time a new database instance is created, and manually validate the region.
• B. Set up different organizations for each database type, and apply policy constraints at the organization level.
• C. Set up Pub/Sub to ingest data from Cloud Logging, send an alert every time a new database instance is created, and manually validate the region.
• D. Set up different projects for PostgreSQL and MySQL databases, and apply organizational policy constraints at a project level.

Correct answer: D

Explanation

The correct choice is D because it allows for clear separation of environments for PostgreSQL and MySQL databases, making it easier to manage compliance and policy constraints relevant to each type. Options A and C involve manual validation which increases administrative effort, and B complicates management by using multiple organizations rather than utilizing projects for better organization and compliance.