70-443 MCITP Braindump
ExamSoon 70-443 Exams
Microsoft Designing a Database Server Infrastructure by Using Microsoft SQL
Server 2005
O rder : 70-443 Exam
Practice Exam: 70-443
Exam Number/Code: 70-443
Exam Name: Designing a Database Server Infrastructure by Using Microsoft SQL
Server 2005
Questions and Answers: 90 Q&As
Free 70-443 Braindumps
Exam : Microsoft 70-443
Title : Designing a Database Server Infrastructure by Using Microsoft SQL Server 2005
1. You are configuring SQL1 so that the distributed query in the Sales database can access data in the CRM
database on SQL2. You create a linked server for SQL2, and you create a linked server login that uses impersonation.
Now, you need to ask the network administrator to configure SQL1.
Which two tasks should you ask the administrator to perform? (Each correct answer presents part of the solution.
Choose two.)
A. Add the user account that is used by the SQL Server service to the local Administrators group.
B. Enable the Do not trust this user for delegation Active Domain property for the user account that is used by the
SQL Server service.
C. Create a Service Principal Name (SPN) for the user account that is used by the SQL Server service.
D. Enable the Trusted for delegation Active Domain property for the user account that is used by the SQL Server
service.
Answer: C AND D
2. You need to improve the speed of backups on SQL1. Management has approved the purchase of additional hard
disks for this server.
What should you do?
A. Configure the hard disks as a RAID-0 array, and store the backups on this new array.
B. Configure the hard disks as a RAID-5 array, and store the backups on this new array.
C. Configure the hard disks as a RAID-10 array, and store the backups on this new array.
D. Configure the hard disks as a spanned volume, and store the backups on this new volume.
E. Use the hard disks to extend the volume that currently holds SQL Server backups.
Answer: A
3. You need to review the current storage system and decide on the best configuration