Google Cloud Associate Cloud Engineer — Question 274

Your company stores data from multiple sources that have different data storage requirements. These data include:
1. Customer data that is structured and read with complex queries
2. Historical log data that is large in volume and accessed infrequently
3. Real-time sensor data with high-velocity writes, which needs to be available for analysis but can tolerate some data loss

You need to design the most cost-effective storage solution that fulfills all data storage requirements. What should you do?

Answer options

• A. Use Firestore for customer data, Cloud Storage (Nearline) for historical logs, and Bigtable for sensor data.
• B. Use Cloud SQL for customer data. Cloud Storage (Coldline) for historical logs, and BigQuery for sensor data.
• C. Use Cloud SQL for customer data. Cloud Storage (Archive) for historical logs, and Bigtable for sensor data.
• D. Use Spanner for all data.

Correct answer: C

Explanation

The correct answer is C because Cloud SQL efficiently handles structured customer data, Cloud Storage (Archive) is cost-effective for infrequently accessed historical logs, and Bigtable is suitable for the high-write, low-latency requirements of sensor data. Options A and B do not align well with cost-effectiveness or the specific needs of the data types, and D is not optimal as Spanner is more expensive and unnecessary for all data types.