Examius
🇮🇳 AWS Certified Solutions Architect – Associate · flashcards
AWS Certified Solutions Architect – Associate Databases Flashcards
51 question-and-answer cards covering Databases as it is examined in AWS Certified Solutions Architect – Associate. 24 of them are printed below, taken from across the deck — no signup, no paywall on the preview.
24 sample cards from the Databases deck
Sampled from the end of the deck, so these are different cards from the ones shown on the syllabus page.
How is one DynamoDB Write Capacity Unit (WCU) defined?
1 WCU = 1 write per second for an item up to 1 KB. Larger items round up to the next 1 KB.
What is DynamoDB Accelerator (DAX)?
A fully managed, in-memory cache for DynamoDB that delivers microsecond read latency for cached reads, requires minimal code changes, and is purpose-built only for DynamoDB.
DAX vs ElastiCache for caching DynamoDB: when to use each?
Use DAX for caching individual DynamoDB queries/objects with microsecond latency and no app changes. Use ElastiCache to store aggregation/computation results or share cached data across multiple data sources.
What are DynamoDB Streams?
An ordered, time-ordered flow of item-level modifications (create/update/delete) in a table, retained 24 hours, often consumed by Lambda for triggers, replication, or analytics.
What is DynamoDB Global Tables?
A multi-Region, multi-active (multi-writer) replication feature giving fast local read/write access across Regions, with last-writer-wins conflict resolution; requires DynamoDB Streams enabled.
What is DynamoDB TTL (Time To Live)?
A feature that automatically deletes expired items based on a timestamp attribute (epoch seconds), reducing storage cost and cleanup work; deletions are free and asynchronous.
What is Amazon ElastiCache?
A fully managed in-memory caching service supporting Redis (and Redis OSS/Valkey) and Memcached, used to reduce database load and provide microsecond/sub-millisecond latency.
ElastiCache Redis vs Memcached: key differences?
Redis supports replication, Multi-AZ failover, persistence, backups, pub/sub, sorted sets, and transactions. Memcached is multi-threaded, supports simple sharding, has no persistence, replication, or failover.
What is the cache-aside (lazy loading) caching strategy?
The app checks the cache first; on a miss it reads from the database and writes the result into the cache. Only requested data is cached, but cache misses incur extra latency and data can become stale.
What is the write-through caching strategy?
Data is written to the cache and the database at the same time on every write, keeping the cache fresh, but it adds write latency and caches data that may never be read.
How does ElastiCache Redis provide high availability?
Through Multi-AZ with automatic failover using a primary node and read replicas, plus optional cluster mode for sharding across multiple node groups.
What is Amazon Neptune?
A fully managed graph database service supporting property graph (Gremlin/openCypher) and RDF (SPARQL) models, ideal for highly connected data like social networks, fraud detection, and recommendation engines.
What is Amazon DocumentDB?
A fully managed document database that is MongoDB-compatible, designed for JSON document workloads with Aurora-like storage that scales automatically.
What is Amazon Keyspaces?
A managed, serverless, Apache Cassandra-compatible database service for wide-column workloads, using CQL, with single-digit-millisecond performance and automatic scaling.
What is Amazon QLDB?
Amazon Quantum Ledger Database: a fully managed ledger database with an immutable, append-only, cryptographically verifiable transaction log, ideal for systems of record/audit trails (single trusted authority).
What is Amazon Timestream?
A fully managed, serverless time-series database optimized for IoT and operational metrics, with built-in tiered storage (memory + magnetic) and time-series analytics functions.
What is Amazon MemoryDB for Redis?
A Redis-compatible, durable, in-memory database delivering ultra-fast performance with Multi-AZ durability, usable as a primary database (not just a cache).
What is AWS Database Migration Service (DMS)?
A managed service that migrates databases to AWS with minimal downtime; the source database remains available during migration. It supports homogeneous and heterogeneous migrations.
What is the difference between homogeneous and heterogeneous migrations in DMS?
Homogeneous = same engine (e.g., Oracle to Oracle). Heterogeneous = different engines (e.g., Oracle to Aurora PostgreSQL), which requires the AWS Schema Conversion Tool (SCT) to convert the schema/code first.
What is the AWS Schema Conversion Tool (SCT) and when is it needed?
A tool that converts a source database schema and code (procedures, views) to a target engine. It is needed for heterogeneous migrations; it is not needed for homogeneous (same-engine) migrations.
What are the DMS migration types (replication tasks)?
Full load (one-time copy of existing data), CDC (change data capture for ongoing replication of changes), and Full load + CDC (migrate existing data then continuously replicate changes for near-zero downtime).
How should you choose a database for a relational, ACID-transaction workload with complex joins?
Use a relational database: Amazon RDS or Amazon Aurora (Aurora for higher performance/availability and cloud-native scaling).
Which AWS databases fit key-value, document, graph, in-memory, time-series, ledger, and wide-column needs respectively?
Key-value/document: DynamoDB. Document (MongoDB): DocumentDB. Graph: Neptune. In-memory: ElastiCache/MemoryDB. Time-series: Timestream. Ledger: QLDB. Wide-column (Cassandra): Keyspaces.
How is encryption at rest and in transit handled for RDS/Aurora, and what manages the keys?
Encryption at rest uses AWS KMS keys (must be enabled at creation; can't encrypt an existing unencrypted DB directly—restore an encrypted snapshot). Encryption in transit uses SSL/TLS. IAM database authentication lets you connect using IAM tokens instead of passwords (Aurora/RDS MySQL & PostgreSQL).
What this deck covers
The Databases deck follows the AWS Certified Solutions Architect – Associate Databases syllabus — 3 chapters and 9 topics — so questions land on material that is genuinely examinable rather than trivia around it. That works out to roughly 17.0 cards per chapter.
Answers are written to be recallable, not just readable — averaging about 183 characters, which is long enough to carry the reasoning and short enough to say out loud.
A deck like this earns its keep on the second and third pass. Read the syllabus first so you know the shape of the subject, then use the cards to find the specific facts that have not stuck.
Databases flashcards FAQ
How many Databases flashcards are in this AWS Certified Solutions Architect – Associate deck?
51 cards. This page previews 24 of them, sampled evenly across the deck so you can judge the difficulty before installing anything.
Are these AWS Certified Solutions Architect – Associate flashcards free?
Yes. The preview here is free to read with no signup, and the full 51-card deck is free inside the Examius app.
What do the Databases cards cover?
They follow the AWS Certified Solutions Architect – Associate Databases syllabus — 3 chapters and 9 topics — so the questions track what is actually examinable.
How should I use these flashcards?
Read the syllabus first so you know the shape of the subject, then drill the deck. Examius schedules each card with spaced repetition, so cards you keep missing come back sooner and ones you know drift further apart.