MCITP(70431)真题精选.docx

1、MCITP（70-431）真题精选多项选择题1、Youarepreparingfora new installation of SQL Server2005. You need to select the protocols that client computers might use to connect to theserver. Which two protocols can you use to achieve this goal?（）A. Named PipesB. TCP/IPC. Shared MemoryD. Virtual Interface Adapter （VIA）E.

2、 Multiprotocol参考答案 ：A,B单项选择题2、Your company has two SQL Server 2005 computers named SQL1 and SQL2. A user in your company named Eric writes many ad hoc queries against the companydatabases. Eric has access to the Customer database on SQL1. He does not have access to the Sales database on SQL2. You ne

3、ed to ensure that Eric can write queries that join information from bothservers. What should you do first?（）A.Create a linked server on SQL1 to SQL2. Configure the linked server to useimpersonation.B.Create a linked server on SQL1 to SQL2. Configure the linked server to use mappedlogins.C.Instruct E

4、ric to write the queries on SQL2 by using the OPENQUERY statement and specifying SQL1 as the servername.D.Instruct Eric to specify SQL Server object names by using four-partnotation.参考答案 ：B单项选择题3、You configure a new SQL Server 2005 computer to use TCP/IP with all defaultsettings. Your corporate poli

5、cy requires that each server use afirewall. You find that you can connect to the SQL Server instance from the localcomputer. However, client computers cannot connect to the SQLServerinstance. You need to identify the most likely cause of the connectionissues. What should you do first?（）A.Ensure that

6、 port 1433 is open in yourfirewall.B.Ensure that port 443 is open in yourfirewall.C.Ensure that client computers connect by using Shared Memoryprotocol.D.Ensure that the server is notpaused.参考答案 ：A多项选择题4、Your company uses SQL Server2005. Users report that report execution isslow. You investigate and

7、 discover that some queries do not use optimal executionplans. You also notice that some optimizer statistics are missing and others are out ofdate. You need to correct the problem so that reports execute morequickly. Which two Transact-SQL statements should you use?（）A. DBCC CHECKTABLEB. ALTER INDE

8、X REORGANIZEC. UPDATE STATISTICSD. CREATE STATISTICSE. DBCC SHOW_STATISTICSF. DBCC UPDATEUSAGE参考答案 ：C,D单项选择题5、You are responsible for implementing maintenance jobs on a SQL Server 2005 databaseserver. Certain jobs run every Sunday and other jobs run at the beginning of everymonth. You need to schedu

9、le the jobs in the way that uses the least amount of administrativeeffort. What should you do?（）A. Create a job schedule that runs everySunday. Assign weekly tasks to thisschedule. Create a second schedule that runs on the first day of everymonth. Assign monthly tasks to thisschedule.B. Create a job

10、 for each task that runs once aday. Use a Transact-SQL statement to check the date and day of theweek. If the day is either a Sunday or the first day of the month, execute thecode.C. Create a job schedule that runs once aday. Assign jobs to this jobschedule. If the day is either a Sunday orthe first

11、 day of the month, execute thejobs.D. Create a job for each task that runs once a week onSunday. Add a second job schedule that runs the job on the first of themonth.参考答案 ：A多项选择题6、Your company Web site includes a page that customers use to send feedback about the company and itsproducts. You use a S

12、QL Server 2005 database to store the comments in the Comments column of a table namedFeedback. You need to implement full-text searching so that you can run reports on thecomments. Which two actions should you perform?（）A. Create a nonclustered index on the Commentscolumn.B. Execute the USE Master T

13、ransact-SQLstatement.C. Create a full-textcatalog.D. Create a full-text index on the Commentscolumn.参考答案 ：C,D单项选择题7、You are creating a SQL Server 2005 database for a mortgagecompany. The database will support a new Web-based application that will handle up to 1,000 simultaneoususers. This applicatio

14、n must quickly display the results of calculation-intensive operations, such as calculating mortgage payments and amortizationschedules. You need to ensure that the database processes calculations as quickly and efficiently aspossible. What should you do?（）A. Implement parameterized Transact-SQL que

15、ries in theapplication.B. Implement Transact-SQL stored procedures in thedatabase.C. Implement CLR stored procedures in thedatabase.D. Implement distributed Webservices.参考答案 ：C单项选择题8、You work with a SQL Server 2005 database that provides banking information forcustomers. You want customers to see ba

16、nking reports that combine data that is retrieved from the database with real-time investment information that comes from a Web service provided by a thirdparty. The investmentinformation must be current when the reports areexecuted. You need to create the appropriate objects that support thereports

17、. What should you do?（）A. Publish the data in the database as an XML Web service by using the FOR XML AUTOclause.B. Create a table to store the banking information for eachcustomer. Create a trigger that fires when data is inserted into the table that joins with the data coming from the Webservice.C

18、. Create a Transact-SQL stored procedure that uses a temporary table to store the banking information for eachcustomer. Update the table with the values from the Webservice.D. Have a developer in your company create an assembly that calls the remote Webservice. Create aCLR function by using theassem

19、bly. Call the CLR function and combine the results with banking information in thedatabase.参考答案 ：D多项选择题9、Your company uses SQL Server2005. You are implementing a series of views that are used in ad hocqueries. The views are used to enforce your companys security policy of abstractingdata. Some of th

20、ese views performslowly. You create indexes on those views to increase performance, while still maintaining the companys securitypolicy. One of the views returns the current date as one of thecolumns. The view returns the current date by using the GETDATE（）function. This view does not allow you to c

21、reate anindex. You need to create an index on theview. Which two actions should you perform?（）A. Remove all deterministic function calls from within theview.B. Remove all nondeterministic function calls from within theview.C. Schema-bind all functions that are called from within theview.D. Create th

22、e view and specify the WITH CHECK OPTIONclause.参考答案 ：B,C单项选择题10、Your company uses a SQL Server 2005database. Customerdata from your trading partners is imported into the Customers table everynight. You need to ensure that the customer record is updated if it already exists in the Customerstable. If

23、the record does not exist, the data needs to be inserted into the Customerstable. What should you do?（）A. Create a FORtrigger.B. Create an INSTEAD OFtrigger.C. Create an AFTERtrigger.D. Create a DDLtrigger.参考答案 ：B多项选择题11、Your company uses a mission-critical database named DB1, which is located on a

24、server named SQL1. You want to mirror DB1 on a second server named SQL2. Before you can establish database mirroring, you need to prepare DB1 and the servers formirroring. Which three actions should you perform?（）A. Set the recovery model of DB1 on SQL1 to bulk-loggedrecovery.B. Set the recovery mod

25、el of DB1 on SQL1 to fullrecovery.C. Back up DB1 on SQL1. Restore the backup on SQL2;specify the NORECOVERYoption.D. Back up DB1 on SQL1. Restore the backup on SQL2;specify the STANDBYoption.E. Back up DB1 on SQL1. Restore the backup on SQL2;specify the RECOVERYoption.F. Create endpoints on all part

26、icipatingservers.G. Set the AutoShrink property of DB1 on SQL1 tofalse.参考答案 ：B,C,F单项选择题12、Your company has two SQL Server 2005 computers named SQL1 and SQL2. Transaction log shipping occurs from SQL1 to SQL2 by using default SQL Server Agent schedulesettings. You need toreconfigure transaction log s

27、hipping to provide minimum latency on SQL2. What should you do?（）A. On SQL1, reschedule the transaction log backup job so that it occurs everyminute. On SQL2, maintain default schedule settings for both the log shipping copy and the restorejobs.B. On SQL1, change the schedule type for the transactio

28、n log backup to Start automatically when SQL Server Agentstarts. On SQL2, change the schedule types for both the log shipping copy and the restore jobs to Start automatically when SQL Server Agentstarts.C. On SQL1, maintain default schedule settings for the transaction log backupjob. On SQL2, change

29、 the schedule types for both the log shipping copy and the restore jobs to Start automatically when SQL Server Agentstarts.D. On SQL1, reschedule the transaction log backup job so that it occurs everyminute. On SQL2, reschedule both the log shipping copy and the restore jobs so that they occur every

30、minute.参考答案 ：D单项选择题13、A full backup of your database named DB1 is created automatically at midnight everyday. Differential backups of DB1 occur twice each day at 10:00 and at 16:00. A database snapshot is created every day atnoon. A developer reports that he accidentally dropped the Pricelist table in DB1 at 12:30. The last update to Pricelist occurred one weekago. You need to recover the Pricelisttable. You want to achieve this goal by using the minimum amo