销售部和财务部在两栋不同的楼里。两个部门由一个2兆位的网络连接。并且都使用SQL Server 2005。销售部在一个名为DB1的数据库里记录所有的销售事务。DB1包含380张表，大小为10GB。财务部为做报表可以只读方式访问DB1里的4张表。财务部会全天进行查询并需要尽可能最新的数据。财务部的用户告诉你报表执行非常缓慢。为优化网络容量，你的部门决定为财务部提供此四张表的副本。现在，你需要提供这些表的副本。因此，你想用一种占最小网络带宽的复制法达成此目标，该怎样做？（）

单项选择题You work with a database named DB1， which is located on a SQL Server 2005 computer. You discover that a table scan on Table1 in DB1 causes a slow query. Table1 is a very large table that is used frequently. You ascertain that the query contains the following statement. SELECT col1， col2 FROM table1 WHERE col3 =  You need to provide maximum query performance. Table1 must remain available to users. What should you do？（）

A.Update all statistics on Table1 in DB1.
B.Use the CREATE STATISTICS statement in DB1 to create missing statistics on col3of Table1.
C.Set the priority boost server option to 1.
D.Execute the following statement.USE DB1GOCREATE INDEX index1 ON table1（col3）INCLUDE（col1， col2） WITH （ONLINE = ON）GO

单项选择题Your SQL Server 2005 database contains a table that has 500 million rows of data. Some of the data is historical and some is current. You need to partition the data on a single server to increase performance and optimize maintenance. What should you do？（）

A.Implement horizontal partitioning.
B.Implement vertical partitioning.
C.Implement a raw partition.
D.Implement distributed partitioning.

单项选择题Application developers in TestKing.com create an assembly that contains a CLR function.This CLR function reads data from a spreadsheet， performs some calculations， and returns the data to a SQL Server 2005 computer. You need to register the assembly with SQL Server 2005 by using the CREATE ASSEMBLY statement and the least privileged security permission set. Which permission set should you use？（）

A.Default
B.SAFE
C.EXTERNAL ACCESS
D.UNSAFE

单项选择题TestKing.com has two SQL Server 2005 computers named SQL1 and SQL2. A user in TestKing.com named Eric writes many ad hoc queries against the company databases.Eric has access to the Customer database on SQL1. He does not have access to the Sales database on SQL2. You need to ensure that Eric can write queries that join information from both servers. What should you do first？（）

A.Create a linked server on SQL1 to SQL2. Configure the linked server to use impersonation.
B.Create a linked server on SQL1 to SQL2. Configure the linked server to use mapped logins.
C.Instruct Eric to write the queries on SQL2 by using the OPENQUERY statement and specifying SQL1 as the server name.
D.Instruct Eric to specify SQL Server object names by using four-part notation.

单项选择题A new employee needs access to a SQL Server 2005 database that is located on a server named SQL1. You create a login named ajones by using the following Transact-SQL statement. CREATE LOGIN ajones WITH PASSWORD = ’SQLServer$1’ The new employee reports that when he logs in， he receives the following error message：  Login failed. The user is not associated with a trusted SQL Server connection.  You need to resolve the error and allow the new employee to gain access to SQL1. What should you do？（）

A.Change the SQL Server security mode from Windows Authentication mode to SQL Server and Windows authentication mode.
B.Change the SQL Server security mode from SQL Server and Windows Authentication mode to Windows authentication mode.
C.Ensure that the login name is created with square brackets （[]）.
D.Give the login access to a specific database by using the CREATE USER Transact-SQL statement.