PROFESSIONAL-CLOUD-DATABASE-ENGINEER · Question #41
Your hotel booking company is expanding into Country A, where personally identifiable information (PII) must comply with regional data residency requirements and audits. You need to isolate customer…
The correct answer is B. Apply an instance data management pattern. When data residency regulations require that data for a specific region remain physically within that region and be auditable in isolation, the instance-level multi-tenancy pattern is the correct choice. A dedicated Cloud SQL instance for Country A can be deployed in that…
Question
Your hotel booking company is expanding into Country A, where personally identifiable information (PII) must comply with regional data residency requirements and audits. You need to isolate customer data in Country A from the rest of the customer data. You want to design a multi- tenancy strategy to efficiently manage costs and operations. What should you do?
Options
- AApply a schema data management pattern.
- BApply an instance data management pattern.
- CApply a table data management pattern.
- DApply a database data management pattern.
How the community answered
(38 responses)- A5% (2)
- B84% (32)
- C8% (3)
- D3% (1)
Explanation
When data residency regulations require that data for a specific region remain physically within that region and be auditable in isolation, the instance-level multi-tenancy pattern is the correct choice. A dedicated Cloud SQL instance for Country A can be deployed in that country's region, providing hard isolation at the infrastructure level. Schema-level (option A), table-level (option C), and database-level (option D) patterns all share underlying compute and storage resources, which does not satisfy strict data residency and auditability requirements.
Topics
Community Discussion
No community discussion yet for this question.