QuestionQ50

VerifiedPlanning and implementing a cloud solution

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?

Explanation

Cloud SQL is the right fit for structured customer data that requires complex relational queries; Cloud Storage in the Archive class is the lowest-cost tier for large volumes of historical logs that are rarely accessed; and Bigtable is purpose-built for high-velocity, low-latency writes of time-series/sensor data at scale. Firestore is a document database not optimized for complex relational queries, and BigQuery is an analytics warehouse rather than a high-throughput write target.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!