Data storage Flashcards
What are the five main categories of databases shown in the infographic?
The five main categories are Relational, Relational & Non-Relational, Non-Relational (NoSQL), In Memory, and Bare Metal
Which database offers multi-dialect support including PostgreSQL and GoogleSQL?
Spanner offers multi-dialect support including PostgreSQL and GoogleSQL
What is the SLA percentage offered by Cloud SQL?
Cloud SQL offers a 99.99% SLA
What distinguishes Firestore from other databases in terms of architecture?
Firestore is unique in being a serverless, document database with built-in cross-client sync capabilities
What type of store is Bigtable primarily designed for?
Bigtable is designed as a key-value store for large-scale, low latency workloads
What is the primary purpose of Memorystore?
Memorystore serves as an in-memory cache and key-value store
What is unique about AlloyDB’s analytical capabilities?
AlloyDB uniquely offers HTAP (hybrid transaction/analytical processing) capabilities
Which database is specifically designed for Oracle workload migration?
Oracle Bare Metal is specifically designed to lift and shift Oracle workloads to Google Cloud
What is the key feature of Spanner regarding scaling?
Spanner offers unlimited scaling without compromising SQL capabilities
Which databases are classified as non-relational (NoSQL)?
Firestore and Bigtable are classified as non-relational (NoSQL) databases
Which database is best suited for IoT and time series data?
Bigtable is best suited for IoT/Clickstream/Time Series data
What database would you choose for electronic medical records?
Spanner is recommended for electronic medical records due to its high availability and scaling capabilities
Which database is recommended for gaming player profiles?
Spanner is ideal for gaming player profiles and gameplay data
For retail catalogs and point of sales, which database is suggested?
Firestore is suggested for retail catalogs and point of sales
Which database should be used for fast data ingestion?
Memorystore should be used for fast data ingestion with sub-millisecond latencies
What database is suitable for news feeds and social chat applications?
Firestore is suitable for news feeds and social chat applications
Which database handles operational analytics best?
AlloyDB handles operational analytics best with its HTAP capabilities
For financial services applications, which database is recommended?
AlloyDB is recommended for financial services applications
Which database is ideal for web and mobile apps?
Cloud SQL is ideal for web and mobile apps
What database solution works best for leaderboards?
Memorystore works best for leaderboards with its in-memory capabilities
What is the minimum latency requirement for Memorystore?
Memorystore offers sub-millisecond latency for reads and writes
Which database provides “4x faster transaction queries”?
AlloyDB provides 4x faster transaction queries
What are the scaling capabilities of Spanner?
Spanner offers unlimited scaling capabilities
How does Firestore handle offline scenarios?
Firestore handles offline scenarios with built-in offline caching
What type of APIs does Bigtable support?
Bigtable supports HBase APIs
What is the primary technical advantage of Cloud SQL for migrations?
Cloud SQL provides the fastest lift and shift migrations for OLTP workloads
How does AlloyDB handle HTAP workloads?
AlloyDB handles HTAP workloads through hybrid transaction/analytical processing
What type of infrastructure does Oracle Bare Metal provide?
Oracle Bare Metal provides pre-configured, tuned infrastructure
How does Firestore handle cross-client synchronization?
Firestore handles cross-client synchronization through built-in capabilities
What type of latency does Bigtable guarantee?
Bigtable guarantees consistent single-digit millisecond latencies
When should you choose a relational vs. non-relational database?
Choose relational databases for structured data with fixed schemas, and non-relational for flexible, scalable needs
What factors should be considered when choosing between Cloud SQL and AlloyDB?
Choose Cloud SQL for simple OLTP workloads and AlloyDB for high-performance PostgreSQL needs
How does the architecture of Firestore support real-time updates?
Firestore’s architecture supports real-time updates through its serverless document database design
Why would you choose Spanner over Cloud SQL for a global application?
Choose Spanner over Cloud SQL when you need unlimited scaling with SQL capabilities
When should you implement Memorystore in your architecture?
Implement Memorystore when you need sub-millisecond latency for caching and key-value storage
How does Bigtable’s architecture support high-scale workloads?
Bigtable’s architecture supports high-scale workloads through its key-value store design
What architectural benefits does AlloyDB provide for PostgreSQL workloads?
AlloyDB’s architecture provides enhanced PostgreSQL compatibility with improved performance
When should you consider Oracle Bare Metal in your architecture?
Consider Oracle Bare Metal when you need to migrate existing Oracle workloads without redesign
How does Firestore’s architecture support offline-first applications?
Firestore’s architecture supports offline-first applications through built-in caching
What architectural considerations are important for choosing between Spanner and Firestore?
Consider scale, consistency requirements, and global distribution needs when choosing between Spanner and Firestore
Which database provides the best performance for analytical queries?
AlloyDB provides the best performance for analytical queries with its HTAP capabilities
How does Bigtable handle scaling for large-scale workloads?
Bigtable handles scaling through its key-value store architecture designed for large-scale workloads
What performance benefits does AlloyDB offer over standard PostgreSQL?
AlloyDB offers 4x faster transaction queries compared to standard PostgreSQL
How does Spanner handle global scaling?
Spanner handles global scaling through unlimited scaling capabilities without compromising SQL functionality
What performance characteristics make Memorystore suitable for caching?
Memorystore achieves sub-millisecond latencies through in-memory processing
How does Cloud SQL handle read scaling?
Cloud SQL provides managed experience with common API and control plane across database engines
What performance benefits does Firestore offer for real-time applications?
Firestore offers real-time performance through its serverless architecture
How does Oracle Bare Metal ensure high performance?
Oracle Bare Metal ensures high performance through pre-configured, tuned infrastructure
What scaling capabilities does Bigtable offer for time-series data?
Bigtable offers consistent single-digit millisecond latencies at any scale
How does AlloyDB handle performance optimization for both transactional and analytical workloads?
AlloyDB optimizes performance through hybrid transaction/analytical processing capabilities
