违法和不良信息举报 联系客服
免费注册 登录

You are the administrator of a SQL server computer. The server is running SQL Server 6.5 and SQL Server 7.0.You install a named instance of SQL Server 2000, and then run the SQL server upgrade wizard. On the database selection screen, some of the SQL Serv

题目

You are the administrator of a SQL server computer. The server is running SQL Server 6.5 and SQL Server 7.0.

You install a named instance of SQL Server 2000, and then run the SQL server upgrade wizard. On the database selection screen, some of the SQL Server 6.5 databases are not listed.

You cancel the SQL Server upgrade wizard.

You need to ensure that the SQL Server 6.5 databases are listed in the wizard. What should you do?

A．Uninstall SQL Server 7.0, and then rerun the SQL Server upgrade wizard.

B．Run the Microsoft SQL Server-switch application, and then rerun the SQL Server upgrade wizard.

C．Create a data transformation services package that imports the databases from SQL Server 6.5 to SQL Server 2000, and then execute the package.

D．Uninstall SQL Server 2000, and then reinstall SQL Server 2000 as the default instance.

参考答案和解析
正确答案：D
解析：Explanation:ToruntheSQLServerUpgradeWizard,youmusthaveadefaultinstanceofMicrosoftSQLServer2000installedonyourcomputer.IncorrectAnswers:A:ItisnotnecessarytouninstallSQLServer7.0.JustinstallSQLServer2000asthedefaultinstance.WecannotruntheSQLServerupgradewizardunlessSQLServer2000isinstalled.B:ToruntheSQLServerUpgradeWizard,youmusthaveadefaultinstanceofMicrosoftSQLServer2000installedonyourcomputer.C:WewanttoensurethattheSQLServer6.5databasesarelistedintheSQLServer2000installationwizard.TocreateDTStransformationpackagesthatupgradeSQLServer6.5databaseestoSQLServer2000databaseswemustinstallSQLServer2000first.
如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

You need to migrate the DeliveryVans， AirlinePreferences， and SeasonalContractors databases into the data center. What should you do？（）

  • A、Install a separate instance of SQL Server 2005 for each of the databases on a single server.
  • B、Create a SQL Server database for each of the databases in a single instance of SQL Server 2005.
  • C、Import the data from each of the databases into a single database in an instance of SQL Server 2005.
  • D、Install a default instance of SQL Server 2005 on three separate servers. Use one server for each of the databases.

正确答案:B

第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. There is a text file which is named SQL01.log on the E: drive. A SQL Server Agent job executes every 2 minutes and logs information to the text file. You get a report from users saying that the sever doesn't make response. As the technical support, you check and find that the SQL Server Agent service does not run and the SQL Server Agent job no longer functions. You have to identify the reason why the SQL Server Agent service is unresponsive. In the options below, which log should you check?（）  

  • A、You should check SQL1.log
  • B、You should check SQLAGENT.OUT
  • C、You should check log_xx.trc
  • D、You should check ERRORLOG

正确答案:B

第3题：

You are the administrator of Microsoft Windows 2000 computer. You are preparing to install SQL Server 2000 on the computer.

Your company contains a variety of client computers that will connect to the SQL server 2000 computer by using a specific Net-Library, as shown in the following table.

You need to allow the client computers to connect to the SQL Server 2000 computer. You also want to minimize the number of configuration changes required on the client computers.

Which three actions should you take? (Each correct answer presents part of the solution. Choose three)

A. Install SQL Server 2000 as a named instance.

B. Install SQL Server 2000 as the default instance.

C. Configure the new instance for Mixed Mode Authentication.

D. Configure the new instance for Windows Authentication.

E. Configure the server to use the Named Pipes, IPX/SPX, and TCP/IP Net-Libraries.

F. Configure the server to use the Multiprotocol Net-Library.


正确答案：BCE
B,C,E 解析：Explanation:
B: We need to use a default instance of SQL Server in order to allow all the different clients to connect.

C: The client computers in this scenario will be running Windows 98, Novel NetWare and Apple Macintosh. SQL Server Authentication is required as these operating systems are not supported by Windows Authentication, however, the use of SQL Server Authentication is offered only for backward compatibility, hence we need to implement Mixed Mode Authentication.

E: By using specific communication protocols, and not the Multiprotocol Net-Library, performance would be better. Every extraneous protocol adds overhead.

Note: Configuring Net-Libraries has been simplified for applications using the SQL Server 2000 client connectivity components. Selecting the client protocols to be installed on the application computer must be done during setup, and selecting the server protocols to be enabled on the instance of SQL Server 2000 must be done during the SQL Server 2000 setup. No other configuration is required. Once setup, a client can connect to any instance of SQL Server 2000 by specifying the network name of the database computer and the instance name.

Note: SQL Server 2000 can operate in either Windows Authentication mode, which allows a user to connect through a Windows NT 4.0 or Windows 2000 user account; Mixed mode, which allows users to connect to an instance of SQL Server 2000 by using either Windows Authentication or SQL Server Authentication.

Furthermore, users who connect through a Windows NT 4.0 or Windows 2000 user account can make use of trusted connections in either Windows Authentication mode or Mixed mode. When a user connects to SQL Server 2000 with a nontrusted connection, SQL Server 2000 performs the authentication itself by checking if a SQL Server login account has been created and if the supplied password is correct. SQL Server Authentication is also used for backward compatibility because applications written for SQL Server 7.0 or earlier may require the use of SQL Server logins and passwords. In addition, SQL Server Authentication is required when an instance of SQL Server is running on Windows 98 because Windows Authentication mode is not supported on Windows 98.

Incorrect Answers:
A: The Multiprotocol Net-Library can only be used to connect to a default instance of SQL Server 2000 as it does not support named instances of SQL Server 2000 or server enumeration.

D: As client computers will be running Windows 98, Novel NetWare and Apple Macintosh, we cannot use Windows Authentication as these operating systems are not supported by Windows Authentication.

Note: Windows Authentication mode allows a user to connect through a Windows NT 4.0 or Windows 2000 user account and makes use of trusted connections. When a user connects to SQL Server 2000 a nontrusted connection, SQL Server 2000 performs the authentication itself by checking if a SQL Server login account has been created and if the supplied password is correct. Mixed mode allows users to connect to an instance of SQL Server 2000 by using either Windows Authentication or SQL Server Authentication.

F: The Multiprotocol Net-Library is used to support the different protocol that the clients use. This provides easy of administration. However, since unused protocols are installed, it also introduces overhead. This is not the best solution.

Note: The Multiprotocol Net-Library allows for the automatic selection of available network protocols to communicate with an instance of SQL Server 2000. This is convenient for connecting to multiple servers running different network protocols without having to reconfigure the client connection for each server. If the client and server Net-Libraries for TCP/IP Sockets, NWLink IPX/SPX, or Named Pipes are installed on the client and server, the Multiprotocol Net-Library will automatically choose the first available network protocol to establish a connection.

The Multiprotocol Net-Library can only be used to connect to a default instance of SQL Server 2000 as it does not support named instances of SQL Server 2000 or server enumeration.

第4题：

You are designing a plan for migrating an existing Microsoft SQL Server 2008 database to SQL Azure.The database includes a SQL Server Agent job that cleans the application log table.   You need to recommend an approach for ensuring that the SQL Server Agent job continues to run without modification.  What should you recommend？（）

  • A、 Use the SQL Azure Data Sync service.
  • B、 Run the SQL Server Agent in SQL Azure.
  • C、 Use SQL Server Integration Services （SSIS） to connect to SQL Azure.
  • D、 Connect the existing on-premise SQL Server Agent jobs to SQL Azure.

正确答案:D

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

第6题：

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.

正确答案:C

第7题：

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 database named Dworks in the instance. Now you get a report from users saying that DB1 meets deadlock problems. As the technical support, you have to capture the deadlock information to the SQL Server error log. What should you do?（）  

  • A、For the AdventureWorks database, enable Server Auditing 
  • B、First you should set the appropriate trace flags as a startup parameter, and then restart the SQL Server instance 
  • C、You should configure the data collector and make it capture the deadlock graphs
  • D、You should configure a SQL Profiler trace, and make it capture the deadlock graphs

正确答案:B

第8题：

You are the administrator of several SQL Server 2000 computers. You want to retrieve information from an archived inventory database. You have a full tape backup of the database. The backup’s header information shows that the backup uses the SQL_Latin1_General_CR437_BIN collation.

However, the existing SQL server computers in your office are configured to use the

SQL_Latin1_General_CP1_CI_AS collation.

You do not want to join tables in the inventory database with tables in other databases. You need to restore the inventory database to a SQL Server 2000 computer by using the least amount of administrative effort.

What should you do?

A．Use the rebuildm utility to rebuild the system database on an existing SQL server computer. Configure all the databases on that server to use the SQL_Latin1_General_CR437_BIN collation. Restore the inventory database to the server.

B．Restore the inventory database to an existing SQL server computer. Accept the SQL_Latin1_General_CR437_BIN collation for that database.

C．Install a new named instance of SQL Server 2000 on an existing SQL Server 2000 computer. Configure the named instance to use the SQL_Latin1_General_CR437_BIN collation. Restore the inventory database to the named instance.

D．Install SQL Server 2000 on a new computer. Configure the new server to use the SQL_Latin1_General_CR437_BIN collation. Restore the inventory database to the new server.


正确答案：B
解析：Explanation:CollationscontrolthephysicalstorageofcharacterstringsinSQLServer2000byspecifyingthebitpatternsthatrepresenteachcharacterandtherulesbywhichcharactersaresortedandcompared.WhereasearlierversionsofSQLServersupportedonlyonecollationforeachinstanceofSQLServer,SQLServer2000allowsobjectsthathavedifferentcollationstobestoredinasingledatabase.WecanthusrestorethedatabasetoanexistingSQLServer2000computerwithouthavingtochangethecollationofthatdatabase.IncorrectAnswers:A:TherebuildmutilityrebuildsthemasterdatabaseandcanbeusedtochangethecollationsettingsofaninstanceofSQLServer2000,ortofixacorruptedmasterdatabase.Rebuildingthemasterdatabaseinvolvesremovesalldatabaseobjectsanddata,re-createthedatabaseobjectsandreloadthedata,orreattachthedataandlogfilesusingsp_attach_dbwhentherebuildiscomplete.C:CollationscontrolthephysicalstorageofcharacterstringsinSQLServer2000byspecifyingthebitpatternsthatrepresenteachcharacterandtherulesbywhichcharactersaresortedandcompared.WhereasearlierversionsofSQLServersupportedonlyonecollationforeachinstanceofSQLServer,SQLServer2000allowsobjectsthathavedifferentcollationstobestoredinasingledatabase.ItisthusnotnecessarytoinstallanewinstanceofSQLServer2000inordertorestorethedata.WecaninsteadrestorethedatabasetoanexistingSQLServer2000computerwithouthavingtochangethecollationofthatdatabase.D:CollationscontrolthephysicalstorageofcharacterstringsinSQLServer2000byspecifyingthebitpatternsthatrepresenteachcharacterandtherulesbywhichcharactersaresortedandcompared.WhereasearlierversionsofSQLServersupportedonlyonecollationforeachinstanceofSQLServer,SQLServer2000allowsobjectsthathavedifferentcollationstobestoredinasingledatabase.ItisthusnotnecessarytoinstallanewinstanceofSQLServer2000onanewcomputerinordertorestorethedata.WecaninsteadrestorethedatabasetoanexistingSQLServer2000computerwithouthavingtochangethecollationofthatdatabase.

第9题：

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 SQL Server 7.0 database. You upgrade the database to the SQL Server instance. According to the company requirement, you must make sure that suspect pages can be detected in the database. So what action should you perform to achieve this goal?（）

  • A、For the database, you should turn on the TRUSTWORTHY database option
  • B、For the database, the PAGE_VERIFY database option should be set to CHECKSUM
  • C、For the database, the database compatibility level option should be set to 10
  • D、For the model database, the PAGE_VERIFY database option should be set to TORN_PAGE_DETECTION. 

正确答案:B

第10题：

You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work a database administrator for your company. There is a Data Transformation Services （DTS） package， and the DTS package is stored in SQL Server 2000. And you plans to have the SQL Server 2000 migrated into SQL Server 2005. The DTS package dynamically configures precedence constraints by utilizing complex Microsoft Visual Basic Scripting Edition （VBScript）. The SQL Server 2005 Package Migration Wizard is run by you， but the wizard cannot convert the package from SQL Server 2000 to SQL Server 2005. You are required to make sure that the DTS package runs in SQL Server 2005. And the package should be run in the shortest time.  Which action should be utilized？（）

  • A、The SQL Server 2000 Data Transformation Services （DTS） package should be wrapped in an Execute DTS 2000 Package task.
  • B、The SQL Server 2000 Data Transformation Services （DTS） package should be manually recreated as a SQL Server Integration Services （SSIS） package.
  • C、The SQL Server 2000 Data Transformation Services （DTS） task should be configured to not utilize precedence constraints. Then， the SQL Server 2005 Package Migration Wizard should be run again.
  • D、The SQL Server 2005 Package Migration Wizard should be run. And when the upgrade fails， a Transfer SQL Server Objects task should be run.

正确答案:A

更多相关问题
相关内容