Which of the following is true about the Raw Fil

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

Which of the following is true about the Raw File Source in SQL Server 2005 Integration Services?

Answer
It does not support an error output.
Explanation
The raw file source has only one output and does not support an error output. It also reads faster than other data sources becuase it has no parsing or translation and does not use a conneciton manager.

(Continued on next question...)

Other Job Interview Questions

• What happens when a transaction fails on the publisher?
• You have a large table that you wish to partition to improve performance...
• What type of update did you perform?
• Which RAID levels store parity information?
• What does the DEALLOCATE statement do in SQL Server 2005?
• What does the CREATE SERVICE statement do in SQL Server 2005?
• What does a report model provide in SQL Server 2005 Reporting Services?
• What is one of the downsides of using RAID 5 as opposed to RAID 1?
• How many plans must you setup?
• What does this method in SQL Server 2005's SMO equate to in T-SQL? db.CheckTables(RepairType.None)
• More...