CompTIA Data+ DA0-002 (V2) Practice Question

nvarchar is the best choice because it stores variable-length Unicode text (UTF-16 or the database's national character set), so every language and supplementary character-including emojis-can be represented while space is allocated only for the actual length of each biography.

• varchar can store variable-length strings, but unless the database or the column is explicitly configured with a UTF-8 (or similar) Unicode character set, it is limited to the code-page of its collation and may corrupt characters that fall outside that range.
• char is fixed-length; short biographies would be padded with spaces, wasting storage and harming performance.
• CLOB can hold multi-megabyte or gigabyte text and supports Unicode, but it is optimized for very large documents. Using it for typical profile bios adds unnecessary overhead and can complicate indexing and filtering compared with a standard column type like nvarchar.