Data World 5 · Warehouse and Scale · Stage 1

Pick the Store

Four access patterns, four stores: the warehouse, the key-value table, the vector index in Postgres, the durable cache.

Domain: Data engineering
World: Data World 5: Warehouse and Scale (Associate)
Game type: Solution board: Drop services into each row's slots, then run records through them.
Time: About 15 minutes on a first attempt (estimated)
Exam guides: SAA-C03Task 3.3: Determine high-performing database solutions; Task 4.3: Design cost-optimized database solutions
DEA-C01Skill 2.1.1: Implement the appropriate storage services for specific cost and performance requirements (for example, Amazon Redshift, Amazon EMR, AWS Lake Formation, Amazon RDS, Amazon DynamoDB, Amazon Kinesis Data Streams, Amazon Managed Streaming for Apache Kafka [Amazon MSK]); Skill 2.1.2: Configure the appropriate storage services for specific access patterns and requirements (for example, Amazon Redshift, Amazon EMR, Lake Formation, Amazon RDS, DynamoDB); Skill 2.1.3: Apply storage services to appropriate use cases (for example, using indexing algorithms like Hierarchical Navigable Small Worlds [HNSW] with Amazon Aurora PostgreSQL and using Amazon MemoryDB for fast key/value pair access); Skill 2.1.8: Describe vector index types (for example, HNSW, IVF)
MLA-C02Skill 1.1.2: Make storage decisions and configure storage services based on cost, performance, data structure, and data compliance; Skill 1.1.7: Configure scalable vector databases for AI applications (for example, OpenSearch Service, Amazon RDS with pgvector, Amazon S3) based on specifications