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

Question 1

A company wants to migrate its on-premises Oracle database to Amazon Aurora PostgreSQL. The company needs to convert the database schema and code from Oracle to PostgreSQL. Which AWS service should they use for schema conversion?

Accepted Answer

AWS Schema Conversion Tool (SCT). Option A is correct because AWS SCT (Schema Conversion Tool) is specifically designed to convert database schemas and code from one engine to another, including Oracle to PostgreSQL. Option B is wrong because AWS DMS focuses on data migration, not schema conversion. Option C is wrong because AWS Database Migration Service is for data migration, not conversion. Option D is wrong because AWS Glue is for ETL, not schema conversion.

Answer

AWS DMS

Answer

AWS Glue

Answer

AWS Database Migration Service

Question 2

A company is migrating a 2 TB Oracle database from on-premises to Amazon RDS for Oracle. The network bandwidth is 100 Mbps. The migration must be completed within 3 days. Which approach is MOST efficient?

Accepted Answer

Use AWS DMS with parallel load and ongoing replication.. Option C is correct because AWS DMS with parallel load can significantly speed up the migration by loading multiple tables simultaneously. Option A is wrong because a single-threaded export/import may not complete within 3 days on 100 Mbps. Option B is wrong because Oracle GoldenGate requires additional licensing and setup. Option D is wrong because RMAN backup and restore requires transferring the full backup over the network.

Answer

Use Oracle RMAN to create a backup and restore to RDS.

Answer

Use Oracle Data Pump with a single export and import.

Answer

Use Oracle GoldenGate for real-time replication.

Question 3

A company is migrating a 500 GB PostgreSQL database from on-premises to Amazon Aurora PostgreSQL. The migration must have a recovery point objective (RPO) of less than 5 minutes and a recovery time objective (RTO) of less than 30 minutes. Which migration strategy should the company use?

Accepted Answer

Use AWS DMS with full load and ongoing replication.. Option B is correct because AWS DMS with ongoing replication can achieve an RPO of less than 5 minutes by continuously replicating changes, and the RTO can be met by cutting over quickly. Option A is wrong because a full backup and restore has an RPO of hours. Option C is wrong because pg_dump export/import has an RPO of the time of the dump. Option D is wrong because creating a read replica from on-premises is not possible.

Answer

Create a read replica of the on-premises database and promote it.

Answer

Take a full backup using pg_basebackup and restore to Aurora.

Answer

Use pg_dump to export the database and import into Aurora.

Question 4

A company is migrating an on-premises MySQL database to Amazon RDS for MySQL. The company wants to minimize application changes. Which endpoint type should the application use after migration?

Accepted Answer

RDS instance endpoint (DNS name). Option C is correct because the RDS instance endpoint (DNS name) is the standard connection endpoint for a single RDS DB instance, which is the target of a direct migration from on-premises MySQL to Amazon RDS for MySQL. This endpoint requires no application changes, as the application simply replaces the old on-premises hostname with the RDS instance DNS name, maintaining the same MySQL protocol and connection logic.

Answer

RDS reader endpoint

Answer

RDS cluster endpoint

Answer

RDS console endpoint

Question 5

Which TWO of the following are valid considerations when migrating an on-premises Oracle database to Amazon RDS for Oracle using AWS DMS? (Select TWO.)

Accepted Answer

DMS can continue to replicate changes after the full load is complete until the cutover.. AWS DMS supports ongoing replication (change data capture, CDC) after the full load completes, allowing you to keep the target database synchronized with the source until you perform the cutover. This minimizes downtime because you can replicate ongoing changes from the on-premises Oracle database to Amazon RDS for Oracle, then stop all applications and switch over with only a brief interruption.

Answer

DMS automatically converts Oracle stored procedures to RDS for Oracle compatible code.

Answer

DMS automatically converts partitioned tables to non-partitioned tables.

Answer

DMS can migrate directly to Amazon RDS Custom for Oracle without any configuration changes.

Question 6

A company is migrating a 5 TB Microsoft SQL Server database to Amazon Aurora MySQL. The migration must be completed with minimal downtime. Which THREE steps should the company take? (Select THREE.)

Accepted Answer

Use AWS DMS to perform a full load and ongoing replication from SQL Server to Aurora.. Options A, B, and D are correct. AWS SCT converts the schema and code from SQL Server to MySQL (A). AWS DMS performs the full data load and ongoing replication (B). After migration, the application connection string is updated to point to the Aurora writer endpoint (D). Option C is wrong because creating a read replica from Aurora to on-premises is not supported. Option E is wrong because the reader endpoint is for read traffic, not for the primary application connection.

Answer

Update the application connection string to point to the Aurora reader endpoint.

Answer

Create a read replica of the Aurora database in the same region.

Question 7

Which TWO of the following are valid methods to migrate an on-premises MySQL database to Amazon RDS for MySQL? (Select TWO.)

Accepted Answer

Use AWS DMS to migrate from on-premises MySQL to RDS.. AWS DMS (Database Migration Service) is a fully managed service designed to migrate databases to AWS with minimal downtime. It supports homogeneous migrations like MySQL to Amazon RDS for MySQL, handling schema conversion, data replication, and ongoing changes via change data capture (CDC). This makes option B a valid and recommended method for migrating an on-premises MySQL database to RDS.

Answer

Use pg_dump to export the data and import into RDS.

Answer

Use SQL Server Integration Services (SSIS) to migrate the data.

Answer

Use Oracle Data Pump to export the data and import into RDS.

Question 8

A company wants to migrate an on-premises Oracle database to Amazon RDS for Oracle with minimal downtime. Which AWS service should be used for the migration?

Accepted Answer

AWS Database Migration Service (DMS). AWS Database Migration Service (DMS) is designed for migrating databases to AWS with minimal downtime. AWS Schema Conversion Tool (SCT) is used for schema conversion but not for the actual data migration. Service Control Policies (SCP) and Systems Manager are not relevant for database migration.

Answer

AWS Systems Manager

Answer

AWS Schema Conversion Tool (SCT)

Answer

AWS Service Control Policies (SCP)

Question 9

A company is migrating a 2 TB MySQL database to Amazon Aurora MySQL. They need to minimize downtime and ensure data consistency. Which approach should be used?

Accepted Answer

Use AWS DMS with ongoing replication (CDC).. Using AWS DMS with change data capture (CDC) from an on-premises source allows continuous replication, minimizing downtime. A full dump and restore requires downtime. SCT is for schema conversion. Direct connect alone doesn't handle migration.

Answer

Use mysqldump to export and import into Aurora.

Answer

Establish AWS Direct Connect and use MySQL replication.

Answer

Use AWS SCT to convert schema and data.

Question 10

An e-commerce company is migrating its PostgreSQL database to Amazon RDS for PostgreSQL. The database has multiple large tables (over 500 GB each) and the migration window is only 2 hours. Which strategy would be MOST effective to meet the time constraint?

Accepted Answer

Use AWS DMS with parallel load by splitting tables into multiple tasks.. AWS DMS parallel load with multiple tasks allows concurrent data transfer, reducing total time. Increasing instance size alone may not be enough if the network is the bottleneck. SCT doesn't speed up data transfer. Homogeneous migration doesn't require SCT, but parallel load is more effective.

Answer

Use a single DMS task with full LOB mode.

Answer

Increase the RDS instance size and use pg_dump.

Answer

Use AWS SCT to optimize schema and then one DMS task.

Question 11

A company wants to migrate a self-hosted MongoDB database to Amazon DocumentDB. They need to convert the schema. Which AWS service should they use?

Accepted Answer

AWS Schema Conversion Tool (SCT). AWS DMS can migrate MongoDB to DocumentDB, and AWS SCT can help convert schemas if needed. However, DocumentDB supports MongoDB wire protocol, so often SCT is not required. But the question asks for schema conversion, so SCT is the correct choice.

Answer

AWS Glue

Answer

AWS Database Migration Service (DMS)

Answer

Amazon Athena

Question 12

A company is migrating an on-premises SQL Server database to Amazon RDS for SQL Server. They need to minimize downtime and have a limited network bandwidth of 50 Mbps. The database size is 1 TB. What is the MOST effective approach?

Accepted Answer

Use AWS Snowball Edge to transfer initial load, then DMS for CDC.. Option C is correct because the 1 TB database size combined with a 50 Mbps network bandwidth would require over 46 hours for the initial load, making a full network transfer impractical. AWS Snowball Edge allows you to transfer the initial 1 TB seed data offline via a physical appliance, bypassing bandwidth constraints. After the seed is loaded into RDS, AWS DMS with Change Data Capture (CDC) can then replicate ongoing changes over the network, minimizing downtime to only the final cutover window.

Answer

Use AWS DMS with CDC over the network.

Answer

Use AWS SCT to compress data before transfer.

Answer

Use native SQL Server backup and restore to Amazon S3.

Question 13

A company is migrating a 10 TB Oracle data warehouse to Amazon Redshift. They want to use AWS DMS for continuous replication. However, the migration is taking longer than expected due to LOB columns. What optimization should be applied?

Accepted Answer

Set MaxLobSize to a value like 64 KB to limit inline LOB transfer.. Setting the DMS task attribute 'MaxLobSize' to a reasonable value limits the size of LOBs transferred inline, improving performance. 'FullLobMode' slows down migration. Increasing instance size helps but not as targeted.

Answer

Use AWS SCT to compress LOBs.

Answer

Enable FullLobMode to transfer all LOBs.

Answer

Increase the number of DMS tasks.

Question 14

A company is migrating an on-premises MySQL database to Amazon RDS for MySQL. They need to validate that the schema is compatible. Which AWS service should they use?

Accepted Answer

AWS Schema Conversion Tool (SCT). AWS SCT can assess and convert schemas for compatibility. AWS DMS is for data migration. Amazon Inspector is for security. AWS Trusted Advisor is for best practices.

Answer

Amazon Inspector

Answer

AWS Database Migration Service (DMS)

Answer

AWS Trusted Advisor

Question 15

A company is migrating a PostgreSQL database to Amazon Aurora PostgreSQL. They have set up AWS DMS with change data capture (CDC). However, after the initial load, the CDC replication is experiencing high latency. What is the MOST likely cause?

Accepted Answer

The source database has large transactions that are not committed quickly.. Large uncommitted transactions on the source database cause DMS CDC to buffer changes until the transaction commits, leading to high latency. DMS must wait for the commit record before applying changes to the target Aurora instance, and during this time, CDC replication stalls, accumulating a backlog of changes.

Answer

The target Aurora instance has insufficient storage.

Answer

The DMS instance is using an older engine version.

Answer

The network bandwidth is too low.