Practice Test GeeksAWS Practice Test
← All AWS Flashcard Decks

Certified Solutions Architect Database Services and Migration Flashcards

7 cards from real AWS practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.

Read the first 7 Certified Solutions Architect Database Services and Migration flashcards as text

  1. A company's DynamoDB table is experiencing throttling due to uneven distribution of read/write traffic across partitions. What is the most likely cause?

    Answer: A 'hot partition' caused by a non-uniform partition key

    Hot partitions occur when a partition key causes disproportionate traffic to a single partition, exceeding its allocated throughput limits.

  2. Which Amazon Redshift feature allows queries to run against data stored in Amazon S3 without loading it into Redshift tables?

    Answer: Redshift Spectrum

    Redshift Spectrum extends queries to data stored in S3 using the Redshift compute nodes, without requiring data to be ingested first.

  3. A team needs to store JSON documents with flexible schemas and run MongoDB-compatible queries on AWS. Which service is most appropriate?

    Answer: Amazon DocumentDB (with MongoDB compatibility)

    Amazon DocumentDB is a fully managed document database that supports MongoDB workloads and APIs with flexible JSON document storage.

  4. Which AWS DMS migration type should be selected to first load existing data and then continuously replicate ongoing changes?

    Answer: Full load and CDC

    Full load and CDC (Change Data Capture) first migrates all existing data, then switches to continuous replication of incremental changes.

  5. A company wants to decommission its on-premises MySQL database and move to Amazon Aurora MySQL. Which approach minimizes downtime?

    Answer: Use AWS DMS with Full Load and CDC to sync changes until cutover

    Using DMS with Full Load and CDC allows continuous replication so the cutover can happen with minimal downtime after the initial load completes.

  6. An application requires a fully managed time-series database to store IoT sensor readings and run time-based queries efficiently. Which AWS service is most suitable?

    Answer: Amazon Timestream

    Amazon Timestream is a purpose-built serverless time-series database that automatically scales and includes built-in time-series analytics functions.

  7. Which feature of Amazon ElastiCache for Redis allows data to persist to disk and survive node restarts?

    Answer: Redis Append Only File (AOF) or Redis Backup (RDB) snapshots

    ElastiCache for Redis supports AOF logging and RDB snapshots to persist in-memory data to disk, enabling recovery after restarts.