Which data type is compatible with the SPARSE option?

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?

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’



Leave a Reply 2

Your email address will not be published. Required fields are marked *


test website

test website

I was reading some of your blog posts on this site and I believe this internet site is very informative ! Continue posting .

swetha

swetha

C.
varchar(max)

Is correct option