Pass4sure Microsoft MCITP 70-431 2.93
Exam 70-431:
TS: Microsoft SQL Server 2005 – Implementation and Maintenance
Audience Profile
Candidates for this exam are professionals who typically pursue careers as database administrators, database developers, or business intelligence developers. Additionally, they can be people who do not work with Microsoft SQL Server as a part of their primary job functions but who want to show their breadth of technology experience, such as developers, systems administrators, and others. Candidates have sought out knowledge and experience with Microsoft SQL Server 2005 to enhance their technical expertise, and they can implement and maintain databases by using specific instructions and specifications.
Candidates for this exam should be experts in following areas:
Tools usage
UI navigation
Wizards usage
Writing code in the appropriate language (Transact-SQL, CLR language, and other scripting languages)
Code debugging or syntactic issue resolution
Troubleshooting
Accomplishing specific focused tasks by using code or UI navigation
Credit Toward Certification
When you pass Exam 70-431: TS: Microsoft SQL Server 2005 – Implementation and Maintenance, you complete the requirements for the following certification(s):
Microsoft Certified Technology Specialist: SQL Server 2005
Exam 70-431: TS: Microsoft SQL Server 2005 – Implementation and Maintenance: counts as credit toward the following certification(s):
MCITP: Database Administrator
MCTS and MCITP upgrade from MCDBA
MCITP: Database Developer
MCSA on Microsoft Windows 2000
MCSA on Windows Server 2003
MCSE on Microsoft Windows 2000
MCSE on Windows Server 2003
Microsoft SQL Server 2005 Implementation & Maintenance : 70-431 Exam
Exam Number/Code: 70-431
Exam Name: Microsoft SQL Server 2005 Implementation & Maintenance
“Microsoft SQL Server 2005 Implementation & Maintenance”, also known as 70-431 exam, is a Microsoft certification. With the complete collection of questions and answers, Pass4sure has assembled to take you through 70 Q&As + 30 Labs to your 70-431 Exam preparation. In the 70-431 exam resources, you will cover every field and category in MCITP helping to ready you for your successful Microsoft Certification.
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. All
servers on the Certkiller .com network run Windows 2000 Server and all client
computers run Windows XP Professional.
Over the past few weeks, while monitoring access to resources on the network, you
have noticed that a few documents hosted on the Certkiller .com file servers have
been accessed by users who are NOT authorized to do so. You decide to audit access
attempts made to all resources hosted on your file servers. You create a new Group
Policy Object and apply it to the Servers OU.
Actualtest.org – The Power of Knowing
You still need to define the security configuration that will implement your
requirements. You also want no security logs to be overwritten, until you have
viewed its contents.
What should you do to achieve all your goals under these circumstances? (Each
correct answer presents only part of the complete solution. Choose two.)
A. Access the Security Log Properties and set the maximum allowed value for the
Maximum Log Size setting.
B. Access the Security Log Properties and select the Do Not Overwrite Events (Clear
Log Manually) setting.
C. In the GPO applied to the Servers OU, enable auditing by using Object Access.
Specify which objects should be audited.
D. In the GPO applied to the Servers OU, enable auditing by using Directory Services
Access.
Specify which objects should be audited.
Answer: B, C
Explanation: To audit access attempts made to file and folder resources, you have to
enable auditing for Object Access in the GPO. Object Access is used to track when a
user accesses operating system components such as files, folders or registry keys.
After enabling auditing by using Object Access, you should use Windows Explorer
to specify which files and folders should be audited on the file servers. This done on
the Auditing tab of the Properties sheet of the resource you want to audit. You also
want to view the contents of the security logs before they are deleted. In Windows
Server 2003, the Do Not Overwrite Events (Clear Log Manually) setting is
automatically disabled, which means that the oldest log entries would start being
deleted as the log fills. If you want to manually clear the security logs, you must
manually enable this setting.
Incorrect Answers:
A: The Maximum Log Size setting controls how much data the security log holds before
it is considered full. It has nothing to do with ensuring that auditing is enabled on the file
servers, and ensuring that the security log files are not overwritten.
C: When needing to audit access to files and folders, you need to use Object Access
and not Directory Services Access. Directory Services Access is used for domain
controllers, to audit when users access Active Directory objects which have system
access control lists (SACLs).
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 have been instructed to create a shared folder named Customers which will be
used by the Sales department. Users that work in this department will use the
Actualtest.org – The Power of Knowing
shared folder to store important customer information in its subfolders and files.
Any user working in the Sales department will be updating the customer base by
keeping the information current within the shared folder. You create the shared
folder named Customers on a file server named Certkiller -SR11. You assign
permissions for the folder to only all users that work in the Sales department.
This morning, a user named Mia Hamm is moved from the Customer Care
department to the Sales department. You add Mia Hamm’s user account to the
Sales security group. A few hours later, Mia complains that she cannot access the
Customers folder.
You need to ensure that Mia Hamm, and any other user that is moved from another
department to work in the Sales department can access the Customers folder after
you add their respective user accounts to the Sales security group. You do not want
to assign any users excessive permissions.
How will you accomplish the task?
A. Grant Mia Hamm’s user account the Allow – Change share permission.
B. Grant Mia Hamm’s user account the Allow – Full Control share permission.
C. Grant Mia Hamm’s user account the Allow – Write NTFS permission.
D. Restart Certkiller -SR11.
E. Inform Mia Hamm to log off and to then log on again.
Answer: E
Explanation: In Active Directory domains, whenever a user logs on to the domain,
an access token is generated for the specific user. This access token contains the
security identifiers (SID) of the user and other necessary security information on a
user that is needed to determine whether the user is permitted access to the object.
SIDs assists in controlling access to resources in the network. A unique SID is
assigned to each security principal account, such as a user or group account, when
you create the account. The moment that a user tries to access a network resource,
the system references the information in the access token and compares it to the
security descriptor of the resource which the user wants to access. In Mia Hamm’s
case, you probably added her to the Sales security group while she was logged on to
the domain. A new access token has not been generated for Mia Hamm yet. The
actual change you made by adding her to the Sales group will only apply when she
logs off and then logs back on to the Certkiller .com domain again.
Incorrect Answers:
A, B, C: There is absolutely no need to grant Mia Hamm’s user account individual
permissions for the folder. No other users in the Sales department have complained about
not being able to access resources.
E: Restarting the Certkiller -SR11 will not generate a new access token for Mia Hamm.
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
Actualtest.org – The Power of Knowing
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 branch offices in Paris, Berlin,
Milan and Madrid. Each branch office is configured as an Active Directory site.
You are the network administrator at the London headquarters office. The
Certkiller .com written security policy does not allow users at any branch office to log
on locally to any servers. Your administrative tasks include archiving event logs on
all servers on the Certkiller .com network. You need view the archived logs on the
hard disk of your client computer named Certkiller -WS152.
All servers on the Certkiller .com network have auditing enabled. You want to
archive the event logs of all servers that are located in the branch offices. You want
to view the auditing information from your London office.
How will you accomplish the task?
A. Establish a Remote Desktop connection to connect to each branch office server.
Use the Security Configuration and Analysis snap-in to save the .inf file on the local hard
disk.
B. Establish a Remote Desktop connection to connect to each branch office server.
Use Event Viewer to save the event logs as an .evt file on the specific server’s hard disk.
Use Windows Explorer to copy each saved .evt file to Certkiller -WS152’s hard disk.
C. Open Event Viewer on Certkiller -WS152.
Save the event logs as an .evt file on Certkiller -WS152’s hard disk.
D. Solicit a Remote Assistance invitation from the administrator at each branch office.
Use the Security and Analysis snap-in to save the .inf file on the local hard disk.
Answer: B
Explanation: Because you work at the London headquarters and you have to collect
auditing logs from the servers at each branch office; to connect to the servers at
each branch office, you have to use a Remote Desktop connection. After the
connection is established to a branch office server, you need to use the local
Computer Management console on the server to open Event Viewer. In Event
Viewer simply right-click the event log that you want to save, click Save log file as,
and save the file with an .evt extension on the server. You can then copy the file to
the hard disk of Certkiller -WS152. Windows Explorer can be used to perform the
copy to Certkiller -WS152’s local hard disk.
Incorrect Answers:
A: While the first half of the solution is correct (Establish a Remote Desktop
connection to connect to each branch office server), the second is not. To save the event
log of a branch office server, you have to use a .evt file name extension. The .inf file
name extensions are used for information files, usually setup information.
C: While you can open Event Viewer on Certkiller -WS152, you have to connect to
each branch office server and save the event log to a shared folder on the server using the
.evt file name extension. You can then access the folder storing the log file from
Certkiller -WS152
D: If you solicit Remote Assistance from an administrator working at either of the
Actualtest.org – The Power of Knowing
branch offices, you will be violating the Certkiller .com written security policy:The
Certkiller .com written security policy does not allow any users at the branch offices
to log on locally to local servers.
Pass4sure 70-431 2.93
Questions and Answers : 70 Q&As + 30 Labs
Updated: October 8rd , 2008
Price: $129.99 $89.99
Free Down: Pass4sure Microsoft 70-431 2.93
Free Down: Testking microsoft 70-431 2.93
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 Pass4sure Microsoft MCITP Dumps
- Free PassGuide Pass4sure Microsoft MCITP Dumps
- Free PassGuide Pass4sure Microsoft MCITP 70-441 2.83
- Free PassGuide Pass4sure Microsoft MCITP 70-443 2.83
- Free PassGuide Pass4sure Microsoft MCITP 70-442 2.83
- Free PassGuide Pass4sure Microsoft MCITP 70-647 2.83
- Free PassGuide Pass4sure Microsoft MCITP 70-447 2.83
- Free PassGuide Pass4sure Microsoft MCITP 70-446 2.95
- Free PassGuide Pass4sure Microsoft 70-624 2.95
- Free PassGuide Pass4sure Microsoft MCITP 70-444 2.83
