Day: October 13, 2014

QUESTION 11 You administer a Microsoft SQL Server 2012 database. You provide temporary securityadmin access to User1 to the database server. You need to know if User1 adds logins to securityadmin. Which server-level audit action group should you use? A.    SERVER_STATE_CHANGE_GROUP B.    SERVER_PRINCIPAL_IMPERSONATION_GROUP C.    SUCCESSFUL_LOGIN_GROUP D.    SERVER_ROLE_MEMBER_CHANGE_GROUP Answer: D Explanation: http://technet.microsoft.com/en-us/library/cc280663.aspx SERVER_STATE_CHANGE_GROUP This event is...

QUESTION 1You 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...