You are employed as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. Domain.com has its headquarters in London and a branch office in Paris. You are based at headquarters. Your duties include administrating a SQL Server 2005 database server named Certkiller -DB01
You have been informed by the CIO that the Research and Development department wants a report that evaluates the customer activity in the previous quarter between the office in London and the branch office in Paris. Domain.com wants the information to be sorted by surname and first name. A Domain.com user named Amy Walsh is a junior technician in the IT department. You inform her to restore a recent backup of the Paris database onto your server. Amy Walsh writes the queries to build the report, ordering the information by the LastName and FirstName columns. Amy Walsh reviews the information and detects that the client lists from the Paris database is sorted different to the one in the headquarters. You receive a notification from the Research and Development department that they require the revised data within 15 minutes for a presentation. Amy Walsh needs to implement the fastest possible solution that will guarantee that the information from both databases is sorted identically.
What should Amy Walsh do?
A.
Amy Walsh needs to use the SQL Server Import and Export Wizard to copy the data from the Paris database into new tables whilst specifying the same collation as the London database.
B.
Amy Walsh needs to copy the data in the Paris database to a new database with the same collation as the London database by using the Copy Database Wizard.
C.
The query needs to be modified by Amy Walsh on the Paris database to use the COLLATE setting in the ORDER BY clause.
Thereafter she should specify the same collation as the London database in the query.
D.
The format file should be modified to specify the same collation as the London database.
Thereafter she can import the table again.
Explanation:
COLLATE {collation_name}
Specifies that the ORDER BY operation should be performed according to the collation specified in collation_name, and not according to the collation of the column as defined in the table or view. collation_name can be either a Windows collation name or a SQL collation name. COLLATE is applicable only for columns of the char, varchar, nchar, and nvarchar data types.