Microsoft
70-459 · Question #6
70-459 Question #6: Real Exam Question with Answer & Explanation
The correct answer is D. ProductType varchar(11) 'ProductType1,. See the full explanation below for the reasoning.
Question
You have a SQL Server 2012 database named Database1. You execute the following code: You insert 3 million rows into Sales. You need to reduce the amount of time it takes to execute Proc1. What should you do?
Exhibit
Options
- AProductive varchar(11) 'ProductType/SID',
- BProductType varchar(11) '@ProductType',
- CProductive varchar(11) 'ProductType/ID',
- DProductType varchar(11) 'ProductType1,
Community Discussion
No community discussion yet for this question.