Microsoft
70-465 · Question #122
You have two databases named DB1 and DB2 that are located on the same server. You plan to create a stored procedure named SProc1 in DB1. SProc1 will query a table named Table2 in DB2. You need to reco
Sign in or unlock 70-465 to reveal the answer and full explanation for question #122. The question stem and answer options stay visible for context.
Submitted by devops_kid· Mar 5, 2026Design database security solutions
Question
You have two databases named DB1 and DB2 that are located on the same server. You plan to create a stored procedure named SProc1 in DB1. SProc1 will query a table named Table2 in DB2. You need to recommend a solution to ensure that SProc1 can access Table2 without granting users direct access to Table2. What should you include in the recommendation? More than one answer choice may achieve the goal. Select the BEST answer.
Options
- AContained databases
- BApplication roles
- CCross-database ownership chaining
- DDigital certificates
Unlock 70-465 to see the answer
You've previewed enough free 70-465 questions. Unlock 70-465 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#Application roles#Cross-database access#Stored procedure security