Home » Microsoft » 70-465 » What should you include in the recommendation?
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?
A. Enable cross-database chaining.
B. Use a server role to group all logins.
C. Use the EXECUTE AS clause in USP_5.
D. Copy USP.5 to each database.
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