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

Question 1

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 2

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. A Multi-AZ deployment provides automatic failover to a standby instance in a different Availability Zone, ensuring high availability. Adding one or more Read Replicas offloads read-heavy workloads from the primary instance, improving performance. This combination meets both the read-heavy and automatic failover requirements for the application.

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 3

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 Schema Conversion Tool (SCT) is the correct choice because it is specifically designed to convert database schemas and code objects (such as stored procedures, functions, and triggers) from one database engine to another. For an Oracle-to-Aurora PostgreSQL migration, SCT analyzes the source schema, identifies incompatible data types and syntax, and generates equivalent PostgreSQL DDL and PL/pgSQL code, handling complex conversions like Oracle sequences to PostgreSQL sequences and Oracle packages to PostgreSQL schemas.

Answer

AWS Lambda

Answer

Amazon S3

Answer

AWS Database Migration Service (DMS)

Question 4

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

Question 5

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 6

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 7

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. DynamoDB Auto Scaling automatically adjusts provisioned read/write capacity based on actual traffic patterns, preventing throttling while controlling costs. This directly supports availability by ensuring the table can handle demand spikes without manual intervention.

Answer

Enable DynamoDB Accelerator (DAX)

Answer

Encrypt data at rest using AWS KMS

Question 8

A company is migrating a 2 TB MySQL database to Amazon Aurora MySQL. They want to minimize downtime and ensure data consistency. Which TWO methods should they use? (Choose two.)

Accepted Answer

Use AWS DMS with ongoing replication. AWS DMS with ongoing replication (Option A) is correct because it allows continuous change data capture (CDC) from the source MySQL database to the target Aurora MySQL cluster, minimizing downtime by keeping the target synchronized during the migration. This approach ensures data consistency by applying incremental changes after the initial full load, enabling a controlled cutover with minimal service interruption.

Answer

Use AWS Schema Conversion Tool to convert the schema

Answer

Use AWS Snowball Edge to transfer backup files

Answer

Use mysqldump to export data

Question 9

Refer to the exhibit. An IAM policy is attached to a user. The user tries to delete a database instance named 'prod-mydb' in us-east-1. What will happen?

Accepted Answer

The delete will be denied because the Deny statement explicitly matches the resource.. D is correct because IAM policy evaluation follows an explicit deny priority rule. Even though the Allow statement grants 'rds:DeleteDBInstance' on 'arn:aws:rds:us-east-1:*:db:*', the Deny statement explicitly matches the resource 'arn:aws:rds:us-east-1:123456789012:db:prod-mydb' and specifies 'rds:DeleteDBInstance'. Since an explicit deny overrides any allow, the delete operation will be denied.

Answer

The delete will be allowed because the Allow statement is broader.

Answer

The delete will fail with an error because the policy is invalid.

Answer

The delete will succeed only if the instance is tagged with 'Environment: prod'.

Question 10

Refer to the exhibit. A database administrator runs the AWS CLI command and gets the following output: {"Engine":"mysql","DBInstanceStatus":"available","MultiAZ":true,"SecondaryAvailabilityZone":"us-east-1b"}. What can be concluded about the database deployment?

Accepted Answer

The database is a Multi-AZ deployment with a standby in a different Availability Zone.. The output shows `"MultiAZ":true` and `"SecondaryAvailabilityZone":"us-east-1b"`, which are explicit indicators of a Multi-AZ deployment for an RDS MySQL instance. In a Multi-AZ deployment, Amazon RDS automatically provisions and maintains a synchronous standby replica in a different Availability Zone, and the `SecondaryAvailabilityZone` field confirms the standby's location. This matches option D exactly.

Answer

The database is a Single-AZ deployment.

Answer

The database has a Read Replica in a different Availability Zone.

Answer

The database is an Amazon Aurora cluster.

Question 11

Refer to the exhibit. An IAM policy allows creation of a DMS replication task only if the source database engine is Oracle. A user attempts to create a replication task with a MySQL source. What will happen?

Accepted Answer

The action will be denied because the condition does not match.. The IAM policy includes a condition that requires the source engine to be Oracle. When the user attempts to create a DMS replication task with a MySQL source, the condition fails, and IAM denies the action by default. The explicit deny is not needed; IAM uses an implicit deny when no policy statement allows the action under the given conditions.

Answer

The action will fail with an error because the policy is malformed.

Answer

The action will succeed but the task will fail later.

Answer

The action will be allowed because the resource is '*'.

Question 12

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.

Question 13

A company wants to migrate its Oracle data warehouse to Amazon Redshift. The source database is 10 TB and has many complex stored procedures. Which AWS service should be used primarily for converting the stored procedures to Amazon Redshift compatible code?

Accepted Answer

AWS Schema Conversion Tool (AWS SCT). AWS Schema Conversion Tool (AWS SCT) is the correct choice because it is specifically designed to convert database schemas and complex code objects, such as stored procedures, functions, and packages, from one database engine to another. For an Oracle-to-Amazon Redshift migration, AWS SCT can automatically translate Oracle PL/SQL stored procedures into Amazon Redshift compatible SQL (e.g., using PL/pgSQL or SQL functions), handling syntax differences and unsupported features. This makes it the primary tool for converting the 10 TB data warehouse's stored procedures, whereas other services focus on data movement or ETL, not schema and code conversion.

Answer

AWS Glue

Answer

AWS Database Migration Service (AWS DMS)

Answer

Amazon Redshift COPY command

Question 14

A company is migrating a 5 TB MySQL database to Amazon Aurora MySQL. The migration must have zero downtime and the source database is continuously written to. The team plans to use AWS DMS with ongoing replication. However, they notice that the target Aurora instance is not receiving all changes from the source. Which configuration change is most likely required to resolve this?

Accepted Answer

Enable binary logging (binlog) on the source MySQL database with row-based logging.. AWS DMS requires binary logging (binlog) with row-based logging on the source MySQL database to capture ongoing changes for continuous replication. Without binlog enabled, DMS cannot read the change data stream needed to replicate transactions to the target Aurora instance, causing missed changes. This is a mandatory prerequisite for any MySQL-to-Aurora migration using DMS with ongoing replication.

Answer

Create an Amazon RDS read replica of the source database and use it as the source endpoint.

Answer

Set the target table preparation mode to 'Do nothing' in the DMS task.

Answer

Configure a VPC endpoint for the DMS replication instance.

Question 15

A company is migrating a 500 GB Oracle database to Amazon RDS for Oracle. They want to minimize downtime and use AWS DMS for ongoing replication. The source database is in a corporate data center behind a firewall. What is the recommended network setup for the DMS replication instance?

Accepted Answer

Deploy the DMS replication instance in a VPC that has a VPN or AWS Direct Connect connection to the corporate data center.. AWS DMS requires network connectivity between the replication instance and both the source and target databases. Since the source Oracle database is behind a corporate firewall, the DMS replication instance must be deployed in a VPC that has a VPN or AWS Direct Connect connection to the corporate data center. This establishes a private, secure, and low-latency network path for ongoing replication, minimizing downtime during migration.

Answer

Launch the DMS replication instance with a public IP address and allow inbound traffic from the corporate firewall.

Answer

Create a VPC endpoint for the DMS service and route traffic through it.

Answer

Install the DMS replication software on a server in the corporate data center to connect directly to the source.