Courseiva

CCNA Deployment and Migration Questions

53 of 353 questions · Page 5/5 · Deployment and Migration · Answers revealed

Practice these questionsDomain overviewAll questions
301
MCQhard

A company is migrating a self-hosted MongoDB replica set to Amazon DocumentDB. The source MongoDB is version 4.0, and the target DocumentDB is 3.6. The migration must be online with minimal downtime. Which approach should be taken?

A.Use AWS DMS with ongoing replication from MongoDB to DocumentDB.
B.Use a custom application to capture MongoDB oplog changes and apply to DocumentDB.
C.Configure DocumentDB as a replica of the MongoDB primary.
D.Export MongoDB collection data to JSON files, then import into DocumentDB.
AnswerB

Custom replication using oplog is a common approach for near-zero downtime.

Why this answer

Option D is correct because DocumentDB doesn't support change streams from MongoDB 4.0; using a custom replication tool is needed. Option A is wrong because DocumentDB has no native replication capability. Option B is wrong because DMS supports MongoDB to DocumentDB but only offline full load.

Option C is wrong because it requires downtime.

Practice this question →
302
MCQmedium

A company is migrating a 2 TB Oracle database to Amazon Aurora PostgreSQL. The on-premises database is 2 TB and the network link is 1 Gbps. The migration must complete within 48 hours with minimal data loss. The DBA has extracted the schema using AWS SCT and created an Aurora cluster. The DBA now needs to transfer the data. The DBA tried using AWS DMS over the network but estimates it will take 72 hours due to network overhead. The DBA also considered using an AWS Snowball Edge device but is concerned about the time to order and ship the device. Which approach should the DBA take to meet the deadline?

A.Use AWS DMS with change data capture and optimize the network by enabling compression
B.Use AWS S3 to upload the database dump and then load into Aurora
C.Use AWS Snowball Edge to transfer the database dump and then use DMS for change data capture
D.Use AWS DMS to perform a full load and then stop replication, accepting some data loss
AnswerC

Snowball Edge can transfer the bulk data faster than the network, and DMS can capture ongoing changes.

Why this answer

Option C is correct. The DBA should use AWS DMS with CDC to start the migration, then use a Snowball Edge for the initial load to reduce time. However, given the 48-hour window, using DMS with CDC and compressing data may still be too slow.

Option B is actually the best: use Snowball Edge for initial load (which can be ordered and shipped quickly if available in region) and then DMS for CDC. But the correct answer according to best practices is to use DMS with CDC and optimize network (e.g., using compression, increasing instance size). However, the scenario suggests DMS alone is too slow.

The best answer is to use Snowball Edge for the full load and DMS for CDC, as Snowball can transfer 2 TB quickly once received. Option A is wrong because it abandons CDC. Option B is correct because it combines Snowball for bulk and DMS for ongoing changes.

Option C is wrong because it only uses DMS. Option D is wrong because it uses S3 only.

Practice this question →
303
MCQhard

A company is migrating a 5 TB Oracle database to Amazon RDS for Oracle. The database has several large tables with LOB columns. The migration must have minimal downtime. Which approach should be taken?

A.Use Oracle GoldenGate to replicate data to RDS.
B.Use AWS DMS with LOB support and ongoing replication from Oracle to RDS.
C.Use Oracle Data Pump to export the database and import into RDS.
D.Copy the database files to Amazon S3 and use the rdsadmin.rds_restore_from_s3 procedure.
AnswerB

AWS DMS supports LOBs and can replicate changes continuously, minimizing downtime.

Why this answer

AWS DMS with LOB support and ongoing replication (change data capture, CDC) is the correct approach because it enables a near-zero downtime migration by continuously replicating changes from the source Oracle database to Amazon RDS for Oracle after an initial full load. DMS handles large LOB columns efficiently using its 'Full LOB mode' or 'Limited LOB mode' settings, which are critical for tables with LOB data. The combination of full load + CDC ensures minimal downtime, as the target remains synchronized until cutover.

Exam trap

The trap here is that candidates may choose Oracle GoldenGate (Option A) because it is a well-known replication tool, but the exam expects you to recognize that AWS DMS is the native, fully managed service designed for minimal-downtime migrations to RDS, and GoldenGate introduces unnecessary complexity and cost.

How to eliminate wrong answers

Option A is wrong because Oracle GoldenGate requires additional licensing costs and complex setup, and while it can achieve minimal downtime, it is not the simplest or most cost-effective AWS-native solution for this scenario; AWS DMS is the recommended service for database migrations to RDS. Option C is wrong because Oracle Data Pump is a logical export/import tool that requires the source database to be in a consistent state (often requiring downtime) and cannot provide ongoing replication, so it does not meet the minimal downtime requirement. Option D is wrong because the rdsadmin.rds_restore_from_s3 procedure is used for restoring physical backups (e.g., from RMAN or Oracle Transportable Tablespaces) to RDS, not for migrating a live database with minimal downtime, and it requires the database files to be in a specific format and typically involves downtime during the restore process.

Practice this question →
304
MCQmedium

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

A.Use AWS Snowball Edge to transfer backup files
B.Use AWS Schema Conversion Tool to convert schema and then bulk insert
C.Use AWS DMS with a full load and ongoing replication
D.Use native SQL Server backup to S3 and restore to RDS
AnswerC

Efficient and supports minimal downtime.

Why this answer

AWS DMS can migrate data efficiently and supports ongoing replication. Option C is correct. Option A (Native backup and restore) requires storage and manual steps.

Option B (SCT only) does not migrate data. Option D (Snowball) is for large data but adds latency.

Practice this question →
305
MCQeasy

A company is migrating an on-premises MongoDB database to Amazon DocumentDB (with MongoDB compatibility). Which AWS service can perform the migration with minimal downtime using ongoing replication?

A.AWS Database Migration Service (AWS DMS)
B.Amazon CloudWatch
C.AWS Schema Conversion Tool (AWS SCT)
D.AWS Glue
AnswerA

DMS supports MongoDB to DocumentDB migration with ongoing replication.

Why this answer

Option A is correct because AWS DMS supports MongoDB as a source and DocumentDB as a target, with ongoing replication via change streams. Option B is wrong because AWS SCT is for schema conversion, not data migration. Option C is wrong because AWS Glue is an ETL service, not specialized for database migration with ongoing replication.

Option D is wrong because Amazon CloudWatch is a monitoring service.

Practice this question →
306
MCQmedium

A company is migrating an on-premises PostgreSQL database to Amazon RDS for PostgreSQL. The database is 2 TB and has a sustained write rate of 150 MB/s. The migration must have minimal downtime. Which AWS service or tool should be used for the initial data load and ongoing replication?

A.Use AWS Database Migration Service (AWS DMS) with full load and ongoing replication
B.Use pg_dump and pg_restore
C.Use AWS Schema Conversion Tool (AWS SCT) to convert schema and AWS DMS for data migration
D.Use AWS S3 Transfer Acceleration to upload data to Amazon S3, then restore to RDS
AnswerA

AWS DMS supports full load and ongoing replication with minimal downtime.

Why this answer

AWS DMS supports ongoing replication from on-premises to RDS with minimal downtime. Option A is incorrect because pg_dump/pg_restore cannot perform ongoing replication. Option B is incorrect because S3 is for storage, not database replication.

Option D is incorrect because the Schema Conversion Tool does not handle data migration.

Practice this question →
307
MCQhard

An IAM policy is attached to a user who is deploying a new RDS instance. What is the effect of this policy on the user's ability to modify an existing production database instance with the identifier 'prod-mydb'?

A.The user cannot modify the production database instance because the Deny statement explicitly denies ModifyDBInstance on production databases.
B.The user can modify the production database instance because the Allow statement grants full access to RDS actions.
C.The user can modify the production database instance if they use the AWS CLI instead of the console.
D.The user cannot modify any database instance because the Deny statement denies ModifyDBInstance on all resources.
AnswerA

Deny overrides Allow, and the resource pattern matches the production database.

Why this answer

Option B is correct because the Deny statement explicitly denies the ModifyDBInstance action on resources matching the ARN pattern for production databases. Since Deny overrides any Allow, the user cannot modify any production database. Option A is wrong because the user can still create and describe instances.

Option C is wrong because the user cannot modify any production instances regardless of region. Option D is wrong because the user cannot modify any production instance, even if they are not the owner.

Practice this question →
308
Multi-Selectmedium

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

Select 2 answers
A.Store database backup files in Amazon S3
B.Use AWS Schema Conversion Tool to convert the schema
C.Use AWS DMS with ongoing change data capture (CDC)
D.Set up AWS Direct Connect for the migration
E.After migration, enable Multi-AZ for high availability
AnswersC, E

Minimizes downtime by replicating changes.

Why this answer

Option A (DMS with CDC) and Option B (Migrate to Multi-AZ after migration) are correct. Option C (S3) is not needed. Option D (Direct Connect) improves bandwidth but not necessary for minimal downtime.

Option E (SCT) is for schema conversion, not needed if schema is compatible.

Practice this question →
309
MCQmedium

Refer to the exhibit. A company is migrating an on-premises database to Amazon RDS for MySQL. During a test migration, the DMS task fails with the error shown. The source database is 500 GB and the target RDS instance has 500 GB allocated storage. What should be done to resolve this error and complete the migration?

A.Increase the DB instance class to a larger size
B.Increase the DMS task's allocated storage
C.Reduce the size of the source database
D.Enable storage autoscaling on the RDS instance
AnswerD

Autoscaling will automatically increase storage as needed.

Why this answer

Option A is correct because enabling storage autoscaling will allow the RDS instance to automatically increase storage when needed during the migration. Option B is wrong because the error is about storage, not instance class. Option C is wrong because the error is about the RDS instance, not the source.

Option D is wrong because DMS tasks do not require an increase in RDS storage allocation upfront; autoscaling handles it.

Practice this question →
310
MCQmedium

A company is migrating a 3 TB PostgreSQL database from on-premises to Amazon Aurora PostgreSQL. They need to minimize downtime and ensure that the migration is completed within a maintenance window. Which approach should they use?

A.Use AWS DMS with full load and ongoing replication (CDC)
B.Use AWS SCT to convert the schema and then migrate data
C.Use pg_dump to export the database and pg_restore to import into Aurora
D.Take a file system snapshot and restore to Aurora
AnswerA

DMS with CDC supports minimal downtime by replicating changes.

Why this answer

AWS DMS with full load and ongoing replication (CDC) is the correct approach because it allows you to perform an initial full load of the 3 TB database while continuously capturing changes from the source PostgreSQL using logical replication (via the pglogical extension or native slot-based replication). This minimizes downtime by keeping the target Aurora PostgreSQL nearly synchronized, and you can switch over during a maintenance window with only a brief outage to apply any final lag.

Exam trap

The trap here is that candidates often choose pg_dump/pg_restore (Option C) because it is a familiar tool, but they overlook the requirement to minimize downtime, which CDC-based replication uniquely addresses.

How to eliminate wrong answers

Option B is wrong because AWS SCT is used for schema conversion (e.g., from Oracle or SQL Server to Aurora PostgreSQL), not for migrating data from PostgreSQL to PostgreSQL, and it does not provide ongoing replication to minimize downtime. Option C is wrong because pg_dump/pg_restore is a logical backup and restore method that requires the source database to be offline or read-only during the dump, causing significant downtime for a 3 TB database, and it does not support continuous replication. Option D is wrong because file system snapshots are not compatible with Aurora PostgreSQL; Aurora uses a distributed storage layer and cannot ingest raw file system snapshots from on-premises PostgreSQL.

Practice this question →
311
MCQeasy

A company wants to migrate a 10 GB PostgreSQL database from an on-premises server to Amazon RDS for PostgreSQL. The migration can tolerate several hours of downtime. Which migration method is the MOST straightforward?

A.Use AWS Database Migration Service (AWS DMS) with ongoing replication
B.Use AWS Schema Conversion Tool (AWS SCT) to migrate the data
C.Create an Amazon RDS Read Replica from the on-premises database
D.Use pg_dump to export the database and pg_restore to import into RDS
AnswerD

This is the simplest method for a one-time migration with downtime tolerance.

Why this answer

Option D is correct because pg_dump and pg_restore are native PostgreSQL utilities that provide a straightforward, reliable method for migrating a 10 GB database with acceptable downtime. The 10 GB size is well within the practical limits of a logical dump, and the process requires no additional AWS services or complex configuration, making it the simplest approach for a migration that can tolerate several hours of downtime.

Exam trap

The trap here is that candidates may over-engineer the solution by choosing AWS DMS with ongoing replication, assuming it is always the best migration tool, when the question explicitly states that several hours of downtime are acceptable, making the simpler native pg_dump/pg_restore approach the most straightforward.

How to eliminate wrong answers

Option A is wrong because AWS DMS with ongoing replication is designed for minimal-downtime migrations and introduces unnecessary complexity (e.g., setting up a replication instance, source/target endpoints, and change data capture) for a scenario where several hours of downtime are acceptable. Option B is wrong because AWS SCT is used for schema conversion when migrating between different database engines (e.g., Oracle to PostgreSQL), not for migrating data between two PostgreSQL databases where the schema is already compatible. Option C is wrong because an Amazon RDS Read Replica cannot be created from an on-premises database; read replicas in RDS are only supported between RDS instances or from an RDS instance to an external source, not the reverse.

Practice this question →
312
MCQhard

A company is migrating a 5 TB SQL Server database to Amazon RDS for SQL Server using AWS DMS. They are using Full LOB mode. The migration is failing with an error about memory allocation. What should they do to resolve this?

A.Decrease the MaxLobSize setting.
B.Increase the DMS replication instance class.
C.Split the migration into multiple DMS tasks.
D.Enable BatchApply on the DMS task.
AnswerB

More memory resolves allocation errors.

Why this answer

The error about memory allocation when using Full LOB mode in AWS DMS indicates that the replication instance does not have sufficient memory to buffer the LOB data during migration. Increasing the replication instance class provides more memory, allowing DMS to handle the LOB data without hitting allocation limits. This is the direct and recommended fix for memory-related failures in DMS LOB migrations.

Exam trap

The trap here is that candidates might confuse memory allocation errors with network or throughput issues and incorrectly choose to split the task or adjust LOB settings, rather than recognizing that the root cause is insufficient instance memory for Full LOB mode.

How to eliminate wrong answers

Option A is wrong because decreasing MaxLobSize would truncate LOB data, potentially causing data loss or migration failure if LOBs exceed the reduced limit; Full LOB mode is designed to handle LOBs of any size without truncation. Option C is wrong because splitting the migration into multiple tasks does not address the underlying memory constraint on the replication instance; each task still runs on the same instance and would encounter the same memory limitation. Option D is wrong because BatchApply optimizes target commit behavior for high-volume transactions but does not affect the memory allocation for LOB processing during the read phase; it is irrelevant to the memory error.

Practice this question →
313
MCQhard

A company is migrating a 10 TB Oracle database to Amazon Aurora PostgreSQL. The migration uses AWS DMS with CDC. After the full load, the CDC phase is falling behind by several minutes. The source Oracle database generates 500 MB of redo logs per minute. Which action will most likely improve CDC performance?

A.Disable CDC and perform a full load only
B.Increase the number of parallel apply threads on the DMS task
C.Reduce the batch size in the DMS task settings
D.Increase the source Oracle redo log size
AnswerB

More parallel apply threads can increase throughput for applying changes to the target.

Why this answer

Option C is correct because increasing the DMS task's parallel apply threads can speed up the apply phase. Option A is wrong because increasing source redo log size does not affect DMS performance. Option B is wrong because disabling CDC is not a solution.

Option D is wrong because reducing batch size would slow down processing.

Practice this question →
314
MCQmedium

A company is migrating a 2 TB Oracle database from on-premises to Amazon RDS for Oracle using AWS DMS. The migration completes successfully, but the new RDS instance shows higher CPU utilization than the on-premises database for the same workload. Which action is MOST likely to reduce CPU utilization on RDS?

A.Disable automated backups to free resources
B.Enable Oracle Multitenant architecture
C.Increase the allocated storage to improve IOPS
D.Change the RDS instance to a burstable class
AnswerB

Multitenant reduces resource overhead by running multiple PDBs in a single CDB.

Why this answer

Option A is correct because enabling Oracle Multitenant reduces overhead by consolidating containers. Option B is wrong because RDS does not allow direct instance type change without downtime. Option C is wrong because increasing storage does not directly reduce CPU.

Option D is wrong because disabling backups is not recommended and may not be the cause.

Practice this question →
315
MCQmedium

A company is migrating an on-premises PostgreSQL database to Amazon RDS for PostgreSQL. The database is 2 TB in size and has a high write volume. The migration window is limited to 4 hours. Which migration approach provides the fastest initial load with minimal downtime?

A.Use pg_dump to export the database and pg_restore to import into RDS.
B.Create a read replica of the on-premises database and promote it to a standalone database in RDS.
C.Use AWS Schema Conversion Tool (AWS SCT) to convert the schema and then use AWS DMS for ongoing replication.
D.Use AWS DMS with PostgreSQL as source and target, using native logical replication for full load and ongoing replication.
AnswerD

DMS with logical replication can perform a full load quickly and then keep the target in sync with minimal downtime.

Why this answer

Option B is correct because AWS DMS can perform a full load using native PostgreSQL logical replication, which is faster than AWS SCT alone (which only converts schema) and faster than using pg_dump/pg_restore for a 2 TB database within 4 hours. Option A is wrong because SCT does not migrate data. Option C is wrong because traditional backup/restore requires downtime for the entire duration.

Option D is wrong because read replicas are not applicable for cross-engine migration.

Practice this question →
316
MCQeasy

A company is deploying Amazon RDS for MySQL in a Multi-AZ configuration for high availability. The database must be able to automatically failover to a standby in another Availability Zone. Which RDS feature enables this?

A.Multi-AZ deployment
B.Automated backups
C.Enhanced Monitoring
D.Read Replicas
AnswerA

Multi-AZ automatically fails over to standby in another AZ.

Why this answer

Option B is correct because Multi-AZ deployments provide automatic failover. Option A is wrong because Read Replicas are for read scaling, not automatic failover. Option C is wrong because Automated backups are for point-in-time recovery, not failover.

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

Practice this question →
317
MCQmedium

A company is migrating a 1 TB SQL Server database to Amazon RDS for SQL Server. They need to minimize downtime and support ongoing replication. Which combination of AWS services should they use?

A.AWS SCT and AWS DMS
B.AWS S3 and AWS Glue
C.AWS DMS alone
D.Native SQL Server backup and restore to RDS
AnswerA

SCT converts schema, DMS migrates data with ongoing replication.

Why this answer

Option C is correct because AWS DMS supports ongoing replication and SCT helps convert the schema. Option A is wrong because native backup/restore does not support ongoing replication. Option B is wrong because S3 is not directly involved in database replication.

Option D is wrong because DMS alone does not handle schema conversion.

Practice this question →
318
MCQeasy

A company wants to migrate a 500 GB MySQL database from an on-premises server to Amazon RDS for MySQL. The migration must be completed within a 2-hour downtime window. Which migration approach is MOST suitable?

A.Use AWS Database Migration Service (DMS) with a full load.
B.Use mysqldump to export the database and then import it into RDS.
C.Create an RDS Read Replica of the on-premises database and promote it.
D.Create a compressed backup using Percona XtraBackup, upload it to S3, and restore it to RDS.
AnswerD

Percona XtraBackup creates a fast physical backup; restoring from S3 is efficient and can complete within 2 hours.

Why this answer

Creating a full backup, transferring to S3, and restoring to RDS is the fastest method with minimal downtime for the given size. DMS requires setting up endpoints and may have overhead. mysqldump is slower for large databases. Read replicas are not applicable for on-premises migration.

Practice this question →
319
Multi-Selectmedium

Which THREE factors should be considered when choosing between a native database migration tool (e.g., pg_dump) and AWS DMS for migrating a database to Amazon RDS? (Choose three.)

Select 3 answers
A.Whether the target database is in a different AWS region
B.Downtime tolerance during migration
C.Requirement for ongoing replication to keep the target in sync
D.Need to perform complex data transformations during migration
E.Total size of the database and network bandwidth
AnswersB, C, E

Native tools typically require full downtime; DMS can minimize downtime with ongoing replication.

Why this answer

Option A is correct because native tools like pg_dump require downtime for the entire export/import. Option D is correct because native tools do not support ongoing replication; DMS does. Option E is correct because native tools can be faster for full load of large databases.

Option B is wrong because DMS supports cross-region migrations. Option C is wrong because DMS supports complex transformations.

Practice this question →
320
MCQhard

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?

A.mysql -h mydb.123456789012.us-east-1.rds.amazonaws.com -P 3306 -u admin -p
B.psql -h mydb.123456789012.us-east-1.rds.amazonaws.com -p 5432 -U admin
C.mysql -h mydb.us-east-1.rds.amazonaws.com -P 3306 -u admin -p
D.mysql -h mydb.123456789012.us-east-1.rds.amazonaws.com -P 5432 -u admin -p
AnswerA

Correct endpoint and port.

Why this answer

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.

Practice this question →
321
MCQhard

A company is migrating a 5 TB PostgreSQL database from on-premises to Amazon RDS for PostgreSQL. The database has a 24/7 uptime requirement and must be migrated with minimal downtime. The on-premises network bandwidth is 100 Mbps. The migration must be completed within 48 hours. The team has chosen to use AWS Database Migration Service (DMS) with ongoing replication from a change data capture (CDC) source. After setting up the source endpoint, target endpoint, and replication instance, the initial full load takes 30 hours. However, during the CDC phase, the target falls behind by over 2 hours and continues to lag. The replication instance is a dms.c5.large (2 vCPUs, 4 GB memory). The source database is heavily utilized with frequent updates. What should the team do to reduce the CDC lag and meet the migration deadline?

A.Increase the replication instance size to dms.c5.2xlarge.
B.Enable Multi-AZ on the replication instance for better performance.
C.Split the migration into multiple DMS tasks for parallel processing.
D.Disable ongoing replication and use a one-time full load migration.
AnswerA

More CPU and memory reduce CDC lag.

Why this answer

Option A is correct: increasing the replication instance size to dms.c5.2xlarge provides more CPU and memory, which can handle higher transaction throughput. Option B is wrong because splitting into multiple tasks adds overhead and may not help with a single source. Option C is wrong because DMS does not use Multi-AZ.

Option D is wrong because disabling ongoing replication would cause data loss.

Practice this question →
322
Multi-Selectmedium

A company is migrating a 1 TB Oracle database to Amazon Aurora PostgreSQL using AWS DMS. They need to ensure minimal downtime and data consistency. Which TWO actions should the company take?

Select 2 answers
A.Increase the target Aurora storage to 2 TB to avoid storage issues
B.Enable change data capture (CDC) on the source Oracle database
C.Enable data validation on the DMS task
D.Disable foreign key constraints on the target during migration
E.Use AWS Schema Conversion Tool to convert the schema
AnswersB, C

CDC captures ongoing changes to minimize downtime.

Why this answer

Option B is correct because enabling Change Data Capture (CDC) on the source Oracle database allows AWS DMS to capture ongoing changes after the full load, enabling a near-zero downtime migration by continuously replicating transactions to the target Aurora PostgreSQL. Option C is correct because enabling data validation on the DMS task ensures that the data migrated is consistent between the source and target, verifying that no data loss or corruption occurred during the migration process.

Exam trap

The trap here is that candidates often confuse the AWS Schema Conversion Tool (SCT) with DMS, thinking it is part of the migration process for minimizing downtime, when in fact SCT is used for schema assessment and conversion before migration, not for ongoing replication or consistency checks.

Practice this question →
323
MCQeasy

A company is deploying a new Amazon RDS for PostgreSQL database. The database will be used by an application that requires read-after-write consistency and low latency. Which deployment configuration is MOST suitable?

A.Deploy with one or more read replicas in the same region
B.Deploy with cross-region replicas
C.Deploy as a single-AZ instance with increased instance size
D.Deploy as Multi-AZ with a synchronous standby
AnswerA

Read replicas offload read traffic and reduce latency for read operations.

Why this answer

Multi-AZ deployment with synchronous standby provides high availability and data durability, but does not improve read performance. Read replicas (Option B) improve read scalability but may have eventual consistency. Option C (single-AZ) lacks HA.

Option D (cross-region) is for DR.

Practice this question →
324
MCQhard

A company is migrating a 10 TB Oracle data warehouse to Amazon Redshift. They want to use AWS DMS for continuous replication. However, the migration is taking longer than expected due to LOB columns. What optimization should be applied?

A.Use AWS SCT to compress LOBs.
B.Enable FullLobMode to transfer all LOBs.
C.Set MaxLobSize to a value like 64 KB to limit inline LOB transfer.
D.Increase the number of DMS tasks.
AnswerC

This optimizes performance.

Why this answer

Setting the DMS task attribute 'MaxLobSize' to a reasonable value limits the size of LOBs transferred inline, improving performance. 'FullLobMode' slows down migration. Increasing instance size helps but not as targeted.

Practice this question →
325
MCQmedium

A company is migrating a 500 GB MongoDB database to Amazon DocumentDB. The migration must have minimal impact on the source database. Which approach should the company take?

A.Use mongodump to export the data, then use mongorestore to import into DocumentDB.
B.Use mongoexport to export CSV, then use the DocumentDB import tool.
C.Use AWS Database Migration Service (DMS) with MongoDB as source and DocumentDB as target.
D.Use AWS Schema Conversion Tool (SCT) to convert schema, then copy data.
AnswerC

DMS allows online migration with minimal impact.

Why this answer

AWS DMS supports MongoDB as a source and DocumentDB as a target, with ongoing replication to minimize downtime. Option A (mongorestore) causes high impact. Option C (export/import) causes impact.

Option D (AWS SCT) is not for migration itself.

Practice this question →
326
MCQmedium

A company is migrating a 1 TB SQL Server database to Amazon RDS for SQL Server using backup and restore. The database has high transaction volume. Which backup type should be used to minimize downtime?

A.Perform a full backup, then transaction log backups, and restore the full backup with the last log backup.
B.Perform only transaction log backups and restore them to RDS.
C.Perform a differential backup and restore it to RDS.
D.Perform a full backup and restore it to RDS.
AnswerA

Allows point-in-time recovery, minimizing data loss.

Why this answer

Option C is correct because a full backup followed by transaction log backups allows restoring to a point in time, minimizing data loss and downtime. Option A is wrong because only full backup requires longer downtime during restore and may lose transactions. Option B is wrong because differential backup alone is not sufficient; you need a full backup chain.

Option D is wrong because transaction log backup alone cannot restore without a full backup.

Practice this question →
327
MCQhard

A team is setting up a DMS migration task. The IAM policy above is attached to the DMS replication instance's IAM role. The team is unable to modify the target RDS instance's maintenance window during the migration. Which additional permission is missing?

A.Add 'rds:ModifyDBInstance' permission for the source RDS instance.
B.Add 'rds:ModifyOptionGroup' permission for the target RDS instance.
C.Add 'dms:ModifyReplicationInstance' permission for the DMS replication instance.
D.Add 'ec2:DescribeVpcs' permission to the policy.
AnswerA

The policy only allows modification of the target instance; the source instance also needs to be modified during migration, e.g., enabling binary logging.

Why this answer

The correct answer is A because modifying the target RDS instance's maintenance window requires the `rds:ModifyDBInstance` permission. The DMS replication instance's IAM role must have this permission for the target RDS instance to allow the migration task to adjust the maintenance window, which is necessary to prevent conflicts during ongoing replication. Without this permission, the DMS task cannot alter the maintenance window, even if the IAM role has other RDS permissions.

Exam trap

The trap here is that candidates may confuse the permissions needed for modifying the target RDS instance's maintenance window with permissions for modifying the DMS replication instance or RDS option groups, leading them to select options B or C instead of the correct `rds:ModifyDBInstance` permission.

How to eliminate wrong answers

Option B is wrong because `rds:ModifyOptionGroup` is used to modify option groups (e.g., enabling Oracle TDE or SQL Server native backup/restore), not the maintenance window of an RDS instance. Option C is wrong because `dms:ModifyReplicationInstance` is an action on the DMS replication instance itself, not on the target RDS instance, and does not grant the ability to modify the RDS maintenance window. Option D is wrong because `ec2:DescribeVpcs` is a read-only permission for describing VPCs, which is unrelated to modifying RDS instance maintenance windows.

Practice this question →
328
MCQmedium

A company is migrating a 100 GB Oracle database to Amazon RDS for Oracle. They want to use AWS DMS. The source database is in a different AWS account. What is required to allow DMS to connect to the source?

A.Establish VPC peering or VPN between the source and target VPCs, and configure security group rules.
B.Assign an IAM role to the source database to allow DMS access.
C.Configure an S3 VPC gateway endpoint for the source VPC.
D.Create a VPC endpoint for DMS in the source account.
AnswerA

DMS requires network connectivity between the replication instance and the source database.

Why this answer

Option C is correct because DMS needs network connectivity via VPC peering or VPN, and the source security group must allow DMS. Option A is wrong because VPC endpoints are not needed for DMS to source. Option B is wrong because DMS does not use an S3 endpoint for source connectivity.

Option D is wrong because DMS does not use an IAM role for database connectivity; it uses database credentials.

Practice this question →
329
MCQmedium

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

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

DMS supports heterogeneous migrations and ongoing replication to minimize downtime.

Why this answer

AWS Database Migration Service (DMS) supports heterogeneous migrations from Oracle to Aurora PostgreSQL and can perform ongoing replication to minimize downtime. Option A is correct. Option B (AWS Snowball) is for large data transfer but not for ongoing replication.

Option C (SCT) helps with schema conversion but not data migration. Option D (Data Pipeline) is not designed for database migrations.

Practice this question →
330
MCQmedium

A company is migrating a 500 GB MongoDB database to Amazon DocumentDB. The migration is done using AWS DMS with full load and ongoing replication. The full load completes successfully, but during CDC, the DMS task logs show 'Memory limit exceeded' errors and the task fails repeatedly. The DMS replication instance is a dms.r5.large. The source MongoDB has a write-heavy workload with many small updates. The DBA needs to fix the migration without restarting from scratch. Which action should the DBA take?

A.Increase the DMS replication instance size to a larger instance class with more memory.
B.Reduce the DMS task's 'BatchApplyEnabled' setting to apply transactions individually.
C.Stop and restart the DMS task to clear the cache.
D.Enable Multi-AZ on the DMS replication instance to distribute the load.
AnswerA

More memory allows DMS to buffer more changes and handle the workload.

Why this answer

Option C is correct. The 'Memory limit exceeded' error often occurs when DMS cannot keep up with the volume of changes, especially for write-heavy workloads. Increasing the replication instance size provides more memory for buffering.

Option A is wrong because stopping and restarting the task does not address the root cause. Option B is wrong because reducing the batch size may not help; the issue is memory capacity. Option D is wrong because enabling multi-AZ does not increase memory; it provides high availability.

Practice this question →
331
Multi-Selectmedium

A company is deploying a DynamoDB table for a global application that requires low-latency reads and writes in multiple AWS Regions. Which THREE features should be enabled? (Choose three.)

Select 3 answers
A.DynamoDB Accelerator (DAX).
B.On-demand capacity mode.
C.DynamoDB Streams.
D.Time to Live (TTL).
E.DynamoDB global tables.
AnswersA, B, E

Provides in-memory caching for low-latency reads.

Why this answer

Options A, C, and D are correct. DynamoDB global tables provide multi-region replication. DAX provides in-memory caching for low-latency reads.

On-demand capacity handles traffic spikes. Option B is wrong because TTL is for data expiration, not performance. Option E is wrong because Streams are for change data capture, not low-latency access.

Practice this question →
332
MCQmedium

A company has an Aurora MySQL cluster with three instances. The current writer instance is 'mycluster-instance-1'. The company wants to failover to 'mycluster-instance-2' for maintenance. What is the most direct way to achieve this?

A.Change the cluster's endpoint to point to instance-2.
B.Modify 'mycluster-instance-2' to promote it to writer.
C.Reboot 'mycluster-instance-1' to trigger a failover.
D.Use the AWS CLI: aws rds failover-db-cluster --db-cluster-identifier mycluster --target-db-instance-identifier mycluster-instance-2
AnswerD

This command initiates failover to the specified instance.

Why this answer

Option B is correct because you can failover to a specific reader instance by using the --target-db-instance-identifier parameter in the failover-db-cluster command. Option A is wrong because rebooting the writer will cause a failover but may choose any reader, not necessarily instance-2. Option C is wrong because you cannot directly promote a reader to writer; failover must be initiated.

Option D is wrong because modifying the cluster does not trigger failover.

Practice this question →
333
MCQeasy

Refer to the exhibit. A developer wants to connect to the database. Which database engine is most likely being used?

A.Oracle
B.SQL Server
C.MySQL
D.PostgreSQL
AnswerC

Port 3306 is default for MySQL.

Why this answer

The output shows port 3306, which is the default port for MySQL and MariaDB. Amazon RDS for MySQL uses port 3306. Aurora MySQL also uses 3306, but the endpoint pattern is RDS, not Aurora-specific.

PostgreSQL uses 5432, Oracle uses 1521, SQL Server uses 1433.

Practice this question →
334
MCQhard

A company is migrating a self-managed Oracle database to Amazon Aurora PostgreSQL using AWS DMS. The source database has a large number of tables with foreign key constraints. During the full load phase, some tables fail to load due to foreign key violations. What is the most efficient way to resolve this?

A.Increase the DMS task memory and parallel load threads
B.Use the table preparation mode 'Do nothing' and load tables in dependency order
C.Disable foreign key constraints on the target before migration and re-enable after
D.Pre-create all target tables with the same constraints and use 'Truncate' mode
AnswerC

This allows flexible loading order and avoids violations.

Why this answer

Option C is correct because disabling foreign key constraints on the target Aurora PostgreSQL database before the migration allows DMS to load tables in any order without violating referential integrity. After the full load completes, re-enabling the constraints ensures data consistency. This approach is the most efficient as it avoids complex dependency ordering and reduces migration failures.

Exam trap

The trap here is that candidates may think increasing resources (Option A) or pre-creating tables (Option D) will solve the issue, but they overlook that foreign key violations are a logical dependency problem, not a performance or schema creation issue.

How to eliminate wrong answers

Option A is wrong because increasing DMS task memory and parallel load threads addresses performance bottlenecks, not foreign key constraint violations; the root cause is referential integrity, not resource contention. Option B is wrong because using 'Do nothing' table preparation mode and loading in dependency order is impractical for a large number of tables with foreign keys, as it requires manual analysis and ordering, and DMS does not automatically resolve dependencies; this approach is error-prone and time-consuming. Option D is wrong because pre-creating target tables with the same constraints and using 'Truncate' mode would still cause foreign key violations during the full load, as DMS does not guarantee insertion order; truncate mode only clears data before reloading, not resolving the dependency issue.

Practice this question →
335
MCQeasy

A team is migrating an on-premises database to Amazon RDS using AWS DMS. After the full load completed, the task stopped. The team needs to perform ongoing replication to minimize downtime. What change should the team make to the DMS task?

A.Modify the replication task to change the migration type to 'full-load-and-cdc'.
B.Restart the replication task with the same settings.
C.Create a new replication instance and start a new full-load task.
D.Use AWS Schema Conversion Tool to convert the schema again.
AnswerA

Changing to 'full-load-and-cdc' enables both full load and ongoing change data capture replication.

Why this answer

After a full load completes and the task stops, the team needs to enable ongoing replication to capture and apply changes made to the source database during the migration window. Modifying the DMS task to use the 'full-load-and-cdc' migration type allows the task to perform the initial full load and then seamlessly transition to Change Data Capture (CDC) to replicate incremental changes, minimizing downtime. This is the correct approach because DMS supports switching a completed full-load task to include CDC without re-running the full load.

Exam trap

The trap here is that candidates may think restarting the task or creating a new instance will automatically enable CDC, but DMS requires explicitly modifying the migration type to include CDC after the full load completes.

How to eliminate wrong answers

Option B is wrong because restarting the replication task with the same settings will simply re-run the full load from scratch, not enable ongoing replication. Option C is wrong because creating a new replication instance and starting a new full-load task would duplicate effort and waste resources, and it still does not enable CDC for ongoing replication. Option D is wrong because the AWS Schema Conversion Tool (SCT) is used for schema conversion, not for enabling CDC or managing replication tasks; it is irrelevant to the need for ongoing replication.

Practice this question →
336
Multi-Selecthard

A company is migrating a 5 TB Microsoft SQL Server database to Amazon Aurora MySQL. The migration must be completed with minimal downtime. Which THREE steps should the company take? (Select THREE.)

Select 3 answers
A.Update the application connection string to point to the Aurora reader endpoint.
B.Use AWS DMS to perform a full load and ongoing replication from SQL Server to Aurora.
C.Create a read replica of the Aurora database in the same region.
D.Use AWS SCT to convert the SQL Server schema to MySQL-compatible schema.
E.Update the application connection string to point to the Aurora writer endpoint after cutover.
AnswersB, D, E

DMS handles data migration with minimal downtime.

Why this answer

Options A, B, and D are correct. AWS SCT converts the schema and code from SQL Server to MySQL (A). AWS DMS performs the full data load and ongoing replication (B).

After migration, the application connection string is updated to point to the Aurora writer endpoint (D). Option C is wrong because creating a read replica from Aurora to on-premises is not supported. Option E is wrong because the reader endpoint is for read traffic, not for the primary application connection.

Practice this question →
337
Multi-Selecthard

Which TWO steps are required when migrating an on-premises Microsoft SQL Server database to Amazon RDS for SQL Server using AWS DMS with ongoing replication?

Select 2 answers
A.Create a VPC peering connection between the on-premises network and the DMS VPC.
B.Install the DMS agent on the source SQL Server instance.
C.Enable MS-CDC (change data capture) on the source database.
D.Configure MS-Replication on the source database.
E.Ensure the source database is using the full recovery model.
AnswersC, E

DMS uses CDC to capture ongoing changes from SQL Server.

Why this answer

Option B is correct because DMS requires full recovery model to capture all transactions. Option E is correct because DMS uses MS-CDC (change data capture) to capture ongoing changes. Option A is wrong because DMS does not require MS-Replication; it uses its own CDC mechanism.

Option C is wrong because DMS uses a replication instance, not an EC2 instance agent. Option D is wrong because cross-VPC peering is not required; DMS can connect via VPN/Direct Connect.

Practice this question →
338
MCQmedium

A company is migrating a PostgreSQL database to Amazon RDS for PostgreSQL. The source database uses custom functions written in PL/Python. What should the company consider?

A.Rewrite the functions in PL/pgSQL or another supported language.
B.Modify the DB parameter group to enable PL/Python.
C.Use RDS Custom for PostgreSQL to install PL/Python.
D.Migrate to Aurora PostgreSQL which supports PL/Python.
AnswerA

RDS PostgreSQL supports only specific procedural languages; PL/Python is not one of them.

Why this answer

Amazon RDS for PostgreSQL does not support PL/Python because it requires the installation of an untrusted procedural language, which poses security risks in a managed database environment. The correct approach is to rewrite the custom functions in a supported language such as PL/pgSQL, PL/Perl, or PL/Tcl, which are trusted languages available in RDS for PostgreSQL.

Exam trap

The trap here is that candidates assume RDS Custom or Aurora PostgreSQL can bypass the PL/Python limitation, but AWS does not support untrusted languages in any managed PostgreSQL offering, and RDS Custom still relies on the standard PostgreSQL engine which lacks PL/Python support.

How to eliminate wrong answers

Option B is wrong because modifying the DB parameter group cannot enable PL/Python; RDS for PostgreSQL does not include the PL/Python extension and does not allow installation of untrusted languages. Option C is wrong because RDS Custom for PostgreSQL still does not support PL/Python; RDS Custom provides OS-level access but the PostgreSQL engine itself must support the language, and PL/Python is not bundled or supported by AWS. Option D is wrong because Aurora PostgreSQL also does not support PL/Python; it shares the same limitations as RDS for PostgreSQL regarding untrusted procedural languages.

Practice this question →
339
Multi-Selecteasy

Which TWO AWS services can be used together to migrate an on-premises MySQL database to Amazon Aurora MySQL with minimal downtime? (Select TWO.)

Select 2 answers
A.AWS Schema Conversion Tool (SCT)
B.Amazon Route 53
C.AWS CloudFormation
D.AWS Database Migration Service (DMS)
E.AWS Global Accelerator
AnswersA, D

Converts schema for compatibility.

Why this answer

AWS Database Migration Service (DMS) can perform continuous replication from an on-premises MySQL source to an Amazon Aurora MySQL target using change data capture (CDC), enabling near-zero downtime. The AWS Schema Conversion Tool (SCT) is used to assess and convert the source schema, including any incompatible objects, to ensure the Aurora target is ready for migration. Together, SCT handles schema transformation while DMS handles the ongoing data replication.

Exam trap

The trap here is that candidates often assume a single service like DMS alone can handle schema conversion, but DMS does not convert incompatible schema objects — that is the specific role of SCT, and both are required for a complete migration with minimal downtime.

Practice this question →
340
MCQeasy

A startup is deploying a new web application on AWS. The application uses Amazon RDS for PostgreSQL as its database. The developers need to create the initial schema and load test data. They have a SQL script file that creates tables and inserts 10,000 rows. The DB instance is a db.t3.micro with 20 GB gp2 storage. The developers connect to the RDS instance using pgAdmin from their local machine and run the script. The script fails with a 'connection reset' error after inserting 5,000 rows. What is the MOST likely cause?

A.The DB instance ran out of memory or CPU credits due to the intensive script
B.The max_connections parameter was set too low
C.The storage volume reached its maximum capacity
D.The security group blocked the connection due to a timeout
AnswerA

db.t3.micro has limited resources; the script may overwhelm it.

Why this answer

Option A is correct because the db.t3.micro instance has limited memory and CPU credits; a large script can exhaust resources and cause a connection reset. Option B is wrong because the storage is 20 GB and 10,000 rows of test data are small. Option C is wrong because security group timeout is not typical for a connection reset.

Option D is wrong because the default max_connections for db.t3.micro is typically sufficient for a single connection.

Practice this question →
341
Multi-Selectmedium

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

Select 3 answers
A.AWS Database Migration Service (DMS) replication instance
B.AWS Schema Conversion Tool (SCT)
C.Amazon Aurora PostgreSQL cluster as the target
D.Source PostgreSQL database configured with logical replication
E.AWS VPN connection between on-premises and AWS
AnswersA, C, D

DMS orchestrates the migration and replication.

Why this answer

Options A, B, and D are correct. AWS DMS performs the migration with ongoing replication. An Aurora PostgreSQL target database is needed.

The source database must be configured to allow replication. Option C is wrong because SCT is not needed when source and target are both PostgreSQL. Option E is wrong because a VPN is optional, not required.

Practice this question →
342
Multi-Selecthard

Which THREE factors should be considered when choosing between a homogeneous migration and a heterogeneous migration to Amazon RDS? (Select THREE.)

Select 3 answers
A.Network latency between source and target.
B.Performance requirements of the target database.
C.Amount of application code changes needed.
D.Schema compatibility between source and target.
E.Licensing costs of the target database engine.
AnswersB, D, E

May influence engine choice.

Why this answer

Option B is correct because the performance requirements of the target database directly influence the choice between homogeneous and heterogeneous migrations. In a homogeneous migration (e.g., MySQL to RDS MySQL), the target engine is identical, so performance tuning is minimal. In a heterogeneous migration (e.g., Oracle to RDS PostgreSQL), the target engine has different query optimizers, indexing strategies, and concurrency models, which may require re-architecting to meet performance SLAs.

AWS DMS Schema Conversion Tool (SCT) can help assess performance impacts, but the target engine's inherent performance characteristics must be evaluated upfront.

Exam trap

The trap here is that candidates confuse migration method factors (e.g., network latency, downtime tolerance) with migration type factors (e.g., schema compatibility, licensing, performance), leading them to select A as a relevant consideration when it only applies to the migration approach, not the choice between homogeneous and heterogeneous.

Practice this question →
343
MCQmedium

A company is migrating a 1 TB SQL Server database to Amazon RDS for SQL Server. The migration window is 4 hours. The on-premises network bandwidth is 1 Gbps. The database is not actively used during the migration window. The team wants to minimize migration time and cost. Which migration strategy is most appropriate?

A.Use SQL Server BCP utility to export data and then import using DTS.
B.Use AWS Snowball to transfer the database files.
C.Create a native backup, upload to S3, restore to RDS.
D.Use AWS DMS with full load only.
AnswerD

DMS can complete full load within 4 hours over 1 Gbps.

Why this answer

Option C is correct: using AWS DMS with full load is the fastest and most cost-effective. Option A is wrong because BCP/DTS may be slower. Option B is wrong because native backup/restore requires S3 transfer and is slower.

Option D is wrong because Snowball is unnecessary for 1 TB over 1 Gbps.

Practice this question →
344
Multi-Selectmedium

A company is deploying an Amazon Aurora MySQL database with read replicas. They need to ensure high availability and disaster recovery across AWS Regions. Which THREE components should be included?

Select 3 answers
A.Aurora Replicas in the same Region
B.Aurora Global Database
C.Auto Scaling groups
D.Amazon Route 53 with health checks and failover policy
E.Amazon CloudFront
AnswersA, B, D

Aurora Replicas provide high availability within the region.

Why this answer

Aurora Replicas in the same Region provide read scaling and automatic failover within an AWS Region. They share the same underlying storage volume as the primary instance, so failover is fast (typically under 30 seconds) and does not require data rehydration. This is a core component for high availability within a single Region.

Exam trap

The trap here is that candidates often confuse Auto Scaling groups (which scale compute resources) with database replication or failover mechanisms, or they mistakenly think CloudFront can serve as a database-level disaster recovery solution when it only caches content at the edge.

Practice this question →
345
Multi-Selectmedium

A company is deploying a new MySQL database on Amazon RDS. The database must be highly available and support cross-Region disaster recovery. Which TWO actions should be taken? (Choose two.)

Select 2 answers
A.Enable encryption at rest using AWS KMS.
B.Deploy a Multi-AZ instance in multiple regions.
C.Enable automated backups with a retention period of 35 days.
D.Create a cross-region read replica.
E.Enable Multi-AZ for automatic failover within a region.
AnswersD, E

Provides disaster recovery in another region.

Why this answer

Options A and C are correct. Enabling Multi-AZ provides high availability within a region. Creating a cross-region read replica provides disaster recovery.

Option B is wrong because automated backups are for point-in-time recovery, not cross-region DR. Option D is wrong because RDS does not support Multi-Region Multi-AZ. Option E is wrong because encryption is for security, not HA or DR.

Practice this question →
346
Multi-Selectmedium

A company is deploying a new application using Amazon RDS for PostgreSQL. They require high availability with automatic failover and the ability to offload read traffic. Which TWO features should they enable? (Choose two.)

Select 2 answers
A.Multi-AZ deployment
B.Read replicas
C.Performance Insights
D.Global Database
E.Auto Scaling for read replicas
AnswersA, B

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

Why this answer

Multi-AZ deployment (Option A) provides high availability by automatically provisioning and maintaining a synchronous standby replica in a different Availability Zone. If the primary DB instance fails, Amazon RDS automatically fails over to the standby, ensuring minimal downtime. Read replicas (Option B) offload read traffic by creating asynchronous copies of the database that can serve read queries, reducing load on the primary instance.

Exam trap

The trap here is that candidates may confuse Multi-AZ with read replicas, thinking they serve the same purpose, or incorrectly assume that Global Database or Auto Scaling for read replicas are available for standard RDS PostgreSQL, when they are either Aurora-specific or not supported.

Practice this question →
347
MCQeasy

A company is deploying a new application that requires a MySQL-compatible database with automatic scaling of compute and storage resources. Which AWS service should be used?

A.Amazon Aurora MySQL
B.Amazon RDS for MySQL
C.Amazon DynamoDB
D.Amazon Redshift
AnswerA

Supports automatic scaling for compute and storage.

Why this answer

Amazon Aurora with Auto Scaling capabilities (Aurora Auto Scaling for replicas, storage auto scaling). Option A: RDS MySQL has manual scaling only. Option C: DynamoDB is NoSQL.

Option D: Redshift is data warehouse.

Practice this question →
348
Multi-Selecteasy

Which TWO AWS services can be used to migrate a MongoDB database to Amazon DocumentDB? (Choose 2.)

Select 2 answers
A.AWS DataSync
B.AWS Database Migration Service (AWS DMS)
C.Amazon S3
D.MongoDB native tools (mongodump and mongorestore)
E.Amazon Kinesis Data Streams
AnswersB, D

DMS supports MongoDB to DocumentDB migration.

Why this answer

AWS DMS supports migration from MongoDB to DocumentDB, and MongoDB's native mongodump and mongorestore can be used. Option C (S3) is not directly used. Option D (DataSync) is for file data.

Option E (Kinesis) is for streaming data.

Practice this question →
349
MCQeasy

A company is migrating an on-premises MySQL database to Amazon RDS for MySQL. They need to validate that the schema is compatible. Which AWS service should they use?

A.AWS Schema Conversion Tool (SCT)
B.Amazon Inspector
C.AWS Database Migration Service (DMS)
D.AWS Trusted Advisor
AnswerA

SCT checks and converts schemas.

Why this answer

AWS SCT can assess and convert schemas for compatibility. AWS DMS is for data migration. Amazon Inspector is for security.

AWS Trusted Advisor is for best practices.

Practice this question →
350
MCQeasy

A company is deploying a new microservices application on Amazon ECS. Each microservice needs its own database. Which AWS database service should be used to minimize operational overhead?

A.Amazon DynamoDB
B.Amazon Aurora
C.Amazon Redshift
D.Amazon RDS for MySQL
AnswerA

DynamoDB is fully managed, serverless, and suitable for microservices.

Why this answer

Amazon DynamoDB is a fully managed NoSQL database that requires no server management. Option A is incorrect because RDS requires provisioning and managing instances. Option B is incorrect because Aurora is also managed but may be overkill for small datasets.

Option D is incorrect because Redshift is a data warehouse.

Practice this question →
351
MCQhard

A company is migrating a 5 TB Oracle database to Amazon Aurora MySQL using AWS DMS. The full load completes successfully, but the CDC phase is slow and the target Aurora cluster is consuming high CPU. The DMS instance type is dms.c4.2xlarge. Which change will most likely improve CDC performance?

A.Increase the Aurora cluster's max_connections parameter
B.Increase the number of parallel apply threads in the DMS task
C.Increase the DMS task's target storage allocation
D.Change the Aurora cluster to a larger instance class
AnswerB

More parallel apply threads can increase the rate of applying changes to Aurora, reducing CPU usage per thread.

Why this answer

Option D is correct because increasing the number of parallel apply threads can improve throughput, reducing CPU strain on Aurora. Option A is wrong because increasing max_connections may not help. Option B is wrong because Aurora auto-scales storage.

Option C is wrong because DMS uses its own storage, not target storage.

Practice this question →
352
Multi-Selectmedium

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

Select 2 answers
A.Export data using mysqldump and import into Aurora during a maintenance window.
B.Use AWS Schema Conversion Tool (SCT) to convert the schema to Aurora MySQL.
C.Create an Amazon Aurora MySQL read replica from an Amazon RDS MySQL DB instance.
D.Use AWS Database Migration Service (DMS) with change data capture (CDC) to migrate data.
E.Enable binary logging (binlog) on the source RDS MySQL instance and set up replication to Aurora.
AnswersC, E

Creating an Aurora read replica from RDS MySQL allows near-zero downtime migration.

Why this answer

Options A and C are correct. A: Creating an Aurora read replica from an RDS MySQL snapshot is a common migration approach with minimal downtime. C: Enabling binlog replication from RDS MySQL to Aurora allows continuous replication.

Option B (DMS with CDC) is also valid but not listed as correct? Actually DMS is also valid, but the question expects A and C. Option D (SCT) is for schema conversion, not needed for MySQL to Aurora. Option E (Snowball) is for large data, but not minimal downtime.

Practice this question →
353
MCQeasy

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

A.AWS Schema Conversion Tool (SCT)
B.AWS Lambda
C.Amazon S3
D.AWS Database Migration Service (DMS)
AnswerA

Converts schema and code.

Why this answer

AWS SCT is designed for schema and code conversion between heterogeneous databases. Option A is correct. Option B (DMS) migrates data, not schema.

Option C (S3) is storage. Option D (Lambda) is compute.

Practice this question →
← PreviousPage 5 of 5 · 353 questions total

Ready to test yourself?

Try a timed practice session using only Deployment and Migration questions.

Start 20-question session