Question 110
At Harborline Logistics, the shipment data operations team maintains a hybrid order-tracking and warehouse database estate with requirements for continuous shipment updates and recoverable transactions. After a claimed fix, the release reviewer evaluates: A migration run reports success even though database users are orphaned and application logins fail after moving to a new SQL Server instance. Which observed result BEST proves the intended problem is corrected?
Explanation
Correct Answer
Approved application principals authenticate to the target without orphaned user errors or unintended administrator grants. That observable result supports resolution of: A migration run reports success even though database users are orphaned and application logins fail after moving to a new SQL Server instance. The corresponding corrective change is: Map and repair server login identities and database user mappings during post-migration verification with least-privilege checks. The Harborline Logistics reviewer can distinguish demonstrated database behavior from an untested change claim.
Incorrect Answers
The new database reaches the expected state on the destination instance and integrity and application checks match the source. That result is evidence for another corrective change: Select the currently supported Managed Instance database copy or move mechanism after checking edition, region and feature requirements. The alternative problem is: An Azure SQL Managed Instance database move is attempted with a tool that does not support the selected source and destination pairing. The current Harborline Logistics issue is instead: A migration run reports success even though database users are orphaned and application logins fail after moving to a new SQL Server instance. Its decisive acceptance evidence would be: Approved application principals authenticate to the target without orphaned user errors or unintended administrator grants.
The signed-off cutover log proves the agreed recovery point and reconciles final source and target transaction counts. That result is evidence for another corrective change: Define a cutover protocol to quiesce writes, confirm synchronization, record the recovery point and switch only after validation. The alternative problem is: A hybrid migration loses writes because engineers stop applications before verifying the final transaction synchronization and recovery checkpoint. The current Harborline Logistics issue is instead: A migration run reports success even though database users are orphaned and application logins fail after moving to a new SQL Server instance. Its decisive acceptance evidence would be: Approved application principals authenticate to the target without orphaned user errors or unintended administrator grants.
The last synchronization lag and cutover outage remain within objectives and source-to-target validation shows no missing committed data. That result is evidence for another corrective change: Choose an online migration strategy with supported continuous synchronization and a timed cutover consistent with downtime and compatibility limits. The alternative problem is: A 12 TB production database must move to Azure with a near-zero outage requirement, but the plan uses backup and restore during a short maintenance window. The current Harborline Logistics issue is instead: A migration run reports success even though database users are orphaned and application logins fail after moving to a new SQL Server instance. Its decisive acceptance evidence would be: Approved application principals authenticate to the target without orphaned user errors or unintended administrator grants.