Pass4sure Microsoft MCSE 70-229 2.93
Preparation Guide for Exam 70-229
Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition
Audience profile
Candidates for this exam work in a medium-sized to enterprise computing environment that uses Microsoft SQL Server 2000 Enterprise Edition. Candidates have at least one year of experience implementing relational databases in environments with the following characteristics:
• Heterogeneous databases.
• SQL Server security integrated with Windows Authentication.
• Client/server configurations of 50 to 5,000 or more users.
• Web configurations that use Microsoft Internet Information Services (IIS) or COM+.
• Databases as large as 2 TB.
• Multiple installations of SQL Server 2000.
Credit toward certification
When you pass the Exam 70-229: Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition, you achieve Microsoft Certified Professional status.
• Learn about Microsoft Certified Professional status
You also earn credit toward the following certifications:
• Core credit toward Microsoft Certified Database Administrator on Microsoft SQL Server 2000 certification
• Elective credit toward Microsoft Certified Systems Engineer on Microsoft Windows 2000 certification
• Elective credit toward Microsoft Certified Systems Engineer on Microsoft Windows NT 4.0 certification
• Elective credit toward Microsoft Certified Solution Developer for Microsoft .NET certification
• Elective credit toward Microsoft Certified Solution Developer certification
• Elective credit toward Microsoft Certified Application Developer for Microsoft .NET certification
Database professionals who use Microsoft SQL Server 2005 should consider the Microsoft Certified Technology Specialist (MCTS) and Microsoft Certified IT Professional (MCITP) credentials. They provide IT professionals with a simpler and more targeted framework to display their technical and on-the-job skills.
• Learn about Microsoft Certified Technology Specialist certification
• Learn about Microsoft Certified IT Professional certification
Preparation tools and resources
To help you prepare for this exam, Microsoft Learning recommends that you have hands-on experience with the product and that you use the following training resources. These training resources do not necessarily cover all of the topics listed in the “Skills measured” section.
Classroom training Microsoft E-Learning Microsoft Press books Practice tests
(Prerequisite) Course 2071: Querying Microsoft SQL Server 2000 with Transact-SQL (two days)
Course 2073: Programming a Microsoft SQL Server 2000 Database (five days)
There is no Microsoft E-Learning training currently available.
MCAD/MCSE/MCDBA Self-Paced Training Kit: Microsoft SQL Server 2000 Database Design and Implementation, Exam 70-229, Second Edition (ISBN: 9780735619609)
MeasureUp
(Measureup.com)
Self Test Software
(Selftestsoftware.com)
Microsoft online resources
• Learning Plan: Get started with a step-by-step study guide that is based on recommended resources for this exam.
• Microsoft Learning Community: Join newsgroups and visit community forums to connect with peers for suggestions on training resources and advice on your certification path and studies.
• TechNet: Designed for IT professionals, this site includes how-to instructions, best practices, downloads, technical resources, newsgroups, and chats.
• MSDN: Designed for developers, the Microsoft Developer Network (MSDN) features code samples, technical articles, downloads, newsgroups, and chats.
MCDBA Designing and Implementing Databases with Microsoft SQL Server 2000, Enterprise Edition : 70-229 Exam
Exam Number/Code: 70-229
Exam Name: MCDBA Designing and Implementing Databases with Microsoft SQL Server 2000, Enterprise Edition
“MCDBA Designing and Implementing Databases with Microsoft SQL Server 2000, Enterprise Edition”, also known as 70-229 exam, is a Microsoft certification. With the complete collection of questions and answers, Pass4sure has assembled to take you through 105 questions to your 70-229 Exam preparation. In the 70-229 exam resources, you will cover every field and category in MCDBA helping to ready you for your successful Microsoft Certification.
QUESTION 1:
HOTSPOT
You work as the network administrator at Certkiller .com. The Certkiller .com
network consists of a single Active Directory forest that contains two domains
named us. Certkiller .com and uk. Certkiller .com. All servers on the Certkiller .com
network run Windows Server 2003 and all client computers run Windows XP
Professional. Certkiller .com has an office in Chicago and an office in London.
The Certkiller .com network contains two file servers named Certkiller -SR13 and
Certkiller -SR14. Each file server resides in one of these offices. Certkiller .com
consists of a development department, which develops in-house accounting
applications for different companies in the region. The lab in the Chicago office
consists of 5 client computer, which are used to test the application before selling the
products. The London office forms part of the development program. The
employees of the Chicago office need to access resources in both domains. The
manager has instructed you to create a single group that will contain all employees
in the department.
What should you do?
To answer, configure the appropriate group options in the New Object dialog box.
Answer:
Actualtest.org – The Power of Knowing
Explanation: The universal group universal group can contain members from any
domain in the forest. This means that it can be used to grant access to resources in
any domain in the forest.
Incorrect answers:
The domain local group can have members in any domain in the forest, but they can only
grant access to resources to the domain that it in resides. It is not advisable to create this
group.
Global groups can be used to grant access to the resources in any domain in the forest,
but they can only contain members from only one domain.
The distribution group is used with e-mail, which you can send an e-mail to a distribution
group. You need a security group to grant access to the files on file servers.
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.
You need to organize the Certkiller .com domain by department. You create an
Organizational Unit (OU) named Research. You plan to add all objects associated
with the users and computers in the Research and Development department to the
Research OU. You create a global group named ResearchAdmins. The
ResearchAdmins group will contain members who will administer the objects in the
Research OU.
Now you need to assign the appropriate permissions to the ResearchAdmins. You
open the properties page of the Research OU in Active Directory Users and
Actualtest.org – The Power of Knowing
Computers; however, the Security tab is not available.
You need to assign the appropriate permissions to the ResearchAdmins to grant its
members the ability to administer the objects in the Research OU. What should you
do?
A. Convert the system partition to NTFS.
B. In the View menu of Active Directory Users and Computers, enable the Advanced
Features option.
C. In the View menu of Active Directory Users and Computers, enable the Users,
Groups, and Computers as Containers option.
D. Log on to the domain using a user account that has Administrator permissions for the
Research OU.
Answer: B
Explanation: The Security tab is available for modification in the Advanced Features
option of the View menu. If you select that entry and click View/Edit, you will see the
specific permissions assigned to. By default we cannot see the security tab. Therefore we
must enable the advanced features option in the View menu of Active Directory Users
and Computers.
Incorrect Answers:
A: Converting the system partition to NTFS does not facilitate the viewing of the
security tab as this tab is available in the view menu of Active Directory Users and
computers and converting any system partition will not make it available as it has to be
enabled in that view menu.
C: A Container is an object in a directory that contains other objects. By enabling the
Users, Groups and Computers as containers, you grant yourself the ability to organize the
objects. Though, you still have to enable the Advanced Features option to get the security
tab available.
D: Administrator permissions – Members of the administration group have complete and
unrestricted access to the domain and to servers and other resources within the domain.
Administrators have the power to grant themselves any rights or permissions that they do
not already have. Because the security context for members of the Administrators group
is so high, the server and the network is vulnerable to attacks from Internet-related
sources and email-related virus-infected attachments if accounts in the Administrators
group are compromised. For these reasons, members of the Administrators group should
log on using an administrative account only when necessary. The Runas command
enables administrators to log on to the machine with their ordinary user accounts yet
launch support tools under an administrative security context. However, to make the
security tab available, they still have to enable the Advanced Features option.
References:
Deborah Littlejohn Shinder and Dr. Thomas W. Shinder, MCSA/MCSE Exam 70-290:
Managing and Maintaining a Windows Server 2003 Environment Study Guide & DVD
Training System, p. 166
Dan Balter, MCSA/MCSE Managing and Maintaining a Microsoft Windows Server 2003
Environment Exam Cram 2 (Exam 70-290), Chapter 7
Actualtest.org – The Power of Knowing
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. The functional level of the Certkiller .com
domain is set to Windows 2000 native.
Certkiller .com has 7,500 field workers who are regularly on the road. The user
accounts for the field workers are contained in a global group named MOBILE. The
field workers are assigned new portable computers, which they will use to run a new
POSIX-compliant application. You create a new global group named POSIX. For
all 7,500 user accounts in the MOBILE group, you change the primary group to
POSIX.
However, the field workers complain that they can no longer access the domain
resources they require to complete their job functions. You need ensure that the
field workers can access the required domain resources.
What should you do to resolve this problem?
A. Ensure that each site on your network is connected to at least one other site by a
replication link.
Configure the SMTP protocol on the replication links.
B. Create two new global groups, MOBILE-1 and MOBILE-2.
Place half of the members of MOBILE in each new group.
Place both MOBILE-1 and MOBILE-2 in MOBILE.
C. Remove all domain users from the Users group, and then add all domain users to the
group again.
D. Remove all users from MOBILE.
Change MOBILE to a universal group.
Answer: B
Explanation: Per Microsoft: Updates to the Active Directory store must be made in
a single transaction. One consequence of this is that you should not create groups
with more than 5,000 members. Because group memberships are stored in a single
multi-valued attribute, a change to the membership requires that the whole
attribute-that is, the whole membership list-be updated in a single transaction.
Microsoft has tested and supports group memberships of up to 5,000 members.
Global groups are used primarily to provide categorized membership in domain local
groups for individual security principals or for direct permission assignment (particularly
in the case of a mixed or interim domain functional level domain). Often, global groups
are used to collect users or computers in the same domain and share the same job, role, or
function. Global groups:
1. Exist in all mixed, interim, and native functional level domains and forests
2. Can only include members from within their domain
3. Can be made a member of machine local or domain local group
Actualtest.org – The Power of Knowing
4. Can be granted permission in any domain (including trusted domains in other forests
and pre-Windows 2003 domains)
5. Can contain other global groups (Windows 2000 native or Windows Server 2003
domain functional level only) A global group is a group that can be used in its own
domain and in trusting domains. However, it can contain user accounts and other global
groups only from its own domain.
A domain local group can contain users and global groups from any domain in the forest,
universal groups, and other domain local groups in its own domain. A local group used
on ACLs only in its own domain. Global group (scope) is a group that is available
domain-wide in any domain functional level.
Incorrect Answers:
A: Replication on network computers enables the contents of a directory, designated as
an export directory, to be copied to other directories, called import directories. Active
Directory changes are replicated to all domain controllers on a regular schedule. Thus the
contents of a directory do not mean access to domain resources.
C: Removing all domain users from the group and then re-adding them to the group will
not help as the Microsoft recommended amount of members per group will still be
exceeded.
D: Converting travelling to a new universal group and in the process getting rid of the
existing travelling group, but universal groups are used primarily to grant access to
resources in all trusted domains, but universal groups can only be used as a security
principal (security group type) in a Windows 2000 native or Windows Server 2003
domain functional level domain. Thus this option is not viable.
References:
Dan Holme and Thomas Orin, MCSA/MCSE Self-Paced Training Kit (Exam 70-290):
Managing and Maintaining a Microsoft Windows Server 2003 Environment, pp. 4: 5-21,
770
Pass4sure 70-229 2.93
Questions and Answers : 105 questions
Expected Date: October 24th , 2008
Price: $129.99 $89.99
Free Down: Pass4sure Microsoft 70-229 2.93
Free Down: Testking microsoft 70-229 2.93
| PassGuide certification braindumps |
|
Type |
Exam Bible | New Questions & Answers |
Latest Updated |
Download link |
 |
All Certbible 's Exam Pack |
893 |
1 days ago | Available |
Dwonload Free Latest Pass4side Certifications Braindumps
- Free PassGuide Pass4sure Microsoft MCSE 70-225 2.93
- Free PassGuide Pass4sure Microsoft MCSE 70-228 2.83
- Free PassGuide Pass4sure Microsoft MCSE 70-224 2.93
- Free PassGuide Pass4sure Microsoft MCSE 70-226 2.93
- Free PassGuide Pass4sure Microsoft MCSE 70-227 2.83
- Free PassGuide Pass4sure Microsoft MCSE 70-223 2.95
- Free PassGuide Pass4sure Microsoft MCSE 70-290 2.95
- Free PassGuide Pass4sure Microsoft MCSE 70-221 2.83
- Free PassGuide Pass4sure Microsoft MCSE 70-220 2.93
- Free PassGuide Pass4sure Microsoft MCSE 70-222 2.83
