Microsoft
70-459 · Question #6
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…
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,
How the community answered
(24 responses)- A8% (2)
- B4% (1)
- C4% (1)
- D83% (20)
Community Discussion
No community discussion yet for this question.