為大家收集整理了《微軟認(rèn)證考試70-432練習(xí)試題15》供大家參考，希望對(duì)大家有所幫助?。?！
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 BillHistory table. Alter the BillHistory table by using the merge option. Alter the Bills table by using the merge option. D.Alter the partition function of the Bills table by using the split option. Alter the BillHistory table by using the split option. Alter the partition function of the BillHistory table by using the merge option. Alter the Bill stable by using the merge option. Answer: C QUESTION 73 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. The company wants to export data from SQL Server to a Microsoft Excel file. The company assigns this task to you. You perform this by using the SQL Server Import and Export Wizard. After this, you save the package definition to a file. Now you have to reexecute the package from the command line. In the options below, which utility should you choose to use? A.bcp.exe B.dta.exe C.dtexec.exe D.sqlmaint.exe Answer: C QUESTION 74 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 table has a table named BillDetails which has a clustered primary key named BillId on the BillId column. The BillDetails table has a single XML column named GoodsDetails. The XML column has an XML index and XML data are stored in this XML column. A new column named GoodsID is added to the BillDetails table. GoodsID must be included in the primary key. So what action should you perform to achieve this goal? A.You should drop the XML index on the table. Modify the primary key. Recreate the XML index B.You should alter the XML index and set the ALLOW_ROW_LOCKS = OFF option. Alter the primary key and set the ALLOW_ROW_LOCKS = ON option. C.You should move the XML data to a temporary table. Clear the XML data from the original table by setting the GoodsDetails column to NULL. Modify the primary key. Repopulate the ProductSpecs column. D.You should disable the XML index on the GoodsDetails column. Modify the primary key.Enable the XML index on the ProductSpecs column. Answer: A QUESTION 75 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 n On-Line Analytical Processing (OLAP) database named in the instance. The database contains a dimension table named Clients. Ever hour backup of data of the Clients table is performed. But the Clinets table contains redundant data. You must keep the disk space used to store the Clients table. In the options below, which compression technology should you use? A.You should use row compression B.You should use page compression C.You should use backup compression D.You should use windows NTFS file system compression Answer: B
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 BillHistory table. Alter the BillHistory table by using the merge option. Alter the Bills table by using the merge option. D.Alter the partition function of the Bills table by using the split option. Alter the BillHistory table by using the split option. Alter the partition function of the BillHistory table by using the merge option. Alter the Bill stable by using the merge option. Answer: C QUESTION 73 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. The company wants to export data from SQL Server to a Microsoft Excel file. The company assigns this task to you. You perform this by using the SQL Server Import and Export Wizard. After this, you save the package definition to a file. Now you have to reexecute the package from the command line. In the options below, which utility should you choose to use? A.bcp.exe B.dta.exe C.dtexec.exe D.sqlmaint.exe Answer: C QUESTION 74 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 table has a table named BillDetails which has a clustered primary key named BillId on the BillId column. The BillDetails table has a single XML column named GoodsDetails. The XML column has an XML index and XML data are stored in this XML column. A new column named GoodsID is added to the BillDetails table. GoodsID must be included in the primary key. So what action should you perform to achieve this goal? A.You should drop the XML index on the table. Modify the primary key. Recreate the XML index B.You should alter the XML index and set the ALLOW_ROW_LOCKS = OFF option. Alter the primary key and set the ALLOW_ROW_LOCKS = ON option. C.You should move the XML data to a temporary table. Clear the XML data from the original table by setting the GoodsDetails column to NULL. Modify the primary key. Repopulate the ProductSpecs column. D.You should disable the XML index on the GoodsDetails column. Modify the primary key.Enable the XML index on the ProductSpecs column. Answer: A QUESTION 75 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 n On-Line Analytical Processing (OLAP) database named in the instance. The database contains a dimension table named Clients. Ever hour backup of data of the Clients table is performed. But the Clinets table contains redundant data. You must keep the disk space used to store the Clients table. In the options below, which compression technology should you use? A.You should use row compression B.You should use page compression C.You should use backup compression D.You should use windows NTFS file system compression Answer: B