DBS-C01 Practice Test 1 — 10 Questions

Question 1

Match each AWS service to its primary purpose.

Question 2

A company needs to migrate a 100 GB MongoDB database to Amazon DocumentDB (with MongoDB compatibility). The migration must have minimal impact on the source database performance. Which approach should the company take?

Accepted Answer

Use AWS Database Migration Service (AWS DMS) with ongoing replication from the MongoDB source.. AWS DMS with ongoing replication is the correct approach because it supports continuous change data capture (CDC) from MongoDB, enabling a live migration with minimal performance impact on the source. DMS reads the MongoDB oplog to capture changes without locking the database, which is critical for a 100 GB production database. This allows the target DocumentDB to stay synchronized until cutover, reducing downtime and avoiding the need for a full export/import that would strain the source.

Answer

Use AWS DataSync to transfer the MongoDB data files.

Answer

Set up a MongoDB replica set on Amazon EC2 and promote it to primary, then migrate to DocumentDB.

Answer

Use mongodump to export the data and mongorestore to import into DocumentDB.

Question 3

A company is designing a database for an IoT application that ingests sensor data from thousands of devices. Each device sends a reading every minute. The data includes device_id, timestamp, temperature, humidity, and pressure. The application needs to store this data and support queries that retrieve all readings for a specific device within a time range. The company expects high write throughput and moderate read frequency. The data must be stored with high durability. Which TWO database designs are appropriate for this workload? (Choose TWO.)

Accepted Answer

Use Amazon DynamoDB with device_id as partition key and timestamp as sort key.. Option C is correct because DynamoDB's partition key (device_id) and sort key (timestamp) design allows efficient retrieval of all readings for a specific device within a time range using a Query operation with a KeyConditionExpression on the sort key. This schema supports high write throughput by distributing writes across partitions based on device_id, and DynamoDB's multi-AZ replication provides high durability.

Answer

Use Amazon DynamoDB with device_id as partition key and store all readings for a device as a list attribute in a single item, updating the list every minute.

Answer

Use Amazon S3 to store compressed JSON files per device per hour, and query using Amazon Athena.

Answer

Use Amazon RDS for MySQL with a single table and index on device_id and timestamp.

Question 4

Arrange the steps to troubleshoot a connection timeout issue from an EC2 instance to an Amazon RDS for SQL Server DB instance in the correct order.

Question 5

Arrange the steps to configure a read replica for an Amazon RDS for PostgreSQL DB instance in a different AWS Region in the correct order.

Question 6

Arrange the steps to perform a point-in-time recovery (PITR) for an Amazon RDS for MySQL DB instance in the correct order.

Question 7

Arrange the steps to migrate an on-premises Oracle database to Amazon RDS for Oracle using AWS DMS (Database Migration Service) in the correct order.

Question 8

Arrange the steps to restore an Amazon RDS for MySQL DB instance to a new instance from a manual snapshot in the correct order.

Question 9

Arrange the steps to enable automated backups for an Amazon RDS for PostgreSQL DB instance in the correct order.

Question 10

Arrange the steps to set up cross-Region read replicas for an Amazon Aurora MySQL DB cluster in the correct order.