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

Question 1

A company is migrating an on-premises Oracle database to Amazon RDS for Oracle. The database is 1.5 TB and the network link can sustain 200 Mbps. The migration must be completed within a 6-hour maintenance window with zero data loss and minimal downtime. Which migration approach should a database specialist use?

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

Accepted Answer

Use AWS Database Migration Service (AWS DMS) with ongoing replication and a change data capture (CDC) task, then cut over during the maintenance window.. AWS DMS with ongoing replication and CDC is the standard approach for minimal-downtime migrations to RDS. It performs a full load while capturing ongoing changes, so the target stays current. During the maintenance window, the application is cut over after the replication lag is near zero, ensuring no data loss and meeting the tight window.

Answer

Use AWS Snowball Edge to ship a full database backup to AWS, restore it to RDS for Oracle, and then apply transaction logs manually.

Answer

Configure an Oracle Active Data Guard standby on Amazon RDS for Oracle and perform a switchover during the maintenance window.

Answer

Use native Oracle Data Pump export to an Amazon S3 bucket, then import into RDS for Oracle during the maintenance window.

Question 2

A company is planning to migrate a large on-premises MongoDB database to Amazon DocumentDB (with MongoDB compatibility). The migration must be performed with minimal downtime and must ensure data consistency. The company will use AWS Database Migration Service (AWS DMS). Which TWO actions should be taken to meet these requirements? (Choose two.)

Accepted Answer

Enable change data capture (CDC) on the source MongoDB replica set.. To achieve minimal downtime and data consistency when migrating MongoDB to DocumentDB with DMS, you must enable CDC on the source replica set and configure the target endpoint for DocumentDB. CDC captures ongoing changes, allowing the source to remain operational during the migration. The target endpoint must be correctly set to the DocumentDB engine so DMS can write to it. Pre-creating collections is also important but is not one of the two actions directly enabling minimal downtime and consistency.

Answer

Pre-create collections and indexes in Amazon DocumentDB before starting the migration.

Answer

Use a MongoDB standalone instance as the source to simplify CDC configuration.

Answer

Configure the source endpoint to use MongoDB's 'mongos' router for sharded clusters.

Question 3

A company is migrating its on-premises Oracle database to Amazon RDS for Oracle. The database has a recovery point objective (RPO) of 5 minutes and a recovery time objective (RTO) of 10 minutes. The company wants to use AWS DMS for ongoing replication. Which configuration should be used to achieve these objectives?

Accepted Answer

Use AWS DMS with change data capture (CDC) enabled and configure the target as RDS for Oracle.. To meet an RPO of 5 minutes and RTO of 10 minutes, continuous replication of changes is essential. AWS DMS with change data capture (CDC) captures ongoing changes from the source and applies them to the target, ensuring minimal data loss and quick cutover. Full load only would miss changes during migration, and adding Data Guard or multi-AZ does not address the core replication need.

Answer

Use AWS Database Migration Service (AWS DMS) with ongoing replication and configure the target as Amazon RDS for Oracle with multi-AZ deployment.

Answer

Use Oracle Data Guard to replicate to an Amazon EC2 instance running Oracle, then use AWS DMS to replicate to RDS for Oracle.

Answer

Use AWS DMS with full load only and configure the target as RDS for Oracle.

Question 4

A company is migrating an on-premises Oracle database to Amazon RDS for Oracle. The database is 1.5 TB and the network link can sustain 200 Mbps. The migration must be completed within a 6-hour maintenance window with zero data loss and minimal downtime. Which migration approach should a database specialist use?

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

Accepted Answer

Pre-create the database schema and objects on the target RDS for Oracle instance, and ensure that the DMS task is configured to not drop them.. Pre-creating the schema and objects on the target and configuring DMS to not drop them is crucial because DMS does not replicate all schema objects by default. This ensures that the target is fully prepared and avoids errors during cutover. The other options either do not affect synchronization or are incorrect configurations.

Answer

Enable multi-AZ on the RDS for Oracle instance before starting the migration.

Answer

Configure the DMS task to use a change data capture (CDC) start position that is after the full load.

Answer

Use Oracle GoldenGate to replicate changes instead of AWS DMS.

Question 5

A company is planning to migrate an on-premises Microsoft SQL Server database to Amazon RDS for SQL Server. The database is 2 TB and has a high transaction rate. The company wants to minimize downtime during the cutover. Which two steps should be included in the migration plan? (Choose two.)

Accepted Answer

Use AWS Database Migration Service (AWS DMS) with change data capture (CDC) to replicate ongoing changes.. To minimize downtime when migrating a large, high-transaction SQL Server database to RDS, you should use AWS DMS with CDC to replicate ongoing changes, and ensure a reliable network connection (Direct Connect or VPN) for continuous data transfer. These two steps allow you to keep the target in sync and cut over with minimal interruption.

Answer

Use AWS Schema Conversion Tool (AWS SCT) to convert the database schema and stored procedures.

Answer

Configure Amazon RDS for SQL Server in Multi-AZ mode for high availability during the migration.

Answer

Take a full backup of the on-premises database and restore it to Amazon RDS for SQL Server using native backup and restore.

Question 6

A media company is migrating a 12 TB on-premises Oracle Database to Amazon RDS for Oracle. The network link between the data center and AWS is a 500 Mbps AWS Site-to-Site VPN, and the cutover window is only four hours. The database team needs to move the bulk data quickly while keeping the change window short. Which combination of steps should the team take to meet these requirements?

Accepted Answer

Use AWS Snowball Edge to transfer a full database export to Amazon S3, import it into RDS for Oracle, then use AWS DMS with change data capture to apply ongoing changes before cutover.. Moving 12 TB over a 500 Mbps VPN is not feasible within a four-hour window, so the bulk data should be shipped with AWS Snowball Edge and imported into RDS for Oracle. AWS DMS with change data capture then applies ongoing changes, so the final cutover is short and the migration meets the aggressive window.

Answer

Use AWS DataSync to copy Oracle data files to Amazon EFS and point RDS for Oracle at the EFS file system for the initial load.

Answer

Use AWS Database Migration Service with full load and change data capture over the Site-to-Site VPN for the entire migration.

Answer

Use Oracle Data Pump over the Site-to-Site VPN to export directly to the RDS for Oracle instance during the cutover window.

Question 7

A company runs an on-premises Oracle database that is critical for its order processing system. The database is 4 TB and the company cannot afford any data loss if a failure occurs during migration. The migration must be completed with minimal downtime, and the cutover should take less than 5 minutes. The company has set up an AWS Direct Connect connection with ample bandwidth. Which AWS service and configuration should be used to meet these requirements?

Accepted Answer

AWS Database Migration Service (AWS DMS) with change data capture (CDC) enabled and a full load plus ongoing replication task. AWS DMS with change data capture (CDC) enables a full load followed by continuous replication of ongoing changes, allowing a cutover with minimal downtime and no data loss. The other options either do not capture changes, are unsupported for the target, or involve lengthy physical shipping. DMS with CDC is the standard AWS approach for minimal-downtime migrations with zero data loss.

Answer

Native Oracle Data Guard to replicate to an Amazon RDS for Oracle instance, then perform a switchover

Answer

AWS DMS with a full load only task and a scheduled cutover after the load completes

Answer

AWS Snowball Edge to transfer the 4 TB database backup to Amazon S3, then restore to Amazon RDS for Oracle

Question 8

A financial services company is migrating an on-premises Microsoft SQL Server 2019 database to Amazon RDS for SQL Server. The database is 2 TB and must be migrated with minimal downtime during a weekend maintenance window. The team wants to use AWS DMS with ongoing replication and needs to minimize the impact on the source server. Which source endpoint configuration should they use?

Accepted Answer

Configure the source endpoint to use MS-Replication (transactional replication) for change data capture. For SQL Server sources, AWS DMS supports MS-CDC and MS-Replication for change data capture. MS-Replication uses transactional replication, which reads the transaction log and has lower overhead on the source than MS-CDC because it does not maintain change tables for every tracked column. This makes it the preferred choice when minimizing source impact is critical for a large database migration.

Answer

Use the AWS DMS SQL Server endpoint with the 'Read changes using native CDC' option

Answer

Use the AWS DMS SQL Server endpoint with the 'Read changes using BCP' option

Answer

Enable MS-CDC on the source database and use the AWS DMS SQL Server endpoint with the 'Read changes using MS-CDC' option

Question 9

A team is deploying an Amazon RDS for MySQL database in a private subnet. The database must be accessible only from an application running on Amazon EC2 instances in the same VPC. The security team requires that access be controlled at the network layer and that no credentials be embedded in the application code. Which configuration should the team use?

Accepted Answer

Place the RDS instance in a private subnet and use an IAM database authentication token generated by the EC2 instance profile to connect.. IAM database authentication uses an authentication token generated from the EC2 instance profile, eliminating stored credentials while restricting access to the private subnet and security group. This satisfies both the network-layer control and the no-embedded-credentials requirement. Secrets Manager still relies on a static password, and public subnets or VPC endpoints do not provide the required private, role-based access.

Answer

Place the RDS instance in a private subnet and store the master password in AWS Secrets Manager, then have the application retrieve it at startup.

Answer

Place the RDS instance in a private subnet and configure a VPC endpoint for Amazon RDS so the EC2 instances connect through the endpoint.

Answer

Place the RDS instance in a public subnet and restrict access using a security group that allows the EC2 instances' public IP addresses.

Question 10

A company is migrating an on-premises MySQL database to Amazon Aurora MySQL. The database is 2 TB and the company wants to use AWS Database Migration Service (AWS DMS) for the migration. The company needs to ensure that the migration does not impact the performance of the source database and that the cutover is as fast as possible. Which combination of actions should the company take?

Accepted Answer

Use a read replica of the source MySQL database as the DMS source endpoint and enable CDC on the replica.. To avoid impacting the source and enable fast cutover, use a read replica as the DMS source and enable CDC. This offloads the read load from the primary and allows ongoing replication. The read replica must have binary logging enabled and be configured with the correct parameters. This approach is a best practice for large migrations where source performance is critical. Other options either impact the source or do not provide continuous replication.

Answer

Use AWS Schema Conversion Tool (AWS SCT) to convert the schema and then use native MySQL replication to Aurora.

Answer

Use the primary MySQL database as the DMS source endpoint and enable binary logging with row-based replication.

Answer

Use DMS with a full load only and schedule the cutover during a maintenance window.

Question 11

A company is migrating a large Amazon DynamoDB table to a new AWS account. The table has millions of items and is heavily used. The migration must be completed with minimal impact on the source table's performance. Which approach should be used?

Accepted Answer

Use AWS Database Migration Service (AWS DMS) with a full load and ongoing replication.. AWS DMS supports DynamoDB as both source and target. It can perform a full load and then capture ongoing changes using DynamoDB Streams, with minimal impact on the source table. DMS allows you to control the read throughput to avoid affecting production workloads, making it the best choice for migrating a large, heavily used table.

Answer

Enable DynamoDB Streams on the source table and use AWS Lambda to replicate items to the new table.

Answer

Create a backup of the table using AWS Backup and restore it to the new account.

Answer

Use AWS Data Pipeline to export the table to Amazon S3 and then import into the new table.

Question 12

A company is migrating an on-premises Oracle database to Amazon RDS for Oracle. The database is 1.5 TB and the network link can sustain 200 Mbps. The migration must be completed within a 6-hour maintenance window with zero data loss and minimal downtime. Which migration approach should a database specialist use?

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

Accepted Answer

Configure the AWS DMS task to use Oracle LogMiner and increase the number of redo log files retained on the source.. When using AWS DMS with Oracle, the replication instance reads redo logs via LogMiner. High CPU on the replication instance and increased redo generation on the source often indicate that the replication instance is struggling to keep up with log volume. Retaining more redo logs on the source ensures that logs are not prematurely archived or deleted, allowing the replication instance to read them without contention. This reduces CPU load and improves replication performance.

Answer

Enable supplemental logging at the database level and reduce the number of tables in the replication task.

Answer

Increase the size of the replication instance and enable multi-threaded replication.

Answer

Change the AWS DMS task to use change data capture (CDC) with a higher number of change tables.

Question 13

A company is planning to migrate an on-premises MongoDB cluster to Amazon DocumentDB (with MongoDB compatibility). The migration must be performed with minimal downtime and must ensure that all indexes are recreated. Which TWO actions should be taken to meet these requirements? (Choose two.)

Accepted Answer

Use AWS Database Migration Service (AWS DMS) with a change data capture (CDC) task to replicate ongoing changes.. To migrate with minimal downtime, use AWS DMS with CDC to replicate ongoing changes. After the full load, create indexes on DocumentDB to ensure they are present and built efficiently. This combination meets both requirements.

Answer

Create the indexes on the DocumentDB cluster before starting the migration.

Answer

Use the mongodump and mongorestore utilities to perform a one-time migration.

Answer

Use AWS Schema Conversion Tool (AWS SCT) to convert the indexes and then apply them.

Question 14

A company is deploying a new Amazon DynamoDB table to support an application that requires strong read consistency and the ability to query data by multiple attributes. The table will store millions of items and must handle sudden spikes in traffic without manual intervention. Which solution should they implement?

Accepted Answer

Create a DynamoDB table with a partition key and sort key, and use on-demand capacity mode with global secondary indexes (GSIs) for additional query patterns.. The combination of a composite primary key, on-demand capacity mode, and global secondary indexes provides the necessary query flexibility and automatic scaling for sudden traffic spikes. Strong read consistency is available for reads on the base table and GSIs if needed. This design meets all the stated requirements without manual intervention.

Answer

Create a DynamoDB table with a partition key only, and use provisioned capacity mode with auto scaling.

Answer

Create a DynamoDB table with a partition key only, and use on-demand capacity mode with local secondary indexes (LSIs).

Answer

Create a DynamoDB table with a partition key and sort key, and use provisioned capacity mode with reserved capacity.

Question 15

A company is migrating an on-premises Microsoft SQL Server database to Amazon RDS for SQL Server. The database is 2 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). The company requires that the migration captures all data changes, including schema changes, and that the target database remains consistent. Which TWO additional steps should be taken to meet these requirements? (Choose two.)

Accepted Answer

Enable MS-CDC on the source SQL Server database for all tables to be migrated. To capture ongoing changes with SQL Server, MS-CDC must be enabled on the source. For large databases, seeding the target with a native backup and then starting CDC from a specific LSN reduces downtime and load on the source. These two steps ensure that all data changes are captured and the target remains consistent. Schema changes are not captured by DMS and must be handled separately.

Answer

Use AWS Schema Conversion Tool (AWS SCT) to convert the schema and apply it to the target before starting the DMS task

Answer

Configure the DMS task to use ongoing replication and enable DDL capture by setting the appropriate task settings

Answer

Set up a replication instance with sufficient storage and enable multi-AZ for high availability