You are preparing a new index on a table that has 1,500 rows. 10 rows are added to this table every day. The table already has a primary key, and the new index does not represent the order in which data in the table is to be stored. Updates to the table occur periodically but are infrequent. Which type of index would you create under this situation?

With only 1500 rows and slow growth (10/day), a nonclustered index is appropriate because the table already has a primary key (which is typically clustered). Low FILLFACTOR leaves space on leaf pages for the new rows being added, reducing page splits. Updates are infrequent, so the wasted space from low fill factor is acceptable. A clustered index would be redundant since one likely exists for the primary key.