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. According to the company requirement, you migrate an application from Microsoft SQL Server 2000 to Microsoft SQL Server 2008. You have to monitor the SQL Server instance, and record the use of features which will be discontinued. What should you do? ()
A. The SQL Server 2008 Upgrade Advisor should be used
B. You should use a SQL server-side trace. The trace captures the Deprecation Announcement and Deprecation Final Support event classes
C. You should use the SQL Server Profiler. The profiler captures the SQL:BatchCompleted and Exception event classes
D. You should use a SQL server-side trace. The trace captures the SQL:BatchCompleted and Exception event classes.
查看答案
您需要确定满足下列条件的类型:始终为数字。不大于65,535。 您应选择哪种类型?()
A
B
C
D
You are developing an ASP.NET Web service. The following code segment implements the service. You need to ensure that both GetProduct methods can be called from a Web client. Which two actions should you perform?()
A. Remove line 01.
B. Add the static modifier on lines 05 and 11.
C. Add the following attribute before line 10. [SoapDocumentMethod(Action="GetProductById")]
D. Modify the attribute on line 10 as follows. [WebMethod(MessageName="GetProductById")]
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. You are going to use the data collector to gather performance data periodically on all instances. You must store all collected data in the same database. This database is hosted on a single instance. Every five hours, you have to collect and load performance data in the management data warehouse. Which data collection process should you implement? ()
A. You should create a cached data collection
B. You should create an on-demand non-cached data collection
C. You should create a scheduled non-cached data collection.
D. You should create two different SQL Agent jobs. The two jobs are scheduled at the same time. One job uploads the data collection and the other job creates a data collection.
YournetworkcontainsaservernamedServer1thatrunsWindowsServer2008R2.Thenetworkcontainsmultiplesubnets.AnadministratorreportsthatServer1failstocommunicatewithcomputersonremotesubnets.Yourunroute.exeprintonServer1asshownintheexhibit.(ClicktheExhibitbutton.)YouneedtoensurethatServer1cancommunicatewithallcomputersonthenetwork. Whatshouldyoudo?()
A. DisableIPv6.
B. Changethesubnetmask.
C. Addadefaultgatewayaddress.
D. Changethedefaultmetricto100.