You should use the http.sys listener to install the SSRS instance.
You should configure the SSRS database, make it use Native mode
You should configure the SSRS database, make it use SharePoint integrated mode
You should use the Internet Information Services default Web site to install the SSRS instance
第1题:
ou 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. According to the company requirement, you intend to perform an installation of an instance of SQL Server Reporting Services (SSRS) to the same machine. Now your company CIO wants version histories of all deployed reports can be kept. As a technical support, what should you do to ensure this?()
第2题:
ou work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now for a new application, a SQL Server 2008 instance has to be installed on an existing server. The server contains a default SQL Server 2005 instance. Your company CIO wants their corresponding certified third-party applications can access to both database instances. The company assigns this task to you. You must achieve this by using as little database administrative effort as possible, and never change the existing application environments. What should you do? ()
第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. 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? ()
第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? ()
第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. 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? ()
第6题:
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
第7题:
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.
第8题:
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
第9题:
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
第10题:
log.trc
default.trc
ERRORLOG
SQLAGENT
第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 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 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?()
第15题:
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?()
第16题:
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?()
第17题:
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?()
第18题:
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.
第19题:
Server
SQL Server Agent
SQL Server Browser
SQL Active Directory Helper
第20题:
You should install SQL Server 2008 as the default instance, and configure 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
You should install SQL Server 2008 as a named instance, and make the new application use the new instance.
第21题:
Agent XPs
remote access
remote proc trans
Ad Hoc Distributed Queries
第22题:
You should use the http.sys listener to install the SSRS instance.
You should configure the SSRS database, make it use Native mode
You should configure the SSRS database, make it use SharePoint integrated mode
You should use the Internet Information Services default Web site to install the SSRS instance
第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