Microsoft
70-433 · Question #58
70-433 Question #58: Real Exam Question with Answer & Explanation
Sign in or unlock 70-433 to reveal the answer and full explanation for question #58. The question stem and answer options stay visible for context.
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'
Unlock 70-433 to see the answer
You've previewed enough free 70-433 questions. Unlock 70-433 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.