CompTIA Data+ DA0-002 (V2) Practice Question

The column must store multilingual text, so a Unicode-capable data type is mandatory. In SQL Server, the Unicode options are nchar and nvarchar.

• nchar(200) allocates a fixed 200 characters (400 bytes) for every row, wasting space on shorter names.
• nvarchar(200) is Unicode and variable-length; it stores only the bytes required for each value plus a small length indicator, so short names consume far less space.
• char(200) and varchar(200) are non-Unicode in most collations (unless UTF-8 is explicitly enabled), so they cannot reliably hold Chinese or Arabic characters.

Therefore, nvarchar(200) is the best fit because it supports full Unicode and minimizes storage for values that are typically shorter than the declared maximum.