THE TABLE THAT YOU WILL BE TRANSFERRING DATA FOR HAS SOME COLUMN...

2008. The table that you will be transferring data for has some columns that use the nvarchar( ) data type, and has. To ensure that the data is transferred without any corruption of the character data, which data file type should you use?A. CharacterB. UnicodeC. NativeD. Unicode nativeCorrect Answer and Explanation: D. D is the correct answer because both the source and target instances will be SQL Server 2008, you can use one of the native data file types. However, to ensure that the Unicode characters in the nvarchar( ) columns are transferred correctly, you should use the Unicode native format.Incorrect Answers and Explanations: B, C, and D. Answer B is incorrect because it does allow the transfer of Unicode characters in the nvarchar( ) fields, but it converts all data (including numbers, dates, etc) to a Unicode character representation. This method is not as efficient as the native representation of SQL Server data use by the native data file types. Answers C and D are incorrect because they do not support the extended Unicode characters that may occur in the nvarchar( ) fields.