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 needs to migrate a 10 TB Oracle database to AWS with minimal downtime. Which service combination is most appropriate?

    Answer: AWS Database Migration Service (DMS) with AWS Schema Conversion Tool (SCT)

    AWS DMS handles ongoing replication while SCT converts schema objects from Oracle to the target AWS database engine.

  2. Which Amazon RDS feature automatically distributes read traffic across multiple database replicas?

    Answer: Aurora Reader Endpoint

    Aurora's reader endpoint automatically load-balances connections across all Aurora Replicas in the cluster.

  3. A solutions architect needs to store session state for a highly available web application. Which DynamoDB feature ensures that reads always reflect the latest write?

    Answer: Strongly consistent reads

    Strongly consistent reads in DynamoDB return the most up-to-date data, reflecting all writes that received a successful response.

  4. Which AWS service provides a fully managed, Redis-compatible in-memory data store that supports cluster mode?

    Answer: Amazon ElastiCache for Redis

    Amazon ElastiCache for Redis supports cluster mode enabled, allowing data to be sharded across multiple shards for scalability.

  5. A company is running a PostgreSQL database and wants to reduce costs by automatically pausing the database during inactivity. Which option supports this?

    Answer: Aurora Serverless v2

    Aurora Serverless v2 automatically scales capacity and can be configured to pause during periods of inactivity to reduce costs.

  6. When using AWS DMS to migrate data, what is the purpose of a replication instance?

    Answer: It provides the compute resources to run replication tasks

    A DMS replication instance is an EC2 instance that hosts the replication engine and performs the actual data movement between source and target.

  7. A company wants to implement database caching to reduce RDS load. DAX is not suitable because the application uses complex SQL joins. Which service should be used?

    Answer: Amazon ElastiCache for Redis

    Amazon ElastiCache for Redis can cache query results from relational databases, reducing load on RDS for complex SQL workloads.