【名词&注释】
正确答案:B。A.Use the ALTER COLUMN clause of the ALTER TABLE statement to change data types in the source tables. Change the data types so that they will use the lowest precision and scale values of the data that will be transferred. B.Use the ALTER COLUMN clause of the ALTER TABLE statement to change data types in the destination tables. Change the data types to reflect the highest precision and scale values involved in data transfer. C.Set a flag on each DTS transformation to require an exact match between source and destination columns. D.Set the maximum error count for each DTS transformation task equal to the number of rows of data you are importing. Use an exception file to store any rows of data that generate errors. E.Write Microsoft ActiveX script. for each DTS transformation. Use the script. to recast data types to the destinations precision and scale values. 更多微软认证的考试资料下载及答案解析请访问不凡考网计算机类考试考试频道。
[单选题]You are the administrator of a SQL Server 2000 computer. The server contains a database that stores financial data. You want to use Data Transformation Services packages to import numeric data from other SQL server computers. The precision and scale values of this data are not defined consistently on the other servers.You want to prevent any loss of data during the import operations. What should you do?
A. Use the ALTER COLUMN clause of the ALTER TABLE statement to change data types in the source tables. Change the data types so that they will use the lowest precision and scale values of the data that will be transferred.
B. Use the ALTER COLUMN clause of the ALTER TABLE statement to change data types in the destination tables. Change the data types to reflect the highest precision and scale values involved in data transfer.
C. Set a flag on each DTS transformation to require an exact match between source and destination columns.
D. Set the maximum error count for each DTS transformation task equal to the number of rows of data you are importing. Use an exception file to store any rows of data that generate errors.
E. Write Microsoft ActiveX script. for each DTS transformation. Use the script. to recast data types to the destinations precision and scale values.
查看答案&解析
点击获取本科目所有试题
举一反三：
[单选题]You are the administrator responsible for security and user desktop settings on your network. You need to configure a custom registry entry for all users. You want to add the custom registry entry into a Group Policy object (GPO) with the least amount of administrative effort.What should you do?
A. Configure an ADM template and add the template to the GPO.
B. Configure an INF policy and add the policy to the GPO.
C. Configure a Microsoft Windows installer package and add the package to the GPO.
D. Configure RIS to include the registry entry.
[单选题]You are the administrator of two SQL Server 2000 computers. One of these servers contains a 4-GB database named marketing. You want to remove the marketing database from one server and add it to the other as quickly as possible.What should you do?
A. Detach the database from the original server by using the sp_detach_db stored procedure. Copy the database and the transaction log files to the new server, and attach them by using the sp_attach_db stored procedure.
B. Use the DTS export wizard to transfer all database objects from the original server to the new server. Drop the database from the original server.
C. Run a full backup of the database on the original server. Create a new database named marketing on the new server. Restore the backup in the new marketing database. Drop the database from the original server.
D. Shut down the original server. Copy the database and the transaction log files to the new server. Use the DISK INIT and DISK REFIT statements to attach the data file to the new server. Drop the database from the original server.
[多选题]You are the administrator of your company's network. Your network has 20 Windows 2000 server computers in the contoso.com domain. Your network also has 250 Windows 98 computers. You want to perform. a clean installation of Windows 2000 Professional on all of the Windows 98 computers. All of the Windows 98 computers are identical models and are PXE complaint.You want to accomplish the following goals:
A. 1. An unattended installation of Windows 2000 Professional will be performed.
B. 2. An unattended installation of company's standard applications will be performed during the installation of Windows 2000 Professional.
C. 3. Each computer will be assigned a unique security identifier description.
D. 4. The unattended installation script. will be modified so that the computers automatically join the contoso.com domain.
E. You take the following actions:
F. 1. Install Windows 2000 Professional on a Windows 98 computer named computer1.
G. 2. Install and configure computer standard applications on computer1.
H. 3. Use Setup Manager on computer1 to create an unattended.txt file based on the current configuration including domain membership.
I. 4. Start the remaining Windows 98 computers and then install Windows 2000 Professional. Use the unattended.txt file to provide the setting for the installation.
J. Which result or results do these actions produce? (Choose all that apply)
K. An unattended installation of Windows 2000 Professional will be performed.
L. An unattended installation of company's standard applications will be performed during the installation of Windows 2000 Professional.
M. Each computer will be assigned a unique security identifier description.
N. The unattended installation script. will be modified so that the computers automatically join the contoso.com domain.
[多选题]You are the administrator of a SQL Server 2000 computer. Your company purchased an accounting application from a vendor. The application stores its data in a database named Accounting on the server. The tables in this database contain columns that function as primary keys, but PRIMARY KEY and FOREIGN KEY constraints are not used.You need to replicate data from this database to another SQL Server computer. This server will use the replicated data to generate reports. Most reports will run each month, but the accounting department needs to have the ability to run reports at any time. Reports should be accurate through the last full working day.
A. You cannot make any changes to the database, but you need to implement replication. Which two actions should you take? (Each correct answer presents part of the solution. Choose two)
B. Implement merge replication.
C. Implement snapshot replication.
D. Implement transactional replication.
E. Schedule replication to run continuously.
F. Schedule replication to run during off-peak hours.
[单选题]You want to upgrade a Windows NT Server 4.0 computer to Windows 2000 Server. The system partition uses the FAT file system.You start the Setup program by starting the computer from the Windows 2000 Server CD-ROM.
A. However, you receive the following error message, "You chose to install Windows 2000 on a partition that contains another operating system. Installing Windows 2000 on this partition might cause the operating system to function improperly".
B. You are unable to perform. the upgrade. What should you do to resolve the problem?
C. Convert the system partition to NTFS.
D. Disable Advanced Configuration and Power Interface (ACPI) support for the computer.
E. Restart the computer, and then run Winnt32.exe from the Windows NT Server 4.0 environment.
F. Remove the Windows 2000 Server CD-ROM and restart the computer by using the setup floppy disks.
[单选题]From your Windows 2000 Professional computer, you need to map drive G to the default administrative share on drive C of a server named AppSrv.What can you do to map the drive?
A. Run thenet share C$=G:\command.
B. Run thenet use G: \\AppSrv\C$command.
C. Browse to AppSrv in Windows Explorer, and map drive G to the C$ share.
D. Browse to AppSrv in My Network Places, and map drive G to the C$ share.
本文链接：https://www.zhukaozhuanjia.com/download/e0g7r7.html
