You have multiple tables that represent properties of the same kind of entities. The property values are comprised of text, geometry, varchar(max), and user-defined types specified as ‘bit NOT NULL’ data types.
You plan to consolidate the data from multiple tables into a single table. The table will use semi-structured storage by taking advantage of the SPARSE option.
You are tasked to identify the data types that are compatible with the SPARSE option.
Which data type is compatible with the SPARSE option?

A.
text

B.
geometry

C.
varchar(max)

D.
A user-defined type defined as ‘bit NOT NULL’