You are the administrator of a SQL Server 2000 computer named SQL1. You want to perform. ad hoc distribution queries against a database that is stored on a SQL Server 2000 computer named SQL2. SQL2 contains several databases, and each of these databases u

第1题：

第2题：

You need to migrate the DeliveryVans， AirlinePreferences， and SeasonalContractors databases into the data center. What should you do？（）

• A、Install a separate instance of SQL Server 2005 for each of the databases on a single server.
• B、Create a SQL Server database for each of the databases in a single instance of SQL Server 2005.
• C、Import the data from each of the databases into a single database in an instance of SQL Server 2005.
• D、Install a default instance of SQL Server 2005 on three separate servers. Use one server for each of the databases.

第3题：

Your application must access data that is located on two SQL Server 2005 computers. One of these servers is named SQL1 and the other is SQL2. You have permissions to create a stored procedure on SQL1 to support your application. However，on SQL2 you only have permissions to select data. You write the stored procedure on SQL1. The stored procedure accesses SQL2 by using the OPENQUERY Transact-SQL statement. However,the query fails when executed.You need to troubleshoot the cause of the error. What should you do？（）

• A、Join the two servers by using the four-part syntax of server.database.schema.table.
• B、Reference SQL2 by using an alias.
• C、Add SQL2 as a remote server to SQL1.
• D、Add SQL2 as a linked server to SQL1.

第4题：

You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for a financial services company. Replication is configured between two SQL Server 2005 computers， and the servers are respectively named SQL1 and SQL2. Real-time transactional data is stored by the SQL1. And SQL2 is utilized for reporting. The data on SQL01 should not be changed by SQL2. The publication contains a large amount of data. Since you are the database administrator， you need to make sure that data is replicated from SQL1 to SQL2 in as near real-time as possible to confirm accurate reporting during replication. In addition， you need to make sure that this data is replicated securely.  Which action should be performed？（）

• A、Snapshot replication should be set on SQL1. And then SQL2 should be set as a standard subscriber for a standard subscription.
• B、Transactional replication should be set on SQL1. And then， SQL2 should be set as a standard subscriber for a standard subscription.
• C、Merge replication should be set on SQL1. And then SQL2 should be set as a standard subscriber for an updateable subscription.
• D、Transactional replication should be set on SQL1. And then， SQL2 should be set as a standard subscriber for an updateable subscription.

第5题：

You are designing a plan to migrate Microsoft SQL Server 2008 databases to SQL Azure. You do not plan to migrate the SQL Server databases to SQL Server 2008 R2.   You need to recommend an approach for performing bulk data transfers from the SQL Server databases to SQL Azure.  What should you recommend？（）

• A、 Use the bcp utility.
• B、 Use the dta utility.
• C、 Use the SQL Server Import and Export Wizard.
• D、 Attach each SQL Server database to SQL Azure.

第6题：

You are designing a strategy for synchronizing a SQL Azure database and multiple remote Microsoft SQL Server 2008 databases.  The SQL Azure database contains many tables that have circular foreign key relationships.  You need to recommend an approach for ensuring that all changes in the remote databases synchronize with the SQL Azure database.  What should you recommend？（）

• A、 Use SQLAzure Data Sync Service.
• B、 Use SQL Server replication.
• C、 Use SQL Server backup and restore.
• D、 Use SQL Server database snapshots.

第7题：

You are the administrator of a SQL Server 2005 computer named SQL1. SQL1 contains a database that utilizes SQL Server log shipping. Log shipping occurs every 30 minutes. Each night， a full backup is made of the database， and all database indexes are rebuilt. The company’s network administrator reports that SQL1s network utilization becomes excessive after the nightly maintenance tasks are complete. You need to reduce the network bandwidth utilization for SQL1. What should you do？（）

• A、Configure the database to use the bulk-logged recovery model.
• B、Each night， rebuild only those indexes that require it.
• C、Disable log shipping before the nightly maintenance. Re-enable log shipping after nightly maintenance completes.
• D、Increase the time between transaction log backups.

第8题：

You are the administrator of a Microsoft Windows Server 2003 computer named Server1. SQL Server 2005 is installed on Server1 to host a database named MedDB. The MedDB database serves as the backend database for a new client/server application named MedDATA. Installation of the MedDATA application creates the database schema， application roles， and administrative accounts. It also sets all of the default permissions. You need to establish a permissions baseline for all objects in the MedDB database.  What should you do？（）

• A、Use the SQL Server 2005 Management Studio to review the permissions of the default database objects.
• B、Query the sys.server_permissions table on Server1.
• C、Execute the sp_helplogins system stored procedure for each of the default users that the MedDATA application creates.
• D、Query the sys.database_permissions and sys.database_principals tables in the MedDB database.

第9题：

Your company uses a mission-critical database named DB1, which is located on a server named SQL1. You want to mirror DB1 on a second server named SQL2. Before you can establish database mirroring, you need to prepare DB1 and the servers for mirroring. Which three actions should you perform?（）

• A、 Set the recovery model of DB1 on SQL1 to bulk-logged recovery. 
• B、 Set the recovery model of DB1 on SQL1 to full recovery. 
• C、 Back up DB1 on SQL1. Restore the backup on SQL2; specify the NORECOVERY option. 
• D、 Back up DB1 on SQL1. Restore the backup on SQL2; specify the STANDBY option. 
• E、 Back up DB1 on SQL1. Restore the backup on SQL2; specify the RECOVERY option.
• F、 Create endpoints on all participating servers. 
• G、 Set the AutoShrink property of DB1 on SQL1 to false.

第10题：

You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work as the administrator of a SQL Server 2005 computer， and the computer is called SQL1. There are two databases on the SQL1， and the two databases are respectively named Production and DW. A new database named Staging is created. When the data are moving from the Production database into the DW database， the Staging database is utilized temporarily to store and manipulate data. Since you are the database administrator， you are required to make sure the points listed below. First， the tables should not be removed from the Staging database. Second， any attempts to have tables migrated should be logged. Third， your solution should not impact on other databases.  Which action should be performed to achieve the goal？（）

• A、To achieve the goal， a DML trigger on each table should be created to prevent deletion of data.
• B、To achieve the goal， a DDL trigger should be created， and that the ON DATABASE parameter is utilized by DDL trigger for the Staging database.
• C、To achieve the goal， an event notification should be created to fire when the TRUNCATE TABLE Transact-SQL statement is submitted to the Staging database.
• D、To achieve the goal， a DDL trigger should be created， and the ON ALL SERVER parameter is utilized by the DDL trigger.

第11题：

第12题：

第13题：

第14题：

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.

第15题：

You are a database administrator for your company. The company has two SQL Server 2005 computers named SQL1 and SQL2. SQL1 is located on the local network. SQL2 is located at a vendors site and is connected by using a VPN over the Internet. You need to write heterogeneous queries on SQL1 that access data from both SQL1 and SQL2. To ensure that your queries are functional， you must configure access to the vendors site. What should you do？（）

• A、Configure an HTTP endpoint for SQL2 on SQL1.
• B、Configure SQL2 as a linked server on SQL1.
• C、Configure an HTTP endpoint for SQL1 on SQL2.
• D、Configure SQL1 as a linked server on SQL2.

第16题：

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. There is a computer which hosts several applications in your company. The instance runs on the computer. A job named DiliveryList is created by you. This job requires a file to be written to a file server. But because the job cannot access the file server, it fails to run. You intend to configure the SQL Server Agent service so that only the SQL Server Agent service has read and write access to the file server. Which account type should you use? （） 

• A、You should use local Service account
• B、You should use network Service account
• C、You should use domain account
• D、You should use local System account

第17题：

You are a database administrator for your company. The company runs a popular database-driven Web site against a SQL Server 2005 computer named SQL2. You need to ensure a quick response time and appropriate audit trail in the event that SQL2 experiences excessive traffic due to denial-of-service （DoS） attacks. Which two actions should you perform？（）

• A、Create a new performance alert to monitor the Current Bandwidth counter.
• B、Create a new performance alert to monitor the Bytes Total/sec counter.
• C、Configure the new performance alert to start a SQL Server Profiler trace.
• D、Configure the new performance alert to start a Network Monitor capture.

第18题：

You want to consolidate some of the databases onto existing SQL Server computers until additional hardware can be purchased.You need to identify which of the servers， in its current configuration， can support additional databases. You need to ensure that your solution fulfills the company’s securiy requirements while allowing for future database growth requirements. Which server and database combination can be used？（）

• A、SQL3 with the OnlineReadOnly and HR databases
• B、SQL4 with the TravelOnline and Storefront databases
• C、SQL2 with the Storefront and TravelOnline databases
• D、SQL2 with the Storefront and HR databases

第19题：

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.

第20题：

You are a database administrator for your company. You are configuring a new SQL Server 2005 computer named SQL1. SQL1 will run Reporting Services. It will also be configured to automatically perform database backups and other maintenance tasks. There are no other SQL Server computers in the network environment. All access to SQL1 will be made by using SQL1s DNS name. You need to disable any unnecessary services on SQL1. Which service or services should you disable？（）

• A、Internet Information Services
• B、SQL Server Browser
• C、SQL Server Agent
• D、Microsoft Distributed Transaction Coordinator

第21题：

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 on the same physical computer. Now users report that they are unable to connect to the named instances. You check and verify that they can only connect to the default instance. You also ensure that all SQL Server instances run normally. You have to start the service which is required to connect to the named instances.  Which service should you start?（）  

• A、Server 
• B、SQL Server Agent 
• C、SQL Server Browser 
• D、SQL Active Directory Helper

第22题：

第23题：