← All CLF-C02 Flashcard Decks

Database Services Flashcards

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

Read the first 7 Database Services flashcards as text
  1. Which pricing model for Amazon DynamoDB is best for applications with consistent, predictable traffic patterns?

    Answer: Provisioned Mode with Auto Scaling

    Provisioned Mode with Auto Scaling is cost-effective for predictable workloads as you specify expected read/write capacity and pay for reserved throughput.

  2. How does Amazon Aurora Global Database help multi-region applications?

    Answer: It replicates data to secondary regions with less than 1 second lag for fast local reads

    Aurora Global Database uses dedicated replication infrastructure to achieve sub-second replication lag to up to five secondary regions.

  3. A company stores user session data that should automatically expire after 24 hours. Which DynamoDB feature handles this without manual deletion?

    Answer: DynamoDB Time to Live (TTL)

    DynamoDB TTL automatically deletes items at a specified expiration timestamp, making it ideal for session data and temporary records.

  4. What is the key advantage of using Amazon Redshift Serverless compared to provisioned Redshift clusters?

    Answer: It charges only when queries are running, with no idle cluster costs

    Redshift Serverless automatically provisions capacity and charges only for the compute used during query execution, eliminating idle cluster costs.

  5. Which AWS service would you use to convert a Microsoft SQL Server database to an open-source engine like Aurora PostgreSQL?

    Answer: AWS Schema Conversion Tool (SCT)

    AWS Schema Conversion Tool automatically converts your existing database schema and most of the application code to a new target database engine.

  6. What does the 'shared responsibility model' mean for Amazon RDS security?

    Answer: AWS manages the infrastructure and database engine; the customer manages data, access, and encryption settings

    In RDS, AWS handles physical security, hardware, and patching while customers are responsible for data encryption, IAM access, and security group rules.

  7. Which statement accurately describes the difference between ElastiCache for Redis and ElastiCache for Memcached?

    Answer: Redis supports advanced data structures, persistence, and replication; Memcached is simpler and multi-threaded

    Redis offers richer data types, persistence, pub/sub messaging, and replication, while Memcached is a simpler, multi-threaded cache for straightforward use cases.