MCSA/MCSE/MCDBA Self-Paced Training Kit: Microsoft SQL Server(TM) 2000 System Administration, Exam 70-228, Second Edition (Pro-Certification) (Paperback)

Product Description
Learn how to install, configure, and administer SQL Server 2000–as you prepare for MCP Exam 70-228, a core requirement for MCDBA certification and an elective for the MCSE and MCSA tracks.

QUESTION 1:
You work as the network administrator at CertKiller.com. The CertKiller.com
network consists of a single Active Directory domain named Certkiller .com.
CertKiller.com network contains twelve servers that run Windows Server 2003 and
all client computers run Windows 2000 Professional.
Four of the servers are configured as domain controllers, while the other servers are
configured as file servers, intranet Web servers, or database servers. The domain
controllers will remain in the default Domain Controllers container. You design
CertKiller.com’s organizational unit (OU) structure to reflect the specific server
roles. The OU structure is displayed in the following exhibit.
Exhibit

Actualtest.org – The Power of Knowing
You create a security template named Servers.inf, which will apply a required set of
NTFS and registry permissions to all servers. You also create a security template for
each server role and name the File.inf. Intranet.inf, and Database.inf. Each of these
templates contains role-specific security settings for each type of server.
You need to ensure that the deployment of each template require as little
administrative effort as possible.
What should you do? (Each correct answer presents part of the solution. Choose
TWO.)
A. You should create a GPO, link it to the Servers OU, and then import the Servers.inf
template into the new GPO.
B. You should create a GPO, link it to the File Servers OU, the Intranet Servers OU, and
the Database Servers OU, and then import the Servers.inf template into the new
GPO.
C. You should create a new GPO for each of the server OUs, link each of the GPOs to its
respective OU, and then import each of the role-specific templates to its corresponding
GPO.
D. You should create a new GPO for each of the server OUs, link each of the GPOs to
the Servers OU, and then import each of the role-specific templates to its corresponding
070-296
Actualtest.org – The Power of Knowing
GPO.
Answer: A, C
Explanation: You can apply the required set of NTFS and registry permissions to all
servers by creating a GPO, linguide it to the Servers OU, and then importing the
Servers.inf template into this GPO. These settings will then be applied to all servers
in the servers OU or one of its child OUs. To apply a role-specific set of security
settings to each server role, you should create a GPO and link it to each of the child
OUs in the Servers OU container. You can then import the appropriate security
template to its respective GPO.
Incorrect Answers:
B: Importing the Servers.inf template into a GPO liked to the File Servers OU, the
Intranet Servers OU, and the Database Servers OU would require more administrative
effort than necessary.
D: Importing each role-specific template into a separate GPO and then linguide these
GPOs to the Servers OU container would apply all settings to all servers located
within the Servers OU.
QUESTION 2:
You work as the network administrator at Certkiller .com. The Certkiller .com
network consists of a single Active Directory domain named Certkiller .com. All
servers on the Certkiller .com network run Windows Server 2003 and all client
computers run Windows XP Professional.
A new Certkiller .com network policy requires that only authorized IT employees be
allowed to use specified troubleshooting tools. The employees in the IT department
are members of the IT security group.
You are currently creating a GPO that contains a software restriction policy to
prevent users from running the specified troubleshooting tools.
You need to ensure that the manner in which the GPO is applied affects all users
except the IT employees.
What should you do? (Choose all that apply)
A. You should place the IT group into an OU named IT Employees, and enable Block
Policy inheritance on the OU.
B. You have to configure the software restriction policy in the Computer Configuration
section of the GPO.
C. You have to configure the software restriction policy in the User Configuration section
of the GPO.
D. Link the GPO to the domain, and then assign the “Deny – Apply Group Policy”
permission for the GPO to the IT group.
Answer: C, D
070-296
Actualtest.org – The Power of Knowing
Explanation: A GPO contains computer-specific policies that are found under the
Computer Configuration node, and user-specific policies that are found under the
User Configuration node. Computer-specific policies target computer accounts and
user-specific policies target user accounts. In this scenario, you should apply the
GPO to all users in the domain except members of the IT group. To do this, you
should configure the appropriate user-specific software restrictions policies in a
GPO, link the GPO to the domain and assign the “Deny – Apply Group Policy”
permission for the GPO to the IT group.
Incorrect Answers:
A: A group is not a container because it does not contain its members. A group is an object
in an Active Directory database, and the group’s membership is a multi-valued attribute
of that object. You can, therefore, not apply a GPO to a group’s members by placing the
group into an OU, or prevent a GPO from being applied to a group’s members by placing
the group object into an OU and selecting Block Policy inheritance on the OU.
B: If you configure a computer-specific software restriction policy, you would only
target computer accounts, and you would not be able to filter the scope of the GPO by
denying permissions to a group that contained only user accounts.
QUESTION 3:
You work as the network administrator at Certkiller .com. The Certkiller .com
network consists of a single Active Directory domain named Certkiller .com. All
servers on the Certkiller .com network run Windows Server 2003 and all client
computers run Windows XP Professional.
You are required to deploy a new version of service pack to Certkiller .com client
computers. You start by adding the installation files in a shared folder hosted on a
files server. You configure the appropriate software installation policy in a GPO.
You receive reports a short while later, from users stating that the service pack is
not installed on their computers.
You need to ensure that the new version of service pack is installed on the
appropriate computers.
What should these users do?
A. The users should invoke the installation from Add or Remove programs in Control
Panel.
B. The users should log off from their computers, and then log back on.
C. The users should restart their computers.
D. The users should invoke the installation from the Start menu.
Answer: C
Explanation: In a computer-specific policy, an application can be assigned to
computers. This application will start installing at startup. Users should, therefore,
restart their computers to initiate the installation of the new version of service pack.
Incorrect Answers:

Actualtest.org – The Power of Knowing
A, D: Applications that are assigned to computers are not advertised in the Start menu or
Add or Remove programs in Control Panel.
B: Using this option could cause only the applications that are assigned to users to be
installed.
Free download:passguide Microsoft Exam 70-228
Free download:passguide Microsoft Exam 70-228

password:www.certbible.org

PassGuide Cisco Exams Questions & Training Materials

1. Free MCSA/MCSE Self-Paced Training Kit: Managing a Microsoft Windows 2000 Network Environment (Exam 70-218)
2. Free MCSA/MCSE Self-Paced Training Kit (Exam 70-270): Installing, Configuring, and Administering Microsoft Windows XP Professional, Second Edition
3. Free MCSE Self-Paced Training Kit (Exam 70-294): Planning, Implementing, and Maintaining a Microsoft Windows Server 2003 Active Directory Infrastructure, Second Edition
4. Free MCSA/MCSE: Windows Server 2003 Network Security Administration Study Guide (70-299)
5. Free MCSE Training Kit : Microsoft SQL Server 2000 Database Design and Implementation (Exam 70-229)
6. Free Passguide Microsoft MCSE Exam 70-294 v2008-18-05 by Ali Starian 108q vce
7. Free MCSE Exam 70-296 Study Guide and DVD Training System: Planning, Implementing and Maintaining a Windows Server 2003 Environment for a MCSE Certified on Windows 2000
8. Free MCSA/MCSE Self-Paced Training Kit (Exam 70-350): Implementing Microsoft Internet Security and Acceleration Server 2004 (Pro-Certification)
9. Free MCSE Training Kit, Microsoft Exchange 2000 Server : Microsoft Exchange 2000 Server Implementation and Administration
10. Free Passguide microsoft Mcdba mcse 70-291 Exam
11. Free MCAD/MCSE/MCDBA 70-229 Exam Cram 2: Designing & Implementing Databases w/SQL Server 2000 Enterprise Edition (Exam Cram 2) (Paperback)
12. Free MCSA/MCSE Self-Paced Training Kit (Exam 70-290): Managing and Maintaining a Microsoft Windows Server 2003 Environment