Pass4sure Microsoft MCITP 70-444 2.83
Preparation Guide for Exam 70-444
PRO: Optimizing and Maintaining a Database Administration Solution by Using Microsoft SQL Server 2005
Audience profile
Candidates for this exam are professional database administrators who optimize and maintain database solutions. They have three or more years dedicated to database work, which may include two or more of the following phases in the product lifecycle: design, development, deployment, optimization, maintenance, or support. The typical work environment is an enterprise or a medium-sized organization. Candidates should be experienced in using Microsoft SQL Server 2005.
Candidates for this exam should be an expert in the following areas:
• Defining high-availability solutions
• Automating administrative tasks
• Defining security solutions
• Monitoring and troubleshooting the database server
• Designing and executing deployments
• Defining the infrastructure (such as storage, hardware, and number of servers or instances)
Credit toward certification
When you pass Exam 70-444: PRO: Optimizing and Maintaining a Database Administration Solution by Using Microsoft SQL Server 2005, you earn credit toward the following certification:
• Microsoft Certified IT Professional: Database Administrator
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
Course 2787: Designing Security for Microsoft SQL Server 2005 (two days)
Course 2789: Administering and Automating Microsoft SQL Server 2005 Databases and Servers (one day)
Course 2790: Troubleshooting and Optimizing Database Servers Using Microsoft SQL Server 2005 (two days)
Collection 2787: Designing Security for Microsoft SQL Server 2005 (12-hour series)
Collection 2789: Administering and Automating Microsoft SQL Server 2005 Databases and Servers (four-hour series)
Collection 2790: Troubleshooting and Optimizing Database Servers Using Microsoft SQL Server 2005 (12-hour series)
MCITP Self-Paced Training Kit (Exam 70-444): Optimizing and Maintaining a Database Administration Solution Using Microsoft SQL Server 2005
Inside Microsoft SQL Server 2005: The Storage Engine
Inside Microsoft SQL Server 2005: T-SQL Querying
Inside Microsoft SQL Server 2005: T-SQL Programming
Inside Microsoft SQL Server 2005: Query Tuning and Optimization
Microsoft SQL Server 2005 Analysis Services Step by Step
Microsoft SQL Server 2005: Database Essentials Step by Step
Microsoft SQL Server 2005 Administrator’s Pocket Consultant
Microsoft SQL Server 2005 Administrator’s Companion
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.
• Microsoft SQL Server 2005 – Learning Portal: Find special offers and information on training and certification.
• Product information: Visit the SQL Server 2005 Web site for detailed product information.
• 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 features 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.
Optimizing and Maintaining a Database Administration Solution by Using Microsoft SQL Server 2005 : 70-444 Exam
Exam Number/Code: 70-444
Exam Name: Optimizing and Maintaining a Database Administration Solution by Using Microsoft SQL Server 2005
“Optimizing and Maintaining a Database Administration Solution by Using Microsoft SQL Server 2005″, also known as 70-444 exam, is a Microsoft certification. With the complete collection of questions and answers, Pass4sure has assembled to take you through 104 Q&As to your 70-444 Exam preparation. In the 70-444 exam resources, you will cover every field and category in MCITP 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 domain named Certkiller .com with three
sites. Integrated DNS is deployed in the Certkiller .com domain. All servers on the
Certkiller .com network run Windows Server 2003 and all client computers run
Windows XP Professional.
Several users have mentioned that they can access resources which they should not
Actualtest.org – The Power of Knowing
be able to. You investigate the issue and find that while some users are obtaining
Group Policy security settings when they log on to the domain, other users are not
receiving the same settings. You cannot isolate the issue to a set of specific users and
need to gather more information to troubleshoot the issue so that you can
implement a solution which will resolve it.
You open Event Viewer. You want to view an event log file on one domain
controller, to filter out information on this specific problem.
How should you go about using Event Viewer? Answer by selecting the appropriate
event log file you should use.
Answer:
Explanation:
For domain controllers, the Directory Service event log file would contain information on
events that pertain to accessing directory service objects in Active Directory. Group
Policy and GPO settings are stored in Active Directory. The application log event file
would display information on events which were logged by applications. The security log
file would display information on security specific events. The system log file would
display information on events which were logged by system components. The DNS log
file would show you information specific to the DNS server. The File Replication Service
log file would show you information specific to Active Directory replication
Actualtest.org – The Power of Knowing
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 five
domain controllers on the Certkiller .com network run Windows Server 2003 and all
client computers run Windows XP Professional.
All account logon events are audited courtesy of the domain’s audit policy.
A temporary employee named Kara Lang uses a client computer named
Certkiller -WS01. When Kara Lang’s temporary assignment concludes, her
employment is terminated.
You have received instruction from the CIO to learn the times and dates when Kara
Langlogged on to the domain, reviewing the minimum amount of the required
information.
How will you accomplish the task? (Each correct answer presents part of the
solution. Choose two.)
A. View the local security log via Event Viewer while logged on to Certkiller -WS01
as a local administrator.
B. View the security log on each domain controller via Event Viewer.
C. List the required events for Kara Lang’s user account by making use of the Find
option.
D. List the required events for the Certkiller -WS01 computer account by making use
of the Find option.
E. Set a filter to list only the required events for Kara Lang’s user account.
F. Set a filter to list only the required events for the Certkiller -WS01 computer
account.
Answer: B, E
Explanation:
When a user logs on to a domain, (and auditing is enabled), the authenticating domain
controller will log an event in its log. It is likely that multiple domain controllers have
authenticated the user at different times; therefore, we must examine the security log on
each domain controller. In event viewer, you can set various filters to simplify the search
for information. In this case, we can filter the logs to show events for only the users’
account.
The default auditing policy setting for domain controllers is No Auditing. This means
that even if auditing is enabled in the domain, the domain controllers do not inherit
auditing policy locally. If you want domain auditing policy to apply to domain
controllers, you must modify this policy setting.
Incorrect Answers:
A: The logon events will be recorded in the logs on the domain controllers, not the client
computer.
C: The Find option will move to the next event in the log according to the Find criteria. It
will not filter the log to just show the relevant information.
Actualtest.org – The Power of Knowing
E: This will show when someone logged on to Certkiller -WS01 using a domain
account. This is not what we’re looking for.
Reference:
Deborah Littlejohn Shinder, Dr. Thomas W. Shinder, Laura E. Hunter & Will Schmied,
MCSA/MCSE: Exam 70-290: Managing and Maintaining a Windows Server 2003
Environment, Study Guide and DVD training system, Syngress Publishing, Rockland,
MA, 2003, pp. 786-789
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.
Certkiller .com has headquarters in London and a branch office Warsaw. You are
the network administrator at the London headquarters office. No users that work at
the branch office have the Log On Locally right on local servers. Certkiller -SR05
is a file server in the Warsaw branch office. Certkiller -SR05 is configured for
auditing. You use a client computer named Certkiller -WS263.
You receive instruction to archive the security log of Certkiller -SR05. You want
view the security log file information from Certkiller -WS263.
What should you do?
A. Solicit Remote Assistance from Certkiller -SR05.
Use Event Viewer to save the security log as an .evt file on Certkiller -SR05’s hard
disk.
Copy each saved .evt file to Certkiller -WS263’s hard disk.
B. Establish a Remote Desktop connection to connect to Certkiller -SR05.
Use the Security Configuration and Analysis snap-in to save the .inf file on the local
hard drive.
C. Solicit Remote Assistance from Certkiller -SR05.
Open the Security Configuration and Analysis snap-in to save the .inf file on the
local hard disk.
D. Establish a Remote Desktop connection to connect to Certkiller -SR05.
Use Event Viewer to save the security log as an .evt file on Certkiller -SR05’s hard
disk.
Copy the security log file to Certkiller -WS263’s hard disk.
Answer: D
Explanation: To connect to Certkiller -SR05 at the Warsaw branch office, you
have to use a Remote Desktop connection. After the connection is established to
Certkiller -SR05, you need to use the local Computer Management console on the
Certkiller -SR05 to open Event Viewer. In Event Viewer simply right-click the
security log, click Save log file as, and save the log with an .evt extension on the
server. You can then copy the file to the hard disk of Certkiller -WS263.
Actualtest.org – The Power of Knowing
Incorrect Answers:
A: No users that work at the Warsaw branch office have the Log On Locally right on
local servers. You therefore cannot solicit Remote Assistance from Certkiller -SR05.
B: To save the security log of Certkiller -SR05, you have to use an .evt file name
extension. The .inf file name extensions are used for information files, usually setup
information files.
C: No users that work at the Warsaw branch office have the Log On Locally right on
local servers. In addition to this, you have to use an .evt file name extension so save the
security log.
Pass4sure 70-444 2.83
Questions and Answers : 104 Q&As
Expected Date: October 24th , 2008
Price: $129.99 $89.99
Free Down: Pass4sure Microsoft 70-444 2.83
Free Down: Testking microsoft 70-444 2.83
password: www.msexams.net
| 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 pass4side MCITP 70-431 v7.1
- Free PassGuide Pass4sure Microsoft MCITP 70-443 2.83
- Free PassGuide Pass4sure Microsoft MCITP 70-431 2.93
- Free PassGuide Pass4sure Microsoft MCITP Dumps
- Free PassGuide Pass4sure Microsoft MCITP 70-441 2.83
- Free PassGuide Pass4sure Microsoft MCITP 70-647 2.83
- Free PassGuide Pass4sure Microsoft MCITP Dumps
- Free PassGuide Pass4sure Microsoft MCITP 70-447 2.83
- Free PassGuide Pass4sure Microsoft MCITP 70-446 2.95
- Free PassGuide Pass4sure Microsoft MCITP 70-442 2.83
