文档介绍：070-229 070 - 229
Designing and Implementing Databases with
Microsoft SQL Server 2000
Enterprise Edition
Version
Leading the way in IT testing and certification tools,
- 1 -
070 - 229
Important Note
Please Read Carefully
This product will provide you questions and answers along with detailed explanations piled and
written by our experts. Try to understand the concepts behind the questions instead of just cramming the
questions. Go through the entire document at least twice so that you make sure that you are not missing
anything.
We are constantly adding and updating our products with new questions and making the previous versions
better so email us once before your exam and we will send you the latest version of the product.
Each pdf file contains a unique serial number associated with your particular name and contact information for
security purposes. So if we find out that particular pdf file being distributed by you. Testking will reserve the
right to take legal action against you according to the International Copyright Law. So don’t distribute this PDF
file.
Leading the way in IT testing and certification tools,
- 2 -
070 - 229
Q. 1
You are a database developer for A Datum Corporation. You are creating a database that will store
statistics for 15 different high school sports. This information will be used by panies that publish
sports information on their web sites. pany's Web site arranges and displays the statistics in a
different format.
You need to package the data for delivery to panies. What should you do?
A. Extract the data by using SELECT statements that include the FOR XML clause
B. Use the sp_makewebtask system stored procedure to generate HTML from the data returned by
SELECT statements
C. Create Data Transformation Services packages tha