The SQL Server 2008 Upgrade Advisor should be used.
The SQL Server Profiler which captures the SQL:BatchCompleted and Exception event classes should be used.
A SQL server-side trace that captures the Deprecation Announcement and Deprecation Final Support event classes should be used
A SQL server-side trace that captures the SQL:BatchCompleted and Exception event classes should be used.
第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. You intend to configure FILESTREAM data, enabling FILESTREAM for file I/O streaming access and allowing remote client computers to have streaming access to FILESTREAM data. You must make sure that FILESTREAM data is enabled. In the options below, which service should you configure? ()
第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. 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? ()
第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. You configure the SQL Server instance to use the -T1222 and -T1204 trace flags during startup. You must make sure that your failure recovery plan performs backup of the use of the trace flags. So what action should you perform to achieve this goal? ()
第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. 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? ()
第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. 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? ()
第6题:
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? ()
第7题:
You should configure Distributed File System
You should configure SQL Server
You should configure SQL Server Full Text
You should configure SQL Server VSS Writer
第8题:
The SQL Server 2008 Upgrade Advisor should be used
You should use a SQL server-side trace. The trace captures the Deprecation Announcement and Deprecation Final Support event classes
You should use the SQL Server Profiler. The profiler captures the SQL:BatchCompleted and Exception event classes
You should use a SQL server-side trace. The trace captures the SQL:BatchCompleted and Exception event classes.
第9题:
You should use Dynamic Management Views
You should use SQL Server Resource Governor
You should use SQL Server Profiler
You should use Windows System Monitor
第10题:
Agent XPs
remote access
remote proc trans
Ad Hoc Distributed Queries
第11题:
bcp.exe
dta.exe
dtexec.exe
sqlmaint.exe
第12题:
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
第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. There is a stored procedure. The stored procedure implements a database maintenance process. A SQL Server Agent job should be created to that runs the stored procedure. Besides this, you must make sure that after it is completed successfully, the job is removed. What should you do? ()
第14题:
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?()
第15题:
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?()
第16题:
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.You must make sure that all SQL Server instances are consistently configured for naming conventions, security settings, force index creation and avoidance of data fragmentation. So what action should you perform to achieve this goal?()
第17题:
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 on the same physical computer. Now users report that they are unable to connect to the named instances. You check and verify that they can only connect to the default instance. You also ensure that all SQL Server instances run normally. You have to start the service which is required to connect to the named instances. Which service should you start?()
第18题:
You work in a company which uses SQL Server 2008. You are the administrator of the company database. In your company there is a server which contains a default SQL Server 2005 instance. For a new application, you have to install a SQL Server 2008 instance on the server. Your company CIO assigns a task to you. You must make sure that the respective certified third-party applications have access to both database instances. You have to achieve this goal without changing the existing application environments. So what should you do to achieve this by using as little database administrative effort as possible?()
第19题:
You should install SQL Server 2008 as a named instance, and make the new application to use the new instance.
You should install SQL Server 2008 as the default instance, and make the new application to use the default instance.
You should upgrade the SQL Server 2005 application to use SQL Server 2008.
You should upgrade the SQL Server 2005 instance to a SQL Server 2008 instance.
第20题:
Server
SQL Server Agent
SQL Server Browser
SQL Active Directory Helper
第21题:
You should use the Database Engine Tuning Advisor.
In Microsoft SQL Server Management Studio, you should create a maintenance plan
You should use the SQL Server Configuration Manager
In Microsoft SQL Server Management Studio, you should create a policy
第22题:
log.trc
default.trc
ERRORLOG
SQLAGENT
第23题:
You should use local Service account
You should use network Service account
You should use domain account
You should use local System account
第24题:
SQLServer:Buffer Manager
SQLServer:Access Methods
SQLServer:General Statistics
SQLServer:Exec Statistics