070-762 Free Dumps Study Materials
Question 5: Note: This question is part of a series of questions that present the same scenario. Each
question in this series contains a unique solution. Determine whether the solution meets the stated
goals.
The Account table was created by using the following Transact-SQL statement:
There are more than 1 billion records in the Account table. The Account Number column uniquely
identifies each account. The ProductCode column has 100 different values. The values are evenly
distributed in the table. Table statistics are refreshed and up to date.
You frequently run the following Transact-SQL SELECT statements:
You must avoid table scans when you run the queries.
You need to create one or more indexes for the table.
Solution: You run the following Transact-SQL statement:
CREATE CLUSTERED INDEX PK_Account ON Account(ProductCode);
Does the solution meet the goal?
A. No
B. Yes
Correct Answer: A
Explanation
We need an index on the productCode column as well.
References: https://msdn.microsoft.com/en-us/library/ms190457.aspx