A FLOOD IN THE SERVER ROOM HAS RENDERED YOUR PRIMARY SQL SERVER IN...

9. A flood in the server room has rendered your primary SQL Server in Washington inoperable, and you must wait at least a week for replacement hardware. In the meantime, you must prepare a customer activity report based on the Sales database. You restore the Sales database to a SQL Server in Moscow. You know that the collation of the Washington server was set to Latin1_General_CI_AI, while the Moscow server’s collation is Cyrillic_General_CS_AS. Unicode is used in all databases in your organization. What must you do to ensure that the customer activity report based on the restored database is sorted in the same way as it was before the disaster?A. Use the COLLATE Latin1_General_CI_AI clause with the ALTER DATABASE statement after the restore.B. Use the COLLATE Latin1_General_CI_AI clause with the SELECT statement in the report.C. Do nothing. The results will be sorted the same way as they were before the restore operation because the database collation will not change.D. Use the COLLATE Latin1_General_CI_AI clause with the RESTORE DATABASE statement.