第1题:
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?()
第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. 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? ()
第3题:
You work as the IT professional in an international company which is named wiikigo. You are experienced in implementing and administering a network operating system. You are specialized in configuring IP addressing and services. Configuring name resolution and network access and so on.Your company is desigiing its network. The network will use an IPv6 prefix of 2001:DB8: BBCC:0000::/53. You have to identify an IPv6 addressing scheme that will support 2000 subnets. Which network mask should you use?()
第4题:
第5题:
第6题:
第7题:
Server
SQL Server Agent
SQL Server Browser
SQL Active Directory Helper
第8题:
log.trc
default.trc
ERRORLOG
SQLAGENT
第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. 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?()
第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. 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? ()
第15题:
第16题:
第17题:
第18题:
第19题:
Agent XPs
remote access
remote proc trans
Ad Hoc Distributed Queries
第20题:
bcp.exe
dta.exe
dtexec.exe
sqlmaint.exe
第21题:
第22题:
第23题:
第24题: