单项选择题
You are a database administrator of two SQL Server 2005 computers named SQL1 and SQL2. You have a Microsoft .NET application that has been modified so that it now accesses a database on SQL2 in addition to SQL1. You do not want the user application to connect directly to SQL2. You need to enable the data retrieval from SQL2 while maintaining the ability to assign different permissions to different users who use the .NET application. What should you do？（）
A.Change the .NET application to define a new server connection to SQL2.
B.Configure a linked server on SQL1 to point to SQL2.
C.Configure a linked server on SQL2 to point to SQL1.
D.Change the stored procedures called by the .NET application to include the OPENXML command.
相关考题
-
单项选择题
Youareadatabaseadministratorforyourcompany.ThecompanyusesaSQLServer2005database.Afullbackupofthedatabaseismadeeachnight.Transactionlogbackupsaremadeeachmorningandeachafternoon.Younoticethatthedatabasetransactionlogfilegrowsverylargethroughouttheday.Youneedtominimizethesizeofthetransactionlogfile.Youalsoneedtominimizedatalossintheeventofafailure.Whatshouldyoudo？（）
A.Decrease the amount of time between transaction log backups.
B.Configure the database to use the simple recovery model.
C.Configure the RECOVERY INTERVAL option to be a smaller value.
D.Run DBCC SHRINKFILE on the transaction log file. -
单项选择题
Youareadatabaseadministratorforyourcompany.YouareresponsibleforaSQLServer2005databasethathasseveralindexes.Youneedtowriteastoredprocedurethatcheckstheindexesforfragmentation.WhichTransact-SQLstatementshouldyouuse？（）
A.DBCC DBREINDEX
B.SELECT * FROM sys.dm_db_index_physical_stats
C.DBCC INDEXDEFRAG
D.SELECT * FROM sys.indexes -
多项选择题
Youareadatabaseadministratorforyourcompany.YouareconfiguringanewSQLServer2005computernamedSQL1.SQL1willrunReportingServices.Itwillalsobeconfiguredtoautomaticallyperformdatabasebackupsandothermaintenancetasks.TherearenootherSQLServercomputersinthenetworkenvironment.AllaccesstoSQL1willbemadebyusingSQL1sDNSname.YouneedtodisableanyunnecessaryservicesonSQL1.Whichserviceorservicesshouldyoudisable？（）
A.Internet Information Services
B.SQL Server Browser
C.SQL Server Agent
D.Microsoft Distributed Transaction Coordinator
