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

Question 1

A company wants to migrate a 200 GB SQL Server database to Amazon RDS for SQL Server with minimal downtime. The database is used by a critical application. Which service should be used for the migration?

Accepted Answer

AWS Database Migration Service (DMS).. Option A is correct because AWS DMS supports SQL Server as both source and target with ongoing replication. Option B is wrong because SCT is only for schema conversion. Option C is wrong because it's command-line tool for exporting/importing, not continuous replication. Option D is wrong because it's a backup/restore tool.

Answer

AWS Schema Conversion Tool (SCT).

Answer

SQL Server Import and Export Wizard.

Answer

SQL Server Management Studio (SSMS) backup and restore.

Question 2

A company is deploying a new application with a PostgreSQL database on Amazon RDS. The database must be highly available across two Availability Zones. Which deployment option meets this requirement?

Accepted Answer

Multi-AZ RDS instance.. Option B is correct because Multi-AZ deployment provides synchronous standby in another AZ. Option A is wrong because it's single-AZ. Option C is wrong because read replicas are for read scaling, not failover. Option D is wrong because it's a different service.

Answer

RDS with a read replica in another AZ.

Answer

Single-AZ RDS instance.

Answer

Amazon Aurora Global Database.

Question 3

A company is migrating a 10 TB Oracle Data Warehouse to Amazon Redshift. The source database runs on premises with limited bandwidth (100 Mbps). The migration must complete within 5 days. Which approach is most cost-effective and meets the timeline?

Accepted Answer

Use AWS Snowball Edge to transfer the initial full load, then AWS DMS for ongoing changes.. Option C is correct because AWS Snowball Edge can transfer 10 TB in days, then use DMS for ongoing sync. Option A is wrong because 100 Mbps would take ~11 days for full load alone. Option B is wrong because direct DMS over 100 Mbps would take too long for initial load. Option D is wrong because SCT is not a data transfer tool.

Answer

Use AWS DMS over the internet to migrate data.

Answer

Use AWS Schema Conversion Tool (SCT) to convert and then upload to S3.

Answer

Use AWS DMS with AWS Direct Connect at 1 Gbps.

Question 4

A company is deploying a MySQL database on Amazon RDS and needs to enforce encryption at rest. Which configuration step is required?

Accepted Answer

Select encryption option when creating the RDS instance.. Option D is correct because enabling encryption at rest is done when launching the RDS instance. Option A is wrong because encryption is applied to the instance, not the engine. Option B is wrong because encryption is set at creation time. Option C is wrong because it's about encryption in transit, not at rest.

Answer

Use a custom DB parameter group with SSL enabled.

Answer

Modify the DB instance to enable encryption after creation.

Answer

Enable SSL/TLS on the RDS instance.

Question 5

A company needs to migrate an on-premises PostgreSQL database to Amazon Aurora PostgreSQL with minimal downtime. Which AWS service should be used for the ongoing replication?

Accepted Answer

AWS Database Migration Service (DMS).. Option A is correct because AWS DMS supports ongoing replication from PostgreSQL to Aurora. Option B is wrong because it's for schema conversion. Option C is wrong because it's a general ETL tool. Option D is wrong because it's a backup service.

Answer

AWS Glue.

Answer

AWS Backup.

Answer

AWS Schema Conversion Tool (SCT).

Question 6

A company is deploying a new web application that requires a highly available MariaDB database. The application is read-heavy and needs to scale read traffic. Which deployment approach meets these requirements?

Accepted Answer

Deploy a Multi-AZ RDS for MariaDB with one or more read replicas.. Option C is correct because Multi-AZ provides HA and read replicas scale reads. Option A is wrong because Multi-AZ alone does not scale reads. Option B is wrong because read replicas alone do not provide HA. Option D is wrong because Aurora is a different engine.

Answer

Deploy Amazon Aurora MySQL with a read replica.

Answer

Deploy a Multi-AZ RDS for MariaDB instance.

Answer

Deploy a single-AZ RDS for MariaDB with a read replica.

Question 7

A company is migrating a self-managed PostgreSQL database with extensions (PostGIS, pg_stat_statements) to Amazon RDS for PostgreSQL. After migration, they find that the extensions are not available. What is the most likely cause?

Accepted Answer

The required extensions are not included in the default parameter group and must be manually added to shared_preload_libraries.. Option B is correct because RDS for PostgreSQL supports many extensions but not all; PostGIS is supported but may require enabling. Option A is wrong because extensions are supported. Option C is wrong because extensions are allowed. Option D is wrong because the question is about extensions not available.

Answer

The extensions are incompatible with the RDS engine version.

Answer

The RDS instance is not configured to allow extensions.

Answer

RDS does not support any PostgreSQL extensions.

Question 8

A company is migrating a 1 TB on-premises SQL Server database to Amazon RDS for SQL Server. The migration must be completed within 24 hours and with minimal downtime. Which TWO approaches should be used? (Choose 2)

Accepted Answer

Use AWS DMS with ongoing replication (CDC).. Options A and D are correct because DMS with CDC provides near-zero downtime, and SCT can help with schema conversion. Option B is wrong because backup/restore requires downtime. Option C is wrong because it's not efficient. Option E is wrong because SSIS is not DMS.

Answer

Use AWS DMS with SSIS packages.

Answer

Use native backup and restore to S3.

Answer

Use AWS DMS full load only.

Question 9

A company is migrating a 5 TB Oracle database to Amazon Aurora PostgreSQL. They have a 4-hour maintenance window weekly. Which THREE steps should be taken to minimize downtime? (Choose 3)

Accepted Answer

Use AWS Snowball to transfer the initial data load.. Options A, C, and D are correct because DMS with CDC provides near-zero downtime; SCT helps with schema conversion; Snowball can transfer initial load fast. Option B is wrong because it doesn't help with migration. Option E is wrong because it's not needed since DMS handles replication.

Answer

Create an Aurora read replica for testing.

Answer

Use AWS Direct Connect for network connectivity.

Question 10

A company is deploying a new MySQL database on Amazon RDS. They need to ensure that the database is automatically backed up daily and retained for 30 days. Which TWO configurations should be set? (Choose 2)

Accepted Answer

Set backup retention period to 30 days.. Options A and D are correct because automated backups are enabled by default and retention period can be set up to 35 days. Option B is wrong because manual snapshots are separate. Option C is wrong because it's not about backups. Option E is wrong because it doesn't set retention.

Answer

Set backup window.

Answer

Enable Multi-AZ deployment.

Answer

Create a manual snapshot daily.

Question 11

Refer to the exhibit. You run the command and get the output shown. The database is an RDS for MySQL instance. You need to connect to it from an EC2 instance in the same VPC. Which connection string should be used?

Accepted Answer

mysql -h mydb.123456789012.us-east-1.rds.amazonaws.com -P 3306 -u admin -p. Option C is correct because the endpoint address and port are shown. Option A is wrong because it uses the wrong port. Option B is wrong because it uses the wrong address. Option D is wrong because it uses the wrong engine.

Answer

psql -h mydb.123456789012.us-east-1.rds.amazonaws.com -p 5432 -U admin

Answer

mysql -h mydb.us-east-1.rds.amazonaws.com -P 3306 -u admin -p

Answer

mysql -h mydb.123456789012.us-east-1.rds.amazonaws.com -P 5432 -u admin -p

Question 12

Refer to the exhibit. An IAM policy is attached to a user who needs to deploy an RDS MySQL instance. After creating the instance, the user tries to modify it to enable deletion protection, but the action fails. What is the most likely reason?

Accepted Answer

The user does not have permission to enable deletion protection.. Option B is correct because the policy does not include rds:ModifyDBInstance permission. Option A is wrong because deletion protection is a modification. Option C is wrong because the policy allows Create. Option D is wrong because the user has Describe permission.

Answer

The user does not have permission to describe instances.

Answer

The resource ARN is not specified in the policy.

Answer

The user does not have permission to create the instance.

Question 13

A company is migrating a 3 TB on-premises Oracle database to Amazon Aurora PostgreSQL. The source database runs Oracle 12c on a Linux server with a 1 Gbps network connection to AWS via Direct Connect. The migration must have minimal downtime and be completed within a 2-day window. The database is heavily used during business hours (9 AM - 5 PM) and has low activity overnight. The company has a test environment on AWS already. The migration team plans to use AWS DMS with CDC for ongoing replication. They also plan to use AWS SCT for schema conversion. They start the migration on a Friday evening. On Saturday morning, the CDC replication lag is increasing, and the target Aurora instance is struggling to keep up. The team notices that the source database has a high number of write transactions even during the weekend, and the DMS replication instance is a small instance type. Which action should the team take to complete the migration on time?

Accepted Answer

Upgrade the DMS replication instance to a larger size to increase throughput.. Option B is correct because upgrading the DMS replication instance increases its capacity to handle high write volume. Option A is wrong because it doesn't address the bottleneck. Option C is wrong because it adds complexity and may not help. Option D is wrong because it doesn't solve the replication lag.

Answer

Reduce the number of tables being migrated to lower the load.

Answer

Pause the migration and restart it on Monday during low activity.

Answer

Switch to use AWS Snowball to transfer data and bypass DMS.

Question 14

A company is migrating an on-premises Oracle database to Amazon RDS for Oracle. The database is 2 TB in size and has a high transaction rate. The migration must have minimal downtime and support ongoing replication. Which AWS service should be used for the migration?

Accepted Answer

AWS Database Migration Service (AWS DMS). AWS Database Migration Service (DMS) supports ongoing replication from Oracle to RDS Oracle with minimal downtime. AWS SCT helps convert the schema but does not perform replication. RDS Read Replicas are for RDS to RDS, not on-premises to RDS. Direct Connect provides a network connection but does not handle data migration. Snowball is for offline data transfer, not minimal downtime.

Answer

AWS Schema Conversion Tool (AWS SCT)

Answer

AWS Direct Connect

Answer

Amazon RDS Read Replica

Question 15

A company is deploying a new web application that uses Amazon RDS for MySQL. The application has unpredictable read traffic spikes. The company wants to minimize read latency and automatically scale read capacity. What is the MOST cost-effective solution?

Accepted Answer

Create an Amazon RDS read replica and configure the application to use it for read traffic. A Multi-AZ deployment provides high availability but does not offload reads. Read replicas offload read traffic and can be scaled manually or via auto-scaling with a custom solution. RDS Proxy is for connection management, not read scaling. ElastiCache is a caching layer but requires application changes and adds cost. Read replicas are the most cost-effective for read scaling.

Answer

Use Amazon ElastiCache as a caching layer

Answer

Use Amazon RDS Proxy to manage connections

Answer

Deploy the RDS instance in a Multi-AZ configuration