You are the administrator of a SQL Server 2000 computer. The

【名词&注释】

布丁学网发布"You are the administrator of a SQL Server 2000 computer. The"考试试题下载及答案，更多微软认证的考试试题下载及答案考试题库请访问布丁学网计算机类考试频道。

[多选题]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.)

A. Save the DTS package so that it has an owner password.
B. Save the DTS package so that it has a user password.
C. Encrypt the DTS package details in the command line of the dtsrun utility.
D. Store the DTS package in the Meta. Data Services repository.
E. Store the DTS package as a Microsoft Visual Basic file.

查看答案&解析查看所有试题

学习资料：

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

A. The object VE32 could not be created.
B. The problem encountered was:
C. The directory service has exhausted the pool of relative identifiers.
D. You need to resolve the problem before continuing the installation.
E. What should you do?
F. Restart the domain's Global Catalog server.
G. Restart the domain's RID master server.
H. Restart the domain's PDC Emulator server.
I. Restart the domain's Infrastructure Master.

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

A. What should you do? (Choose all that apply)
B. Map a network drive to the AccSecured\intern folder from Richard's computer.
C. Map a network drive to the AccSecured shared folder from Richard's computer.
D. Allow the intern user account modify permissions on the intern subfolder.
E. Allow the intern user account traverse folder/execute file permission on the AccSecured folder.
F. Allow the intern user account list folder content permission on the AccSecured folder. Remove read extended attributes and read permissions.

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

A. What should you do?
B. Create several different computer configurations. Install Windows 2000 Professional and enable driver signing.
C. Create a bootable floppy disk that contains and automatically runsWinNT32.exe/CheckUpgradeOnlyQ. Send the floppy disk to each user on the network.
D. Copy the contents of Windows 2000 Professional CD-ROM to a network share. From the network, modify your network logon scripts to runWinNT32.exe/Unattended:ReportOnly.
E. 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.

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

A. SQL_Latin1_General_CP1_CI_AS collation.
B. 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.
C. What should you do?
D. 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.
E. Restore the inventory database to an existing SQL server computer. Accept the SQL_Latin1_General_CR437_BIN collation for that database.
F. 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.
G. 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.

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

A. --Detach the msdb database
B. --Send the database to the administrator in an e-mail message
C. --Reattach the msdb database
D. You test the job, and it fails on the first step. You need to ensure that the msdb database is mailed to the administrator every night.
E. What should you do?
F. Ensure that the SQLServerAgent service is running under a user account that has database owner access to the msdb database
G. Delete the first and last steps in the job
H. Configure the job to back up the msdb database to a temporary file. Send the file to the administrator in an e-mail message
I. Insert a new job step before the first step. Configure the new step to terminate all processes that use the msdb database

本文链接：https://www.51ksbd.net/show/r4wk4j.html