An enterprise operations team is configuring Google Cloud storage and database resources for a web application. The application requires a database engine capable of handling complex relational schemas with ACID transactions and multi-table SQL joins. Additionally, product assets stored in Google Cloud Storage must have access permissions managed strictly at the bucket level via IAM policies, disabling individual object ACLs. Which TWO operational choices align with these technical requirements?
- Provision Cloud SQL as the database solution to support relational schemas, ACID compliance, and SQL join capabilities.Answer
- Enable Uniform Bucket-Level Access on the Cloud Storage bucket and grant permissions exclusively using IAM roles.Answer
- CProvision Cloud Bigtable as the primary database solution for executing multi-table SQL join operations and enforcing relational constraints.
- DConfigure per-object Access Control Lists (ACLs) on individual media files uploaded to a Cloud Storage bucket that has Uniform Bucket-Level Access enabled.
Answer
The correct operational choices are provisioning Cloud SQL to handle relational transactions and SQL joins, and enabling Uniform Bucket-Level Access on Cloud Storage to manage permissions via IAM policies.
Provisioning Cloud SQL correctly satisfies the requirement for a relational engine capable of complex SQL joins and ACID compliance. Enabling Uniform Bucket-Level Access on the Cloud Storage bucket ensures permissions are managed uniformly through IAM policies while turning off legacy object-level ACLs.
Step-by-Step Solution
Key Concept
Selecting appropriate GCP storage and database engines based on query pattern and access control requirements.