Question 18 of 139
Single answerYou 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?
AReplicate Cloud SQL databases across different zones.
BCreate 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.
CAllow 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.
✓DUse features like customer-managed encryption keys (CMEK), VPC Service Controls, and Identity and Access
Management (IAM) policies.
✓
Correct Answer: D
Use features like customer-managed encryption keys (CMEK), VPC Service Controls, and Identity and Access Management (IAM) policies.
▥
Explanation
The correct answer is highlighted above. Review the wording carefully, then use the next question to continue building your understanding of Google certification topics.