单项选择题
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. Now your company CIO assigns a task to you. The company CIO wants you to configure FILESTREAM data and the two requirements below must be met: you must enable FILESTREAM for file I/O streaming access; remote client computers must be able to have streaming access to FILESTREAM data. You must make sure that FILESTREAM data is enabled. Which service should you configure? （）
A.You should configure SQL Server VSS Writer
B.You should configure Distributed File System
C.You should configure SQL Server
D.You should configure SQL Server Full Text
相关考题
-
单项选择题
ouworkinacompanywhichisnamedWiikigoCorp.ThecompanyusesSQLServer2008.Youaretheadministratorofthecompanydatabase.Nowforanewapplication,aSQLServer2008instancehastobeinstalledonanexistingserver.TheservercontainsadefaultSQLServer2005instance.YourcompanyCIOwantstheircorrespondingcertifiedthird-partyapplicationscanaccesstobothdatabaseinstances.Thecompanyassignsthistasktoyou.Youmustachievethisbyusingaslittledatabaseadministrativeeffortaspossible,andneverchangetheexistingapplicationenvironments.Whatshouldyoudo?（）
A.You should install SQL Server 2008 as the default instance, and configure the new application to use the default instance
B.You should upgrade the SQL Server 2005 application to use SQL Server 2008
C.You should upgrade the SQL Server 2005 instance to a SQL Server 2008 instance
D.You should install SQL Server 2008 as a named instance, and make the new application use the new instance. -
单项选择题
YouworkinacompanywhichisnamedWiikigoCorp.ThecompanyusesSQLServer2008.Youaretheadministratorofthecompanydatabase.NowyouareinchargeofaSQLServer2008instance.Accordingtothecompanyrequirement,thenamesofalluser-definedstoredproceduresmustcontaintheprefixusp_onallinstances.Besidesthis,youmustmakesurethatstoredproceduresthatdonotcontainthisprefixcannotbecreatedbyyou.Whatshouldyoudo?（）
A.A policy should be created. The policy targets the name of the stored procedure that is evaluated on demand.
B.A policy should be created. The policy targets the name of the stored procedure that is evaluated on change.
C.A condition should be created. The condition targets the name of the stored procedure that is evaluated on change
D.A condition should be created. The condition targets the name of stored procedure that is evaluated on demand. -
单项选择题
YouworkinacompanywhichisnamedWiikigoCorp.ThecompanyusesSQLServer2008.Youaretheadministratorofthecompanydatabase.NowyouareinchargeofaSQLServer2008instance.YouconfiguretheSQLServerinstancetousethe-T1222and-T1204traceflagsduringstartup.Youmustmakesurethatyourfailurerecoveryplanperformsbackupoftheuseofthetraceflags.Sowhatactionshouldyouperformtoachievethisgoal?（）
A.You should backup the master database
B.You should backup the default.trc file
C.You should backup the SQL Server registry hive.
D.You should backup the resource database
