Question 33


Answer E is correct. Anything other than the default delimiters requires the use of a format file to identify the field and record orientation used for the data.

For more information, see the following sources:

  • Chapter 5, "Data Consumption and Throughput"

  • SQL Server 2005 Books Online: "SQL Server Database Engine, Administering the Database Engine, Administering the Database Engine, Importing and Exporting Bulk Data, Format Files for Importing or Exporting Data"

  • "Using Format Files," http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_impt_bcp_9yat.asp

  • Within MSDN Library, go to MSDN Home, MSDN Library, Servers and Enterprise Development, SQL Server, SQL Server 2000, Importing and Exporting Data, Using bcp and BULK INSERT, Using Format Files.




MCTS 70-431(c) Implementing and Maintaining Microsoft SQL Server 2005
MCTS 70-431 Exam Cram: Implementing and Maintaining Microsoft SQL Server 2005 Exam
ISBN: 0789735881
EAN: 2147483647
Year: 2006
Pages: 200
Authors: Thomas Moore

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net