70-444 MCITP Braindump
ExamSoon 70-444 Exams
Microsoft Optimizing and Maintaining a Database Administration Solution by Using
Microsoft SQL Server 2005
O rder : 70-444 Exam
Practice Exam: 70-444
Exam Number/Code: 70-444
Exam Name: Optimizing and Maintaining a Database Administration Solution by
Using Microsoft SQL Server 2005
Questions and Answers: 95 Q&As
Free 70-444 Braindumps
Exam : Microsoft 70-444
Title : Optimizing and Maintaining a Database Administration Solution by Using Microsoft SQL Server 2005
1. You are the administrator of a SQL Server 2005 computer named SQL All databases on SQL1 have been created
with the default auto file growth properties on one RAID 10 volume. All transaction logs on SQL1 have been created
without file growth enabled on a second RAID 10 volume.
You need to ensure that you are notified when the databases are approaching disk capacity.
You also need to prevent errors caused when any transaction log runs out of space.
Which two actions should you perform? (Each correct answer presents part of the solution.Choose two.)
A. Create a performance alert on the SQLServer:SQL Errors:Errors/sec counter.
Have the alert notify you of the problem.
B. Create a performance alert on the SQLServer:Databases:Data File(s) Size (KB) counter.
Have the alert notify you of the problem.
C. Create a performance alert on the LogicalDisk:% Free Space counter.
Have the alert notify you of the problem.
D. Create a SQL Server performance condition alert on the SQLServer:Databases:PercentLogUsed counter on each
transaction log.
Define a response to automatically backup the transaction log and notify you about the problem.
E. Create SQL Server performance condition alerts on the SQLServer:Databases:Data File(s) Size (KB) counter for
each database.
Define a response to add 100 MB to the existing data file size and notify you about the problem.
F. Create SQL Server performance condition alerts on the SQLServer:Databases:Log Growths counter for each
database.Define a response to automatically bac