Concept:SQL Server supports two main types of indexes based on how data is sorted and stored.Explanation:The two types of indexes are clustered and nonclustered indexes.A clustered index sorts and stores the actual data rows in the table according to the key values.A nonclustered index stores the key values separately and keeps a reference to the actual data rows.Therefore, SQL Server has exactly two types of indexes: clustered and nonclustered.Answer:D. 2