You want to move a database from server 1 to server 2. When this operation is going on users should be able to execute their reports without modifying reports. Which method you will use?

When moving a database between servers while keeping reports functional, Backup/Restore (C) preserves all database objects, permissions, and metadata without users needing to modify anything. SMO (B) can also transfer databases with full metadata preservation. Detach/Attach (A) can work but is more disruptive and may require fixing orphaned users. Option D 'All' is incorrect because not all methods are equally suitable - Detach/Attach has significant limitations for this use case.