微软认证考试70-432练习试题3[1]

【网络综合 - 微软认证(MCSE)试题】
无忧考网为大家收集整理了《微软认证考试70-432练习试题3》供大家参考，希望对大家有所帮助！！！

QUESTION 11 You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named Dworks in the instance. The Dworks database has a table named Orderthings. The Orderthings table is partitioned on the OrderId column. The first partition contains integer values greater than 100,000, while the second partition contains integer values between 1 and 100,000. You have to add a new partition. The new partition should contain integer values greater than 200,000. What should you do? A.A new partition function should be created B.You should change the existing partition scheme C.You should use a Merge clause to change the existing partition function D.You should use a Split clause to change the existing partition function Answer: D QUESTION 12 You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named Dworks in the instance. Now you get a report from users saying that DB1 meets deadlock problems. As the technical support, you have to capture the deadlock information to the SQL Server error log. What should you do? A.For the AdventureWorks database, enable Server Auditing B.First you should set the appropriate trace flags as a startup parameter, and then restart the SQL Server instance C.You should configure the data collector and make it capture the deadlock graphs D.You should configure a SQL Profiler trace, and make it capture the deadlock graphs Answer: B QUESTION 13 You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named Dworks in t微软认证(MCSE)