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 da

Question

Options

• AUse Spanner for all data.
• BUse Cloud SQL for customer data, Cloud Storage (Coldline) for historical logs, and BigQuery for
• CUse Cloud SQL for customer data, Cloud Storage (Archive) for historical logs, and Bigtable for
• DUse Firestore for customer data, Cloud Storage (Nearline) for historical logs, and Bigtable for

• A
  9% (3)
• B
  18% (6)
• C
  67% (22)
• D
  6% (2)

Explanation

Customer Data: Structured and queried with complexity Cloud SQL is well suited for structured, relational data and supports complex SQL queries. It is a managed relational database service that provides a familiar SQL interface, which is ideal for customer data with complex querying needs. Historical Log Data: Large in volume and accessed infrequently Cloud Storage offers various storage classes optimized for cost based on access frequency. For data that is rarely accessed, the Archive storage class is the most cost-effective option. Although Archive has longer retrieval times compared to other classes, it is appropriate when the data is kept solely for audit or compliance purposes and isn’t expected to be read often. Real-Time Sensor Data: High-velocity writes and available for analysis (with some tolerance for data loss) Bigtable is designed to handle high ingestion rates and large volumes of time-series or sensor data. It provides low-latency reads and writes, making it an excellent choice for real-time analytics of sensor data. Its design also aligns well with scenarios where occasional data loss is

No community discussion yet for this question.