70-463 · Question #222
70-463 Question #222: Real Exam Question with Answer & Explanation
The correct answer is C: Nonclustered. The factSales table already has a clustered index on its primary key - a table can have only one clustered index, so option A is not viable. Semantic Search indexes are for full-text and meaning-based searching of unstructured text, which does not apply here. XML indexes are for
Question
Options
- AClustered
- BSemantic search
- CNonclustered
- DXML
Explanation
The factSales table already has a clustered index on its primary key - a table can have only one clustered index, so option A is not viable. Semantic Search indexes are for full-text and meaning-based searching of unstructured text, which does not apply here. XML indexes are for XML data type columns, which are not present. A nonclustered index is the correct choice: it creates a separate index structure that can cover the foreign key columns and/or the aggregate column, allowing the query optimizer to use index seeks and avoid full table scans during data retrieval. In a data warehouse, nonclustered indexes on foreign key columns are a standard technique for improving query performance on fact tables.
Community Discussion
No community discussion yet for this question.