You are the administrator of two SQL Server 2000 computers. One of these servers contains a 4-GB database named marketing. You want to remove the marketing database from one server and add it to the other as quickly as possible.What should you do?A．Detach

第1题：

第2题：

第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 have an Exchange Server 2010 that contains a DAG named DAG1.Contains 3 Mailbox Servers including a server named Server 1. Server 1 fails.You restore Server 1.You need to ensure that Server 1 can replicate Mailbox Databases from DAG1. What should you do first？（）

• A、Modify the GUID for Server 1
• B、Remove the object for Server 1 from DAG1
• C、Remove the default Mailbox Database from Server 1
• D、Disable log truncation for the Mailbox database in DAG1

第5题：

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 database named Dworks in the instance. Now you get a report from users saying that DB1 meets deadlock problems. As the technical support, you have to capture the deadlock information to the SQL Server error log. What should you do?（）  

• A、For the AdventureWorks database, enable Server Auditing 
• B、First you should set the appropriate trace flags as a startup parameter, and then restart the SQL Server instance 
• C、You should configure the data collector and make it capture the deadlock graphs
• D、You should configure a SQL Profiler trace, and make it capture the deadlock graphs

第6题：

Your company has an Active Directory forest.  The forest contains two sites named Site1 and Site2.  You plan to deploy Exchange Server 2010 servers in both sites.  You need to plan a high-availability solution for the Mailbox servers that meets the following requirements：.Users must be able to access their mailboxes if a single server fails  .Users must be able to access their mailboxes remotely if a single site becomes unavailable What should you do？（）

• A、Deploy two Mailbox servers in each site. Install and configure continuous cluster replication （CCR）.
• B、Deploy one Mailbox server in Site1 and one Mailbox server in Site2. Install and configure continuous cluster replication （CCR）.
• C、Deploy two Mailbox servers in each site. Create one database availability group （DAG） named  DAG1. Add all Mailbox servers to DAG1.
• D、Deploy two Mailbox servers in each site. Create two database availability groups （DAGs） named  DAG1 and DAG2. Add the Mailbox servers from Site1 to DAG1 and the Mailbox servers from Site2 to  DAG2.

第7题：

Your network contains two Exchange Server 2010 Client Access servers named CAS1 and CAS2 and two Mailbox servers named MBX1 and MBX2.You have one mailbox database and one public folder database.You need to ensure that the public folders are available if MBX1 fails.What should you do？（）

• A、Create a Failover Cluster and then add MBX1 and MBX2 to the Failover Cluster
• B、Create a database availability group （DAG） and then add MBX1 and MBX2 to the DAG
• C、Create a public folder database on MBX2 and then modify the replication settings on each public folder
• D、Create a public folder database on MBX2 and then modify the replication settings on the public folder database

第8题：

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 database named Dworks in the instance. You are log shipping the Adventureworks database to a remote SQL Server 2008 instance. The primary SQL Server instance required a restart during the weekend. But you notice that log shipping has stopped working after the weekend. You have to check log shipping of the Adventureworks database and find out the problem. What should you do? （） 

• A、You should use the EXTENDED_LOGICAL_CHECKS option to execute a DBCC CHECKDB statement on the AdventureWorks database by. 
• B、You should identify whether the SQL Server Agent is started on the primary server. 
• C、You should identify whether the AdventureWorks database uses the Simple recovery model. 
• D、You should identify whether the SQL Server Volume Shadow Copy Service (VSS) Writer is started on the primary server

第9题：

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 database named Service in the instance. There is a database user who is named ServiceGreatUser. A SQL Server login named ServiceGreatLogin maps to ServiceGreatUser in the Service database. According to the requirement of the company CIO, the database user can only perform the two tasks below: the database user executes all stored procedures that currently exist in the Sales database and executes all stored procedures that will be created in the Sales database. So what should you do to ensure this? （）

• A、ServiceGreatUser should be added to the appropriate fixed database roles. 
• B、You should assign the appropriate object-level permissions to ServiceGreatUser 
• C、You should assign the appropriate server-level permissions to ServiceGreatLogin 
• D、You should assign the appropriate database-level permissions to ServiceGreatUser

第10题：

You have an Exchange organization.All servers in the organization have Exchange Server 2010 Service Pack 1 （SP1） installed. The organization contains a database availability group （DAG） named DAG1.DAG1 contains three Mailbox servers including a server named Server1. Server1 fails.You restore Server1.You need to ensure that Server1 can replicate mailbox databases from DAG1. What should you do first？（）

• A、Remove the default mailbox database from Server1.
• B、Modify the GUID for Server1.
• C、Remove the object for Server1 from DAG1.
• D、Disable log truncation for the mailbox databases in DAG1.

第11题：

第12题：

第13题：

第14题：

第15题：

You need to design a configuration for the mailbox servers. What should you do？（）

• A、Create two Exchange Server 2003 computers. Place the mailboxes for main office users on one server， and place the mailboxes for remote users on the other server
• B、Create a Network Load Balancing cluster that contains two Exchange Server 2003 computers. Place half of the user mailboxes on one server， and place half of the user mailboxes on the other server
• C、Create a Microsoft Cluster Server cluster that contains two Exchange Server 2003 computers. Place all of the user mailboxes on one server and configure the other server as a failover node
• D、Create a Microsoft Cluster Server cluster that contains two Exchange Server 2003 computers. Place half of the user mailboxes on one server， and place half of the user mailboxes on the other server

第16题：

You have an Exchange Server 2010 organization that contains a database availability group （DAG） named DAG1.DAG1 contains five Mailbox servers including a server named MBX1.MBX1 fails.You plan to perform a recovery installation of MBX1.You need to ensure that the restored server can become a member of DAG1.The solution must ensure that mailbox databases are available if a single server fails.What should you do？（）

• A、Remove MBX1 from DAG1.
• B、Remove all mailbox database copies from DAG1.
• C、Remove the computer account for MBX1 from Active Directory.
• D、Run the Clean-MailboxDatabase cmdlet on all other members of DAG1 except MBX1.

第17题：

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 an internal application which uses Analysis Services and Reporting Services. You use the application on the basis of SQL Server 2008. According to the requirement of company security policy, the surface area for all the deployed components of SQL Server 2008 should be configured. You have to implement the security policy and devise a method to evaluate the security policy against other database servers. What should you do?（）  

• A、You should create policies based on the appropriate facets. Apply the policies against a server group. The server group includes the database servers that need to be configured 
• B、You should create a Transact-SQL script based on the sp_configure stored procedure. Use a configuration server to run the script against a server group that includes the database servers that need to be configured 
• C、You should edit the RSReportServer.config configuration file. Distribute the file to all database servers that need to be configured 
• D、You should analyze your database servers by using the SQL Server Best Practices Analyzer (BPA). Implement the recommendations of the BPA

第18题：

You have an Exchange organization.All servers in the organization have Exchange Server 2010 Service Pack 1 （SP1） installed. The organization contains two Mailbox servers named Server1 and Server2.Each Mailbox server has one mailbox database and one public folder database. You discover that all users create public folders on Server1 only. You need to ensure that all users create public folders on Server2 only. What should you do？（）

• A、Move all mailboxes to Server2.
• B、Modify the properties of both mailbox databases.
• C、Remove all public folder replicas from Server1.
• D、Modify the properties of both public folder databases.

第19题：

You have an Exchange Server 2010 organization.The organization contains two Mailbox servers named Server1 and Server2.Both servers are members of a database availability group （DAG） named DAG1.Server1 and Server2 have a copy of a mailbox database named DB1.You need to remove the copy of DB1 from Server1.What should you do？（）

• A、From the Exchange Management Shell， run Clean-MailboxDatabase -Identity DB1.
• B、From the Exchange Management Shell， run Remove-MailboxDatabase -Identity DB1/Server1.
• C、From the Exchange Management Console （EMC）， right-click the database copy and select Remove.
• D、From the Exchange Management Console （EMC）， right-click DAG1 and select Manage Database Availability Group Membership.Remove Server1 from the list and click Manage.

第20题：

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 your company. You utilize the SP：Recompile event class to run SQL Server Profiler. You find that a great amount of recompiles occurring. The possible causes of the large number of recompiles should be identified.  From the flowing four options， which one is the most possible cause of the problem？（）

• A、The sp_executesql batches are not being recovered from the procedure cache.
• B、A database administrator executed UPDATE STATISTICS statements on all tables， and the most common stored procedures reference all the tables.
• C、One new stored procedure is created by a database administrator.
• D、Ad hoc batches are not being recovered from the procedure cache.

第21题：

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.

第22题：

You are the network administrator for TestKing. The network consists of a single Active Directory domain named testking.com. All domain controller run Windows Server 2003. employes three database administrators who administer seven databases servers that run Windows Server 2003. The database administrators occasionally restore a database server after a disaster. To restore a server, database administrators need the rights required to perform the following tasks: 1. Back up files and folders 2. Restore files and folders. 3. Restore the System State data. You need to assign the database administrators the rights that they require to perform the specified tasks. For security reasons, you must not assign the administrators more rights than they require to perform the tasks. What should you do?（）

• A、Add the database administrators' user accounts to the Administrators group on each of the database servers.
• B、Add the database administrators' user accounts to the Power Users group on each of the database servers.
• C、Add the database administrators' user accounts to the Backup Operators group on each of the database servers.
• D、Add the database administrators' user accounts to the Backup Operators group on one of the domain controllers.
• E、Add the database administrators' user accounts to the Server Operators group on one of the domain controllers.

第23题：