正确答案: 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.

查看原题 点击获取本科目所有试题

举一反三的答案和解析：

[单选题]You are the database administrator for a retail company. The company owns 270 stores. Every month, each store submits approximately 2,000 sales records, which are loaded into a SQL Server 2000 database at the corporate headquarters.A Data Transformation Services (DTS) package transforms the sales records, as they are loaded. The package writes the transformed sales records to the Sales table, which has a column for integer primary key values. The IDENTITY property automatically assigns a key value to each transformed sales record.

Use the DBCC CHECKIDENT statement to reseed the Sales table's IDENTITY property.

解析：解析：Explanation: DBCC CHECKIDENT is used to check the current identity value for the specified table. It can be set to correct the identity value by specifying the RESEED option with DBCC CHECKIDENT.

[单选题]You are the database administrator for a financial services company. Employees enter data 24 hours a day into a SQL Server 2000 database. These employees report slower response times when new account information is gathered from branch offices and added to the database. You currently use the following BULK INSERT statement to add the account information:BULK INSERT finance.dbo.customers

Remove the TABLOCK option from the BULK INSERT statement.

解析：解析：Explanation: The TABLOCK hint increases the number of locks during the adding process. This is the reason why response time are slows down during this process. By removing the TABLOCK hint the default more granular row-level lock will be used. This would decrease the scope of the locks which would result in less waiting jobs and performance would improve.

[单选题]You are the administrator of a Windows 2000 Professional computer that has a shared printer. Several departments in your company use the shared printer.The Sales department frequently prints multiple-page presentation graphics, which take a long time to print. Users in other departments who have short messages to print must wait an unnecessarily long time for their jobs to print.

Configure the priority of the printer to 50. Add a new printer, and set the priority to 99. For the new printer, deny print permissions for users in the Sales department.

解析：解析：Explanation: The Sales department has long-running printing jobs that are blocking the print device for long periods of time. In order to give the other departments' print jobs higher priority than the Sales department's print jobs, we create a new printer with higher priority. We deny print permission for the Sales department on the new printer.