Valid 70-465 Dumps shared by ExamDiscuss.com for Helping Passing 70-465 Exam! ExamDiscuss.com now offer the newest 70-465 exam dumps, the ExamDiscuss.com 70-465 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com 70-465 dumps with Test Engine here:
You need to recommend a solution to minimize the amount of time it takes to execute USP_5. What should you include in the recommendation?
Correct Answer: A
Explanation/Reference: Explanation: * Scenario: A stored procedure named USP_5 changes data in multiple databases. Security checks are performed each time USP_5 accesses a database. * Cross-database ownership chaining occurs when a procedure in one database depends on objects in another database. A cross-database ownership chain works in the same way as ownership chaining within a single database, except that an unbroken ownership chain requires that all the object owners are mapped to the same login account. If the source object in the source database and the target objects in the target databases are owned by the same login account, SQL Server does not check permissions on the target objects. Reference: http://technet.microsoft.com/en-us/sqlserver/bb669059(v=vs.71).aspx