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 are queries that have an estimated execution cost less than 3. You intend to configure the instance, make it use a single thread for these queries. In the options below, which sp_configure configuration option should you set?（）

A、You should set query governor cost limit

B、You should set cost threshold for parallelism

C、You should set priority boost 

D、You should set precompute rank

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 DB1 in the instance. You have set the recovery model of DB1 to Full. At 2：00 There is a full database backup of all the user databases every day. Every quarter the transaction log backup is performed. Every 4 hours a differential backup is occurred. You are going to perform a full backup of DB1 at 11：00. When you perform this back up， you must make sure that the overall backup will not be affected. What'；s more， you have to restore procedures for DB1. You must make sure that the backup files are restored in proper sequence.  In the options below， which Transact-SQL statement should you use？（）

A、BACKUP LOG DB1 TO DISK = 't:/backups/db1.trn'; 

B、BACKUP DATABASE DB1 TO DISK = 't:/backups/db1.bak' WITH DIFFERENTIAL; 

C、BACKUP DATABASE DB1 TO DISK = 't:/backups/db1.bak' WITH NOUNLOAD; 

D、BACKUP DATABASE DB1 TO DISK = 't:/backups/db1.bak' WITH COPY_ONLY; 

被称为"辛温发汗之峻剂"的方剂是（）

A、麻黄汤

B、桂枝汤

C、九味羌活汤

D、败毒散

E、参苏饮

热病后期，气阴两伤，余热未清，胃失和降，见身热汗出，渴饮少食，气逆欲呕，舌红苔少，脉虚数等。洽宜选用（）

A、竹叶石膏汤

B、麦门冬汤

C、白虎汤加人参汤

D、清暑益气汤

E、青蒿鳖甲汤

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. Now according to the company requirement, you are designing a consolidated repository of performance data. You must make sure that the four requirements below are met: the data collector is used to gather performance information; a single database stores performance information for all instances; performance information that is older than 15 days is deleted; reduce the administrative effort to manage performance to the least. So what action should you perform to achieve this goal? （） 

A、You should create a SQL Agent job process on each instance to store and delete performance data in a single database for all instances. 

B、You should configure a management data warehouse process on each instance, then use this process to store and delete performance data in a single database for all instances. 

C、You should configure an automated server-side trace process on each instance, then use this process to store and delete performance data in a single database for all instances. 

D、You should create and schedule a single Microsoft SQL Service Integration Services (SSIS) package process, then use this process to store and delete performance data in a single database for all instances. 

You have a Windows Server 2008 server that has the Web Server （IIS） server role installed. The server hosts multiple Web sites.  You need to configure the server to automatically release memory for a single Web site. You must achievethis goal without affecting the other Web sites. What should you do？（）

A、Create a new Web site and edit the bindings for the Web site.

B、Create a new application pool and associate the Web site to the application pool.

C、Create a new virtual directory and modify the Physical Path Credentials on the virtual directory.

D、From the Application Pool Defaults， modify the Recycling options.