nerdexam
Microsoft

70-458 · Question #63

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…

The correct answer is A. The Select permission on Customers B. The Execute permission on GetCustomerOrderInfo. See the full explanation below for the reasoning.

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

How the community answered

(61 responses)
  • A
    77% (47)
  • C
    2% (1)
  • D
    11% (7)
  • E
    7% (4)
  • F
    3% (2)

Community Discussion

No community discussion yet for this question.

Full 70-458 Practice