70-465 · Question #16
Drag and Drop Question You have a server named SQL1 that has SQL Server 2012 installed. SQL1 hosts a database named Database1. Database1 contains a table named Table1. Table1 is partitioned across fiv
The correct answer is IX_Type: Aligned; IX_Account: Nonaligned; IX_DATE: Nonaligned; IX_Amount: Nonaligned. IX_Type should be Aligned because it is the clustered index on the partitioned table - aligned indexes share the same partition scheme as the base table, which optimizes partition elimination and improves query performance when filtering by the Date field. The remaining indexes (
Question
Exhibits
Answer Area
Drag items
Correct arrangement
- IX_Type: Aligned
- IX_Account: Nonaligned
- IX_DATE: Nonaligned
- IX_Amount: Nonaligned
Explanation
IX_Type should be Aligned because it is the clustered index on the partitioned table - aligned indexes share the same partition scheme as the base table, which optimizes partition elimination and improves query performance when filtering by the Date field. The remaining indexes (IX_Account, IX_DATE, IX_Amount) should be Nonaligned because they are nonclustered indexes that do not follow the table's partition scheme; nonaligned nonclustered indexes can span all filegroups independently, allowing them to be more efficiently used across the entire table without being bound to the partition boundaries, which maximizes query performance for cross-partition lookups on those columns.
Topics
Community Discussion
No community discussion yet for this question.