READ Free Dumps For Microsoft- 70-461
| Question ID 15096 | You are a database developer at an independent software vendor. You create stored
procedures that contain proprietary code.
You need to protect the code from being viewed by your customers.
Which stored procedure option should you use?
|
| Option A | ENCRYPTBYKEY
|
| Option B | ENCRYPTION
|
| Option C | ENCRYPTBYPASSPHRASE
|
| Option D | ENCRYPTBYCERT
|
| Correct Answer | B |
Explanation Reference: http://technet.microsoft.com/en-us/library/bb510663.aspx Reference: http://technet.microsoft.com/en-us/library/ms174361.aspx Reference: http://msdn.microsoft.com/en-us/library/ms187926.aspx Reference: http://technet.microsoft.com/en-us/library/ms190357.aspx Reference: http://technet.microsoft.com/en-us/library/ms188061.aspx
| Question ID 15097 | You develop a stored procedure for a Wholesale glass manufacturing company. The
Stored procedure is based combination of the following tables:
You observe that the stored procedure returns results very slowly.
You need to improve the execution speed of the stored procedure.
Which cursor type should you use?
|
| Option A | GLOBAL STATIC
|
| Option B | LOCAL STATIC READ_ONLY FORWARD_ONLY
|
| Option C | GLOBAL FORWARD_ONLY.
|
| Option D | LOCAL FAST_FORWARD
|
| Correct Answer | D |
Explanation