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.
Practice questions
Which AWS database service is built for graph data such as social networks and fraud-detection relationships?
- Amazon Keyspaces
- Amazon Neptune
- Amazon DocumentDB
- 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.
Which service-to-data-model pairings are correct?
- Amazon Neptune: time series from IoT sensors
- Amazon Keyspaces: wide-column, Apache Cassandra compatible
- Amazon Redshift: data warehouse for large-scale analytics
- Amazon MemoryDB: ephemeral cache with no persistence
- 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.
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.
