Courseiva

DBS-C01 · topic practice

Deployment and Migration practice questions

Practise AWS Certified Database Specialty DBS-C01 Deployment and Migration practice questions — original exam-style scenarios with answer choices, explanations, and analysis of common mistakes.

Courseiva uses original exam-style practice questions designed for learning and revision. The goal is to understand the concepts, recognise exam patterns, and improve through explanations — not memorise copied exam dumps.

Reviewed byJohnson Ajibi· MSc IT Security
20 questionsDomain: Deployment and Migration
Practice 10 questionsBrowse domain →

What the exam tests

What to know about Deployment and Migration

Deployment and Migration questions test whether you can apply the concept in context, not just recognise a definition.

How the topic appears in realistic exam-style scenarios.

Which detail in the question changes the correct answer.

How to eliminate plausible but wrong options.

How to connect the question back to the wider exam objective.

Watch out for

Common Deployment and Migration exam traps

  • ▸Answering from memory before reading the full scenario.
  • ▸Missing a constraint such as cost, availability, security, scope or command context.
  • ▸Choosing a broad answer when the question asks for the most specific fix.
  • ▸Ignoring why the wrong options are tempting.

Practice set

Deployment and Migration questions

20 questions · select your answer, then reveal the explanation

Question 1mediummultiple choice
Read the full Deployment and Migration explanation →

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 workload. The company needs to minimize downtime during the migration. Which AWS service or feature should the company use to achieve this?

Question 2easymultiple choice
Read the full NAT/PAT explanation →

A company wants to migrate its on-premises Oracle database to Amazon Aurora PostgreSQL. The company needs to automatically convert the Oracle schema to PostgreSQL-compatible format. Which AWS service should the company use?

Question 3hardmultiple choice
Read the full Deployment and Migration explanation →

A company is using AWS Database Migration Service (AWS DMS) to migrate a 5 TB MySQL database to Amazon RDS for MySQL. The migration is taking longer than expected. The company notices that the source database has a high volume of write operations. Which configuration change would MOST likely improve the migration performance?

Question 4mediummultiple choice
Read the full Deployment and Migration explanation →

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?

Question 5easymultiple choice
Read the full NAT/PAT explanation →

A company needs to migrate a 100 GB MongoDB database to Amazon DocumentDB (with MongoDB compatibility). The migration must have minimal impact on the source database performance. Which approach should the company take?

Question 6mediummulti select
Read the full Deployment and Migration explanation →

A company is migrating a 3 TB on-premises Oracle database to Amazon Aurora PostgreSQL using AWS DMS. The migration task is failing with an error indicating insufficient memory. Which TWO actions should the company take to resolve this issue? (Choose TWO.)

Question 7hardmulti select
Read the full Deployment and Migration explanation →

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

Question 8hardmultiple choice
Read the full Deployment and Migration explanation →

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?

Exhibit

{
  "Version": "2012-10-17",
  "Statement": [
    {
      "Effect": "Allow",
      "Action": [
        "dms:CreateEndpoint",
        "dms:ModifyEndpoint",
        "dms:DescribeEndpoints"
      ],
      "Resource": "*"
    },
    {
      "Effect": "Allow",
      "Action": [
        "rds:DescribeDBInstances",
        "rds:ModifyDBInstance"
      ],
      "Resource": "arn:aws:rds:us-east-1:123456789012:db:target-db"
    }
  ]
}
Question 9easymultiple choice
Read the full Deployment and Migration explanation →

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?

Network Topology
$ aws dms describe-replication-tasksfilters Name=replication-task-id"ReplicationTasks": ["ReplicationTaskIdentifier": "my-task","SourceEndpointArn": "arn:aws:dms:us-east-1:123456789012:endpoint:AAAAAA","TargetEndpointArn": "arn:aws:dms:us-east-1:123456789012:endpoint:BBBBBB","ReplicationInstanceArn": "arn:aws:dms:us-east-1:123456789012:rep:CCCCCC","MigrationType": "full-load","TableMappings": "...","ReplicationTaskStats": {"FullLoadProgressPercent": 100,"TablesQueued": 0,"TablesLoaded": 5,"TablesCurrent": 0,"TablesSkipped": 0,"TablesErrored": 0},"Status": "stopped","StopReason": "Full load completed"
Question 10mediummultiple choice
Read the full Deployment and Migration explanation →

A company is migrating a 500 GB on-premises PostgreSQL database to Amazon RDS for PostgreSQL. The migration must have minimal downtime and support ongoing replication after the initial load. Which AWS service should be used?

Question 11hardmultiple choice
Read the full Deployment and Migration explanation →

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?

Question 12easymultiple choice
Read the full Deployment and Migration explanation →

A company wants to migrate an on-premises MySQL database to Amazon RDS for MySQL with minimal downtime. They plan to use AWS DMS. Which source database configuration is required to enable ongoing replication (CDC)?

Question 13mediummultiple choice
Read the full Deployment and Migration explanation →

A company is migrating a 2 TB SQL Server database to Amazon RDS for SQL Server. They need to minimize downtime and are using AWS DMS with CDC. The migration is taking longer than expected during the full load phase. Which change would most likely improve the full load performance?

Question 14easymultiple choice
Read the full NAT/PAT explanation →

A company is migrating an on-premises MongoDB database to Amazon DocumentDB (with MongoDB compatibility). They want to validate that the data is consistent after migration. Which tool should they use?

Question 15mediummulti select
Read the full Deployment and Migration explanation →

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?

Question 16hardmulti select
Read the full Deployment and Migration explanation →

A company is migrating a self-managed PostgreSQL database to Amazon Aurora PostgreSQL. They want to use the pglogical extension for logical replication to minimize downtime. Which THREE prerequisites must be met before setting up pglogical?

Question 17mediummultiple choice
Read the full Deployment and Migration explanation →

A company is migrating a 500 GB on-premises PostgreSQL database to Amazon RDS for PostgreSQL. The migration must have minimal downtime and support ongoing replication after the initial load. The network link has limited bandwidth, and the company wants to avoid costly data transfer fees. Which approach should be used?

Question 18hardmultiple choice
Read the full Deployment and Migration explanation →

A team is using AWS DMS to migrate a 3 TB Oracle database to Amazon Aurora PostgreSQL. They configured the task as shown. After the full load completes, they notice that the target tables have no indexes, primary keys, or foreign keys. What is the most likely cause?

Exhibit

Refer to the exhibit.

-- AWS DMS Migration Task JSON excerpt:
{
  "MigrationType": "full-load",
  "TableMappings": {
    "rules": [
      {
        "rule-type": "selection",
        "rule-id": "1",
        "rule-name": "1",
        "object-locator": {
          "schema-name": "%",
          "table-name": "%"
        },
        "rule-action": "include"
      }
    ]
  },
  "TargetTablePrepMode": "DROP_AND_CREATE"
}
Question 19easymultiple choice
Read the full Deployment and Migration explanation →

A company is migrating a 2 TB MySQL database from on-premises to Amazon RDS for MySQL. They need to minimize downtime and ensure data consistency. They plan to use AWS DMS. What is the first step they should take before starting the migration task?

Question 20mediummultiple choice
Read the full Deployment and Migration explanation →

A company is migrating a 500 GB MySQL database from on-premises to Amazon RDS for MySQL. The migration must have minimal downtime and support ongoing replication. Which AWS service should be used?

Continue with 20-question session →

Free account

Track your progress over time

Create a free account to save your results and see which topics improve across sessions.

Sign up freeLog in

Focused Deployment and Migration sessions

Start a Deployment and Migration only practice session

Every question in these sessions is drawn from the Deployment and Migration domain — nothing else.

10 questions20 questions30 questions50 questions
Browse all Deployment and Migration questions →Mixed DBS-C01 session

Related practice questions

Related DBS-C01 topic practice pages

Move into related areas when this topic feels solid.

Workload-Specific Database Design practice questions

Practise DBS-C01 questions linked to Workload-Specific Database Design.

Deployment and Migration practice questions

Practise DBS-C01 questions linked to Deployment and Migration.

Management and Operations practice questions

Practise DBS-C01 questions linked to Management and Operations.

Monitoring and Troubleshooting practice questions

Practise DBS-C01 questions linked to Monitoring and Troubleshooting.

Database Security practice questions

Practise DBS-C01 questions linked to Database Security.

DBS-C01 fundamentals practice questions

Practise DBS-C01 questions linked to DBS-C01 fundamentals.

DBS-C01 scenario practice questions

Practise DBS-C01 questions linked to DBS-C01 scenario.

DBS-C01 troubleshooting practice questions

Practise DBS-C01 questions linked to DBS-C01 troubleshooting.

Frequently asked questions

What does the DBS-C01 exam test about Deployment and Migration?
Deployment and Migration questions test whether you can apply the concept in context, not just recognise a definition.
How should I use these practice questions?
Select your answer before revealing the explanation. Then read why each option is right or wrong — this active recall approach builds retention far faster than re-reading notes.
Can I practise just Deployment and Migration questions in a focused session?
Yes — the session launcher on this page draws every question from the Deployment and Migration domain. Use a 10-question session first to gauge your baseline, then move to 20 or 30 once the weak spots are clear.
Where can I practise other DBS-C01 topics?
Use the topic links above to move to related areas, or go back to the DBS-C01 question bank to see all topics.
Are these real exam questions or dumps?
These are original practice questions written to test the same concepts the DBS-C01 exam covers. They are not copied from any real exam or dump site.