Google Associate Cloud EngineerPlanning and configuring a cloud solutionHard
A financial services company needs to store highly sensitive customer data. The data must be encrypted at rest and in transit, and also meet strict compliance requirements for data residency within a specific geographic region. The data is accessed frequently by applications and occasionally by analytics jobs. Which Google Cloud storage option should they choose?
- ACloud Firestore
- BCloud Storage Archive
- CCloud Storage Nearline
- DCloud SQL
Show answer & explanationAnswer & explanation
Correct answer: D. Cloud SQL
Cloud SQL provides managed relational databases with built-in encryption at rest and in transit. It supports regional deployments for data residency and is suitable for frequently accessed structured data, which aligns with the needs of sensitive customer data and compliance.
Why the other options are wrong
- A. Cloud Firestore is a NoSQL document database, which might not be ideal for highly structured financial data requiring strict schema and relational integrity, and while encrypted, Cloud SQL offers a more traditional RDBMS for such use cases.
- B. Cloud Storage Archive is for very infrequently accessed, long-term archival data, not for frequently accessed operational data.
- C. Cloud Storage Nearline is for infrequently accessed data and doesn't inherently provide the relational structure or compliance features required for sensitive customer data.
Cloud SQL
A fully managed relational database service on Google Cloud that supports MySQL, PostgreSQL, and SQL Server. It handles patching, backups, replication, and provides high availability.
- Managed relational database (MySQL, PostgreSQL, SQL Server)
- Automatic backups and replication
- High availability options
- Encryption at rest and in transit
- Supports regional deployments for data residency
Memory trick: Storage choices: Match your data's 'personality' to its perfect 'home'!