Microsoft
70-433 · Question #66
You work as a network database administrator at ABC.com. ABC.com has a poorly designed database with similar data stored in numerous tables. The tables use columns with different data types. You…
The correct answer is B. On columns of the varchar(max) data type. See the full explanation below for the reasoning.
Question
You work as a network database administrator at ABC.com. ABC.com has a poorly designed database with similar data stored in numerous tables. The tables use columns with different data types. You need to collate these tables into a single table by using the SPARSE option. On which of the following can the SPARSE option be used?
Options
- AOn columns of the geography data type.
- BOn columns of the varchar(max) data type.
- COn IDENTITY columns.
- DOn columns with user-defined data types.
- EOn NOT NULL columns.
How the community answered
(47 responses)- A11% (5)
- B83% (39)
- C4% (2)
- E2% (1)
Community Discussion
No community discussion yet for this question.