CertInside 70-444
Http://www.CertInside.com CertInside Help you pass any IT Exams
Microsoft 70-444
Optimizing and Maintaining a Database Administration Solution
by Using Microsoft SQL Server 2005
Q&A v 3.99
http://www.CertInside.com/
CertInside,The Most Realistic Practice Exams!
CertInside 70-444
Http://www.CertInside.com CertInside Help you pass any IT Exams
1. You are the administrator of 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?
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. Execute the sp_helplogins system stored procedure for each of the default users that the MedDATA application
creates.
D. Query the sys.database_permissions and sys.database_principals tables in the MedDB database.
Answer: D
2. You are the administrator of a SQL Server 2005 computer named SQL1. SQL1 is a member of a Microsoft Active
Directory domain. You do not have any rights or privileges to perform domain administration. However, you have been
granted membership in the local Administrators group on SQL1. You perform most of the management of SQL1 from
your administrative workstation. However, for security reasons, you want to track all attempts for interactive logons and
network connections to SQL1. What should you do?
A. Create a Group Policy object (GPO) that is configured for success and failure auditing of the Audit account logon
events settin