第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? ()
第2题:
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?()
第3题:
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? ()
第4题:
第5题:
第6题:
第7题:
Agent XPs
remote access
remote proc trans
Ad Hoc Distributed Queries
第8题:
bcp.exe
dta.exe
dtexec.exe
sqlmaint.exe
第9题:
You should configure SQL Server VSS Writer
You should configure Distributed File System
You should configure SQL Server
You should configure SQL Server Full Text
第10题:
SQLServer:Buffer Manager
SQLServer:Access Methods
SQLServer:General Statistics
SQLServer:Exec Statistics
第11题:
第12题:
第13题:
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?()
第14题:
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? ()
第15题:
第16题:
第17题:
第18题:
Server
SQL Server Agent
SQL Server Browser
SQL Active Directory Helper
第19题:
log.trc
default.trc
ERRORLOG
SQLAGENT
第20题:
You should use local Service account
You should use network Service account
You should use domain account
You should use local System account
第21题:
第22题:
第23题: