70-432 · Question #126
You are mastering the company database, including the SQL Server 2005 database which include a table called Production. Product. The table has more than 50 columns The most common queries are listed…
The correct answer is A. You should develop a clustered index on the Name column. See the full explanation below for the reasoning.
Question
You are mastering the company database, including the SQL Server 2005 database which include a table called Production. Product. The table has more than 50 columns The most common queries are listed below Transact-SQL statements. --QUERY 1SELECT [Name], [ProductLine], [ListPrice], [Class], [Style] FROM [Production]. [Product]WHERE [ProductLine] = 'T' --QUERY 2SELECT * FROM [Production]. [Product] ORDER BY [Name] When you are minimizing the space required for the indexes. You should select the best indexes to maintain the most common searched to the Production. Product table Which is the correct answer?
Options
- AYou should develop a clustered index on the Name column.
- BYou should develop a nonclustered index on the Name column.
- CYou should develop a clustered index on the ProductLine, ListPrice, Class and Style columns.
- DYou should develop a nonclustered index on the ProductLine, ListPrice columns.
How the community answered
(26 responses)- A81% (21)
- B12% (3)
- C4% (1)
- D4% (1)
Community Discussion
No community discussion yet for this question.