Data store management
Practise only this domain. 76 questions with explanations, 20 at a time.
Start data store managementSample questions
- A social platform needs to store and traverse a network of users, follows, and shared interests, with hundreds of billions of edges that must be queried by multi-hop relationship patterns. Which managed service fits best?Easy
- A university portal stores students, courses and enrollments in one DynamoDB table. The app must list all courses for a student and all students in a course, with each query served by key lookups rather than scans. Which data model should the team use?Hard
- A data team writes clickstream events as Parquet files in S3 and queries them interactively with Athena. They want a compression codec that keeps decompression fast so dashboards stay responsive. Which codec should they choose?Hard
- A team wants to run standard SQL against a folder of CSV files stored in S3 for ad hoc questions, without loading the files into a database or provisioning a cluster. Which service is the best fit?Easy
- A team's raw clickstream files in S3 gain new columns every few weeks, and Athena queries break because the catalog table still shows the old layout. Which setup keeps the catalog aligned without manual table edits?Medium
- A multiplayer game keeps short-lived player session records keyed by a session identifier. The records are small, traffic varies by time of day, and the service must answer reads and writes in single-digit milliseconds as the player base grows. Which data store fits best?Easy
- A team must lift an existing Apache Cassandra workload to AWS. The application uses CQL, expects tunable consistency, must keep single-digit millisecond reads, and needs the data replicated to a second Region for local access. Which service is the closest fit?Medium
- A platform team must change the storage engine and several parameters on a production RDS for MySQL instance. They want a managed staging copy that receives the changes, can be validated with production-like traffic, and supports a fast switchover with rollback. Which capability should they use?Medium
- A high-transaction OLTP database on RDS for MySQL needs a sustained 40,000 IOPS with consistent single-digit millisecond latency, independent of how much data is stored. Which volume type should be chosen?Easy