The perform Integrated Change Contorl process is the ultimate responsibility of the(①).Although

参考答案：C

正确答案：B
解析：Explanation: Performing an unattended installation from a distribution server will work since the upgrade must be done in non-business hours.

An answer file provides the generic answers to setup questions. This is typically a file with a .txt extension (although the extension does not matter).

A uniqueness database file: This file, which has a .udf extension, provides the answers to computer specific questions that will change from machine to machine (for example, the computer name). Thus it identifies names of computers.

Incorrect answers:
A: This /cmdcons switch specifies that files required for command-line repair console be installed when making use of winnt32.exe. This is not what is required; you need to completer upgrades and not repair.

C: The winnt.exe command line is used in DOS-based and 16-bit installations.

D: To use a bootable CD-ROM for a fully automated operating system installation, the answer file must be called Winnt.sif and be located on a floppy disk. This is not how the upgrade is envisaged under the given circumstances.

正确答案：A

参考答案：A

正确答案：D
解析：Explanation: We must use Setup Manager to create a winnt.sif. We must then copy this file to a floppy. Then start the installation process from the CD-ROM and insert the floppy disk. The installation process will be a fully automated unattended installation.

Incorrect answers:
A: Makebt32.exe is used to create four installation startup disks. This is not automated.

B: Makeboot.exe is used to make Windows 2000 setup floppy disks.

C: Performing the installation using the Windows 2000 Installation CD alone is not what is required in this instance.

答案D

参考答案：C

正确答案：A

正确答案：CE
解析：Explanation:
C: Most OLTP backup schemes include a full database, differential, and transaction log backups

E: In order to recover the data as quickly as possibly we backup the data to network share, and then backup that share to tape. This minimizes the impact of the backup process on the SQL Server computer.

Note 1: SQL Server 2000 provides three database recovery models. These are the Simple recovery model, the Full Recovery Model and the Bulk-Logged Recovery model. Simple Recovery requires the least administration. In the Simple Recovery model, data is recoverable only to the last full database or differential backup. Transaction log backups are not used, and consequently, minimal transaction log space is required.

This Recovery Model is not an appropriate choice for production systems where loss of recent changes is unacceptable. Full Recovery and Bulk-Logged Recovery models provide the greatest protection for data. These models rely on the transaction log to provide full recoverability and to prevent work loss in the broadest range of failure scenarios.

The Full Recovery model provides the most flexibility for recovering databases to an earlier point in time. The Bulk-Logged model provides higher performance and lower log space consumption for certain large-scale operations. It does this at the expense of some flexibility of pointin- time recovery. In this scenario we would want to implement the Full Recovery model as this Recovery model provides complete protection against media failure and provides the ability to recover the database to the point of failure or to a specific point in time.

To guarantee this degree of recoverability, all operations are fully logged. The backup strategy for full recovery consists of database backups, differential backups, which are optional, and transaction log backups. The differential backups are optional but have less of an effect on the system while they run, as they are smaller than full database backups.

This is because a differential backup creates a copy of all the pages in a database modified after the last database backup. A transaction log backup makes a copy only of the log file and backs up the changes made to the database after the last full or differential database backup. A log file backup cannot be used by itself to restore a database. A log file is used after a database restore to recover the database to the point of the original failure. The full database, differential, and transaction log backups can be written to a hard disk or other disk storage media such as a tape drive.

Disk backup devices can be defined on a local disk of a server or on a remote disk on a shared network resource. Tape backup devices are used in the same way as disk devices, with the exception that the tape device must be connected physically to the computer running an instance of SQL Server. SQL Server 2000 thus does not support backing up to remote tape devices.

Note 2, file backup, filegroup backup: SQL Server 2000 supports backing up or restoring individual files or filegroups within a database. This is a complex backup and the restore process that is usually reserved for large databases with high availability requirements. If the time available for backups is not long enough to support backing up the full database, subsets of the database can be backed up at different times. If a disk holding database files or filegroups fails, the site can restore just the lost files or filegroups. This allows for a quicker recovery because only the damaged files or filegroups are restored in the first step, not the entire database.

Incorrect Answers:
A: An OLTP server requires transaction log backups in order to be able to recover up to the point of failure.

B: An OLTP server requires transaction log backups in order to be able to recover up to the point of failure.

D: Backing up to a local tape device would minimize cost but it would compared to a backup to a network it would decrease performance of the server more, and it would take more time to recover.

正确答案：B