IT인증자격증은 국제적으로 승인받는 자격증이기에 많이 취득해두시면 취업이나 승진이나 이직이나 모두 편해집니다. 다른 사람이 없는 자격증을 내가 가지고 있다는것은 실력을 증명해주는 수단입니다. MCITP 70-447 (UPGRADE:MCDBA Skills to MCITP DB Admin by Using MS SQL 2005) 시험은 널리 승인받는 자격증의 시험과목입니다.

 

NO.1 You are a professional level SQL Server 2005 database administrator in an international corporation
named Wiikigo. You are experienced in implementing high-availability solutions, monitoring the database
server, and design deployment. In the company, you major job is the deployment, maintenance and
support of Microsoft SQL Server 2005. You work as a database administrator for your company. More
than a month ago, the SQL 2005 Server computer is deployed in operation. There are some query
performance problems last week. Therefore, you perform an investigation on the locking contention. From
the sys.dm_os_wait_stats dynamic management view (DMV), you can see a high value in the
max_wait_time_ms column. You want to check out whether this value is a factor which leads to the
current performance problems. In addition, the impact on database users should e cut to the least. Which
action should be performed to achieve the goal?
A.To achieve the goal, the UPDATE STATISTICS command should be excuted.
B.To achieve the goal, the SQL Server Service should be restarted.
C.To achieve the goal, the SQL Server computer should be restarted.
D.To achieve the goal, the statistics in the dynamic management view (DMV) should be reset.
Answer:D

NO.2 You are a professional level SQL Server 2005 database administrator in an international corporation
named Wiikigo. You are experienced in implementing high-availability solutions, monitoring the database
server, and design deployment. In the company, you major job is the deployment, maintenance and
support of Microsoft SQL Server 2005. You work as the administrator of a SQL Server 2005 computer.
And recently the server performs gradually slowly. The indexing environment is troubleshooted by you.
The clustered indexes are rebuilt by you, and the clustered indexes are utilized the most frequently. The
most frequently accessed nonclustered index will be optimized by you. The
sys.dm_db_index_usage_stats dynamic management view (DMV) is accessed by you. You can see the
results from the table listed below. When the entire index is not read, the nonclustered index which is
being utilized the most frequently should be identified. From the following four object_id and index_id
combinations, which one should be utilized to finish the task?
A.To finish the task, the object_id 869578136 and the index_id 1 should be utilized.
B.To finish the task, the object_id 869578136 and the index_id 5 should be utilized.
C.To finish the task, the object_id 309576141 and the index_id 1 should be utilized.
D.To finish the task, the object_id 2066106401 and the index_id 1 should be utilized.
E.To finish the task, the object_id 2066106401 and the index_id 2 should be utilized.
Answer:B