Bitzu

SAA-C03 ยท High-performing databases and caching

Purpose-built databases: match the data model to the service

Matching data models to services: Redshift (columnar warehouse), Timestream (time series), Neptune (graph), DocumentDB (documents), Keyspaces (Cassandra) and MemoryDB.

Key points

  • Relational: RDS, Aurora. Key-value (carts, sessions): DynamoDB.
  • JSON documents, MongoDB-compatible: DocumentDB. Wide-column, Cassandra: Keyspaces.
  • Graph (social, fraud, recommendations): Neptune. Time series (IoT, metrics): Timestream.
  • Analytics (OLAP), data warehouse: Redshift. Ephemeral cache: ElastiCache.
  • Durable in-memory primary DB, Valkey/Redis OSS, microseconds, Multi-AZ: MemoryDB.
  • One app can combine several.

Source: https://docs.aws.amazon.com/decision-guides/latest/databases-on-aws-how-to-choose/databases-on-aws-how-to-choose.html

Practice questions

Single choice

Which AWS database service is built for graph data such as social networks and fraud-detection relationships?

  1. Amazon Keyspaces
  2. Amazon Neptune
  3. Amazon DocumentDB
  4. Amazon Timestream
Show answer

Answer: B. Amazon Neptune

Amazon Neptune is the graph database, optimized for traversing large numbers of relationships. Timestream handles time series, Keyspaces is Cassandra-compatible wide-column, and DocumentDB stores JSON documents.

Select all that apply

Which service-to-data-model pairings are correct?

  1. Amazon Neptune: time series from IoT sensors
  2. Amazon Keyspaces: wide-column, Apache Cassandra compatible
  3. Amazon Redshift: data warehouse for large-scale analytics
  4. Amazon MemoryDB: ephemeral cache with no persistence
  5. Amazon DocumentDB: JSON documents, MongoDB compatible
Show answer

Answer: B. Amazon Keyspaces: wide-column, Apache Cassandra compatible, C. Amazon Redshift: data warehouse for large-scale analytics, E. Amazon DocumentDB: JSON documents, MongoDB compatible

DocumentDB is the MongoDB-compatible document database, Keyspaces is the Cassandra-compatible wide-column service, and Redshift is the data warehouse for large-scale analytics. Neptune is a graph database, not time series, and MemoryDB is durable, unlike an ephemeral cache.

True or false

Amazon MemoryDB and Amazon ElastiCache are interchangeable, because both are only ephemeral caches that sit in front of another database.

Show answer

Answer: False

False. ElastiCache is positioned as an ephemeral cache for frequently accessed data, while MemoryDB is a durable in-memory database with Multi-AZ durability that can serve as the primary database, for example for microservices.

Practice 8 questions on this topic in Bitzu

Short lessons, instant explanations and spaced review of what you get wrong. Free on iOS and Android.

Download on the App StoreGet it on Google Play

More SAA-C03 topics in this module