单选题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. According to the company requirement, you have to move the application f

题目
单选题
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. According to the company requirement, you have to move the application from Microsoft SQL Server 2000 to Microsoft SQL Server 2008. You have to monitor the SQL Server instance to record the use of features.  These features will be discontinued. What should you do? ()
A

The SQL Server 2008 Upgrade Advisor should be used. 

B

The SQL Server Profiler which captures the SQL:BatchCompleted and Exception event classes should be used. 

C

A SQL server-side trace that captures the Deprecation Announcement and Deprecation Final Support event classes should be used 

D

A SQL server-side trace that captures the SQL:BatchCompleted and Exception event classes should be used.


相似考题
更多“You work in a company which uses SQL Server 2008. You are th”相关问题
  • 第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? () 

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

    正确答案:B

  • 第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? () 

    • 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

    正确答案:D

  • 第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? () 

    • A、You should backup the master database
    • B、You should backup the default.trc file
    • C、You should backup the SQL Server registry hive.
    • D、You should backup the resource database 

    正确答案:C

  • 第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? () 

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

    正确答案:B

  • 第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? () 

    • 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

    正确答案:A

  • 第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? () 

    • 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

    正确答案:C

  • 第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. 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? ()
    A

    You should configure Distributed File System

    B

    You should configure SQL Server

    C

    You should configure SQL Server Full Text

    D

    You should configure SQL Server VSS Writer


    正确答案: D
    解析: 暂无解析

  • 第8题:

    单选题
    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. 


    正确答案: B
    解析: 暂无解析

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


    正确答案: D
    解析: 暂无解析

  • 第10题:

    单选题
    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. Now according to the requirement of the company CIO, users on the SQL Server instance must be able to use the OPENROWSET() function to query remote data source.  In the options below, which sp_configure configuration option should you configure?
    A

    Agent XPs 

    B

    remote access 

    C

    remote proc trans 

    D

    Ad Hoc Distributed Queries


    正确答案: C
    解析: 暂无解析

  • 第11题:

    单选题
    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 company wants to export data from SQL Server to a Microsoft Excel file. The company assigns this task to you. You perform this by using the SQL Server Import and Export Wizard. After this, you save the package definition to a file. Now you have to reexecute the package from the command line.  In the options below, which utility should you choose to use?()
    A

    bcp.exe 

    B

    dta.exe 

    C

    dtexec.exe 

    D

    sqlmaint.exe


    正确答案: A
    解析: 暂无解析

  • 第12题:

    单选题
    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


    正确答案: B
    解析: 暂无解析

  • 第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? ()

    • A、You should create a job which is assigned to the Database Maintenance category
    • B、You should create an Alert which will run another to delete the maintenance job.
    • C、You should create a job. You schedule the job to run only once.
    • D、You should create a job. The job uses the Automatically delete job option

    正确答案:D

  • 第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?()  

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

    正确答案:D

  • 第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?()

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

    正确答案:C

  • 第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?()  

    • A、You should use the Database Engine Tuning Advisor. 
    • B、In Microsoft SQL Server Management Studio, you should create a maintenance plan 
    • C、You should use the SQL Server Configuration Manager 
    • D、In Microsoft SQL Server Management Studio, you should create a policy

    正确答案:D

  • 第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?()  

    • A、Server 
    • B、SQL Server Agent 
    • C、SQL Server Browser 
    • D、SQL Active Directory Helper

    正确答案:C

  • 第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?()

    • A、You should install SQL Server 2008 as a named instance, and make the new application to use the new instance. 
    • B、You should install SQL Server 2008 as the default instance, and make the new application to use the default instance. 
    • C、You should upgrade the SQL Server 2005 application to use SQL Server 2008. 
    • D、You should upgrade the SQL Server 2005 instance to a SQL Server 2008 instance. 

    正确答案:A

  • 第19题:

    单选题
    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?()
    A

    You should install SQL Server 2008 as a named instance, and make the new application to use the new instance. 

    B

    You should install SQL Server 2008 as the default instance, and make the new application to use the default instance. 

    C

    You should upgrade the SQL Server 2005 application to use SQL Server 2008. 

    D

    You should upgrade the SQL Server 2005 instance to a SQL Server 2008 instance. 


    正确答案: B
    解析: 暂无解析

  • 第20题:

    单选题
    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?()
    A

    Server 

    B

    SQL Server Agent 

    C

    SQL Server Browser 

    D

    SQL Active Directory Helper


    正确答案: B
    解析: 暂无解析

  • 第21题:

    单选题
    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?()
    A

    You should use the Database Engine Tuning Advisor. 

    B

    In Microsoft SQL Server Management Studio, you should create a maintenance plan 

    C

    You should use the SQL Server Configuration Manager 

    D

    In Microsoft SQL Server Management Studio, you should create a policy


    正确答案: D
    解析: 暂无解析

  • 第22题:

    单选题
    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. Now you get an order from your company CIO, you have to identify whether a database integrity check (DBCC CHECKDB) was run for a particular database.  Which log file should you examine?()
    A

    log.trc 

    B

    default.trc 

    C

    ERRORLOG 

    D

    SQLAGENT


    正确答案: A
    解析: 暂无解析

  • 第23题:

    单选题
    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


    正确答案: C
    解析: 暂无解析

  • 第24题:

    单选题
    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. For some reason, now the company wants to view the number of users who access the SQL Server instance. The company CIO assigns this task to you. You have to use Windows System Monitor to find out the concrete number. Which performance object should you capture?()
    A

    SQLServer:Buffer Manager 

    B

    SQLServer:Access Methods 

    C

    SQLServer:General Statistics 

    D

    SQLServer:Exec Statistics


    正确答案: C
    解析: 暂无解析