Courseiva
← DBS-C01
Full test
Deployment and Migration →mediumMultiple ChoiceObjective-mapped

DBS-C01 Deployment and Migration Practice Question

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?

⚠ Common exam trap

Many exam-takers assume a full backup alone is sufficient for migration, overlooking the need for transaction log backups to capture ongoing changes and minimize downtime in a high-transaction environment.

Answer choices

Why each option matters

Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.

Correct answer & explanation

✓

Perform a full backup, then transaction log backups, and restore the full backup with the last log backup.

A full backup followed by transaction log backups allows point-in-time recovery and minimizes downtime during migration. You restore the full backup to RDS, then apply the latest transaction log backup to capture all changes up to the migration cutover, ensuring data consistency without requiring the database to be offline for the entire duration.

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

  • ✓

    Perform a full backup, then transaction log backups, and restore the full backup with the last log backup.

    Why this is correct

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

  • ✗

    Perform only transaction log backups and restore them to RDS.

    Why it's wrong here

    Cannot restore without a full backup.

  • ✗

    Perform a differential backup and restore it to RDS.

    Why it's wrong here

    Requires a prior full backup; still loses transactions.

  • ✗

    Perform a full backup and restore it to RDS.

    Why it's wrong here

    Requires downtime and loses transactions after backup.

About these practice questions

One of 1,663 original DBS-C01 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →

How Courseiva writes practice questions · Editorial policy

JA

Written by Johnson Ajibi, MSc IT Security

Senior Network & Security Engineer · founder of Courseiva

This DBS-C01 practice question is part of Courseiva's free Amazon Web Services certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the DBS-C01 exam.