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

Question 1

A company is planning to migrate a 5 TB Oracle data warehouse to Amazon Redshift. The migration must be completed within a 2-day maintenance window. The source database is heavily normalized and uses complex joins. Which strategy is most appropriate?

Accepted Answer

Use AWS SCT to convert the Oracle schema to Redshift-compatible format, then use AWS DMS to load the data.. Option B is correct because Redshift is columnar and optimized for denormalized schemas; using SCT to convert the schema and DMS for data loading is the standard approach. Option A is wrong because direct copy does not account for schema conversion. Option C is wrong because S3 Transfer Acceleration only speeds up uploads, not schema conversion. Option D is wrong because Glue is for ETL but not purpose-built for large-scale data warehouse migration with schema conversion.

Answer

Use AWS DMS to directly migrate data to Redshift with full load and ongoing replication.

Answer

Export data to flat files, use S3 Transfer Acceleration to upload to S3, then COPY into Redshift.

Answer

Use AWS Glue to crawl the Oracle schema and create Redshift tables, then run a Glue ETL job to load data.

Question 2

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.. Option B is correct because a read replica can be created from the production instance and then promoted to a standalone instance for testing. Option A is wrong because it would impact production performance. Option C is wrong because DMS is for migration, not for creating test copies. Option D is wrong because S3 is not a database.

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 3

A company is migrating a 200 GB Oracle database to Amazon Aurora MySQL. They want to minimize downtime and ensure data consistency. Which two services should they use together? (Choose TWO.)

Accepted Answer

AWS Schema Conversion Tool (SCT). Options B and D are correct. AWS SCT converts the Oracle schema to MySQL-compatible format, and AWS DMS performs the data migration with ongoing replication to minimize downtime. Option A is wrong because Snowball is for offline data transfer, which would introduce downtime. Option C is wrong because Data Pipeline is not the primary migration tool. Option E is wrong because EC2 is not needed.

Answer

AWS Snowball Edge

Answer

AWS Data Pipeline

Answer

Amazon EC2 with Oracle installed

Question 4

A company is migrating a 3 TB SQL Server database to Amazon RDS for SQL Server. They have limited network bandwidth (100 Mbps) and need to complete the migration within 3 days. Which two approaches could meet the requirements? (Choose TWO.)

Accepted Answer

Use AWS Snowball to physically transfer a full database backup to AWS, then restore into RDS.. Options A and D are correct. AWS Snowball can transfer the backup offline, bypassing network constraints. AWS DMS with ongoing replication can use change data capture to minimize downtime after initial load. Option B is wrong because VPN does not increase bandwidth. Option C is wrong because DataSync is for file storage, not databases. Option E is wrong because direct transfer over the internet would be too slow.

Answer

Export the database to a flat file, compress it, and upload to S3 via the internet, then import into RDS.

Answer

Use AWS DataSync to transfer the database files directly to Amazon S3.

Answer

Establish a VPN connection and use AWS DMS with full load only.

Question 5

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. Options A, B, and D are correct. AWS DMS performs the migration with ongoing replication. An Aurora PostgreSQL target database is needed. The source database must be configured to allow replication. Option C is wrong because SCT is not needed when source and target are both PostgreSQL. Option E is wrong because a VPN is optional, not required.

Answer

AWS Schema Conversion Tool (SCT)

Answer

AWS VPN connection between on-premises and AWS

Question 6

A database administrator runs the command shown in the exhibit to create a read replica in us-west-2 from a source DB instance in us-east-1. The command fails. What is the most likely cause?

Accepted Answer

The source DB instance does not have backup retention enabled.. Option B is correct because cross-region read replicas require that the source DB instance have backup retention enabled, which is a prerequisite for automated backups. Option A is wrong because the instance class is valid. Option C is wrong because public accessibility is not required for read replicas. Option D is wrong because the replica can have a different instance class.

Answer

The source DB instance is not publicly accessible.

Answer

The replica instance class db.r5.large is not available in us-west-2.

Answer

The replica must use the same DB instance class as the source.

Question 7

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. Option C is correct because creating a DMS replication task requires permissions to create the DMS endpoint resources, which are not included in the policy. Option A is wrong because S3 permissions are not needed for a basic task. Option B is wrong because EC2 permissions are not required. Option D is wrong because CloudWatch Logs permissions are not required at creation time.

Answer

ec2:DescribeSecurityGroups to allow network configuration

Answer

s3:PutObject for the S3 bucket

Answer

logs:CreateLogGroup to enable logging

Question 8

After migrating a database to Amazon RDS, an application on an EC2 instance in the same VPC cannot connect. The command in the exhibit shows the endpoint. What is the most likely cause?

Accepted Answer

The security group for the DB instance does not allow inbound traffic from the EC2 instance's security group.. Option B is correct because the most common issue is security group rules not allowing inbound traffic on the database port from the EC2 instance. Option A is wrong because the endpoint is correct. Option C is wrong because the RDS instance is in the same VPC, so no VPN is needed. Option D is wrong because public accessibility is not required for same VPC connectivity.

Answer

The EC2 instance is in a different VPC and needs a VPN connection.

Answer

The DB instance endpoint is incorrect.

Answer

The DB instance is not publicly accessible.

Question 9

A company is migrating a 2 TB Oracle database to Amazon Aurora PostgreSQL. They need to minimize downtime. Which AWS service should they use?

Accepted Answer

AWS Database Migration Service (DMS). AWS Database Migration Service (DMS) supports heterogeneous migrations from Oracle to Aurora PostgreSQL and can perform ongoing replication to minimize downtime. Option A is correct. Option B (AWS Snowball) is for large data transfer but not for ongoing replication. Option C (SCT) helps with schema conversion but not data migration. Option D (Data Pipeline) is not designed for database migrations.

Answer

AWS Schema Conversion Tool (SCT)

Answer

AWS Data Pipeline

Answer

AWS Snowball

Question 10

A company is deploying a new application that uses Amazon RDS for MySQL. The database must be highly available with automatic failover. Which deployment configuration meets these requirements?

Accepted Answer

Multi-AZ deployment with a standby replica in a different Availability Zone. Multi-AZ deployment with a standby replica provides automatic failover in RDS MySQL. Option C is correct. Option A (Read Replica) does not provide automatic failover. Option B (Single-AZ) lacks high availability. Option D (Multi-AZ with synchronous replication) is correct but the description is more accurate for Aurora; for RDS MySQL, Multi-AZ uses synchronous replication to a standby.

Answer

Single-AZ with a Read Replica in the same region

Answer

Multi-AZ deployment with synchronous replication to a cross-region replica

Answer

Single-AZ with automated backups

Question 11

A developer needs to migrate a 500 GB MongoDB database to Amazon DocumentDB. Which approach will minimize application downtime?

Accepted Answer

Use AWS DMS with ongoing replication from MongoDB to DocumentDB. AWS DMS can perform a live migration with ongoing replication to minimize downtime. Option B is correct. Option A (Snapshot and restore) involves downtime. Option C (Application-level migration) is manual and error-prone. Option D (AWS DataSync) is not for database migration.

Answer

Write a custom script to migrate data in batches

Answer

Export data from MongoDB, upload to S3, and import into DocumentDB

Answer

Use AWS DataSync to transfer data files

Question 12

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 can migrate data efficiently and supports ongoing replication. Option C is correct. Option A (Native backup and restore) requires storage and manual steps. Option B (SCT only) does not migrate data. Option D (Snowball) is for large data but adds latency.

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 13

A company is deploying a new web application using Amazon RDS for PostgreSQL. The application requires read-heavy workloads and automatic failover. Which configuration should be used?

Accepted Answer

Multi-AZ deployment with one or more Read Replicas. Multi-AZ deployment provides automatic failover, and Read Replicas offload read traffic. Option D is correct. Option A (Single-AZ) no HA. Option B (Multi-AZ) gives HA but no read scaling. Option C (Read Replicas only) no automatic failover.

Answer

Multi-AZ deployment without Read Replicas

Answer

Single-AZ with a Read Replica in the same region

Answer

Multiple Read Replicas in different regions

Question 14

A company wants to migrate an on-premises Oracle database to Amazon Aurora PostgreSQL. They need to convert the schema and code. Which AWS service should they use?

Accepted Answer

AWS Schema Conversion Tool (SCT). AWS SCT is designed for schema and code conversion between heterogeneous databases. Option A is correct. Option B (DMS) migrates data, not schema. Option C (S3) is storage. Option D (Lambda) is compute.

Answer

AWS Lambda

Answer

Amazon S3

Answer

AWS Database Migration Service (DMS)

Question 15

A company is migrating a 5 TB MySQL database to Amazon RDS for MySQL. They need to minimize downtime. Which approach should they use?

Accepted Answer

Use AWS DMS with full load and change data capture (CDC). AWS DMS with full load and change data capture (CDC) minimizes downtime by performing an initial full load of the 5 TB database while continuously replicating ongoing changes from the source. Once the full load completes and the target is nearly synchronized, you can cut over with minimal downtime, typically seconds to minutes. This approach is specifically designed for large-scale migrations with low downtime requirements.

Answer

Use Percona XtraBackup to take a backup and restore to RDS

Answer

Use mysqldump to export and import data

Answer

Use AWS DataSync to copy database files