I have passed 70-028 today at first try. I would say thanks to www.examcheets.com and everybody participated in this braindumps site. Don’t worry about the exam, everybody can pass the test as long as take serious study and practice. You do not need expensive CTEC course for passing this one.

Suggestion for exam preparation :

1) Make sure that you have experience with the common administrative task of SQL 7
2) Browse through Books Online (BOL).
3) Take your material summary / study guide from www.brainbuzz.com.
4) Take your first practice exam from www.msexpert.com (130+ question in pool), its free
5) Take your brain dumps from this site ie  www.myresearchinstitute.com
6) Take exam simulation from this site : www.examcheets.com

I guarantee you will pass with minimal score 900 !

OK Guys, below is my dumps as long as I remember today.

1)You are developing a security strategy for a new installation of SQL. You want to minimize the administration required of login. What should you do?

a) Use Windows NT Authentication Add Windows NT accounts as SQL Server login.

b) Use Windows NT Authentication Add Windows NT groups as SQL Server login.

c) Use SQL Server Authentication Add SQL Server login for authorized users.

d) Use SQL Server Authentication. Add Windows NT accounts as SQL Server login.

Answer: B Note: Ref: BOL - Index on: Windows NT groups - Topic: Adding a Windows NT User or Group. Existing Microsoft(r) Windows NT(r) accounts (users or groups) are granted permissions to connect to Microsoft SQL Server(tm) before they can access a database. If all members of a Windows NT group will be connecting to SQL Server, you can grant permission to connect to SQL Server for the group as a whole. Managing group permissions is much easier than redundantly managing permissions for individual users. If a Windows NT group should not be granted permission collectively, you can grant permission to connect to SQL Server for each individual Windows NT user.


2) Your domain has two SQL Server computers named SQL1 and SQL2. Two related databases are on SQL1 and SQL2. You have standard logins on both servers. You are able to connect to both databases on both servers, and you are able to execute queries on both databases on both servers. You are attempting to execute a distributed query that joins data on SQL2 to data on SQL1. On SQL1, you add SQL2 as a linked server. However, when you try to execute the distributed query on SQL1, you receive a message that your login failed. What is the most likely cause of the problem?

A. You did not execute the query on SQL2.

B. You did not map your login on SQL1 to your login on SQL2.

C. You did not use a Windows NT login for the distributed query.

D. You did not establish a direct connection to SQL2, so you are not authenticated for the distributed query.


Answer: B Ref: BOL - Index on: mapping login information, Topic: Security for Linked Servers. During a linked server connection (for example, when processing a distributed query), the sending server provides a login name and password to connect to the receiving server on its behalf. For this connection to work, create a login mapping between the linked servers, using Microsoft(r) SQL Server(tm) stored procedures.

3) A user who has a SQL Server login forgot his password. How should you restore his ability to connect to SQL Server?

A. Drop and re-create both his Windows NT account and his SQL Server login with a new password.

B. Drop and re-create only his SQL Server login with a new password.

C. Change his account password in Windows NT User Manager.

D. Change the password in the SQL Server Login properties dialog box.

Answer: D, SQL server Enterprise Manager allows for easy enterprise-wide configuration and management.

4) Maria preceded you as administrator for Microsoft Windows NT Server and SQL Server. Maria created SQL Server logins and passwords matching users Windows NT accounts. When user logon to the Windows NT Server domain they obtain access to the SQL Server. Which permissions do users receive to access SQL Server by using a trusted connection?

a) Only the same permissions as those that are granted to their SQL Server login

b) Only the same permissions as those that are granted to their Windows NT account

c) The cumulative permissions that are granted to their SQL Server login and their Windows NT account

d) Only the permissions that are granted in common to their SQL Server login and their Windows NT account

Answer: B Note: The NT accounts and the SQL are different entities and mutually exclusive, it is one or the other. Trusted connection is NT Authentication that is why NT Accounts.

5) You plan to give users in the Windows NT Sales group limited access to the Sales and Inventory databases. All access for data modifications and reporting will be through a Microsoft Excel Application. How should you set up access for the Sales group in both databases?

a) Create a single application role. Grant the Sales group permissions on that role in each database.

b) b) Create an application role for each database. Grant the Sales group permissions in each database.

c) c) Create a single application role, and grant it permissions in each database.

d) d) Create an application role in each database, and grant it the appropriate permissions.

Answer: D Ref: BOL - Index on: applications, roles, (Topic: Application Security and Application Roles) Application roles contain no members. Users, Microsoft Windows NT(r) groups, and roles cannot be added to application roles; the permissions of the application role are gained when the application role is activated for the user's connection through a specific application(s). A user's association with an application role is due to being capable of running an application that activates the role, rather than being a member of the role. It is necessary for a connection to lose default permissions applied to the login/user account or other groups or database roles in all databases for the duration of the connection and gain the permissions associated with the application role to ensure that all the functions of the application can be performed. For example, if a user is usually denied access to a table that the application must access, then the denied access should be revoked for the user to successfully use the application. Application roles overcome any conflicts with user's default permissions by temporarily suspending the user's default permissions and assigning them only the permissions of the application role.