You have multiple tables that represent properties of the same kind of entities. The property values
are comprised of text, geometry, varchar(max), and userdefined
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 userdefined
type defined as ‘bit NOT NULL’