A healthcare organization processes Electronic Health Records (EHR) stored in BigQuery and Cloud Storage inside a dedicated Google Cloud project named Project-Analytics. Authorized analysts access these services from an on-premises datacenter via a Dedicated Interconnect connection. To satisfy regulatory mandates, the security team must enforce two controls: 1) Authorized internal users with valid IAM permissions must be strictly prevented from copying datasets to unauthorized external Google Cloud storage locations or external projects. 2) An analytics service running in a separate VPC inside Project-App must securely query BigQuery in Project-Analytics using internal IP routing, without granting Project-App network visibility to all other resources in Project-Analytics. Which architectural design should you recommend?
- Configure a VPC Service Controls perimeter around Project-Analytics to restrict service API communication to authorized perimeter boundary rules. Create a Private Service Connect endpoint in Project-App to privately connect to BigQuery in Project-Analytics, and define VPC Service Controls ingress and egress rules to grant explicit cross-perimeter API access.Answer
- BGrant the BigQuery Admin and Storage Admin IAM roles to the analytics team service accounts, and establish VPC Network Peering between Project-App's VPC and Project-Analytics's VPC to route traffic privately over internal IP addresses.
- CEstablish VPC Network Peering between Project-App and a central Hub VPC network, which is already peered with Project-Analytics, to leverage multi-hop routing for BigQuery queries while assigning predefined IAM roles.
- DAssign the primitive Editor role at the project level to Project-App's service account, and attach Google Cloud Armor security policies directly to Cloud Storage buckets and BigQuery datasets to filter unauthorized access.