Courseiva

CCNA Deployment Migration Questions

75 of 353 questions · Page 2/5 · Deployment Migration topic · Answers revealed

Practice these questionsExam hubAll questions
76
MCQhard

A company needs to migrate a 3 TB Amazon RDS for SQL Server database to Amazon RDS for PostgreSQL. The migration must be automated and repeatable with minimal manual intervention. Which combination of services should be used?

A.Use AWS SCT to convert the schema and export data to PostgreSQL-compatible format, then import.
B.Use AWS Schema Conversion Tool (SCT) to convert the schema, then use AWS DMS to migrate the data.
C.Use AWS DMS with native SQL Server CDC to migrate directly to PostgreSQL.
D.Use Microsoft Data Migration Assistant to assess and migrate to PostgreSQL.
AnswerB

SCT handles schema conversion, DMS handles data migration.

Why this answer

AWS SCT converts the schema, AWS DMS migrates the data with continuous sync. Option B: DMS only does not convert schema. Option C: SCT only does not migrate data.

Option D: Data Migration Assistant is for SQL Server to SQL Server.

Practice this question →
77
MCQmedium

A company is migrating a 2 TB Oracle database to Amazon Aurora PostgreSQL using AWS SCT and DMS. After migration, the application reports that some queries are significantly slower than before. The database schema was converted automatically. What is the most likely cause?

A.The schema conversion did not create appropriate indexes
B.Aurora storage is slower than Oracle's storage
C.DMS introduced data type conversions that slow down queries
D.Aurora PostgreSQL does not support partitioning, causing full table scans
AnswerA

Indexes may not be migrated optimally, requiring manual tuning.

Why this answer

Option C is correct because SCT may not always generate optimal indexes for Aurora PostgreSQL, leading to performance issues. Option A is wrong because Aurora PostgreSQL supports partitioning. Option B is wrong because DMS does not affect query execution plans.

Option D is wrong because storage performance should not cause query slowness.

Practice this question →
78
Multi-Selecthard

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)

Select 3 answers
A.Create an Aurora read replica for testing.
B.Use AWS Snowball to transfer the initial data load.
C.Use AWS Direct Connect for network connectivity.
D.Use AWS DMS with change data capture (CDC).
E.Use AWS Schema Conversion Tool (SCT) to convert schema.
AnswersB, D, E

Speeds up initial load.

Why this answer

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.

Practice this question →
79
MCQmedium

A company is deploying a new Amazon Aurora MySQL database. The development team requires a separate database instance for testing that is a clone of the production database but does not require the same level of performance. What is the MOST cost-effective way to create this test database?

A.Use the Aurora cloning feature to create a clone of the production cluster
B.Create a new Aurora cluster from the latest snapshot of the production cluster
C.Create a read replica of the production cluster and promote it to a standalone cluster
D.Create a new Aurora cluster and use a smaller DB instance class
AnswerA

Aurora cloning is fast and space-efficient, ideal for test environments.

Why this answer

Aurora cloning creates a logical copy of the cluster volume that is space-efficient and fast, using copy-on-write semantics. Creating a new instance from a snapshot incurs storage costs and takes longer. Read replicas are for read scaling, not cloning.

Using a different DB instance class does not reduce storage.

Practice this question →
80
MCQhard

A financial services company is migrating a 2 TB Oracle database to Amazon Aurora PostgreSQL. The database uses Oracle-specific features like hierarchical queries and stored procedures. The company wants to minimize manual code changes. Which service should be used to automate schema conversion?

A.AWS Database Migration Service (DMS) with full load and ongoing replication.
B.AWS Schema Conversion Tool (SCT).
C.AWS Storage Gateway to cache data on-premises and then sync to S3.
D.AWS Lambda to execute custom scripts for schema transformation.
AnswerB

SCT automates the conversion of Oracle schema objects to PostgreSQL-compatible format.

Why this answer

Option B is correct because AWS Schema Conversion Tool (SCT) is designed to convert database schemas from commercial engines like Oracle to open-source engines like PostgreSQL. Option A is wrong because DMS handles data migration but not schema conversion. Option C is wrong because S3 is storage, not conversion.

Option D is wrong because Lambda is for serverless compute, not schema conversion.

Practice this question →
81
MCQmedium

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?

A.ec2:DescribeSecurityGroups to allow network configuration
B.dms:CreateEndpoint permission
C.s3:PutObject for the S3 bucket
D.logs:CreateLogGroup to enable logging
AnswerB

The policy lacks permission to create endpoints, which are required for the replication task.

Why this answer

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.

Practice this question →
82
Multi-Selecthard

A company is planning to migrate a 1 TB MySQL database from on-premises to Amazon RDS for MySQL. The migration must have minimal downtime and support ongoing replication. Which THREE steps should the company include in the migration plan? (Choose THREE.)

Select 3 answers
A.Set up an AWS Direct Connect or VPN connection between on-premises and AWS.
B.Deploy an Amazon EC2 instance to act as a proxy for the DMS replication.
C.Create the target Amazon RDS for MySQL instance.
D.Use AWS DMS with ongoing replication from the on-premises MySQL database.
E.Install the AWS Schema Conversion Tool on the source server to convert the schema.
AnswersA, C, D

Network connectivity is required for DMS to access the source.

Why this answer

Option A is correct because a stable, low-latency network connection (Direct Connect or VPN) is essential for AWS DMS to perform ongoing replication with minimal downtime. Without this, the replication can be interrupted by network issues, causing data loss or extended cutover windows.

Exam trap

The trap here is that candidates often assume an EC2 proxy is needed for DMS replication, but DMS replication instances handle connectivity directly, and the proxy is only used in specific scenarios like VPC peering across regions or complex network topologies.

Practice this question →
83
MCQeasy

A company wants to migrate an on-premises SQL Server database to Amazon RDS for SQL Server. They need to convert stored procedures and functions. Which AWS service should they use?

A.AWS CloudEndure Migration
B.AWS DMS
C.AWS SCT
D.AWS Snowball
AnswerC

SCT converts schema and code objects.

Why this answer

AWS SCT helps convert database schema and code objects like stored procedures from one engine to another (including SQL Server to RDS for SQL Server for compatibility checks). DMS handles data migration, not schema conversion. CloudEndure is for server migration.

Snowball is for offline data transfer.

Practice this question →
84
MCQhard

A database administrator runs the above CLI command. The output shows that 'mydb' is a read replica of 'mydb-source'. The administrator wants to promote 'mydb' to a standalone instance with no downtime. Which action should be taken?

A.Use the promote-read-replica CLI command.
B.Modify the DB instance to enable Multi-AZ, which automatically promotes it.
C.Create a snapshot of the read replica and restore it as a new DB instance.
D.Modify the DB instance class to a larger size to force promotion.
AnswerA

Promoting a read replica makes it a standalone instance without downtime.

Why this answer

Option C is correct because promoting a read replica makes it a standalone instance; it can be done without downtime. Option A is wrong because modifying MultiAZ requires a reboot, causing downtime. Option B is wrong because creating a snapshot and restoring is not a promotion.

Option D is wrong because modifying the DB instance class requires a reboot.

Practice this question →
85
MCQmedium

Refer to the exhibit. A developer runs the command against an RDS MySQL instance. The application team reports that the database is experiencing high read latency during peak hours. The database is not currently in Multi-AZ. What is the MOST cost-effective way to reduce read latency?

A.Enable Multi-AZ to distribute reads to the standby.
B.Upgrade the instance to db.r5.2xlarge.
C.Migrate to Aurora MySQL with a read replica.
D.Create a read replica in the same region.
AnswerD

Offloads read traffic; cost-effective.

Why this answer

Option C is correct because creating a read replica offloads read traffic from the primary instance, reducing read latency without changing the instance class. Option A is wrong because enabling Multi-AZ is for high availability, not read performance. Option B is wrong because upgrading to a larger instance class is more expensive than adding a read replica.

Option D is wrong because converting to Aurora is a significant migration effort and may not be cost-effective for this issue.

Practice this question →
86
MCQhard

A company is deploying a new web application on AWS. The application uses Amazon RDS for MySQL with a Multi-AZ deployment. The application team wants to reduce latency for read-heavy workloads. Which action should be taken?

A.Enable Multi-AZ on the existing RDS instance
B.Increase the instance size of the primary RDS instance
C.Add a read replica in the same Region
D.Switch from RDS to Amazon DynamoDB with DAX
AnswerC

Read replicas can handle read queries, reducing load on the primary and improving latency.

Why this answer

Adding read replicas offloads read traffic from the primary instance, reducing latency. Option A is incorrect because increasing instance size may not significantly reduce read latency. Option B is incorrect because enabling Multi-AZ does not improve read performance.

Option D is incorrect because switching to DynamoDB is a different database paradigm and may require application changes.

Practice this question →
87
Multi-Selecthard

Which THREE considerations are important when deploying Amazon Aurora Global Database? (Choose 3.)

Select 2 answers
A.AWS DMS must be used to set up replication
B.Each secondary region can have up to 16 read replicas
C.Cross-region read replicas are created for each secondary region
D.Amazon S3 is used to store transaction logs
E.Replication is typically less than 1 second between regions
AnswersB, E

Each secondary region supports up to 16 read replicas.

Why this answer

Aurora Global Database supports up to 5 secondary regions, uses storage-based replication, and allows failover to a secondary region. Option C (cross-region read replicas) is not used; instead Global Database uses dedicated clusters. Option D (DMS) is not required.

Option E (S3) is not used.

Practice this question →
88
MCQmedium

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?

A.The delete will be allowed because the Allow statement is broader.
B.The delete will fail with an error because the policy is invalid.
C.The delete will succeed only if the instance is tagged with 'Environment: prod'.
D.The delete will be denied because the Deny statement explicitly matches the resource.
AnswerD

Explicit Deny overrides Allow.

Why this answer

The Deny statement applies to all resources matching 'prod-*', so the delete action is denied for 'prod-mydb'. Even though the Allow statement permits delete, an explicit Deny overrides any Allow. Option B is correct.

Option A (Allowed) ignores the Deny. Option C (Error) is not correct because the policy is valid. Option D (Only if tagged) is not in the policy.

Practice this question →
89
MCQeasy

A company is deploying a new web application and needs a fully managed relational database with automatic failover and read replicas. Which AWS service should they choose?

A.Amazon DynamoDB
B.Amazon RDS for MySQL with Multi-AZ deployment
C.Amazon EC2 with self-managed MySQL
D.Amazon Redshift
AnswerB

RDS is fully managed, Multi-AZ provides automatic failover, and read replicas are supported.

Why this answer

Amazon RDS for MySQL with Multi-AZ deployment provides a fully managed relational database service that automatically provisions and maintains a synchronous standby replica in a different Availability Zone. In the event of a failure, Amazon RDS automatically fails over to the standby, ensuring high availability. Additionally, RDS for MySQL supports read replicas for offloading read traffic, which meets the requirement for both automatic failover and read replicas.

Exam trap

The trap here is that candidates often confuse DynamoDB's high availability and read replicas (DAX, global tables) with relational database requirements, or they assume that a self-managed database on EC2 can be 'fully managed' by using automation scripts, but the question explicitly requires a fully managed service.

How to eliminate wrong answers

Option A is wrong because Amazon DynamoDB is a NoSQL key-value and document database, not a relational database, and it does not support SQL joins or traditional relational schemas. Option C is wrong because Amazon EC2 with self-managed MySQL requires the company to manually configure and manage the database, including failover and read replicas, which contradicts the requirement for a 'fully managed' service. Option D is wrong because Amazon Redshift is a petabyte-scale data warehouse optimized for analytical queries, not a relational database for transactional web applications, and it does not provide automatic failover or read replicas in the same manner as RDS.

Practice this question →
90
Multi-Selectmedium

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.)

Select 2 answers
A.Use AWS DMS with full load and ongoing replication.
B.Export to flat files, transfer via AWS Snowball, and import.
C.Perform a mysqldump and restore to Aurora.
D.Use MySQL native replication to replicate to Aurora MySQL.
E.Use AWS SCT to convert the schema and then use DMS.
AnswersA, D

DMS supports CDC for minimal downtime.

Why this answer

Options B and D are correct. Option A is not minimal downtime. Option C is incorrect because SCT is for schema conversion, not data migration.

Option E is incorrect because Snowball is not minimal downtime (requires downtime for transport).

Practice this question →
91
MCQeasy

A company wants to deploy a highly available Amazon RDS for MySQL database across two Availability Zones. Which feature should be enabled?

A.Read replicas in a different AZ
B.Automated backups with retention
C.Enhanced Monitoring
D.Multi-AZ deployment
AnswerD

Multi-AZ provides synchronous standby for automatic failover.

Why this answer

Option A is correct because Multi-AZ deployment provides automatic failover to a standby in a different AZ. Option B is wrong because read replicas are for read scaling, not high availability. Option C is wrong because automatic backups are for point-in-time recovery.

Option D is wrong because Enhanced Monitoring provides metrics, not HA.

Practice this question →
92
MCQeasy

A developer is configuring an RDS for PostgreSQL instance for a new application. The application requires automatic failover to a standby instance in a different Availability Zone. Which deployment option should be selected?

A.Deploy a Single-AZ instance with a read replica.
B.Deploy a Multi-AZ instance.
C.Deploy a Single-AZ instance and take frequent snapshots.
D.Deploy a Single-AZ instance with a cross-region read replica.
AnswerB

Multi-AZ provides automatic failover.

Why this answer

Option B is correct because Multi-AZ deployment provides automatic failover to a standby in a different AZ. Option A is wrong because read replicas are for read scaling, not automatic failover. Option C is wrong because a single-AZ deployment lacks failover.

Option D is wrong because RDS does not have a 'Cross-Region Standby' deployment option; Cross-Region Read Replicas are for disaster recovery but don't provide automatic failover.

Practice this question →
93
MCQhard

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?

A.AWS Schema Conversion Tool (AWS SCT)
B.AWS Database Migration Service (AWS DMS)
C.AWS Direct Connect
D.Amazon RDS Read Replica
AnswerB

AWS DMS supports ongoing replication from on-premises to RDS, enabling minimal downtime migrations.

Why this answer

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.

Practice this question →
94
MCQeasy

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?

A.The EC2 instance is in a different VPC and needs a VPN connection.
B.The security group for the DB instance does not allow inbound traffic from the EC2 instance's security group.
C.The DB instance endpoint is incorrect.
D.The DB instance is not publicly accessible.
AnswerB

Security group rules control access; if not configured, connections are blocked.

Why this answer

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.

Practice this question →
95
MCQhard

A company is deploying a new application that requires a globally distributed database with low latency reads. They choose Amazon DynamoDB global tables. What is a key consideration for this deployment?

A.Writes are synchronously replicated to all regions.
B.Each replica can serve reads and writes independently.
C.The table class must be DynamoDB Standard-Infrequent Access.
D.Global tables support strongly consistent reads from any region.
AnswerB

Global tables are multi-master; each region can handle both reads and writes.

Why this answer

DynamoDB global tables use active-active replication with eventual consistency. Writes are replicated asynchronously. Strongly consistent reads are only supported in the region where the write occurred.

Each replica can handle reads and writes. Table class is not region-specific.

Practice this question →
96
Multi-Selectmedium

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.)

Select 2 answers
A.DMS automatically converts Oracle stored procedures to RDS for Oracle compatible code.
B.DMS can continue to replicate changes after the full load is complete until the cutover.
C.DMS automatically converts partitioned tables to non-partitioned tables.
D.DMS can migrate directly to Amazon RDS Custom for Oracle without any configuration changes.
E.DMS can perform ongoing replication to minimize downtime during migration.
AnswersB, E

DMS supports ongoing replication for near-zero downtime.

Why this answer

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.

Exam trap

AWS often tests the misconception that AWS DMS can automatically convert database code (like stored procedures) or that it can handle all schema transformations without additional tools, but in reality DMS focuses on data migration and ongoing replication, while schema and code conversion requires AWS Schema Conversion Tool (SCT).

Practice this question →
97
MCQmedium

A company is migrating an on-premises Microsoft SQL Server database to Amazon RDS for SQL Server. The database uses SQL Server Agent jobs for ETL processes. After migration, the company needs to continue running these jobs. What is the MOST efficient way to manage these jobs in the AWS cloud?

A.Recreate the jobs as AWS Lambda functions and trigger them with Amazon CloudWatch Events.
B.Install SQL Server Agent on an Amazon EC2 instance and connect to RDS.
C.Use the AWS Schema Conversion Tool (AWS SCT) to convert the jobs to PostgreSQL functions.
D.Use AWS Database Migration Service (AWS DMS) tasks to replicate the jobs.
AnswerA

AWS Lambda can run ETL jobs and be scheduled via CloudWatch Events, replacing SQL Server Agent.

Why this answer

AWS Lambda functions triggered by Amazon CloudWatch Events (now Amazon EventBridge) provide a serverless, fully managed alternative to SQL Server Agent jobs. This approach eliminates the need to manage any compute infrastructure, as Lambda handles the execution of ETL logic directly against the RDS for SQL Server instance. It is the most efficient because it requires no additional servers, reduces operational overhead, and integrates natively with AWS monitoring and scheduling services.

Exam trap

The trap here is that candidates assume SQL Server Agent can be installed on an EC2 instance to control RDS, but RDS does not allow external Agent connections, and the correct approach is to use a serverless scheduling service like EventBridge with Lambda to replicate the job logic.

How to eliminate wrong answers

Option B is wrong because SQL Server Agent cannot be installed on an EC2 instance to manage jobs on RDS; RDS for SQL Server does not expose the SQL Server Agent service to external instances, and jobs must be managed within RDS using its limited Agent support or via external automation. Option C is wrong because the AWS Schema Conversion Tool (AWS SCT) is designed to convert database schemas and code to different database engines, not to convert SQL Server Agent jobs to PostgreSQL functions, and the question specifies staying with SQL Server on RDS. Option D is wrong because AWS DMS is a service for migrating data between databases, not for managing or replicating SQL Server Agent jobs; DMS tasks handle ongoing replication of data changes, not job scheduling or execution logic.

Practice this question →
98
Multi-Selecthard

A company is migrating a 1 TB SQL Server database to Amazon RDS for SQL Server. The migration requires minimal downtime and must support ongoing changes. Which TWO AWS services should be used together to achieve this? (Choose two.)

Select 2 answers
A.AWS Schema Conversion Tool (AWS SCT) and AWS Snowball
B.AWS Database Migration Service (AWS DMS) and AWS Direct Connect
C.AWS Database Migration Service (AWS DMS) and AWS Lambda
D.AWS Database Migration Service (AWS DMS) and AWS Schema Conversion Tool (AWS SCT)
E.AWS Database Migration Service (AWS DMS) and AWS Snowball
AnswersD, E

DMS handles ongoing replication; SCT helps with schema conversion for compatibility.

Why this answer

AWS DMS is the primary service for database migration with minimal downtime and ongoing replication. AWS SCT is used to convert the schema from SQL Server to RDS SQL Server (which may not need conversion) but more importantly to assess and convert any incompatible objects. However, for a like-to-like migration (SQL Server to SQL Server), SCT may not be required, but the question says 'migrating' and 'ongoing changes', so DMS is necessary.

For minimal downtime, DMS uses Change Data Capture (CDC). To use CDC on SQL Server, you need to enable it, and SCT can help with schema conversion if needed. But the best pair is DMS and SCT because SCT can help with any schema incompatibilities and DMS handles data.

Option A (DMS + SCT) is the standard recommendation for heterogeneous and homogeneous migrations. Option B (DMS + Snowball) is for large initial loads, but with 1 TB and minimal downtime, DMS alone may suffice. Option C (SCT + Snowball) doesn't include DMS for ongoing replication.

Option D (DMS + Direct Connect) is about network, not a service. Option E (DMS + Lambda) is not typical. So correct is A and B? Wait: The question asks for TWO services.

The typical best practice for minimal downtime is to use DMS with ongoing replication. For large databases, you might use Snowball for initial load and then DMS for CDC. So DMS and Snowball is a valid combination.

Also DMS and SCT is also valid for schema conversion. Which two are correct? The question is 'Which TWO' and there are exactly two correct. I'll set correct options as A and B, but need to ensure exactly two.

I'll make A: DMS and SCT, B: DMS and Snowball. Both are valid. But the stem says 'must support ongoing changes', so DMS is needed.

SCT is for schema conversion, which may be needed but not always. Snowball is for initial load. Both are valid.

I'll choose A and B as correct. Explanation: DMS is required for ongoing replication; SCT helps with schema conversion; Snowball helps with initial load for large databases.

Practice this question →
99
MCQmedium

A company wants to migrate an on-premises MySQL database to Amazon RDS for MySQL with minimal downtime. The database is 500 GB and has moderate write activity. Which approach is MOST suitable?

A.Use AWS Database Migration Service (DMS) with a full load and ongoing replication.
B.Use mysqldump to export the database, then import into RDS.
C.Use AWS Server Migration Service (SMS) to migrate the database server.
D.Create a read replica of the on-premises database and promote it to RDS.
AnswerA

DMS supports ongoing replication to minimize downtime.

Why this answer

Option C is correct because AWS DMS with ongoing replication allows continuous data synchronization from on-premises to RDS, enabling a cutover with minimal downtime. Option A is wrong because taking a snapshot of the on-premises database and restoring to RDS would require downtime during backup and restore, and does not capture ongoing changes. Option B is wrong because AWS Database Migration Service (DMS) supports homogeneous migrations like MySQL to MySQL, not just heterogeneous.

Option D is wrong because exporting to a dump file and importing requires downtime and does not handle ongoing writes.

Practice this question →
100
MCQmedium

A company is migrating an on-premises Oracle database to Amazon RDS for Oracle. The database uses Oracle Data Pump for export/import. The migration must be completed within a short maintenance window. Which migration approach should they use?

A.Use AWS Snowball to transfer the database files to AWS and then restore to RDS.
B.Use AWS Database Migration Service with full load and change data capture (CDC).
C.Use Oracle Data Pump to export the database and import into RDS.
D.Use AWS Schema Conversion Tool (SCT) to convert the schema and then use DMS for data migration.
AnswerB

DMS with CDC minimizes downtime by replicating changes until cutover.

Why this answer

Option A (Use AWS DMS with a full load + CDC) is correct because it minimizes downtime by capturing changes. Option B (Use Oracle Data Pump export/import) requires significant downtime. Option C (Use AWS SCT to convert schema and then use DMS) is unnecessary if staying on Oracle.

Option D (Use AWS Snowball) is for large data transfers, not for minimal downtime.

Practice this question →
101
MCQhard

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?

A.The source DB instance does not have backup retention enabled.
B.The source DB instance is not publicly accessible.
C.The replica instance class db.r5.large is not available in us-west-2.
D.The replica must use the same DB instance class as the source.
AnswerA

Cross-region read replicas require automated backups enabled on the source.

Why this answer

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.

Practice this question →
102
MCQeasy

A company is migrating an on-premises MySQL database to Amazon RDS for MySQL. The database is 500 GB in size and has a 24-hour maintenance window. Which AWS service or tool should be used for the initial data transfer with minimal downtime?

A.Amazon S3 with AWS Glue
B.AWS Snowball Edge
C.AWS Database Migration Service (DMS)
D.mysqldump and restore to RDS
AnswerC

DMS supports ongoing replication from on-premises to RDS, minimizing downtime.

Why this answer

AWS Database Migration Service (DMS) supports ongoing replication to minimize downtime during migration. Option B is wrong because AWS Snowball is for large data transfers but does not support continuous replication. Option C is wrong because S3 is not directly used for database migration.

Option D is wrong because RDS does not support native MySQL replication from on-premises without DMS.

Practice this question →
103
MCQhard

A company is deploying a new Amazon RDS for SQL Server DB instance with Multi-AZ. The database will be used by a critical application that requires minimal downtime during failover. The application uses a single connection string with the CNAME of the RDS endpoint. During a recent failover test, the application experienced a 3-minute timeout. The DBA wants to reduce the failover time. The current RDS instance is db.r5.large with 100 GB gp2 storage. The application is hosted on EC2 in the same VPC. Which change would MOST effectively reduce the failover time?

A.Change the storage to Provisioned IOPS (io1)
B.Change the instance type to db.r5.xlarge
C.Configure the application to use a low TTL for DNS lookups and implement connection retries
D.Use a read replica with automatic failover
AnswerC

Low TTL ensures the DNS record is refreshed quickly, reducing failover time.

Why this answer

Option A is correct because Multi-AZ failover typically completes within 1-2 minutes; the 3-minute timeout may be due to DNS caching. Enabling TTL=5 on the application side for DNS lookups can reduce failover time. Option B is wrong because increasing instance size does not directly reduce failover time.

Option C is wrong because Provisioned IOPS does not reduce failover time. Option D is wrong because read replicas do not provide automatic failover.

Practice this question →
104
MCQhard

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?

A.Reduce the number of tables being migrated to lower the load.
B.Upgrade the DMS replication instance to a larger size to increase throughput.
C.Pause the migration and restart it on Monday during low activity.
D.Switch to use AWS Snowball to transfer data and bypass DMS.
AnswerB

Larger instance can handle more write transactions.

Why this answer

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.

Practice this question →
105
MCQhard

A company is deploying a multi-region application with Amazon Aurora Global Database. They need to ensure that the secondary region can be promoted to primary with minimal data loss in the event of a regional failure. Which configuration should they use?

A.Deploy Amazon Aurora Serverless with cross-Region replication.
B.Deploy Amazon Aurora Global Database with one primary Region and up to five secondary Regions.
C.Deploy Amazon RDS for MySQL with cross-Region read replicas.
D.Deploy Amazon RDS for PostgreSQL with Multi-AZ and cross-Region snapshot copy.
AnswerB

Aurora Global Database provides low-latency reads and managed failover with minimal data loss.

Why this answer

Option B (Aurora Global Database with one primary and up to five secondary regions) is correct because it provides failover with typically less than 1 second of data loss. Option A (Cross-Region Read Replicas) is not Aurora Global Database. Option C (Multi-AZ) is within a region.

Option D (Aurora Serverless) does not support global databases.

Practice this question →
106
MCQeasy

A company has a 100 GB MySQL database on an EC2 instance. They want to migrate to Amazon RDS for MySQL with minimal downtime. They have set up replication from the source to the target using MySQL native replication. After enabling replication, the 'Seconds_Behind_Master' value is increasing. The source database is write-heavy. What should the team do to reduce replication lag?

A.Tune the source database to reduce write load.
B.Enable Multi-AZ on the RDS instance.
C.Increase the RDS instance size to a larger instance class.
D.Switch to AWS DMS for migration.
AnswerC

More CPU and I/O capacity reduces apply lag.

Why this answer

Option B is correct: using a larger RDS instance class provides more resources to apply changes. Option A is wrong because enabling Multi-AZ does not improve replication performance. Option C is wrong because DMS is not needed.

Option D is wrong because tuning the source may help but the target is the bottleneck.

Practice this question →
107
MCQhard

A company is running a production PostgreSQL database on an EC2 instance (db.m5.xlarge) with 500 GB of gp2 EBS storage. The database is used by a customer-facing application that requires low latency. The company plans to migrate this database to Amazon RDS for PostgreSQL with minimal downtime. The current database has a high write load with frequent updates and deletes, and the table sizes are growing. The company also wants to enable Multi-AZ for high availability and use read replicas for reporting workloads. During migration planning, they discover that the source database has several large unlogged tables and uses custom PostgreSQL extensions that are not available in RDS. Which migration strategy should the company use to minimize downtime and meet all requirements?

A.Use AWS DMS with ongoing replication, convert unlogged tables to logged tables, and migrate custom extensions using AWS SCT.
B.Use pg_dump to export the database and pg_restore to import into RDS, then set up read replicas.
C.Copy the database files to Amazon S3, then use the rdsadmin.rdsadmin_restore_from_s3 procedure to restore to RDS.
D.Set up PostgreSQL streaming replication from the EC2 instance to an RDS read replica, then promote the replica.
AnswerA

DMS can handle unlogged tables by replicating data as regular tables, and SCT can suggest alternatives for unsupported extensions.

Why this answer

Option B is correct because AWS DMS can migrate data while converting the unlogged tables to logged tables (since DMS replicates changes) and can handle custom extensions by focusing on schema conversion. Option A is wrong because unlogged tables cannot be replicated via streaming replication. Option C is wrong because native pg_dump/pg_restore is offline and would cause downtime.

Option D is wrong because S3 copy is not a supported migration method.

Practice this question →
108
MCQeasy

A company needs to migrate a 5 TB Oracle database to Amazon Aurora PostgreSQL. The company has a limited maintenance window and requires the migration to be completed within a few hours. Which approach should be used?

A.Use AWS Schema Conversion Tool (AWS SCT) to convert the schema and AWS DMS for data migration
B.Use pg_dump to export the Oracle database and pg_restore to import into Aurora
C.Use AWS Database Migration Service (AWS DMS) to migrate the data
D.Use AWS S3 to store the data and AWS Glue to transform and load into Aurora
AnswerC

AWS DMS supports heterogeneous migrations from Oracle to Aurora PostgreSQL.

Why this answer

AWS DMS can handle large data migrations efficiently. Option A is incorrect because pg_dump is for PostgreSQL, not Oracle. Option C is incorrect because S3 is not suitable for direct database migration.

Option D is incorrect because AWS SCT is for schema conversion, not data migration.

Practice this question →
109
MCQeasy

A company wants to deploy an Amazon RDS for MySQL database for a new application. The database must be highly available with automatic failover. Which configuration should they choose?

A.Deploy a single-AZ instance with automated backups
B.Deploy a cross-region replica
C.Deploy a single-AZ instance with a read replica
D.Deploy a Multi-AZ instance with a standby replica
AnswerD

Multi-AZ provides automatic failover to the standby.

Why this answer

Multi-AZ deployment provides automatic failover to a standby in a different AZ. Option A (single-AZ) does not provide HA. Option C (read replicas) do not provide automatic failover.

Option D (cross-region) is for DR, not HA.

Practice this question →
110
MCQmedium

A company is migrating a 200 GB PostgreSQL database to Amazon Aurora PostgreSQL. They want to use the AWS DMS console to create a migration task. The source database is in a VPC and the target Aurora cluster is in the same VPC. The DMS replication instance is also in the same VPC. The source database is publicly accessible. What additional configuration is required to enable connectivity between DMS and the source database?

A.Associate the DMS replication instance with a subnet group that includes public subnets.
B.Place the source database in the same public subnet as the DMS replication instance.
C.Create a VPC endpoint for the source database service.
D.Configure the source database's security group to allow inbound traffic from the DMS replication instance's security group.
AnswerD

The security group must allow traffic from DMS to reach the database.

Why this answer

Option D is correct because even though the source is publicly accessible, DMS is in a VPC and cannot directly access public IPs unless the VPC has an internet gateway and the route table allows it. The security group of the source must allow inbound traffic from the DMS replication instance's security group. Option A is wrong because DMS does not require a VPC endpoint for source connectivity.

Option B is wrong because the replication instance subnet group is already set. Option C is wrong because the source database should not be in public subnet; it can be private with proper routing.

Practice this question →
111
MCQmedium

A company is deploying a new multi-AZ Amazon RDS for PostgreSQL database. The security team requires that all traffic to the database be encrypted in transit. Which configuration ensures this?

A.Use a customer master key (CMK) for RDS
B.Enable SSL/TLS and require client connections to use SSL
C.Place the RDS instance in a public subnet
D.Enable encryption at rest using AWS KMS
AnswerB

SSL/TLS encrypts data in transit.

Why this answer

Enabling SSL/TLS and enforcing that client connections use SSL ensures encryption in transit. Option A (encryption at rest) does not cover transit. Option B (default VPC) does not enforce encryption.

Option D (KMS) is for encryption at rest.

Practice this question →
112
MCQmedium

Refer to the exhibit. A company is creating an Aurora MySQL cluster using the AWS CLI. The command fails with an error. The company has a default KMS key but the command specifies a customer-managed KMS key. What is the most likely cause of the failure?

A.The IAM user does not have permission to use the specified KMS key
B.The --kms-key-id parameter is not supported for aurora-mysql engine
C.The KMS key does not exist
D.The KMS key is in a different region
AnswerA

Permission to use the KMS key is required.

Why this answer

Option B is correct because the IAM role used to run the CLI command must have permission to use the specified KMS key. The error is likely due to missing KMS permissions. Option A is wrong because the --kms-key-id parameter is valid for Aurora clusters.

Option C is wrong because the key exists; the issue is permissions. Option D is wrong because KMS keys can be used across regions if configured, but the error is more likely due to permissions.

Practice this question →
113
MCQhard

A financial services company is migrating a 10 TB Oracle data warehouse to Amazon Redshift. The source database uses a combination of partitioned tables, indexes, and materialized views. The migration team plans to use AWS SCT and DMS. Which approach should the team take to optimize query performance after migration?

A.Create indexes on frequently queried columns
B.Recreate all materialized views using standard views
C.Define appropriate distribution keys and sort keys
D.Partition tables by date using the PARTITION BY clause
AnswerC

These are the primary performance optimization mechanisms in Redshift.

Why this answer

Option D is correct because Redshift uses distribution keys and sort keys for performance, not traditional indexes. Option A is wrong because Redshift does not support materialized views in the same way. Option B is wrong because indexes are not used in Redshift.

Option C is wrong because partitioning in Redshift is done via distribution and sort keys, not like Oracle.

Practice this question →
114
Multi-Selecteasy

Which TWO AWS services can be used to migrate an on-premises SQL Server database to Amazon RDS for SQL Server?

Select 2 answers
A.AWS DataSync
B.AWS DMS
C.Native SQL Server backup to S3 and restore to RDS
D.AWS Storage Gateway
E.AWS DynamoDB
AnswersB, C

DMS supports SQL Server as source and target.

Why this answer

Correct: A (AWS DMS) and C (native backup/restore to S3). B is for NoSQL; D is for file storage; E is for data transfer between on-premises and S3, not database migration.

Practice this question →
115
MCQeasy

A company is migrating an on-premises MongoDB database to Amazon DocumentDB. The migration must be online with minimal downtime. Which AWS service should be used?

A.AWS DataSync
B.AWS DMS
C.AWS S3
D.AWS Snowball Edge
AnswerB

DMS supports MongoDB to DocumentDB with CDC for minimal downtime.

Why this answer

Option B is correct because AWS DMS supports MongoDB as a source and DocumentDB as a target with ongoing replication. Option A is wrong because Snowball is offline. Option C is wrong because S3 is not a migration tool.

Option D is wrong because DataSync is for file storage.

Practice this question →
116
MCQmedium

A company is deploying a new multi-AZ Aurora MySQL database. The application requires read-heavy workloads and low latency. Which configuration will best meet these requirements?

A.Enable Multi-AZ and use the secondary for read traffic.
B.Deploy a single instance with one read replica in the same AZ.
C.Enable Aurora Auto Scaling with a target metric of average CPU utilization.
D.Use an RDS Proxy in front of the database.
AnswerC

Aurora Auto Scaling adds reader instances automatically to handle read-heavy workloads, improving latency.

Why this answer

Option C is correct because Aurora Auto Scaling dynamically adds reader instances based on the average CPU utilization metric, which directly addresses the read-heavy workload requirement by distributing read traffic across multiple replicas. This configuration ensures low latency by scaling out read capacity automatically as demand increases, without manual intervention.

Exam trap

The trap here is that candidates confuse Multi-AZ with read scaling, assuming the standby instance can serve reads, but in Aurora Multi-AZ, the secondary is a writer instance for failover only, not a reader.

How to eliminate wrong answers

Option A is wrong because in Aurora Multi-AZ, the secondary (writer) instance is not used for read traffic; it only provides failover support, and using it for reads would degrade write performance and violate Aurora's architecture. Option B is wrong because deploying a single instance with one read replica in the same AZ does not provide high availability or fault tolerance, and a single replica cannot handle heavy read loads effectively, leading to potential latency issues. Option D is wrong because RDS Proxy manages connection pooling and reduces database load from connection churn, but it does not directly address read-heavy workloads or scale read capacity; it is a connection management tool, not a read scaling solution.

Practice this question →
117
MCQmedium

A company is deploying a new web application on AWS. The application uses Amazon RDS for MySQL as its database. The database must be highly available and automatically failover in the event of an AZ outage. The company also needs to offload read traffic from the primary database to improve performance. The application read-to-write ratio is 80:20. The database workload is variable, with occasional spikes. The company wants a cost-effective solution that scales read capacity automatically. The operations team has limited experience with AWS. Which solution should the company implement?

A.Deploy an RDS for MySQL instance with Multi-AZ and one or more read replicas, and use Application Auto Scaling to add replicas based on CPU utilization
B.Deploy an RDS for MySQL instance with Multi-AZ and enable automatic scaling of the instance size
C.Deploy an Amazon Aurora MySQL cluster with Multi-AZ and enable Aurora Auto Scaling for read replicas
D.Deploy an RDS for MySQL instance with multiple read replicas and use a custom script to promote a read replica in case of failure
AnswerC

Aurora provides automatic failover and auto-scaling of read replicas, and is MySQL-compatible, making it a cost-effective and simpler solution.

Why this answer

Multi-AZ provides automatic failover. Read replicas offload read traffic. However, read replicas do not auto-scale automatically; you need to add replicas manually or use auto-scaling with a custom solution.

But given limited experience, the simplest solution is to use Multi-AZ and one or more read replicas. Option C (Multi-AZ with read replicas and Application Auto Scaling) is the most complete, but Application Auto Scaling for read replicas requires custom metrics. Option D (Aurora with Auto Scaling) is simpler because Aurora Auto Scaling automatically adds/removes read replicas based on CPU or connections.

Aurora is MySQL-compatible and provides better performance and scalability. For limited experience, Aurora is a better choice. Option A (Multi-AZ only) does not offload reads.

Option B (Read replicas only) lacks automatic failover. So the best is D.

Practice this question →
118
Multi-Selectmedium

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.)

Select 2 answers
A.AWS Snowball Edge
B.AWS Schema Conversion Tool (SCT)
C.AWS Database Migration Service (DMS)
D.AWS Data Pipeline
E.Amazon EC2 with Oracle installed
AnswersB, C

SCT converts Oracle schema to Aurora MySQL.

Why this answer

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.

Practice this question →
119
MCQhard

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?

A.Multi-AZ deployment without Read Replicas
B.Single-AZ with a Read Replica in the same region
C.Multiple Read Replicas in different regions
D.Multi-AZ deployment with one or more Read Replicas
AnswerD

Provides HA and read scaling.

Why this answer

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.

Practice this question →
120
Multi-Selecthard

A company is deploying a new Amazon RDS for Oracle database in a VPC. The database must be accessed by an application running on an EC2 instance in a different subnet. Which THREE steps are required to allow this access?

Select 3 answers
A.Create a VPC peering connection between the subnets.
B.Attach an Internet Gateway to the VPC.
C.Configure the network ACL for the RDS subnet to allow inbound traffic from the EC2 subnet.
D.Ensure the VPC has the 'Enable DNS hostnames' attribute set to true.
E.Add an inbound rule to the RDS security group that allows traffic from the EC2 security group.
AnswersC, D, E

NACLs provide stateless filtering.

Why this answer

The security group of the RDS instance must allow inbound traffic from the EC2 security group. The VPC must have an association between subnets. The network ACLs must allow inbound traffic.

Option D (Internet Gateway) is not needed for private connectivity. Option E (VPC peering) is not needed if in same VPC.

Practice this question →
121
Multi-Selectmedium

A company needs to migrate a 1 TB Oracle database to Amazon RDS for Oracle. The migration must have minimal downtime and the source database is running on-premises. Which TWO AWS services should be used together to achieve this?

Select 2 answers
A.AWS Database Migration Service (DMS)
B.AWS Schema Conversion Tool (SCT)
C.AWS CloudEndure Migration
D.AWS Snowball
E.AWS Direct Connect
AnswersA, B

DMS supports ongoing replication for minimal downtime.

Why this answer

Options B and D are correct. AWS DMS (B) can perform the initial full load and ongoing replication, while AWS SCT (D) can help convert the Oracle schema to be compatible with RDS. Option A is wrong because Snowball is for large offline data transfer, not for minimal downtime migration with ongoing replication.

Option C is wrong because Direct Connect is a network service, not a migration service. Option E is wrong because CloudEndure is for server migration, not database migration.

Practice this question →
122
MCQeasy

A company wants to deploy a DynamoDB table that requires consistent single-digit millisecond latency regardless of traffic spikes. Which DynamoDB capacity mode should be selected?

A.DynamoDB Accelerator (DAX) enabled.
B.Provisioned capacity mode with auto scaling.
C.On-demand capacity mode.
D.Provisioned capacity mode with fixed read/write capacity.
AnswerC

Automatically scales to handle any traffic level.

Why this answer

Option D is correct because on-demand mode automatically scales to handle traffic spikes while maintaining latency. Option A is wrong because provisioned mode can throttle if capacity is exceeded. Option B is wrong because provisioned with auto scaling still has a maximum capacity.

Option C is wrong because global tables are for multi-region replication, not for handling spikes.

Practice this question →
123
MCQmedium

Refer to the exhibit. An IAM policy is attached to an IAM user that performs database migrations. When the user tries to start an AWS DMS replication task that writes to the RDS instance 'targetdb', the task fails with an access denied error. Which additional permission is required?

A.dms:CreateEndpoint
B.dms:CreateReplicationInstance
C.dms:DescribeReplicationInstances
D.rds:ModifyDBInstance on the source database
AnswerC

The user may need to describe replication instances to select one for the task.

Why this answer

The policy allows dms:StartReplicationTask but does not include the necessary DMS permissions for the replication instance or endpoints. Specifically, the user needs dms:CreateReplicationInstance and dms:CreateEndpoint. Also, the task may need to pass a role.

But from the error, likely missing dms:StartReplicationTask? No, that's allowed. The error might be due to missing dms:CreateReplicationTask? That is allowed. Actually, the task might need to describe endpoints or replication instances.

The missing permission is likely dms:DescribeReplicationInstances or dms:DescribeEndpoints. However, the most common missing permission is dms:DescribeReplicationInstances to list available instances. Option D (dms:DescribeReplicationInstances) is plausible.

Option A (rds:ModifyDBInstance) is allowed for targetdb. Option B (dms:CreateReplicationInstance) is not needed if instance exists. Option C (dms:CreateEndpoint) is needed if endpoint not created.

But the exhibit shows the task already created? The user might need to describe replication instances to choose one. However, the task was started, so the instance must exist. The most likely missing permission is dms:DescribeReplicationInstances.

Practice this question →
124
MCQmedium

A company is migrating a 2 TB Oracle database to Amazon Aurora PostgreSQL. They need to minimize downtime and ensure data consistency. Which migration strategy should they use?

A.Use AWS DMS with full load only, then cut over during a maintenance window.
B.Use AWS DMS with ongoing replication (change data capture) from Oracle to Aurora.
C.Export the database to Amazon S3 using Oracle Data Pump, then import into Aurora.
D.Use pg_dump to export the database and pg_restore to import into Aurora.
AnswerB

DMS CDC captures ongoing changes, allowing near-zero downtime migration.

Why this answer

Option C is correct because AWS DMS with ongoing replication allows continuous data sync, minimizing downtime. Option A is wrong because exporting to CSV and importing is manual and not suitable for minimal downtime. Option B is wrong because native PostgreSQL pg_dump/pg_restore requires downtime.

Option D is wrong because S3 transfer is for file-based data, not live databases.

Practice this question →
125
MCQhard

A company is planning to migrate a 5 TB Oracle data warehouse to Amazon Redshift. They need to transform the data during migration. Which AWS service should they use to perform the transformation?

A.Amazon Kinesis Data Analytics for real-time transformation.
B.Amazon Athena to query the source data and write results to Redshift.
C.AWS Glue to perform extract, transform, and load (ETL) jobs.
D.AWS Database Migration Service (DMS) with transformation rules.
AnswerC

Glue is a fully managed ETL service suitable for transforming data before loading into Redshift.

Why this answer

Option D is correct because AWS Glue is a serverless ETL service that can perform transformations. Option A is wrong because AWS DMS is for database migration with minimal transformation. Option B is wrong because Kinesis is for real-time streaming data.

Option C is wrong because Athena is a query service, not an ETL tool.

Practice this question →
126
MCQeasy

A company wants to migrate an on-premises MongoDB database to Amazon DocumentDB. The migration should be performed with minimal application changes. Which AWS service should be used?

A.Amazon S3 Transfer Acceleration
B.AWS DataSync
C.AWS Schema Conversion Tool (AWS SCT)
D.AWS Database Migration Service (AWS DMS)
AnswerD

AWS DMS can migrate data from MongoDB to DocumentDB with minimal application changes.

Why this answer

AWS DMS is the correct service because it supports homogeneous migrations from MongoDB to Amazon DocumentDB, including ongoing replication via change data capture (CDC) to minimize downtime. It handles schema conversion automatically for compatible data types, requiring minimal application changes since DocumentDB is MongoDB-compatible. AWS DMS can migrate data directly from a MongoDB source to a DocumentDB target without needing an intermediate schema transformation tool.

Exam trap

The trap here is that candidates may choose AWS SCT thinking schema conversion is always required, but for a homogeneous migration to a MongoDB-compatible target like DocumentDB, AWS DMS alone handles both schema and data migration without needing SCT.

How to eliminate wrong answers

Option A is wrong because Amazon S3 Transfer Acceleration is used to speed up uploads to S3 over long distances, not for database migration or replication. Option B is wrong because AWS DataSync is designed for moving large datasets between on-premises storage and AWS storage services (e.g., S3, EFS, FSx), not for database migration or ongoing replication. Option C is wrong because AWS Schema Conversion Tool (AWS SCT) is used for heterogeneous database migrations (e.g., Oracle to Aurora) to convert schema and code, but it is not needed for a homogeneous migration from MongoDB to DocumentDB, and it does not perform the actual data migration.

Practice this question →
127
MCQhard

A company is migrating a 2 TB Oracle database running on an on-premises Linux server to Amazon RDS for Oracle. The migration must have minimal downtime and must be fully reversible if any issues arise. The DBA has configured AWS DMS with a full load and ongoing replication task. The full load completes successfully, and CDC is replicating changes. During the cutover window, the DBA stops the source database and promotes the target RDS instance. However, after cutover, the application team reports that some recent transactions are missing from the target database. The DBA confirms that the DMS task showed a 'healthy' status before stopping. Which action should the DBA take to resolve the issue and prevent recurrence?

A.Rebuild the entire migration using a native Oracle export/import tool.
B.Increase the replication instance size to improve throughput.
C.Restart the DMS task from the beginning to recapture the missing data.
D.Before stopping the source database, run the 'Stop task' command with the '--apply-immediately' option to ensure all cached changes are written to the target.
AnswerD

This ensures that all remaining CDC changes are applied before stopping.

Why this answer

Option B is correct. In a DMS migration, the final step should be to capture remaining changes after stopping the source database. This is done by running the 'Stop task' command with the '--apply-immediately' flag or by using the 'Last Stop' command in the console.

Option A is wrong because increasing the replication instance size does not address missing transactions. Option C is wrong because restarting the task does not capture the missed transactions; they were already lost. Option D is wrong because rebuilding the migration from scratch is time-consuming and does not address the root cause.

Practice this question →
128
MCQeasy

A company is deploying a new application that requires a highly available DynamoDB table with eventual consistency. The table will be accessed from multiple AWS Regions. What is the most appropriate deployment strategy?

A.Use DynamoDB auto scaling to handle regional traffic
B.Use DynamoDB Accelerator (DAX) to cache data across regions
C.Use DynamoDB global tables
D.Use DynamoDB Streams to replicate data to another region
AnswerC

Global tables provide managed multi-region replication with eventual consistency.

Why this answer

Option C is correct because DynamoDB global tables provide multi-region replication with eventual consistency, meeting the requirements. Option A is wrong because DynamoDB Accelerator (DAX) is a caching layer, not a multi-region solution. Option B is wrong because DynamoDB Streams can be used for cross-region replication but require custom code; global tables are the managed solution.

Option D is wrong because DynamoDB auto scaling adjusts capacity, not replication.

Practice this question →
129
MCQmedium

A company is migrating a 2 TB Oracle database from on-premises to Amazon RDS for Oracle. The database has a 4-hour maintenance window and the migration must have minimal downtime. Which AWS service should be used for the migration?

A.Use AWS Schema Conversion Tool (SCT) to convert the schema and then perform a full data load.
B.Create an RDS Cross-Region Read Replica and promote it to a standalone instance.
C.Use AWS Database Migration Service (DMS) with ongoing replication from the source database.
D.Take a full backup of the on-premises database, upload it to S3, and restore it to RDS.
AnswerC

AWS DMS can perform continuous replication, minimizing downtime.

Why this answer

AWS DMS with ongoing replication (change data capture) is the correct choice because it allows you to perform a full load of the 2 TB Oracle database and then continuously replicate incremental changes from the source to the target RDS instance. This minimizes downtime by enabling a cutover window of minutes rather than hours, which is critical given the 4-hour maintenance window constraint.

Exam trap

The trap here is that candidates often confuse AWS SCT with DMS, assuming SCT can handle ongoing replication, or they mistakenly think RDS Cross-Region Read Replicas can be created from an on-premises source, when in fact they only work between RDS instances.

How to eliminate wrong answers

Option A is wrong because AWS Schema Conversion Tool (SCT) is used for heterogeneous migrations (e.g., Oracle to Aurora PostgreSQL) and does not handle ongoing replication; it only converts schema and performs a one-time full load, which would cause extended downtime. Option B is wrong because RDS Cross-Region Read Replicas are only supported within RDS itself, not for on-premises databases; they cannot replicate from an external Oracle source. Option D is wrong because taking a full backup, uploading to S3, and restoring to RDS is a one-time bulk operation that does not capture ongoing changes, resulting in significant downtime during the backup and restore process.

Practice this question →
130
MCQmedium

A developer deploys the CloudFormation stack. After testing, they delete the stack. What happens to the RDS instance?

A.The RDS instance is retained and the stack deletion fails.
B.The RDS instance is deleted after a final snapshot is taken.
C.The RDS instance is deleted without a final snapshot.
D.The RDS instance is retained and a final snapshot is taken automatically.
AnswerA

DeletionProtection causes the stack deletion to fail, retaining the instance.

Why this answer

Option D is correct because DeletionProtection is set to true, which prevents stack deletion from deleting the RDS instance. Option A is wrong because DeletionProtection prevents deletion. Option B is wrong because the instance is not deleted.

Option C is wrong because snapshot is not taken automatically due to DeletionProtection.

Practice this question →
131
MCQeasy

A company needs to migrate a 2 TB PostgreSQL database from an on-premises data center to Amazon Aurora PostgreSQL. The network bandwidth is limited to 100 Mbps. The migration window is 5 days. Which approach is most cost-effective and likely to succeed?

A.Use AWS DMS with a VPN connection to the on-premises database
B.Set up AWS Direct Connect and use DMS
C.Use AWS Snowball Edge to transfer data offline
D.Export to Amazon S3 and import into Aurora
AnswerA

DMS can migrate online within bandwidth constraints.

Why this answer

Using AWS DMS over a VPN connection allows online migration without physical devices. Snowball requires shipping time. Direct Connect has setup time and cost.

S3 import is not supported for Aurora PostgreSQL.

Practice this question →
132
MCQmedium

A company is migrating a 500 GB Oracle database to Amazon RDS for Oracle. The migration must be completed within 24 hours with minimal downtime. The on-premises network bandwidth is 1 Gbps. The migration team plans to use AWS DMS with ongoing replication. During the initial load, the DMS task fails with an error indicating that the source database is experiencing high CPU utilization. The source database is a production system serving live traffic. The team needs to reduce the impact on the source database while still meeting the migration deadline. Which approach should the team take?

A.Change the DMS task to perform only full load and skip ongoing replication
B.Reduce the number of tables loaded in parallel in the DMS task and schedule the migration during off-peak hours
C.Increase the size of the DMS replication instance to speed up the migration
D.Use AWS Snowball to transfer the data offline and then use DMS for ongoing replication
AnswerB

This reduces source CPU load and still meets the deadline if off-peak window is sufficient.

Why this answer

The issue is that DMS is consuming too many resources on the source. Reducing the number of tables loaded in parallel and scheduling the migration during off-peak hours will reduce CPU impact. Option B is the most balanced.

Option A (increase DMS instance size) would increase source CPU usage. Option C (change to full load only) would require downtime. Option D (use Snowball) may not meet the 24-hour deadline due to shipping time.

Practice this question →
133
MCQmedium

A company is migrating a 1 TB Amazon RDS for Oracle database to Amazon RDS for PostgreSQL. The migration must be completed within a 4-hour maintenance window. The database has a high volume of transactions. Which migration method minimizes risk of data loss?

A.Use AWS SCT to convert the schema, then use AWS DMS for full load and ongoing replication.
B.Set up Oracle log shipping to an EC2 instance, then restore to RDS PostgreSQL.
C.Use AWS DMS with a full load and change data capture (CDC) enabled, with task restart and validation.
D.Export the Oracle database using Data Pump, import to PostgreSQL using pgloader.
AnswerC

CDC captures ongoing changes, task restart ensures reliability.

Why this answer

AWS DMS with task restart and validation ensures data consistency and minimizes data loss. Option A (SCT + DMS) may not complete within 4 hours. Option C (export/import) is time-consuming.

Option D (log shipping) is not supported across engines.

Practice this question →
134
MCQeasy

A company is migrating a 100 GB SQL Server database to Amazon RDS for SQL Server. They need to minimize downtime and ensure that only the schema is converted. Which tool should they use?

A.AWS Database Migration Service (DMS)
B.AWS Schema Conversion Tool (SCT)
C.AWS DMS with schema conversion enabled
D.SQL Server Management Studio (SSMS)
AnswerB

SCT is designed to convert database schema from one engine to another.

Why this answer

AWS Schema Conversion Tool (SCT) is the correct choice because it is specifically designed to convert database schemas (including stored procedures, functions, and data types) from one engine to another, such as SQL Server to Amazon RDS for SQL Server. Since the requirement is to minimize downtime and only convert the schema (not migrate data), SCT can perform an offline schema conversion without impacting the source database, whereas DMS is a continuous data replication tool that would incur downtime for schema changes.

Exam trap

The trap here is that candidates often confuse AWS DMS (which handles data replication) with AWS SCT (which handles schema conversion), and assume DMS can perform schema-only migrations without realizing it always includes data transfer and potential downtime.

How to eliminate wrong answers

Option A is wrong because AWS DMS is primarily a data migration service that replicates ongoing changes and requires a full load of data, which would cause downtime and does not focus on schema-only conversion. Option C is wrong because DMS with schema conversion enabled still performs data migration and schema conversion together, leading to unnecessary downtime and data transfer when only schema conversion is needed. Option D is wrong because SQL Server Management Studio (SSMS) can generate schema scripts but does not automate conversion to RDS SQL Server's specific dialect or handle compatibility issues, and it would require manual intervention and potential downtime.

Practice this question →
135
MCQhard

A financial services company is migrating a 500 GB Oracle database to Amazon Aurora MySQL-Compatible Edition. The migration must have minimal downtime and support bidirectional replication for a test-and-cutover approach. The company currently uses Oracle GoldenGate for replication. Which migration strategy should be used?

A.Use AWS DMS with a full load and ongoing replication from Oracle to Aurora MySQL, then cut over.
B.Use AWS Schema Conversion Tool (SCT) to convert the schema and then use AWS DMS for a one-time full load.
C.Use AWS DMS with Oracle GoldenGate as a source for continuous replication to Aurora MySQL.
D.Use Oracle GoldenGate to replicate directly to Aurora MySQL, then cut over.
AnswerA

DMS supports ongoing replication for cross-engine migrations, enabling minimal downtime and test-and-cutover.

Why this answer

Option C is correct because AWS DMS supports ongoing replication from Oracle to Aurora MySQL, enabling a test-and-cutover approach with minimal downtime. Option A is wrong because the AWS Schema Conversion Tool (SCT) does not handle data replication. Option B is wrong because AWS DMS supports cross-engine migrations from Oracle to Aurora MySQL.

Option D is wrong because AWS DMS cannot use Oracle GoldenGate as a source; GoldenGate is a separate replication tool that is not directly integrated.

Practice this question →
136
MCQeasy

A company wants to migrate an on-premises MongoDB database to Amazon DocumentDB. The migration must be performed with minimal downtime and should support live data synchronization. Which AWS service should be used?

A.AWS Glue with streaming ETL jobs.
B.AWS Data Pipeline to schedule periodic data loads.
C.AWS S3 with AWS Lambda functions to sync data.
D.AWS Database Migration Service (DMS) with ongoing replication.
AnswerD

DMS can connect to MongoDB as source and DocumentDB as target with change data capture for minimal downtime.

Why this answer

Option A is correct because AWS DMS supports MongoDB as a source and DocumentDB as a target, and can perform live synchronization. Option B is wrong because Data Pipeline is for data processing, not live migration. Option C is wrong because Glue is for ETL, not ongoing replication.

Option D is wrong because S3 is for storage, not data replication.

Practice this question →
137
MCQhard

A company is migrating a 2 TB on-premises Microsoft SQL Server database to Amazon RDS for SQL Server. The migration must have minimal downtime. The company uses AWS DMS with ongoing CDC. During the full load phase, the DMS task fails with an error indicating that the source table 'Orders' has a large number of LOB columns and the task is running out of memory. The DMS replication instance is a dms.c4.large with 4 GB RAM. The company needs to complete the migration successfully. What should the company do?

A.Set the LOB chunk size to 64 KB in the task settings.
B.Increase the replication instance size to dms.c4.xlarge (8 GB RAM).
C.Split the 'Orders' table into multiple DMS tasks running in parallel.
D.Change the DMS task settings to disable LOB support for the 'Orders' table.
AnswerB

More memory allows handling large LOB columns without running out of memory.

Why this answer

Option B is correct because increasing the replication instance size provides more memory to handle LOB columns. Option A is wrong because disabling LOB support would truncate LOB data. Option C is wrong because using a smaller LOB chunk size reduces memory per LOB but may not solve the memory issue; increasing instance size is more direct.

Option D is wrong because using parallel tasks does not address memory constraints.

Practice this question →
138
MCQhard

Refer to the exhibit. A company is creating an IAM policy for a migration engineer who needs to perform a database migration from an on-premises SQL Server to Amazon RDS for SQL Server using AWS DMS. The policy is attached to the engineer's IAM user. Which additional permission is required for the engineer to create a DMS replication instance?

A.kms:CreateKey
B.dms:CreateEndpoint
C.s3:PutObject
D.ec2:CreateInstance (or equivalent)
AnswerD

DMS replication instances require EC2 permissions to be created.

Why this answer

Option A is correct because to create a DMS replication instance, the IAM user needs permissions to create EC2 instances, as replication instances run on EC2. The policy currently allows creating DMS tasks but not the replication instance itself. Option B is wrong because DMS endpoints do not require EC2 permissions.

Option C is wrong because S3 permissions are not needed for the replication instance. Option D is wrong because KMS permissions are for encryption keys, not for creating the replication instance.

Practice this question →
139
MCQeasy

A company is migrating an on-premises MySQL database to Amazon RDS for MySQL. The database has a table with 100 million rows. During the migration using AWS DMS, the full load phase is taking too long. What change can speed up the full load?

A.Increase the number of DMS task mappings (parallel threads)
B.Reduce the target RDS instance storage to minimize write latency
C.Increase the size of the source on-premises database instance
D.Disable LOB columns in the task settings
AnswerA

More threads can process data in parallel, speeding up full load.

Why this answer

Option B is correct because increasing the number of DMS task mappings (parallel threads) can improve throughput. Option A is wrong because reducing storage does not help. Option C is wrong because disabling LOBs is not always possible and may lose data.

Option D is wrong because increasing RDS instance size of the source doesn't affect DMS performance.

Practice this question →
140
MCQeasy

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 initial data load and ongoing replication?

A.AWS Database Migration Service (DMS)
B.AWS Snowball
C.AWS Direct Connect
D.AWS Schema Conversion Tool (SCT)
AnswerA

DMS supports full load and ongoing replication for minimal downtime.

Why this answer

AWS DMS can perform a full load and then continuously replicate changes to keep the target in sync with the source, enabling minimal downtime migration. SCT is used for schema conversion, not replication. Direct Connect provides network connectivity, not data migration.

Snowball is for offline data transfer and does not support ongoing replication.

Practice this question →
141
MCQhard

A company is migrating a 3 TB SQL Server database to Amazon RDS for SQL Server. The migration must be completed with less than 15 minutes of downtime. The company has set up AWS DMS with ongoing replication. During the final cutover, the DMS task fails with a 'Target error: Cannot insert duplicate key' error. What is the most likely cause?

A.The target table has an identity column that is not set to allow insert of explicit values.
B.The DMS task is not set to truncate the target before loading.
C.The source database transaction log is full.
D.The source database has a primary key violation.
AnswerA

If identity insert is off, DMS cannot insert source values, causing duplicate key errors.

Why this answer

Option D is correct because duplicate key errors in DMS often occur when there are identity columns or triggers on the target that generate values conflicting with the source. Option A is wrong because DMS handles primary key conflicts by default. Option B is wrong because DMS usually handles this if configured, but the error suggests target-side uniqueness.

Option C is wrong because transaction log size does not cause duplicate key errors.

Practice this question →
142
Multi-Selecthard

A company is deploying a new Amazon RDS for Oracle instance and needs to ensure high availability and automatic failover. Which TWO configurations should be used?

Select 2 answers
A.Read Replicas in a different Region
B.Multi-AZ deployment
C.Enhanced Monitoring
D.Automated backups with point-in-time recovery
E.Deletion protection
AnswersB, D

Multi-AZ provides automatic failover to a standby in another AZ.

Why this answer

Option B (Multi-AZ deployment) is correct because it provisions a synchronous standby replica in a different Availability Zone, enabling automatic failover without data loss when the primary instance fails. This meets the high availability and automatic failover requirements for Amazon RDS for Oracle.

Exam trap

The trap here is that candidates often confuse Read Replicas with Multi-AZ, assuming read replicas provide automatic failover, but they require manual promotion and do not offer synchronous replication or automatic failover.

Practice this question →
143
MCQmedium

A company is migrating a 1 TB Microsoft SQL Server database to Amazon RDS for SQL Server using native backup and restore. The DBA has taken a full backup of the source database and uploaded it to an S3 bucket. The DBA then uses the 'aws rds restore-db-instance-from-db-snapshot' CLI command to restore the backup to an RDS instance. The restore fails with an error: 'Could not find the specified backup file in the S3 bucket.' The DBA verifies that the backup file exists in the correct S3 bucket and that the IAM role used by RDS has permissions to access the bucket. What is the most likely cause of the failure?

A.The backup file has an incorrect file extension, such as .trn instead of .bak.
B.The backup file is not encrypted with AWS KMS.
C.The RDS instance is not configured to use native restore.
D.The backup file is not placed in the correct S3 bucket path that includes the account ID prefix.
AnswerD

RDS expects the backup file to be in a path like 'bucket-name/account-id/filename'. If missing, it cannot find the file.

Why this answer

Option C is correct. The backup file must be stored with a specific key prefix that includes the AWS account ID and the hyphen, e.g., '123456789012/mybackup.bak'. The error 'Could not find the specified backup file' often occurs when the file is not in the expected path.

Option A is wrong because the backup file does not need to be encrypted; native restore can handle unencrypted backups. Option B is wrong because RDS supports native restore from S3; the error is not about unsupported features. Option D is wrong because the backup file extension does not matter; RDS accepts both .bak and .trn files.

Practice this question →
144
Multi-Selecteasy

A company is migrating an on-premises MySQL database to Amazon RDS for MySQL. The database is 500 GB and the migration must have minimal downtime. Which TWO AWS services should be used together to accomplish this?

Select 2 answers
A.AWS App2Container
B.AWS CloudFormation
C.AWS DataSync
D.AWS Database Migration Service (AWS DMS)
E.AWS Schema Conversion Tool (AWS SCT)
AnswersD, E

AWS DMS handles data migration with minimal downtime.

Why this answer

AWS DMS provides data migration with ongoing replication, and AWS SCT can help convert schema if needed, but for homogeneous migration, DMS alone is sufficient. However, the combination is commonly used. Option C (CloudFormation) is for provisioning.

Option D (DataSync) is for file transfer. Option E (App2Container) is for containerization.

Practice this question →
145
MCQhard

A company is migrating a 10 TB PostgreSQL database from on-premises to Amazon RDS for PostgreSQL. They need to minimize downtime and have limited network bandwidth. Which approach is most appropriate?

A.Use AWS Database Migration Service (DMS) with a full load and ongoing replication to keep the target in sync.
B.Use pg_dump to export the database and pg_restore to import to RDS, then use DMS for replication.
C.Use AWS Snowball to transfer a physical backup to AWS, then use DMS for ongoing replication.
D.Use AWS Direct Connect to increase bandwidth and then use DMS for full load and replication.
AnswerC

Snowball handles the large initial load offline; DMS handles ongoing changes with minimal bandwidth.

Why this answer

Using AWS DMS for ongoing replication after a full load is the standard approach to minimize downtime. Snowball is suitable for large initial loads over limited bandwidth, but ongoing replication still requires DMS. Using only DMS replication may take too long for the initial load over slow bandwidth. pg_dump/pg_restore requires downtime during the dump and restore.

Practice this question →
146
MCQmedium

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

A.Use Percona XtraBackup to take a backup and restore to RDS
B.Use mysqldump to export and import data
C.Use AWS DMS with full load and change data capture (CDC)
D.Use AWS DataSync to copy database files
AnswerC

Minimizes downtime with CDC.

Why this answer

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.

Exam trap

The trap here is that candidates often choose mysqldump (Option B) because it is familiar, but they overlook its inability to handle CDC and the impracticality of exporting 5 TB with minimal downtime.

How to eliminate wrong answers

Option A is wrong because Percona XtraBackup creates a physical backup of the MySQL data files, but restoring to RDS requires additional steps like uploading to S3 and using the mysql_restore tool, which does not support CDC and thus cannot minimize downtime for a live database. Option B is wrong because mysqldump is a logical backup tool that exports data as SQL statements, which is extremely slow for 5 TB and requires the source database to be read-locked or offline during the export, causing significant downtime. Option D is wrong because AWS DataSync is designed for copying files over NFS or SMB, not for direct database migration; it cannot handle MySQL's internal file structure or ongoing transactional changes, and would require the database to be stopped to ensure consistency.

Practice this question →
147
MCQmedium

A company is migrating a 1 TB SQL Server database from on-premises to Amazon RDS for SQL Server. The database has a large table with a LOB column. The network bandwidth between the on-premises data center and AWS is limited to 50 Mbps. The migration must be completed within a week. Which approach should the company use?

A.Use BCP to export the LOB table to flat files and then import to RDS.
B.Use SQL Server native backup and restore to RDS.
C.Use AWS DMS with compression enabled.
D.Create a read replica of the on-premises database and promote it.
AnswerC

DMS supports compression to reduce data transfer time.

Why this answer

Option D is correct because AWS DMS can compress data during transfer, reducing the amount of data sent over the network, and can complete within a week even with a 50 Mbps connection. Option A is wrong because SQL Server native backup and restore requires the backup file to be transferred over the network, which may take too long with 50 Mbps. Option B is wrong because BCP export/import also transfers the entire data over the network.

Option C is wrong because creating a read replica is not possible from on-premises.

Practice this question →
148
MCQhard

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?

A.Switch to a full load only migration strategy.
B.Disable archiving on the source database.
C.Increase the DMS replication instance size to improve log reading speed.
D.Configure DMS to use an S3 bucket to store archived redo logs.
AnswerD

S3 acts as a buffer; DMS can read logs from S3 before they are deleted.

Why this answer

Option B is correct: using an S3 staging area to store archived logs temporarily gives DMS more time to read them. Option A is wrong because increasing instance size does not affect log retention. Option C is wrong because it would cause data loss.

Option D is wrong because changing to full load only would cause downtime.

Practice this question →
149
MCQhard

An administrator runs the CLI command shown in the exhibit and sees the output. The DB instance 'mydb' is currently running MySQL 5.7.22. What does the output indicate?

A.The master user password has been changed
B.The DB instance has failed to apply modifications
C.The DB instance is using a custom DB parameter group
D.The DB instance has a pending minor version upgrade to 5.7.23
AnswerD

The EngineVersion in PendingModifiedValues indicates a pending upgrade.

Why this answer

Option A is correct because the PendingModifiedValues show EngineVersion 5.7.23, indicating a pending minor version upgrade. Option B is wrong because the parameter group is the default, not custom. Option C is wrong because the password is pending modification, but the question asks about the version.

Option D is wrong because the output does not show a failure.

Practice this question →
150
MCQhard

A company needs to migrate a 10 TB SQL Server database from on-premises to Amazon RDS for SQL Server with minimal downtime. The database is heavily used with frequent write operations. Which migration strategy should be used?

A.Use native SQL Server backup and restore to Amazon S3, then restore to RDS.
B.Export the database to CSV files, upload to S3, and use the COPY command in RDS.
C.Use AWS Schema Conversion Tool (SCT) to convert the schema, then use AWS DMS for full load.
D.Use AWS DMS with ongoing replication from the on-premises database to RDS until cutover.
AnswerD

DMS ongoing replication enables minimal downtime by keeping the target current.

Why this answer

Option C is correct because AWS DMS with ongoing replication allows minimal downtime by keeping the target in sync until cutover. Option A is wrong because native backup/restore would require downtime and is not designed for minimal downtime. Option B is wrong because SCT is for schema conversion, not data migration.

Option D is wrong because exporting to CSV and using COPY is not suitable for large databases with minimal downtime.

Practice this question →
← PreviousPage 2 of 5 · 353 questions totalNext →

Ready to test yourself?

Try a timed practice session using only Deployment Migration questions.

Start 20-question session