Q: 10
You are running a data warehouse on BigQuery. A partner company is offering a recommendation
engine based on the data in your data warehouse. The partner company is also running their
application on Google Cloud. They manage the resources in their own project, but they need access
to the BigQuery dataset in your project. You want to provide the partner company with access to the
dataset What should you do?
Options
Discussion
Its D, since you want the partner to control their own service account. Granting their service account access is least privilege. A is tempting but not correct here.
Why not just have the partner own their service account and you grant it access? That way you don't have to manage their credentials, and permissions stay tidy. Feels like that's standard on GCP for cross-project access. Or am I missing a reason to do it differently?
D - If the partner controls their own service account, you can just grant it access to your BigQuery dataset directly. That keeps permissions clean and separation clear. Pretty sure that's the preferred way per GCP docs.
Ugh, Google cross-project IAM setups are always more confusing than they need to be. D tbh
Pretty sure D is correct since you want them to manage their own service account in their project, and then you grant only necessary BigQuery access from your side. This way you're not sharing credentials or creating accounts you can't control. Keeps IAM clean and follows least privilege, which is what GCP recommends too. Anyone disagree?
Google makes this way too convoluted imo. D tbh
D imo. Partner controls their own service account in their project, then you grant that account access to your BigQuery dataset. Less risk for you, cleaner separation of duties. Not totally sure if C is ever right but D matches how GCP usually handles cross-project sharing.
C/D? I get why D seems right since it's standard for partners to own the service account and you grant access, but C almost looks OK unless you miss that "in your project" bit. D avoids messy shared credentials, so I'm leaning that way. Open to other takes though.
Yeah, it's D here. Partner's service account in their project, you just grant dataset access.
Its D. Partner manages their service account, you just grant access to your dataset, keeps things simple.
Be respectful. No spam.