PrepAway - Latest Free Exam Questions & Answers

Which types of stored procedures should you alter?

You need to alter stored procedures to use the WITH RECOMPILE option. Which types of stored
procedures should you alter? (Each correct answer represents a complete solution. Choose two.)

PrepAway - Latest Free Exam Questions & Answers

A.
Stored procedures implemented from CLR assemblies.

B.
Stored procedures that require the FOR REPLICATION option.

C.
Stored procedures that require the WITH ENCRYPTION option.

D.
Stored procedures that contain queries that use the OPTION (RECOMPILE) hint.


Leave a Reply