Google Cloud Certified - Professional Cloud Database Engineer Professional-Cloud-Database-Engineer Question # 26 Topic 3 Discussion

Google Cloud Certified - Professional Cloud Database Engineer Professional-Cloud-Database-Engineer Question # 26 Topic 3 Discussion

Professional-Cloud-Database-Engineer Exam Topic 3 Question 26 Discussion:
Question #: 26
Topic #: 3

You are evaluating Cloud SQL for PostgreSQL as a possible destination for your on-premises PostgreSQL instances. Geography is becoming increasingly relevant to customer privacy worldwide. Your solution must support data residency requirements and include a strategy to:

configure where data is stored

control where the encryption keys are stored

govern the access to data

What should you do?


A.

Replicate Cloud SQL databases across different zones.


B.

Create a Cloud SQL for PostgreSQL instance on Google Cloud for the data that does not need to adhere to data residency requirements. Keep the data that must adhere to data residency requirements on-premises. Make application changes to support both databases.


C.

Allow application access to data only if the users are in the same region as the Google Cloud region for the Cloud SQL for PostgreSQL database.


D.

Use features like customer-managed encryption keys (CMEK), VPC Service Controls, and Identity and Access Management (IAM) policies.


Get Premium Professional-Cloud-Database-Engineer Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.