Which IGP should you use to achi

第1题：

You work as a Web Developer at Certkiller.com. You are in the process of creating a Webapplication using Microsoft ASP.NET 3.5.  You create a folder named Dark in the App_Themes folder of the Web application. You also addfour skin files to this folder. You have to make sure that the controls on a page have their appearances overridden by the control definitions defined in the skin files. What should you do？  Which Page directive should you use？（）

• A、You should use the page directive: <%@ Page StyleSheetTheme="App_Themes.Dark"/>
• B、You should use the page directive: <%@ Page Theme="App_Themes.Dark"/>
• C、You should use the page directive: <%@ Page Theme="Dark"/>
• D、You should use the page directive: <%@ Page StyleSheetTheme="Dark"/>

第2题：

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

第3题：

第4题：

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

第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 DB1 in the instance. In the database, a small percentage of data is modified everyday. Ever day in the morning, you have to create a read-only copy of the database for reporting purposes and make sure that you use as little disk space as possible.  In the options below, which strategy should you use? （） 

• A、You should use database snapshots 
• B、You should use database backup and restore 
• C、You should use database backup and restore along with compression 
• D、You should use schema-bound views in a read-only database. The database resides on the same instance.

第6题：

You work as an administrator at ENSUREPASS.com. The ENSUREPASS.com network consists of a single domain named ENSUREPASS.com.Subsequent to deploying a Server Core Installation of Windows Server 2012 on a new ENSUREPASS.com server， you are instructed to add a graphical user interface （GUI） to the server.You want to achieve this goal from the command prompt. Which of the following actions should you take？（）

• A、You should consider making use of the dism.exe command.
• B、You should consider making use of the dsquery.exe command
• C、You should consider making use of the dsadd.exe command
• D、You should consider making use of the dsrm.exe command

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

第8题：

第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. According to the company requirement, you migrate an application from Microsoft SQL Server 2000 to Microsoft SQL Server 2008. You have to monitor the SQL Server instance, and record the use of features which will be discontinued. What should you do? （） 

• A、The SQL Server 2008 Upgrade Advisor should be used 
• B、You should use a SQL server-side trace. The trace captures the Deprecation Announcement and Deprecation Final Support event classes 
• C、You should use the SQL Server Profiler. The profiler captures the SQL:BatchCompleted and Exception event classes 
• D、You should use a SQL server-side trace. The trace captures the SQL:BatchCompleted and Exception event classes. 

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