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

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

QUESTION 71 You work in a company which 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 named Dworks in the instance. The Dworks database has a table named Bills which contains several indexes and a great amount of rows. An enterprise Web environment is supported by the database. On the Bills table 28% of the indexes have been fragmented. You have to defragment the indexes, making sure that you reduce the effect on database availability to the least. In the ALTER INDEX statement, which option should be included? A.Sort in tempdb B.Online C.Fill factor D.Pad index Answer: B QUESTION 72 You work in a company which 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 named Dworks in the instance. The table below shows the two tables of the Dworks database: There are two partitions in the BillHistory table. Partition1 is empty while partition2 contains all data. Now you intend to move data from partition2 to the appropriate partition of the BillHistory table. Partions2 contains data for the oldest month of the Bills table. You are going to develop a process to achieve this. You must make sure that at the end of every month the process can be repeated. A.Alter the partition function of the BillHistory table by using the split option. Switch the appropriate partition of the Bills table to the appropriate partition of the BillHistory table. Alter the BillHistory table by using the split option. B.Alter the partition function of the Bills table by using the split option. Alter the Billstable by using the merge option. C.Alter the partition function of the BillHistory table by using the split option. Switch the appropriate partition of the Bills table to the appropriate partition of the Bill微软认证(MCSE)