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

Question 1

A company is migrating a 2 TB Oracle database to Amazon RDS for Oracle. The migration requires minimal downtime. They use AWS SCT to convert the schema and AWS DMS for data migration. After the full load, DMS ongoing replication is unable to capture changes because the archived redo logs are being deleted on the source before DMS can read them. The source database has a log retention setting of 2 hours. The team cannot increase the retention due to storage constraints. What should they do?

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

Accepted Answer

Configure DMS to use an S3 bucket to store archived redo logs.. AWS DMS can be configured to read archived redo logs from an Amazon S3 bucket instead of directly from the source Oracle database. By using Oracle's ARCHIVELOG destination to S3 (via DBMS_LOGMNR or a log shipping mechanism), DMS can continue reading changes even if the source deletes logs after 2 hours, decoupling log retention from source storage constraints.

Answer

Switch to a full load only migration strategy.

Answer

Disable archiving on the source database.

Answer

Increase the DMS replication instance size to improve log reading speed.

Question 2

A company has a 50 GB MariaDB database on an on-premises server. They want to migrate to Amazon RDS for MariaDB. They have a 100 Mbps network connection. The migration window is 2 hours. The database can be offline for up to 30 minutes. Which migration approach is most appropriate?

Accepted Answer

Create a MariaDB dump, transfer to an EC2 instance in the same region, then import to RDS.. The database is 50 GB, and the network is 100 Mbps. A dump and transfer over the network would take approximately 50 GB * 8 / 100 Mbps = 4000 seconds ≈ 1.1 hours, which fits within the 2-hour migration window. The database can be offline for up to 30 minutes, so a brief outage for the dump and import is acceptable. AWS DMS with ongoing replication would require more setup and might not meet the tight window, while Snowball is unnecessary for 50 GB. AWS SCT is for schema conversion, not needed for homogeneous migration.

Answer

Use AWS DMS with ongoing replication.

Answer

Use AWS Snowball to transfer the database files.

Answer

Use AWS SCT to convert schema and then use DMS.

Question 3

A company wants to migrate a 1 TB MySQL database to Amazon Aurora MySQL with minimal downtime. The database has a high write load. Which TWO options are valid approaches? (Choose two.)

Accepted Answer

Use AWS DMS with full load and ongoing replication.. AWS DMS supports full load and ongoing change data capture (CDC) replication, which can migrate the 1 TB MySQL database to Aurora MySQL with minimal downtime by continuously applying changes from the source binary logs. This approach handles high write loads efficiently by using transactional replication to keep the target nearly synchronized until cutover.

Answer

Export to flat files, transfer via AWS Snowball, and import.

Answer

Perform a mysqldump and restore to Aurora.

Answer

Use AWS SCT to convert the schema and then use DMS.

Question 4

A company is migrating a 3 TB SQL Server database to Amazon RDS for SQL Server. The migration must have minimal downtime. The current database uses Transparent Data Encryption (TDE). Which TWO steps are necessary to complete the migration? (Choose two.)

Accepted Answer

Export the TDE certificate and private key from the source and import them to the target RDS instance.. Option B is correct because RDS for SQL Server requires the TDE certificate and its private key to be imported into the target instance before a TDE-encrypted database can be restored; without the matching certificate, the backup cannot be decrypted and the restore fails. Option C is correct because native SQL Server backup to S3 followed by restore on RDS is the supported, minimal-downtime migration path for a 3 TB TDE database, using the RDS SQLSERVER_BACKUP_RESTORE option group and the msdb stored procedures to copy the .bak file from S3 and restore it. Option A is wrong because switching to the simple recovery model does not enable the migration and would break log backups needed for point-in-time consistency. Option D is wrong because AWS SCT targets schema conversion to Aurora, not a same-engine SQL Server to RDS for SQL Server migration. Option E is wrong because full supplemental logging is only needed for DMS change data capture, which is not required for a native backup-and-restore migration.

Answer

Set the source database recovery model to simple to reduce log size.

Answer

Use AWS SCT to convert the schema to Amazon Aurora.

Answer

Enable full supplemental logging on the source database for DMS CDC.

Question 5

A company is using an Amazon RDS for SQL Server database with Multi-AZ deployment. They need to migrate to Amazon RDS for SQL Server in a different AWS region. The database is 1 TB and cannot tolerate more than 15 minutes of downtime. Which strategy minimizes downtime?

Accepted Answer

Set up cross-region replication using native SQL Server log shipping or DMS with ongoing replication, then perform a DNS cutover to the target instance.. It combines native SQL Server log shipping or AWS DMS with ongoing replication to keep the target region instance nearly synchronized with the source, enabling a DNS cutover with minimal downtime. This approach meets the 15-minute downtime requirement by allowing a controlled final sync and cutover, unlike snapshot restore or full-load-only methods that require longer outages. Multi-AZ deployment does not prevent cross-region replication, and log shipping or DMS can handle the 1 TB database within the downtime window if properly configured.

Answer

Create a cross-region read replica in the target region and promote it to a standalone instance.

Answer

Take a snapshot of the source RDS instance and restore it in the target region. Then update the application connection string.

Answer

Use AWS DMS to perform a full load to a new RDS instance in the target region. During the final sync, stop the source and resume from the target.

Question 6

A company is migrating a 50 GB PostgreSQL database from on-premises to Amazon RDS for PostgreSQL. The network bandwidth between on-premises and AWS is 50 Mbps. The migration must complete within 24 hours. What is the most efficient way to transfer the initial data?

Accepted Answer

Use pg_dump to export the database and upload to S3 via the internet, then restore into RDS.. The most efficient method is to use pg_dump to export the database, upload the dump file to Amazon S3 via the internet (or using AWS CLI with multipart upload), and then restore it into Amazon RDS for PostgreSQL. Given the database size of 50 GB and a 50 Mbps link, the theoretical transfer time is about 2.3 hours, and even with realistic overhead and retransmissions, it can complete well within the 24-hour window. This approach avoids the shipping delay and logistical overhead of AWS Snowball, which would take several days to arrive and process.

Answer

Use AWS Snowball to physically transfer the database backup to AWS, then load into RDS.

Answer

Use AWS DMS to perform a full load directly over the internet.

Answer

Set up a VPN connection and use AWS DMS with ongoing replication.

Question 7

A company wants to test an application against an Amazon RDS for MySQL database with a recent set of production data without impacting the production database. The test database must be available quickly and be refreshed regularly. Which solution should be used?

Accepted Answer

Create a read replica of the production database, then promote it to a standalone instance for testing.. Creating a read replica of the production RDS for MySQL database and then promoting it to a standalone instance is the fastest way to obtain a near-current copy of production data without impacting the source. The replica is created asynchronously using MySQL's native binlog replication, and promotion breaks the replication link, leaving a fully writable test instance. This approach minimizes setup time because the replica is already hydrated with data from the moment of creation.

Answer

Export production data to S3 and import into a test instance using Lambda.

Answer

Use AWS DMS to continuously replicate data from production to a test RDS instance.

Answer

Create a snapshot of the production database and restore it as a new RDS instance.

Question 8

A company is migrating a 500 GB PostgreSQL database from on-premises to Amazon Aurora PostgreSQL. They need to minimize downtime and ensure that all data changes made during migration are synchronized. Which three components are required for this migration? (Choose THREE.)

Accepted Answer

AWS Database Migration Service (DMS) replication instance. AWS DMS replication instance is required because it orchestrates the continuous replication of data from the source PostgreSQL database to the target Aurora PostgreSQL cluster. It manages the connection, reads changes from the source using logical replication slots, and applies them to the target, enabling near-zero downtime migration.

Answer

AWS Schema Conversion Tool (SCT)

Answer

AWS VPN connection between on-premises and AWS

Question 9

A user has the IAM policy shown in the exhibit. When attempting to create a DMS replication task, they receive an authorization error. What is the most likely missing permission?

Accepted Answer

dms:CreateEndpoint permission. The user is attempting to create a DMS replication task, which requires the ability to create the underlying DMS resources. The error indicates a missing permission for the `dms:CreateEndpoint` action, as DMS replication tasks depend on source and target endpoints that must be created first. Without this permission, the API call to create the endpoint fails, resulting in an authorization error.

Answer

ec2:DescribeSecurityGroups to allow network configuration

Answer

s3:PutObject for the S3 bucket

Answer

logs:CreateLogGroup to enable logging

Question 10

A company is migrating a 10 TB SQL Server database to Amazon RDS for SQL Server. They need to minimize the migration time and cost. Which approach should they use?

Accepted Answer

Use AWS DMS with a full load and ongoing replication. AWS DMS with a full load and ongoing replication is the most efficient approach for migrating a 10 TB SQL Server database to Amazon RDS for SQL Server because it performs a one-time full load of the existing data and then continuously replicates ongoing changes, minimizing downtime. DMS handles schema conversion automatically for homogeneous migrations (SQL Server to SQL Server) and supports resumable tasks, which reduces the risk of restarting from scratch on failure. This approach balances speed and cost by using the network for data transfer without the overhead of physical media or manual restore steps.

Answer

Use AWS Snowball Edge to transfer backup files

Answer

Use AWS Schema Conversion Tool to convert schema and then bulk insert

Answer

Use native SQL Server backup to S3 and restore to RDS

Question 11

A company is deploying a global application that requires a database with sub-millisecond read latency across multiple regions. Which AWS database service should they use?

Accepted Answer

Amazon DynamoDB Global Tables. Amazon DynamoDB Global Tables provides a fully managed, multi-Region, multi-active database that delivers single-digit millisecond read and write latency anywhere in the world. It replicates data across AWS Regions automatically, ensuring sub-millisecond read latency by serving reads from the local Region. This makes it the ideal choice for a global application requiring low-latency reads across multiple regions.

Answer

Amazon ElastiCache for Redis

Answer

Amazon Aurora Global Database

Answer

Amazon RDS for MySQL with cross-region Read Replicas

Question 12

A company wants to migrate a 1 TB on-premises PostgreSQL database to Amazon RDS for PostgreSQL. They have a limited internet bandwidth. Which service should they use to accelerate the migration?

Accepted Answer

AWS Snowball Edge. AWS Snowball Edge is the correct choice because it provides a physical storage device that can be used to transfer large volumes of data (1 TB) over a limited internet bandwidth. By shipping the device to AWS, the initial bulk data load bypasses the internet entirely, which accelerates the migration. After the data is loaded into Amazon RDS for PostgreSQL via Snowball Edge, AWS DMS can be used for ongoing replication to keep the database in sync.

Answer

AWS Database Migration Service (DMS)

Answer

Amazon S3

Answer

AWS Direct Connect

Question 13

A company is migrating a 500 GB SQL Server database to Amazon RDS for SQL Server. They need to minimize downtime. Which TWO actions should they take? (Choose two.)

Accepted Answer

Use AWS DMS with ongoing change data capture (CDC). Option C is correct because AWS Database Migration Service (DMS) with ongoing change data capture (CDC) performs a full load followed by continuous replication of ongoing changes from the source SQL Server to Amazon RDS for SQL Server, allowing the cutover to be brief and thus minimizing downtime. Option D is correct because AWS Direct Connect provides a dedicated, consistent, low-latency private network connection between the on-premises data center and AWS, which speeds up the bulk transfer of the 500 GB database and reduces the risk of interruptions compared to transferring over the public internet. Option A is not required because storing backup files in Amazon S3 is a native/offline restore approach that typically involves taking the database offline during the final backup and restore, which does not minimize downtime as effectively as continuous replication. Option B is incorrect because the AWS Schema Conversion Tool is used for heterogeneous migrations (for example, Oracle to PostgreSQL/Aurora), whereas this is a homogeneous SQL Server-to-SQL Server migration where the schema does not need conversion. Option E is incorrect because enabling Multi-AZ after migration addresses high availability and failover, not the downtime during the data migration itself.

Answer

Store database backup files in Amazon S3

Answer

Use AWS Schema Conversion Tool to convert the schema

Answer

After migration, enable Multi-AZ for high availability

Question 14

A company is deploying a new application using Amazon DynamoDB. They need to ensure data durability and availability. Which THREE steps should they take? (Choose three.)

Accepted Answer

Configure Auto Scaling for read and write capacity. Option A is correct because configuring Auto Scaling for read and write capacity lets DynamoDB automatically adjust provisioned throughput to match traffic, preventing throttling that would otherwise make the table unavailable to the application. Option D is correct because point-in-time recovery (PITR) provides continuous backups of the table for the last 35 days, allowing restoration to any second within that window and thus protecting data durability against accidental writes or deletions. Option E is correct because DynamoDB Global Tables replicate data across multiple AWS Regions in an active-active configuration, giving multi-Region availability and durability if an entire Region becomes impaired. Option B does not belong because DAX is an in-memory read cache that reduces read latency; it does not improve data durability or availability. Option C does not belong because encryption at rest with AWS KMS is a security control that protects confidentiality of stored data, not a durability or availability mechanism.

Answer

Enable DynamoDB Accelerator (DAX)

Answer

Encrypt data at rest using AWS KMS

Question 15

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 volume. The migration window is limited to 4 hours. Which migration approach provides the fastest initial load with minimal downtime?

Accepted Answer

Use AWS DMS with PostgreSQL as source and target, using native logical replication for full load and ongoing replication.. AWS DMS with native logical replication (using PostgreSQL's built-in logical replication slots) performs a full load of the 2 TB database while simultaneously capturing ongoing changes, enabling near-zero downtime during the migration window. This approach is optimized for high-write volumes and limited windows, as it avoids the need for a separate export/import step and minimizes the time the source database is unavailable.

Answer

Use pg_dump to export the database and pg_restore to import into RDS.

Answer

Create a read replica of the on-premises database and promote it to a standalone database in RDS.

Answer

Use AWS Schema Conversion Tool (AWS SCT) to convert the schema and then use AWS DMS for ongoing replication.