正确答案: AC

Save the DTS package so that it has an owner password. Encrypt the DTS package details in the command line of the dtsrun utility.

题目：You are the administrator of a SQL Server 2000 computer. The server contains a Data Transformation Services (DTS) package that queries multiple databases and writes the results to a text file. You run this package by using a Microsoft Windows batch file. The batch file uses the dtsrun utility to execute the DTS package.You want to ensure that connection properties, such as login names and passwords, cannot be read or modified by users. Which two actions should you take? (Each correct answer represents part of the solution. Choose two.)

解析：解析：Explanation: In this scenario we will use a windows batch file with the owner password for maximum security.

查看原题查看所有试题

学习资料的答案和解析：

[单选题]Ezonexam uses static TCP/IP addressing for its servers. You are installing Windows 2000 Server on a new computer named VE32. VE32 needs to join an existing Windows 2000 Active Directory domain named Ezonexam.com. While installing VE32 you are unable to join the existing domain. You use another Windows 2000 Server to attempt to create a computer account for the new server in the domain. When attempting to create the new computer account you receive the following message.Active Directory Service

Restart the domain's RID master server.

解析：解析：Explanation: The domain controller assigned the RID master role allocates sequences of relative IDs to each of the various domain controllers in its domain. At any time, there can be only one domain controller acting as the RID master in each domain in the forest.

[多选题]You have stored confidential financial data in a shared folder named AccSecured on your Windows 2000 Professional computer. Your company hires an intern named Richard. You create a subfolder named intern, which Richard needs to access. You want to allow Richard access to the intern subfolder only.You create a user account named intern. You want to allow the intern user account the ability to update, create, and delete files within the intern folder. You need to prevent Richard from accessing any other files or folders within the AccSecured folder.

Allow the intern user account modify permissions on the intern subfolder.

Allow the intern user account traverse folder/execute file permission on the AccSecured folder.

解析：解析：Explanation: The traverse folder/execute file permission" enables Richard to traverse the AccSecured folder to reach the intern folder, while the modify permissions on the intern folder allow Richard to modify information in the intern subfolder.

[单选题]You want to upgrade 400 computers from Windows 95 to Windows 2000 Professional. Most of the computers in your company use the same hardware. However, several different peripheral devices are used throughout the company.You want to verify that the hardware in use is compatible with Windows 2000 Professional. You want to accomplish this with least amount of administrative effort.

Use Setup Manager to create a Setup.inf file. Add the entryReportOnly=Yes to the [Win9xUpg] section of the answer file. RunWinnt32.exe /Unattended:Setup.infon all of the different computer configurations.

解析：解析：Explanation: Winnt32.exe /unattended:setup.inf will start an unattended installation using the answer file setup.inf. When ReportOnly=Yes is added in the [Win9xUpg] section of the answer file, the installation only generates an upgrade report and then exits without making any changes to the current Windows 95 or Windows 98 installation. The upgrade report contains a list of hardware and software incompatibilities and is saved to the root of the system drive if the SaveReportTo key is not specified.

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

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

解析：解析：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.

[单选题]server’s msdb database in an e-mail message to the administrator of another SQL Server computer.You create a job that contains the following steps:

Configure the job to back up the msdb database to a temporary file. Send the file to the administrator in an e-mail message

解析：解析：Explanation:Thecurrentjobfailssincethedetachmsdbstatementfails.Itfailsbecausedetachingadatabaserequiresthatnooneisusingthedatabase.ThemsdbdatabaseisusedbytheSQLServerAgentservice,whichperformsscheduledactivitiessuchasbackupsandreplicationtasks.Wewanttosendthemsdbdatabase.Themsdbdatabasecouldbedetachedifallprocessesthatuseitwhereterminated.Thenwecouldsendthedatabasefileandreattachthemsdbdatabase.Thiswouldstopscheduledtasksfrombeingrunduringthisperiod.Abetterapproachwouldtobetobackupthedatabaseandsendthetemporaryfileinstead.Note:AnewSQLServer2000installationautomaticallyincludessixdatabases:master,model,tempdb,pubs,Northwind,andmsdb.Themaster,model,andtempdbdatabasescannotbedetached.Incorrectanswers:A:TheproblemthattheSQLServiceAgentisusingthemsdbdatabase.ThisproblemwouldstillbethereevenuseraccountrunningtheSQLServerAgentserviceischanged.B:ThemsdbdatabaseisusedbytheSQLServerAgentserviceandthedatabasefilewouldbelocked.Itcannotbesentdirectlyinane-mailmessage.D:Themsdbdatabasecouldbedetachedifallprocessesthatuseitwhereterminated.Thenwecouldsendthedatabasefileandreattachthemsdbdatabase.Thiswouldstopscheduledtasksfrombeingrunduringthisperiod.