单项选择题
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. You intend to configure FILESTREAM data, enabling FILESTREAM for file I/O streaming access and allowing remote client computers to have streaming access to FILESTREAM data. You must make sure that FILESTREAM data is enabled. In the options below, which service should you configure? （）
A.You should configure Distributed File System
B.You should configure SQL Server
C.You should configure SQL Server Full Text
D.You should configure SQL Server VSS Writer
相关考题
-
单项选择题
YouworkinacompanywhichusesSQLServer2008.Youaretheadministratorofthecompanydatabase.InyourcompanythereisaserverwhichcontainsadefaultSQLServer2005instance.Foranewapplication,youhavetoinstallaSQLServer2008instanceontheserver.YourcompanyCIOassignsatasktoyou.Youmustmakesurethattherespectivecertifiedthird-partyapplicationshaveaccesstobothdatabaseinstances.Youhavetoachievethisgoalwithoutchangingtheexistingapplicationenvironments.Sowhatshouldyoudotoachievethisbyusingaslittledatabaseadministrativeeffortaspossible?（）
A.You should install SQL Server 2008 as a named instance, and make the new application to use the new instance.
B.You should install SQL Server 2008 as the default instance, and make the new application to use the default instance.
C.You should upgrade the SQL Server 2005 application to use SQL Server 2008.
D.You should upgrade the SQL Server 2005 instance to a SQL Server 2008 instance. -
单项选择题
ouworkinacompanywhichusesSQLServer2008.Youaretheadministratorofthecompanydatabase.NowyouareinchargeofaSQLServer2008instance.Accordingtothecompanyrequirement,youintendtoperformaninstallationofaninstanceofSQLServerReportingServices(SSRS)tothesamemachine.NowyourcompanyCIOwantsversionhistoriesofalldeployedreportscanbekept.Asatechnicalsupport,whatshouldyoudotoensurethis?（）
A.You should use the http.sys listener to install the SSRS instance.
B.You should configure the SSRS database, make it use Native mode
C.You should configure the SSRS database, make it use SharePoint integrated mode
D.You should use the Internet Information Services default Web site to install the SSRS instance -
单项选择题
YouworkinacompanywhichusesSQLServer2008.Youaretheadministratorofthecompanydatabase.NowyouareinchargeofaSQLServer2008instance.Therearequeriesthathaveanestimatedexecutioncostlessthan3.Youintendtoconfiguretheinstance,makeituseasinglethreadforthesequeries.Intheoptionsbelow,whichsp_configureconfigurationoptionshouldyouset?（）
A.You should set query governor cost limit
B.You should set cost threshold for parallelism
C.You should set priority boost
D.You should set precompute rank
