Retrieving and modifying data

These questions are based on: 70-229 – Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition Microsoft Self-Test Software Practice Test.

Objective: Retrieving and modifying data
SubObjective: Import and export data; methods include the bulk copy program, the Bulk Insert task and Data Transformation Services (DTS)

Item No. 70-
Single Answer, Multiple Choice

You are the SQL Server 2000 administrator for an apparel retailer with stores worldwide. Your company wants to use SQL Server to improve sales and inventory update procedures. Consultants have been hired to do an in-depth study of company procedures. Each consultant will only be analyzing one area of the company.

The consultants periodically will need access to data that is in a SQL Server 2000 database named Sales, which is about 750 MB. The consultants will need access to only a small portion of the data, however. The consultants will be dialing into the network to download their data.

You create a snapshot of the database that you will use for testing. Any proposed procedural changes will first be implemented on this copy of the database.

You want each consultant to have access to only the portion of the database they need to fulfill their contractual duties. Only the appropriate users should be able to transfer the data to the consultants. In addition, the consultants might need their data updated periodically.

What is the best method to transfer the data so it can be used by the consultants?



Posted in Uncategorized|


Powered by WebDesk