DP-300 · Question #423
Hotspot Question You have two resource groups named RG1 and RG2. RG1 contains an Azure SQL managed instance named MI1 that hosts a database named DB1. RG2 contains a SQL managed instance named MI2…
The correct answer is The copy of DB1 will be dropped from MI1. = No; A copy of DB1 on MI1 will be available during the operation. = Yes; A copy of DB1 will be restored to MI2 by using a point-in-time restore (PITR) from a backup taken at the time the operation started. = No. The PowerShell script performs a Move-AzSqlInstanceDatabase operation, which moves DB1 from MI1 to MI2. During a managed instance database move operation, the source database remains available and online throughout the process - the move uses log-shipping/seeding under the hood…
Question
Exhibits
Answer Area
- The copy of DB1 will be dropped from MI1.No
- A copy of DB1 on MI1 will be available during the operation.Yes
- A copy of DB1 will be restored to MI2 by using a point-in-time restore (PITR) from a backup taken at the time the operation started.No
Explanation
The PowerShell script performs a Move-AzSqlInstanceDatabase operation, which moves DB1 from MI1 to MI2. During a managed instance database move operation, the source database remains available and online throughout the process - the move uses log-shipping/seeding under the hood to sync data before the final cutover. The source database (DB1 on MI1) is only dropped after the move completes and is committed, not during the operation, making it available during the process. The operation is NOT a point-in-time restore (PITR); it is a live move/migration using continuous log shipping to synchronize the database to the target instance before cutover.
Topics
Community Discussion
No community discussion yet for this question.