You have a table named Books that contains information about books. Books has the columns in the following table.
You plan to create several queries that will filter on Title and ISBN. The queries will return values from Title, ISBN, and Description.
You need to recommend an indexing solution to meet the following requirements:
• Minimize the amount of time required to return the results of the planned queries
• Minimize the number of indexes
What should you recommend?
A. Create a nonclustered index on each column.
B. Create a clustered index on Title and ISBN and set the index fill factor to 75.
C. Create a nonclustered index on Title and ISBN and include the Description column.
D. Create a clustered index on Title, ISBN and Description as the key value.
