You are the administrator of a SQL Server computer. Users report that the database times out when they attempt to modify data. You use the Current Activity window to examine locks held in the database as shown in the following screenshot.You need to disco

第1题：

第2题：

第3题：

You work in Dublin at the main office of TestKing.com. You are responsible for managing a SQL Server 2005 database. The sales department wants a report that compares customer activity in the previous quarter between the main office in Dublin and the branch office in Buenos Aires. They want the data sorted by surname and first name.You restore a recent backup of the Buenos Aires database onto your server. You write queries to build the report， ordering the data by the Surname and FirstName columns. You review the data and notice that the customer list from the Buenos Aires database is sorted differently. The sales department needs the revised data within 15 minutes for a presentation.  You need to implement the fastest possible solution that ensures that the data from both databases is sorted identically. What should you do？（）

• A、Use the Copy Database Wizard to copy the data in the Buenos Aires database to a new database with the same collation as the Dublin database.
• B、Use the SQL Server Import and Export Wizard to copy the data from the Buenos Airesdatabase into new tables， specifying the same collation as the Dublin database.
• C、Modify the format file to specify the same collation as the Dublin database. Import the table again.
• D、Modify the query on the Buenos Aires database to use the COLLATE setting in the ORDER BY clause. In the query， specify the same collation as the Dublin database.

第4题：

You are a database administrator for your company. The company uses a vendor company’s application that is based on a proprietary database. You query data from the application database and import the data into a SQL Server 2005 database. The application vendor provides you with a new OLE DB driver to be used when querying the application database. Company policy prohibits connections between the SQL Server database and the application database， except when querying this data. You need to provide a way to query data from the application database. What should you？（）

• A、Configure a Linked Server connection to the application database.
• B、Write a query that uses an OPENDATASOURCE command.
• C、Write a query that uses an OPENQUERY command.
• D、Configure a Remote Server connection to the application database.

第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 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

第6题：

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. A user reports that when he runs a query, it takes a quite long time and it is still unfinished. As the IT support, you have to verify whether the query is blocked.  Which tool should you use? （） 

• A、You should use the Database Engine Tuning Advisor tool 
• B、You should use the Windows System Monitor tool 
• C、You should use the Job Activity Monitor tool in Microsoft SQL Server Management Studio 
• D、You should use the Activity Monitor tool in Microsoft SQL Server Management Studio

第7题：

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. There is a database named DB1 in the instance. You put forward a database maintenance plan. The maintenance plan rebuilds indexes, checks database integrity, writes a report to a text file. Now the company requires that when the maintenance plan executes abnormally, the operators can be notified by an e-mail message. You've been assigned this task. So you have to make modifications on the SQL Server instance. What should you do?（）

• A、For the SQL Server Agent, you should enable a fail-safe operator 
• B、You should modify the database maintenance plan, making it send an e-mail to the appropriate operators 
• C、You should modify the database maintenance plan, making it include a Notify Operator task that e-mails the appropriate operators. 
• D、You should modify the SQL Server Agent job. The job executes the database maintenance plan to notify the appropriate operators.

第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 report which is often executed during business time. There is a stored procedure that is used as the data source for the report. You get a report from users saying that they receive the data returned by the report but the data is inconsistent. As the technical support, you check and find that phantom reads cause this problem. You must make sure that consistent data is returned by the report while not affecting other users. So what action should you perform to achieve this goal?（）  

• A、You should configure the database for Read Committed Snapshot isolation. 
• B、You should modify the stored procedure to use the Snapshot isolation level 
• C、You should configure the database for Auto Update Statistics asynchronously 
• D、You should modify the stored procedure to use the Repeatable Read isolation level

第9题：

A Windows Azure application retrieves data from SQL Azure.   You need to recommend an approach for improving application query performance.  What should you recommend？（）

• A、 Create a database view to retrieve the data.
• B、 Use a clustered index on the SQL Azure database tables.
• C、 Open a new database connection when an operation times out.
• D、 Create SQL Azure database table indexes basedon application queries

第10题：

第11题：

第12题：

第13题：

第14题：

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. There is a database named DB1 in the instance. When you are absent, a user will use a login named Mary to log in and maintain the database snapshots. The user has to delete the database snapshots for DB1, so you have to give the appropriate permissions to the user.  So which database permission should you give the user?（）  

• A、DELETE 
• B、CONTROL 
• C、DROP DATABASE 
• D、ALTER ANY DATASPACE

第15题：

In which situation would you use static database registration for a listener（）

• A、when multiple databases are to be registered with the listener
• B、when DBAs need to connect remotely to start up the database instance
• C、when users need to connect the database instance using the host naming method
• D、when the database instance that is to be registered with the listener is configured in shared server mode

第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 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

第17题：

You are the network administrator for The network consists of a single Active Directory domain named All servers run Windows Server 2003. A server named TestKing2 functions as an application server. Users in the TestKing marketing department use an application on TestKing2 to analyze data. The application produces a high volume of disk activity. You give access to 15 new users for the application on TestKing2. Users in the TestKing marketing department report unacceptable delays when they use the application during periods of peak activity. You use System Monitor to analyze the performance of TestKing2. You need to ensure that TestKing2 can support the new users. Which counter should you monitor?（）

• A、The % Disk Time counter for the PhysicalDisk performance object
• B、The Current Disk Queue Length counter for the PhysicalDisk performance object
• C、The Free Megabytes counter for the LogicalDisk performance object
• D、The Disk Transfers/sec counter for the LogicalDisk performance object

第18题：

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.

第19题：

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

第20题：

You are a database administrator for your company. The company uses a SQL Server 2005 computer that runs Reporting Services. Reporting Services is used to produce hundreds of reports each day. You discover that the ReportServerTempDB database is growing. You need to minimize the size of the ReportServerTempDB database. What should you do？（）

• A、Decrease the time between transaction log backups of the database.
• B、Delete report snapshot history each week.
• C、Minimize the use of session caching in the reports.
• D、Minimize the use of report snapshots in the reports.

第21题：

第22题：

第23题：