MCSE Training Kit : Microsoft SQL Server 2000 Database Design and Implementation (Exam 70-229)

This official MCSE TRAINING KIT teaches how to design and implement database solutions using Microsoft SQL Server 2000 Enterprise Edition, as well as providing in-depth preparation for MCP Exam 70-229-a core exam for MCDBA certification and an elective on the Microsoft Windows 2000 MCSE track. Topics map directly to the objectives measured by the MCP exam, including developing a logical data model, implementing the physical database, retrieving and modifying data, programming business logic, tuning and optimizing data access, and designing a database security plan. Students learn through an integrated system of skill-building tutorials, case study examples, and self-assessment exercises. An economical alternative to classroom instruction, this kit enables students to set their own pace and learn by doing

QUESTION 1
You work as the network administrator at Certkiller .com. The Certkiller .com logical
network design consists of a single Active Directory domain named Certkiller .com.
All servers on the Certkiller .com network run Windows Server 2003.
The Certkiller .com domain consists of four sites. These four sites are named
Certkiller 1, Certkiller 2, Certkiller 3, and Certkiller 4 respectively. The network is not
fully routed and site link bridging has been disabled. The exhibit below illustrates
the site configuration:
The Certkiller .com schema administrator added a few new attributes to the schema
on a domain controller in the Certkiller 1 site on a Saturday. On the following
Monday you verified the schema on a domain controller in the Certkiller 3 site and
then discovered that the modifications have not been replicated to the domain
controller. You then received instruction to ensure that the Active Directory
replicate to the Certkiller 3 site in an efficient manner.
What should you do?

Actualtest.org – The Power of Knowing
A. Configure a site link bridge between Certkiller 1 and Certkiller 3.
B. Configure a site link between Certkiller 1 and Certkiller 3.
C. Move the schema master operations role to a Certkiller 4 domain controller.
D. Install a domain controller for Certkiller 4 in the Certkiller 3 site.
Answer: A
Explanation
: A Site link bridge is used to connect two or more sites if the IP network is not fully
routed or if replication is not converging efficiently. Site link bridging enables domain
controllers that are not directly connected via a communication link to communicate with
each other. Thus a site link bridge between Certkiller 1 and Certkiller 4 would solve the
problem.
Incorrect answers:
B: Site links can only be created on a fully IP routed network between the sites that have
IP connectivity.
C: You should not move the schema master role to a domain controller in Certkiller 4.
This will result in a replica schema modification to the Certkiller 3 site, but would not
improve Active Directory replication to Certkiller 3.
D: There is no need to place a domain controller for Certkiller 4 in the Certkiller 3 site. This
will not provide efficient replication between Certkiller 1 and Certkiller 3.
QUESTION 2
HOTSPOT
You work as the network architect at Certkiller .com. Your job description involves
designing the Certkiller .com logical network design. All servers on the Certkiller .com
network will run Windows Server 2003 after they have been migrated from a
Windows NT 4.0 environment. Certkiller .com has its headquarters in Chicago and
branch offices in Dallas and Miami.
Each of the Certkiller .com offices has a Finance department, Sales department and a
Marketing department. Only the head quarters in Chicago has two additional
departments named the Research and Development department and the
Management department respectively. Domain administration will be handled by
the Certkiller .com IT department. In addition, onsite administrators will be deployed
and they will be responsible for the administration of user accounts in each of the
Certkiller .com branch offices. At the Chicago office an administrator will be assigned
to manage the Research and Development department users and another
administrator to manage the Management department users.
You have been given instruction to create the organization unit (OU design to
support the company’s administrative structure. You thus need to keep in mind
that:
1. Administrators should only be delegated control to objects for which they are
responsible.
2. The design must allow for permissions to be maintained using the least amount of

Actualtest.org – The Power of Knowing
administrative effort.
To this end you need to decide on which OU structure would best suit the
Certkiller .com administrative goals.
What should you do? (To answer choose the appropriate OU structure that you
would implement.)
Answer:
Explanation:
The scenario needs the OU design to accommodate the IT administrative model of the
company. There is a strong centralized tendency in the IT department being responsible
for domains. But there is also the geographic aspect that has to be kept in mind. Thus it is
a hybrid administrative model which calls for an OU structure that is geographically
based at the higher level OU and then maguide use of unit-based lower level OUs. With

Actualtest.org – The Power of Knowing
this type of approach you can have granular delegation of administration.
Thus you should have three top level OUs based of geographic location, then create two
child OUs that is subordinate to the Chicago OU. This way all the different requirements
and responsibilities of the IT department are accommodated. Furthermore the containers
will be tailored to both geographic and departmental requirements which maguide
administrative permissions that have to be applied and modified possible with the least
amount of administrative effort.
Incorrect answers:
A: You should not choose a geographic based OU structure. This would not make
provision for the ability to maintain the permissions and administrative assignments for
the Research and Development department and the Management department in an
efficient way.
B: This design where the OU structure includes top-level OUs for Chicago, Dallas,
Miami and Management would not provide the ability to maintain the permissions and
administrative assignments for the Research and Development department and the
Management department.
D: Chicago OU should not be the only top-level OU with Dallas, Miami, Research and
Development, and Management the child OUs. This structure will allow for the
delegation of administrative duties, but is not compatible with the Microsoft
recommendations for hybrid administrative models.
QUESTION 3
You work as the network architect at Certkiller .com. Your job description involves
designing the Certkiller .com logical network design. All servers on the Certkiller .com
network will run Windows Server 2003 and all client computers will run Windows
XP Professional. Certkiller .com has its headquarters in Chicago and branch offices
in Dallas, Los Angeles and Miami.
A new Certkiller .com company directive is as follows:
1. Administrators are to be deployed to each office.
2. These administrators will be responsible for the local resources where they will be
located.
3. Only the Chicago office administrators will have the exclusive ability to create
and manage all user accounts.
4. The branch office administrators will not be granted any abilities that will allow
them to control resources in the other locations.
To this end you decided on a design that will make use of a decentralized IT
administration model.
What should you do? (Each correct answer presents part of the solution. Choose
two.)
A. Use a domain tree.
Configure Chicago as the parent domain.
Configure each branch office as a child domain.
B. The branch office administrators should be added to the Domain Admins group in

Actualtest.org – The Power of Knowing
their child domain.
C. Use a single domain structure with organizational units (OUs) representing each
branch office.
Place the branch office resources in their respective OUs.
D. The branch office administrators should be added to the Enterprise group in the
domain tree.
E. Authority for resource administration should be delegated to branch office
administrators for their respective OUs.
The ability to create and manage user accounts for the domain should be delegated to the
Chicago office administrators.
Answer: C, E
Explanation: A single domain with the appropriate OUs will provide the best solution.
You should only create extra domains when a single domain will not suffice. OUs
provide containers into which groups of users and other types of objects can be places.
OUs can also be used to model the organization’s management hierarchy for delegation
of administration. Thus creating an OU per office allows resource management to be
delegated to local administrators. The authority for user administration would not be
delegated to the branch office administrators for these OUs, but this authority should be
granted to the Chicago administrators from the domain level.
Incorrect answers:
A: There is no need to make use of a domain tree; a domain tree implies multiple
domains which is an unnecessary complexity that is not required at this stage.
B: The branch office administrators should not be added to the Domain Admins group in
their child domains as it will result in them having excessive permissions.
D: The branch office administrators should not be added to the Enterprise group in the
domain tree. This will allow them with too many permissions than is necessary under the
circumstances.
Free download:passguide Microsoft 70-229
Free download:passguide Microsoft 70-229

password:www.certbible.org

PassGuide Cisco Exams Questions & Training Materials

1. Free SQL Server 2000 Database Design and Implementation: MCAD/MCSD/MCSE Training Guide Exam 70-229 (Training Guides (Que)) (Paperback)
2. Free MCDBA, MCSE, MCSD, MCAD Training Guide (70-229): SQL Server 2000 Database Design and Implementation
3. Free MCSA/MCSE/MCDBA Self-Paced Training Kit: Microsoft SQL Server(TM) 2000 System Administration, Exam 70-228, Second Edition (Pro-Certification) (Paperback)
4. Free MCITP: Microsoft Exchange Server 2007 Messaging Design and Deployment Study Guide: Exams 70-237 and 70-238
5. Free Managing and Maintaining a Windows Server 2003 Environment 70-292
6. Free MCSE Self-Paced Training Kit (Exam 70-294): Planning, Implementing, and Maintaining a Microsoft Windows Server 2003 Active Directory Infrastructure, Second Edition
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 MCSE Training Kit, Microsoft Exchange 2000 Server : Microsoft Exchange 2000 Server Implementation and Administration
9. Free MCSE Training Kit — Microsoft(r) Windows(r) 2000 Server
10. Free MCAD/MCSD Training Guide (70-310): Developing XML Web Services and Server Components with Visual Basic .NET and the .NET Framework
11. Free Microsoft.Cert-70-315.Practice.Exam.v7.0
12. Free Passguide Microsoft mcse 70-232 v2.93