70-433 · Question #58
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'…
The correct answer is C. varchar(max). Sparse columns are ordinary columns that have an optimized storage for null values. Sparse columns reduce the space requirements for null values at the cost of more overhead to retrieve nonnull values. The following data types cannot be specified as SPARSE:
Question
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?
Options
- Atext
- Bgeometry
- Cvarchar(max)
- DA user-defined type defined as 'bit NOT NULL'
How the community answered
(30 responses)- A10% (3)
- B3% (1)
- C70% (21)
- D17% (5)
Explanation
Sparse columns are ordinary columns that have an optimized storage for null values. Sparse columns reduce the space requirements for null values at the cost of more overhead to retrieve nonnull values. The following data types cannot be specified as SPARSE:
Topics
Community Discussion
No community discussion yet for this question.