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 its Amazon RDS database to be encrypted at rest. When must encryption be enabled?

    Answer: Only when creating the DB instance; it cannot be added later

    RDS encryption at rest must be enabled at instance creation time; you cannot directly enable encryption on an existing unencrypted instance.

  2. Which DynamoDB capacity mode automatically adjusts throughput based on actual traffic patterns without requiring capacity planning?

    Answer: On-Demand capacity mode

    DynamoDB On-Demand mode instantly accommodates any traffic level without pre-provisioning capacity, paying per request.

  3. A solutions architect must ensure that Amazon RDS automated backups are retained for compliance for 90 days. What is the maximum automated backup retention period for RDS?

    Answer: 35 days

    Amazon RDS supports automated backup retention periods from 1 to 35 days; for longer retention, manual snapshots must be used.

  4. A company is migrating a large data warehouse from Teradata to Amazon Redshift. Which AWS tool helps assess and convert the proprietary SQL to Redshift-compatible SQL?

    Answer: AWS Schema Conversion Tool (SCT)

    AWS SCT analyzes source data warehouse schemas and automatically converts Teradata SQL, stored procedures, and ETL scripts to Redshift equivalents.

  5. Which Amazon Aurora scaling feature automatically adds read capacity in response to increasing query load without manual intervention?

    Answer: Aurora Auto Scaling for replicas

    Aurora Auto Scaling monitors CloudWatch metrics and automatically adds or removes Aurora Replicas based on CPU or connection thresholds.

  6. A company needs a managed Apache Cassandra-compatible database on AWS to handle wide-column data at scale. Which service should they choose?

    Answer: Amazon Keyspaces (for Apache Cassandra)

    Amazon Keyspaces is a serverless, fully managed Cassandra-compatible database service that supports CQL and Cassandra APIs natively.

  7. When using AWS DMS for homogeneous migration (e.g., MySQL to Amazon RDS for MySQL), what is the primary role of AWS SCT?

    Answer: SCT is generally not required since the source and target engines are the same

    In homogeneous migrations, the source and target use the same database engine, so schema conversion is unnecessary and SCT can be skipped.