You work as a Database Administrator (DBA) for a company named ABC.com. The company has
a Windows Azure subscription. The company uses a cloud-based SQL Server environment
hosted on SQL Azure.
A database named SalesDB is hosted on SQL Azure. A stored procedure named
SP_UpdateTotals reads data from a table named Orders and inserts the data in a table named
Products.
A new Sales employee named Jane attempts to run SP_UpdateTotals but is unsuccessful. You
check the permissions on the tables in the SalesDB database and verify that Jane has the
SELECT permission.
Company security policy states that all users must have the minimum permissions required to
perform their roles.
How can you enable Jane to run SP_UpdateTotals?
A.
By granting Jane the UPDATE permission on the Products table.
B.
By granting Jane the INSERT permission on the Products table.
C.
By granting Jane the CONTROLE permission on the SP_UpdateTotals stored procedure.
D.
By granting Jane the EXECUTE permission on the SP_UpdateTotals stored procedure.
Explanation: