Microsoft
70-451 · Question #43
70-451 Question #43: Real Exam Question with Answer & Explanation
Sign in or unlock 70-451 to reveal the answer and full explanation for question #43. The question stem and answer options stay visible for context.
Question
You are a database developer. You plan to design a database solution by using SQL Server 2008. A database contains a table named Person. The structure of the table is as shown in the following exhibit. (Click the Exhibit button.) The table has the following indexes: - A unique clustered index on the PersonID column named IX_Person_PersonID - A nonclustered index on the FirstName and LastName columns named IX_Person_FirstName_LastName A nonclustered index on the PersonType column named IX_Person_PersonType that has FirstName and LastName as included columns The table contains approximately 700,000 records. The approximate number of records for each PersonType is 3,000. You execute the following query. SELECT P.FirstName, P.LastName FROM Person P WHERE P.PersonType = 'DR' You plan to analyze the performance of the query by using an execution plan. You need to ascertain that the indexes are used optimally. What should you do?
Exhibit
Options
- AVerify that a clustered index scan operation is performed on the IX_Person_PersonID index.
- BVerify that an index seek operation is performed on the IX_Person_PersonType index.
- CVerify that an index seek operation is performed on the IX_Person_PersonType index, and
- DVerify that an index seek operation is performed on the IX_Person_PersonType index, and
Unlock 70-451 to see the answer
You've previewed enough free 70-451 questions. Unlock 70-451 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.