DBS-C01 Deployment and Migration Practice Test 17 — 15 Questions

Question 1

A company is deploying a new Amazon Aurora PostgreSQL database cluster. They need to ensure that the cluster is encrypted at rest and that they can manage the encryption keys themselves. They also require that the encryption key can be rotated annually. Which of the following should they do?

Choose an answer to begin — your selection is scored in the full session.

Accepted Answer

Create an AWS KMS customer managed key (CMK) with automatic key rotation enabled, and specify it when creating the Aurora cluster.. To meet the requirements of self-managed keys and annual rotation, the company should create an AWS KMS customer managed key with automatic rotation enabled and use it when creating the Aurora cluster. This provides control over the key and satisfies the rotation requirement.

Answer

Enable encryption at rest using an AWS KMS customer managed key, but key rotation must be done manually by creating a new key and re-encrypting the cluster.

Answer

Use an AWS CloudHSM cluster to store the encryption keys and configure Aurora to use it.

Answer

Use the default AWS managed key for Aurora, as it automatically rotates every year.

Question 2

A company is deploying a new Amazon Aurora PostgreSQL database. They want to ensure that the database is highly available and can survive an Availability Zone failure. Which configuration should they use?

Accepted Answer

Enable Multi-AZ deployment for the Aurora cluster.. Amazon Aurora is designed for high availability by default. Each Aurora cluster includes a primary instance and a standby instance in different Availability Zones. The standby is automatically provisioned and maintained, and failover is automatic. This architecture allows the database to survive an Availability Zone failure with minimal downtime. While you can add Aurora Replicas for read scaling, the built-in Multi-AZ capability is what provides high availability.

Answer

Use Amazon RDS for PostgreSQL with Multi-AZ enabled instead of Aurora.

Answer

Create an Aurora Replica in a different Availability Zone.

Answer

Create a read replica in a different region.

Question 3

A company is deploying a new Amazon DynamoDB table to support a high-traffic web application. The table will store session data with a partition key of SessionId and a sort key of Timestamp. The application requires consistent low-latency reads and writes. Which deployment option should be used to achieve this?

Accepted Answer

Use DynamoDB with provisioned capacity mode and auto scaling enabled.. For a high-traffic application requiring consistent low-latency reads and writes, DynamoDB provisioned capacity mode with auto scaling is the best choice. It allows you to set a baseline throughput and automatically adjust to traffic changes, ensuring performance while optimizing cost. On-demand mode can introduce latency during scaling, DAX only accelerates reads, and global tables address multi-region needs rather than single-region latency.

Answer

Use DynamoDB global tables to replicate data across multiple regions.

Answer

Use DynamoDB with on-demand capacity mode.

Answer

Use DynamoDB Accelerator (DAX) in front of the table.

Question 4

A team is deploying a new Amazon DynamoDB table to support an order-processing workload with unpredictable but bursty traffic. They need the table to scale automatically without manual intervention, and they want to avoid throttling during sudden spikes. Which two actions should the team take? (Choose two.)

Accepted Answer

Configure the table with provisioned capacity mode and attach an Application Auto Scaling target that adjusts read and write capacity based on consumed capacity utilization.. Both on-demand mode and provisioned mode with Application Auto Scaling remove the need for manual capacity planning. On-demand follows traffic instantly, which suits genuinely unpredictable bursts, while provisioned mode with a target utilization below 100 percent keeps buffer capacity available so scaling can catch up during spikes. Either choice satisfies the goal of automatic scaling without operator action.

Answer

Create a global secondary index for every attribute the application queries and enable auto scaling on each index independently of the base table.

Answer

Enable DynamoDB Streams and use an AWS Lambda function to rewrite throttled requests back into the table with exponential backoff.

Answer

Set the table's provisioned read and write capacity to the peak observed traffic level and disable auto scaling to prevent capacity oscillation.

Question 5

A company is migrating an on-premises Oracle database to Amazon RDS for Oracle. The database is 5 TB and the company wants to minimize downtime during the migration. They plan to use AWS Database Migration Service (AWS DMS) with change data capture (CDC). Which two actions should be taken to ensure the migration is successful? (Choose two.)

Accepted Answer

Configure the AWS DMS replication instance with sufficient storage and network throughput to handle the change volume.. For Oracle CDC with AWS DMS, supplemental logging must be enabled on the source to capture sufficient information for updates and deletes. Additionally, the replication instance must be sized appropriately to handle the initial load and ongoing change volume; insufficient resources can lead to replication lag and migration failure. These two actions are critical for a successful minimal-downtime migration.

Answer

Grant the AWS DMS user the SELECT ANY TABLE privilege on the source database.

Answer

Set the target database to read-only mode during the migration.

Answer

Enable automatic backups on the target Amazon RDS for Oracle database.

Question 6

A company is migrating an on-premises Microsoft SQL Server 2016 database to Amazon RDS for SQL Server. The database uses Transparent Data Encryption (TDE) with a certificate protected by the database master key. The team wants to use native backup and restore to move the database to RDS. Which action must be taken to restore the encrypted backup to Amazon RDS for SQL Server?

Accepted Answer

Export the TDE certificate and private key, upload them to an Amazon S3 bucket, and import them into RDS for SQL Server using the rds_restore_tde_certificate stored procedure.. Amazon RDS for SQL Server supports restoring native backups that are encrypted with TDE, but only if the TDE certificate and private key are imported into the instance first. The supported workflow is to export the certificate and private key, upload them to Amazon S3, and run the rds_restore_tde_certificate stored procedure. This preserves encryption and avoids decrypting the source database or using a different migration method.

Answer

Use AWS DMS with a full-load task to copy the data, because DMS automatically decrypts TDE-protected SQL Server databases.

Answer

Disable TDE on the source database, take a native backup, and restore the unencrypted backup to RDS.

Answer

Export the TDE certificate and private key from the source, and upload them to Amazon RDS using the rdsadmin.rdsadmin_password_verify procedure.

Question 7

A company is migrating an on-premises PostgreSQL database to Amazon RDS for PostgreSQL. The database is 2 TB in size and has a high write workload. The company needs to minimize downtime during the migration. Which AWS service or feature should the company use to achieve this?

Accepted Answer

Use AWS Database Migration Service (AWS DMS) with ongoing replication.. AWS DMS with ongoing replication (change data capture, CDC) is the correct choice because it allows continuous synchronization of the source PostgreSQL database with the target RDS for PostgreSQL instance after an initial full load. This minimizes downtime by enabling the target to stay up-to-date with changes until the cutover, which is critical for a 2 TB database with a high write workload.

Answer

Use pg_dump and pg_restore to export and import the database.

Answer

Use the AWS Schema Conversion Tool (AWS SCT) to convert the schema and migrate data.

Answer

Use AWS DataSync to replicate the database files.

Question 8

A company wants to migrate its on-premises Oracle database to Amazon Aurora PostgreSQL. The company needs to automatically convert the Oracle schema to PostgreSQL-compatible format. Which AWS service should the company use?

Accepted Answer

AWS Schema Conversion Tool (AWS SCT). AWS Schema Conversion Tool (AWS SCT) is designed specifically to convert database schemas from one engine to another, including Oracle to Amazon Aurora PostgreSQL. It automatically translates Oracle DDL (tables, indexes, stored procedures, functions, etc.) into PostgreSQL-compatible format, handling data type mappings, PL/SQL to PL/pgSQL conversion, and other schema-level transformations. AWS DMS handles data migration, not schema conversion, making SCT the correct choice for this requirement.

Answer

AWS Database Migration Service (AWS DMS) with the Oracle native dump and load option

Answer

AWS Server Migration Service (AWS SMS)

Answer

AWS Database Migration Service (AWS DMS)

Question 9

A company is using AWS Database Migration Service (AWS DMS) to migrate a 5 TB MySQL database to Amazon RDS for MySQL. The migration is taking longer than expected. The company notices that the source database has a high volume of write operations. Which configuration change would MOST likely improve the migration performance?

Accepted Answer

Increase the number of parallel threads in the DMS task settings.. Increasing the number of parallel threads in the DMS task settings allows AWS DMS to process multiple table partitions or row changes concurrently, which directly addresses the bottleneck caused by a high volume of write operations on the source. By default, DMS uses a single thread per table, but when the source is under heavy write load, parallel threads can capture and apply changes more efficiently, reducing the overall migration time.

Answer

Enable Multi-AZ on the target RDS instance.

Answer

Use a smaller instance class for the replication instance to reduce cost.

Answer

Set the LOB mode to 'Full LOB mode'.

Question 10

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 11

A company is planning to migrate a 1 TB MySQL database from on-premises to Amazon RDS for MySQL. The migration must have minimal downtime and support ongoing replication. Which THREE steps should the company include in the migration plan? (Choose THREE.)

Accepted Answer

Set up an AWS Direct Connect or VPN connection between on-premises and AWS.. A stable, low-latency network connection (Direct Connect or VPN) is essential for AWS DMS to perform ongoing replication with minimal downtime. Without this, the replication can be interrupted by network issues, causing data loss or extended cutover windows.

Answer

Deploy an Amazon EC2 instance to act as a proxy for the DMS replication.

Answer

Install the AWS Schema Conversion Tool on the source server to convert the schema.

Question 12

A company is migrating a 500 GB on-premises PostgreSQL database to Amazon RDS for PostgreSQL. The migration must have minimal downtime and support ongoing replication after the initial load. Which AWS service should be used?

Accepted Answer

AWS Database Migration Service (DMS) with ongoing replication. AWS Database Migration Service (DMS) with ongoing replication (change data capture, CDC) is required because the scenario demands minimal downtime and continuous synchronization after the initial 500 GB load. DMS uses transaction logs (e.g., PostgreSQL WAL) to capture and apply ongoing changes, enabling a near-zero-duration cutover. Full load only (Option B) would cause downtime during the final sync and cannot support ongoing replication.

Answer

AWS Schema Conversion Tool (SCT)

Answer

AWS Database Migration Service (DMS) with full load only

Answer

AWS Glue

Question 13

A company wants to migrate an on-premises MySQL database to Amazon RDS for MySQL with minimal downtime. They plan to use AWS DMS. Which source database configuration is required to enable ongoing replication (CDC)?

Accepted Answer

Enable binary logging (binlog) on the source database. AWS DMS requires binary logging (binlog) enabled on the source MySQL database to capture ongoing changes for continuous replication (CDC). The binlog records all data modifications (INSERT, UPDATE, DELETE) in a sequential log, which DMS reads to apply those changes to the target RDS instance with minimal downtime. Without binlog enabled, DMS can only perform a full load migration and cannot support ongoing replication.

Answer

Set auto_increment_increment to 1

Answer

Enable the slow query log

Answer

Enable the query cache

Question 14

A company is migrating a 2 TB SQL Server database to Amazon RDS for SQL Server. They need to minimize downtime and are using AWS DMS with CDC. The migration is taking longer than expected during the full load phase. Which change would most likely improve the full load performance?

Accepted Answer

Increase the number of parallel load tasks in the DMS task settings. Increasing the number of parallel load tasks in the DMS task settings allows the full load to be split into multiple concurrent threads, each handling a subset of tables or partitions. This directly improves throughput by utilizing more of the available source and target resources, which is the most effective way to accelerate a slow full load phase when using AWS DMS with CDC.

Answer

Disable CDC to focus on full load only

Answer

Use AWS Schema Conversion Tool to optimize schema

Answer

Use a larger RDS instance class for the target

Question 15

A company is migrating a 1 TB Oracle database to Amazon Aurora PostgreSQL using AWS DMS. They need to ensure minimal downtime and data consistency. Which TWO actions should the company take?

Accepted Answer

Enable change data capture (CDC) on the source Oracle database. Enabling Change Data Capture (CDC) on the source Oracle database allows AWS DMS to capture ongoing changes after the full load, enabling a near-zero downtime migration by continuously replicating transactions to the target Aurora PostgreSQL. Option C is correct because enabling data validation on the DMS task ensures that the data migrated is consistent between the source and target, verifying that no data loss or corruption occurred during the migration process.

Answer

Increase the target Aurora storage to 2 TB to avoid storage issues

Answer

Disable foreign key constraints on the target during migration

Answer

Use AWS Schema Conversion Tool to convert the schema