CompTIA Data+ DA0-002 (V2) Practice Question

NVARCHAR is the appropriate choice because it always stores Unicode text using UTF-16, guaranteeing support for virtually all modern languages regardless of the server's code page or collation.

• VARCHAR requires a code-page-specific or UTF-8 collation. When the server is using the default non-UTF-8 collation (as in this scenario), characters outside that code page-such as Japanese or Cyrillic-may be truncated or converted to question marks.
• CHAR is a fixed-length, non-Unicode type under the same limitations as VARCHAR and also wastes space for variable-length feedback.
• CLOB (Character Large Object) is intended for very large blocks of text and is not a standard SQL Server column type; in SQL Server the modern equivalent would be NVARCHAR(MAX). For typical feedback strings, NVARCHAR or NVARCHAR(MAX) is more flexible.