Practice 1　　● You work in the IT Center of a company, which

第1题：

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

第2题：

Your company has an Active Directory Domain Services (AD DS) domain. You virtualize applications by using Microsoft Application Virtualization (App - V). You are creating an application virtualization package. Which sh ould you use?（）

• A、Microsoft Application Virtualization Sequencer
• B、Microsoft Application Virtualization Desktop Client
• C、Microsoft System Center Application Virtualization Streaming Server
• D、Microsoft System Center Application Virtualization Management Server

第3题：

第4题：

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. Today you notice that applications that run on the server have poor performances. You doubt that this has something to do with table scans. You have to capture the appropriate information by using an appropriate Windows System Monitor object. In the options below, which performance object should you use? （） 

• A、You should use SQLServer:Buffer Manager
• B、You should use SQLServer:Memory Manager 
• C、You should use SQLServer:Databases 
• D、You should use SQLServer:Access Methods

第5题：

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. You have to perform the backup of the default trace according to the requirement of your failure recovery plan. The default trace is contained in the subdirectory.You have to backup the subdirectory.  Which SQL Server database engine subdirectory should be backed up？（）

• A、DATA
• B、INSTALL 
• C、LOG 
• D、BINN

第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. There is a database named DB1 in the instance. TheDB1 database includes spatial data types. On DB1 databse, you have to perform a database consistency check to include the spatial indexes. Besides this, you must make sure that you can reduce the effect on the database concurrency to the least.  So which Transact-SQL statement should you run? （） 

• A、DBCC CHECKCATALOG (DB1); 
• B、DBCC CHECKALLOC (DB1) WITH TABLOCK; 
• C、DBCC CHECKDB (DB1) WITH TABLOCK, PHYSICAL_ONLY; 
• D、DBCC CHECKDB (DB1) WITH EXTENDED_LOGICAL_CHECKS; 

第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 which contains a database. Now your company CIO assigns a task to you. You have to check the performance of the SQL Server 2008 instance. You have to find out which common language runtime (CLR) queries takes the longest-running time.  So in the options below, which dynamic management view should you choose to use?（）  

• A、sys.dm_os_wait_stats 
• B、sys.dm_exec_requests 
• C、sys.dm_exec_sessions 
• D、sys.dm_exec_query_stats

第8题：

You work as a network administrator in your company. Communication inside the company is ensured by network environments, such as GET VPN, Dynamic Multipoint VPN and Ethernet. Which PIN architecture is applicable in those environments?（）

• A、Campus
• B、Teleworker
• C、Branch
• D、Data center

第9题：

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. The instance contains a database named DB1. An application which is continuously connected uses DB1. The application extensively uses the INSERT command and triggers the population of multiple tables. Now you notice that the application has a poor performance. You doubt that this problem has something to do with blocking. You have to monitor the state of the instance at regular intervals while not affecting the application performance further.  Which tool should you use? （） 

• A、You should use Dynamic Management Views 
• B、You should use SQL Server Resource Governor 
• C、You should use SQL Server Profiler 
• D、You should use Windows System Monitor

第10题：

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 your company CIO assigns a task to you. The company CIO wants you to configure FILESTREAM data and the two requirements below must be met: you must enable FILESTREAM for file I/O streaming access; remote client computers must be able to have streaming access to FILESTREAM data. You must make sure that FILESTREAM data is enabled. Which service should you configure? （） 

• A、You should configure SQL Server VSS Writer 
• B、You should configure Distributed File System 
• C、You should configure SQL Server 
• D、You should configure SQL Server Full Text