可以反映证券组合期望收益水平和多因素风险水平之间均衡关系的模型是（）。

个副本保存在名为SQLtest的服务器上，SQLtest同时也在运行着SQLSERVER2005.你发觉在SQL1上的查询存在着大量的对表完全扫描，为此你得出结论DB1数据库需要额外的引。目前已经有适合DTA（DatabaseEngineTuningAdvisor：数据库引擎优化顾问）的工作负荷文件，你需要做的是利用DTA对工作负荷文件进行分析。在分析的过程中，你必须要保证SQL1服务器良好的工作性能，而且要保证DTA推荐的建议是有效的。你应该如何实现这个目标？（）

A.把工作负荷文件保存在SQL1上。在SQLTest上启动DTA并连接到SQL1上，然后选上所有的优化选项并且在高级选项对话框中选中“仅生成联机建议”，然后启动分析。

B.把工作负荷文件存储在SQLtest上。在SQLTest上启动DTA并连接到SQLTest上，然后选上所有的优化选项并且在高级选项对话框中选中“仅生成联机建议”，然后启动分析。

C.把工作负荷文件保存在SQL1上。在SQL1上启动DTA并连接到SQL1上，然后选上所有的优化选项并且在高级选项对话框中选中“所有建议均为脱机建议”，然后启动分析。

D.把工作负荷文件存储在SQLtest上。在SQLTest上启动DTA并连接到SQLTest上，然后选上所有的优化选项并且在高级选项对话框中选中“所有建议均为脱机建议”，然后启动分析。

enetwork.Youneedtoensurethatthehost（A）recordsfortheremovedcomputersareautomaticallydeletedfromthecontoso.comDNSzone.Whatshouldyoudo（）

A.Configuredynamicupdates.

B.Configureagingandscavenging.

C.CreateascheduledtaskthatrunstheDnscmd/ClearCachecommand.

D.CreateascheduledtaskthatrunstheDnscmd/ZoneReloadcontoso.comcommand.

un WindowsServer 2003. All client computers run Windows XP Professional and have the latest service pack installed.You manage a server that has Windows Server Update Services (WSUS) installed. The latest updates weresynchronized and approved for installation on the client computers.You need to configure the client computers to download and automatically install the approved updates from the WSUS server.What should you do? （）

A. On the client computers, open the System Properties dialog box. On the Automatic Updates tab, configure the client computers to update automatically every day.

B. Create a Group Policy object (GPO) that has the appropriate Automatic Updates settings configured. Apply the GPO to an organizational unit (OU) that includes the client computers.

C. In Active Directory Users and Computers, modify the settings for the client computer accounts. Configure the Managed By property to specify the WSUS server account.

D. Create a local group on the WSUS server. Assign the group the Allow - Read and the Allow - Write permissions for the WSUSContent folder on the WSUS server. Add all the users of the client computers to the local group.

heSQLAzureserversforavarietyofpurposes.YousuccessfullydeployanewWindowsAzureapplicationwithitsownSQLAzureserver.Whenon-premiseusersattempttoconnecttothenewSQLAzureservertheyreceiveconnectionerrors.Youneedtorecommendanapproachformitigatingtheconnectivityissue.Whatshouldyourecommend？（）

A.Openport1433onthenetworkfirewall.

B.UseSecuritySupportProviderInterface（SSPI）.

C.DisablethevalidationoftheSSLcertificatefortheSQLAzureserverthroughtheconnectionstring.

D.ChangethefirewallrulesofthenewSQLAzureservertoallowaccessbycomputersontheinternalnetwork.

A.EnableloggingonthecompanyWebsiteandselecttheNCSACommonLogFileFormat.StorethelogfilesonaSQLServercomputer

B.UseSystemMonitortocreateacounterlogthatcapturesnetworktraffictotheWebserverbyusingtheWebServiceobject.StorethelogfilesonaSQLServercomputer

C.RuntheNetworkMonitorontheWebserver.CreateacapturefilterfortheSNAprotocolandsavetheresultstoacapturefile.StorethecapturefileonaSQLServercomputer

D.EnableloggingonthecompanyWebsiteandselectODBCLogging.ConfiguretheODBClogging optionsbyusinganonadministrativeSQLaccount

A.A

B.B

C.C

D.D

he SqlConnection object. Your connection objects are being pooled. As the pool fills up, connection requests are queued. Some connection requests are rejected. You need to ensure that the application releases connections back to the pool as soon as possible. Also, you need to decrease the likelihood that connection requests will be rejected.Which three actions should you perform?（）

A. Ensure that the Close method is called on each connection object after it has finished executing.

B. Ensure that each connection object is left open after it has finished executing.

C. Increase the Max Pool Size value inside the connection string.

D. Increase the Min Pool Size value inside the connection string.

E. Increase the Connection Lifetime value inside the connection string.

F. Increase the value of the ConnectionTimeout property of the SqlConnection object.

controllersnamedDC2andDC3.AllserversrunWindowsServer2003ServicePack2（SP2）.YouverifytheIPconfigurationofServer1asshowninthefollowingCommandPromptwindow.YouneedtoensurethatServer1canlocateadomaincontrollerifasingleserverfails.WhichIPconfigurationshouldyouchangeonServer1？（）

A.Add10.10.0.2asaDNSserver.

B.Add10.10.0.2asaWINSserver.

C.Add10.11.0.20asaWINSserver.

D.AddasecondnetworkadapterthathasanIPaddressof10.10.0.20.

A.在SQLServerManagementStudio，打开活动监视器，打开进程信息页，查看进程54的阻塞者列信息

B.在SQLServerManagementStudio，打开活动监视器，打开按进程分类的锁页，查看进程54请求模式列

C.在SQLServerManagementStudio，打开新查询窗口并且执行如下语句：SELECT*FROMsys.dm_exec_requestsWHEREsession_id=54然后查看blocking_session_id列

D.在SQLServerManagementStudio，打开新查询窗口并且执行如下语句：SELECT*FROMsys.dm_exec_sessionsWHEREsession_id=54查看status列

A.

B.

C.

D.