Microsoft
70-458 · Question #63
70-458 Question #63: Real Exam Question with Answer & Explanation
Sign in or unlock 70-458 to reveal the answer and full explanation for question #63. The question stem and answer options stay visible for context.
Question
You administer a Microsoft SQL Server 2012 database. The database has a table named Customers owned by UserA and another table named Orders owned by UserB. You also have a stored procedure named GetCustomerOrderInfo owned by UserB. GetCustomerOrderInfo selects data from both tables. You create a new user named UserC. You need to ensure that UserC can call the GetCustomerOrderInfo stored procedure. You also need to assign only the minimum required permissions to UserC. Which permission or permissions should you assign to UserC? Choose all that apply.
Options
- AThe Select permission on Customers
- BThe Execute permission on GetCustomerOrderInfo
- CThe Take Ownership permission on Customers
- DThe Control permission on GetCustomerOrderInfo
- EThe Take Ownership permission on Orders
- FThe Select permission on Orders
Unlock 70-458 to see the answer
You've previewed enough free 70-458 questions. Unlock 70-458 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.