YOU HAVE BEEN ASKED TO PRODUCE A REPORT COMPARING SALES ACTIVITY BE...

6. You have been asked to produce a report comparing sales activity between the London and São Paulo offices. You restore a backup of the São Paulo sales database on the London SQL Server. You write a query to show sales by product, ordered by product name, and execute it against both databases. You notice that the report based on the São Paulo database is sorted differently. The sales department requires your report in 15 minutes. What is the quickest way to make the sort results of both reports consistent?A. Use the Import / Export data wizard to copy the table from the São Paulo database to the London database.B. Use the ALTER TABLE statement to change the collation of the Product Name column in the Product table to the collation used in the London database.C. Use the copy database wizard to copy the database to a new database on the London server, specifying the new collation.D. Use the COLLATE Collation_Name option with the ORDER BY clause for the SELECT statement that the report is based on. Specify the colla-tion of the London server as Collation_Name.