单项选择题
ou 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. According to the company requirement, you intend to perform an installation of an instance of SQL Server Reporting Services (SSRS) to the same machine. Now your company CIO wants version histories of all deployed reports can be kept. As a technical support, what should you do to ensure this?（）
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 -
单项选择题
YouworkinacompanywhichisnamedWiikigoCorp.ThecompanyusesSQLServer2008.Youaretheadministratorofthecompanydatabase.NowyouareinchargeofaSQLServer2008instance.ThereisadatabasenamedDB1intheinstance.DB1isavailabletoaWindowsgroupwhichisnamedWIIKIGO\Supervisors.AWindowsusernamedUser1isamemberoftheWIIKIGO\Supervisorsgroup.WIIKIGO\Supervisorsisamemberofthedb_ownerroleintheDB1database.YoumustmakesurethattheSQLServerinstanceisavailabletoUser1.IntheDB1database,whichTransact-SQLstatement(s)shouldyouexecute?（）
A. DROP LOGIN "WIIKIGO\User1";
B. EXEC dbo.sp_droprolemember 'db_owner', 'WIIKIGO\User1';
C. EXEC dbo.sp_revokedbaccess 'WIIKIGO\User1';EXEC dbo.sp_revokelogin 'WIIKIGO\User1';
D. CREATE LOGIN "WIIKIGO\User1" FROM Windows;DENY CONNECT SQL TO "WIIKIGO\User1"; -
单项选择题
YouworkinacompanywhichisnamedWiikigoCorp.ThecompanyusesSQLServer2008.Youaretheadministratorofthecompanydatabase.NowyouareinchargeofaSQLServer2008instance.ThereisadatabasenamedDB1intheinstance.DB1hasatablewhichisnamedTable01andastoredprocedurenamedProcedure01.Procedure01choosedatafromTable01byusingasp_executesqlTransact-SQLstatement.Youcompanysecurityrulesforbiduserstoaccesstablesdirectlyinanydatabase.Lookattheexceptionbelow:"Msg229,Level14,State5,Line1TheSELECTpermissionwasdeniedontheobject'Table01',database 'DB1',schema'dbo'."TheexceptionisraisedwhenProcedure01isexecutedbyusers.YoumustmakesurethateusercansuccessfullyexecuteProcedure1complyingwiththecompanyrules.Sowhatactionshouldyouperformtoachievethisgoal?（）
A.You should execute the GRANT SELECT ON dbo.Table01 TO User1 Transact-SQL statement.
B.You should execute the GRANT EXECUTE ON dbo.Procedure1 TO User1 Transact-SQL statement.
C.You should alter Procedure01 and add the WITH EXECUTE AS OWNER option to its header
D.You should alter Procedure01 and add the EXECUTE AS USER = 'dbo' option immediately before the call to the sp_executesql stored procedure.
