Soru

Zorluk: OrtaManaging Storage and Database Solutions

An operations team is evaluating database solutions for an application that requires ACID compliance, multi-table SQL joins, and relational transaction capabilities. A developer recommends replacing the current database instance with Cloud Bigtable to increase write throughput. Which statement accurately explains why Cloud Bigtable does not meet the operational requirements for this workload?

  1. Cloud Bigtable is a NoSQL key-value and wide-column store designed for heavy throughput workloads and does not support relational SQL queries or multi-row transactions.Cevap
  2. B
    Cloud Bigtable mandates configuring the Coldline storage class for all table data, resulting in high operational retrieval fees for frequent transactional reads.
  3. C
    Cloud Bigtable instances must be deployed on public IP addresses and cannot integrate with Private Service Access inside a Virtual Private Cloud (VPC).
  4. D
    Cloud Bigtable clusters must be created using gcloud compute instances create commands, which restricts automated database maintenance operations.

Cevap

Cloud Bigtable is a NoSQL wide-column database optimized for high-throughput time-series and analytical workloads, lacking support for relational SQL queries and multi-row ACID transactions.
The correct answer highlights that Cloud Bigtable is a NoSQL key-value and wide-column data store intended for large-scale analytical and time-series data. Because it does not support relational SQL queries, joins, or multi-row transactions, it cannot replace a relational database requiring full ACID SQL capabilities.

Adım Adım Çözüm

1
Analyze workload requirements
Identified requirements for relational data structure, complex SQL joins, and multi-table ACID transactions.
Relational capabilities dictate whether a SQL (Cloud SQL, Cloud Spanner) or NoSQL engine is required.
2
Evaluate Cloud Bigtable engine capabilities
Recognized Cloud Bigtable as a NoSQL wide-column database engine optimized for single-key access patterns and high write rates.
Cloud Bigtable does not provide relational SQL features or multi-row transactional guarantees.
3
Select the appropriate storage and database operational solution
Concluded that Cloud SQL or Cloud Spanner must be retained for relational SQL workloads instead of Cloud Bigtable.
Choosing a NoSQL engine for relational transactional needs leads to architectural failure.

Anahtar Kavram

Cloud SQL vs Cloud Bigtable Engine Selection
Tahmini Süre:1m 30s
Bu soruyu puanla