Microsoft
70-451 · Question #52
70-451 Question #52: Real Exam Question with Answer & Explanation
The correct answer is D. Create a nonclustered index on Title and ISBN and include the Description column.. See the full explanation below for the reasoning.
Question
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?
Exhibit
Options
- ACreate a nonclustered index on each column.
- BCreate a clustered index on Title, ISBN and Description as the key value.
- CCreate a clustered index on Title and ISBN and set the index fill factor to 75.
- DCreate a nonclustered index on Title and ISBN and include the Description column.
Community Discussion
No community discussion yet for this question.