PrepAway - Latest Free Exam Questions & Answers

What should you do?

You work as DBA at AIOTestKing.com. You administer a Microsoft Windows Server 2003 computer named Server1. SQL Server 2005 is installed on Server1 to host a database named MedDB. The MedDB database serves as the backend database for a new client/server application named MedDATA. Installation of the MedDATA application creates the database schema, application roles, and administrative accounts. It also sets all of the default permissions. You need to establish a permissions baseline for all objects in the MedDB database. What should you do?

PrepAway - Latest Free Exam Questions & Answers

A.
Use the SQL Server 2005 Management Studio to review the permissions of the default database objects.

B.
Query the sys.server_permissions table on Server1.

C.
Query the sys.database_permissions and sys.database_principals tables in the MedDB database.

D.
Execute the sp_helplogins system stored procedure for each of the default users that the MedDATA application creates.


Leave a Reply